Fresh Install on Debian 8 from tutorial

questions about php5-mysql package conflict another not found and request to help provide other installation options

i installed TurnKey Core | TurnKey GNU/Linux which is debian 8 jessie

From:  Composr Tutorial: Webhosting for Composr - Composr
I selected, copied and pasted into the Bash from the following section:

ubuntu/debian

apt-get install apache2 libapache2-mod-php5 php5 php5-common php5-cli php5-apcu php5-curl php5-enchant php5-ffmpeg php5-gd php5-imap php5-mysql php5-mysqlnd php5-pspell openssl mysql-server mysql-client postfix nano wget lynx hunspell git openssh-server nano

my first apt-get install returned
1) a conflict between:  php5-mysql and php5-mysqlnd

2) it could not locate "php5-ffmpeg" 

3) the following packages already had the newist version installed
postfix nano wget git openssh-server

for the second apt-get install i removed:  php5-mysqlnd and all the packages in 3) above and it went through and installed everything. i forget how many packages but it did take several minutes.

next i did apt-get install php5-mysqlnd and it installed but i noticed it had to un-install 3 or 4 things

next i tried to find and install php5-ffmpeg which i was not able to do. i added the multivers repository as per a web search and most things came up with ffmpeg but  not php5-ffmpeg. i did found a package for debian 7 wheezy but not for debian 8 jessie.

next I successfully did the following from the same compo.sr tutorial page (above)
Some lines in the default PHP ini (/etc/php5/apache2/php.ini) file need changing:
upload_max_filesize = 2M → upload_max_filesize = 500M
post_max_size = 8M → post_max_size = 500M
;date.timezone = → date.timezone = "UTC" (to avoid errors on PHP startup)
; extension_dir = "./" → extension_dir = "usr/lib/php5/20121212"
;opcache.enable=0 → ;opcache.enable=1 

i'm also wondering if anyone would be interested in coming up with a turnkeylinux.org/composr appliance or at least do what i've described here and come up with a step by step for installing compsr on it?

the one composr installation tutorial combines different OS specific installation which get run together into one document. it gets confusingly jumbled for me to try and follow. And, naturally it gets even worse trying to follow the links for more details which are incorporated along the way.

maybe we can have a page for each OS that actually gave feedback on multiple versions of the same OS. I have been using OSPortal for about 2 years now. I have 5 different instances being hosted on cpanel accounts because it's the only one of about 8 linux servers that I use that does not have a turnkeylinux or vmdk that i can easily load and run on my qemu-kvm server. there is a bitnami vm but it does not work on my system.

hope there is at least a couple people out there in this community that is willing to help make it easier for me to work as a systems integrator being able to offer compsosr as an option.

thank you. 
 

Hi,

Thanks for sharing your experience .

The apt command in the tutorial isn't perfect as Linux distributions regularly change packages around. I do note how though that php5-mysql and php5-mysqlnd seem to be compatible, we'll fix that. Just having php5-mysqlnd should be fine.

php5-ffmpeg isn't needed unless you really need video thumbnails to be automatically generated.

Certainly if someone wants to share OS-specific tutorials we'd link them into the tutorial index!

For v11 the tutorial will be simplified a bit because we're raising the requirements to PHP 5.6 (the oldest supported PHP), and 128MB memory limit (the default for quite a while). That way we don't have to go over what is required, and what is recommended.

Thank you very much for your reply. I spent more time with trying to install composr and found my understanding of how php myrusql and apache work together to be quit limited. I used the TurnKey Core | TurnKey GNU/Linux and after running the series apt-get-installs (above) and editing the php.ini i started the install.php and the php and mysql was not connected. I realize this is very basic to lamp. I can follow instructions well but when there are missing steps and non OS specifics mixed in I do get lost.

I did discover that for $65.50 or 8 credits I can get pro support for an installation.

My preference would be to use postgresql instead of mysql so i installed LAPP | TurnKey GNU/Linux and during the install.php i got further but still could not get it to connect with the cms database that i created maybe because i created it as root and was trying to access it as postgres. it also notified me that it was not tested for postgresql.

thanks again Chris.  it would be nice to have a base distro on turnkeylinux or distrowatch to install composr onto. i figure the goal is for people to use pro support but i hope you or someone else can help provide more details for the install process because those that will use pro support will not be affected by those of us that need to be able to do it ourselves, mainly because i need to do it over and over again.

I was able to install Composr on my CentOS VM very easily... Does Ubuntu use yum? This may be an easier way to obtain the necessary packages, and resolve dependancies. ... If so lemme know and I can lend a hand.

Please send me a link to the cenOS vm or the steps you used to install it. I would love to be able to install it on cenOS. thanks. also make sure it includes the GD Libraries which is the other issue i'm having.

i've confirmed that the database is accessible not and running the install.php again i get the following on the first step:

There is no PHP GD extension on the server (no PHP graphics functionality). Officially Composr requires this, and a number of very useful features will not work without it (such as automatic thumbnail generation).

PHP does not have PNG support built-into the GD library, which is required. This is very unusual. If you have made a custom PHP build you should install the PNG library and rebuild.

PHP does not have JPEG support built-into the GD library, which is required. This is very unusual. If you have made a custom PHP build you should install the PNG library and rebuild.

PHP does not have TTF support built-into the GD library, which is required. If you have made a custom PHP build you should install the FreeType2 library and rebuild. If you are using a third-party PHP build with unusual settings (such as those on MacOS), you should install an official PHP build.

it was able to login to the database and then on step 5 i get the following

File	'/var/www/html/sources/minikernel.php'
Line	'225'
Function	'get_html_trace'
Args

File	'/var/www/html/sources/minikernel.php'
Line	'342'
Function	'fatal_exit'
Args	'PHP [2] pg_num_fields() expects parameter 1 to be resource, boolean given'

Function	'composr_error_handler'
Args	2 'pg_num_fields() expects parameter 1 to be resource, boolean given' '/var/www/html/sources/database/postgresql.php' 386 array ( 'results' => false, 'start' => NULL, )

File	'/var/www/html/sources/database/postgresql.php'
Line	'386'
Function	'pg_num_fields'
Args	false

File	'/var/www/html/sources/database/postgresql.php'
Line	'355'
Function	'db_get_query_rows'
Class	'Database_Static_postgresql'
Object	Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), ))
Type	'->'
Args	false

File	'/var/www/html/sources/database.php'
Line	'1,305'
Function	'db_query'
Class	'Database_Static_postgresql'
Object	Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), ))
Type	'->'
Args	'SELECT m_name,m_table,m_type FROM cms_db_meta WHERE m_type LIKE \'SHORT_TRANS__COMCODE\' OR m_type LIKE \'LONG_TRANS__COMCODE\' OR m_type LIKE \'?SHORT_TRANS__COMCODE\' OR m_type LIKE \'?LONG_TRANS__COMCODE\'' NULL NULL NULL true false false false

File	'/var/www/html/sources/database.php'
Line	'1,080'
Function	'_query'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'SELECT m_name,m_table,m_type FROM cms_db_meta WHERE m_type LIKE \'SHORT_TRANS__COMCODE\' OR m_type LIKE \'LONG_TRANS__COMCODE\' OR m_type LIKE \'?SHORT_TRANS__COMCODE\' OR m_type LIKE \'?LONG_TRANS__COMCODE\'' NULL NULL true false NULL ''

File	'/var/www/html/sources/database.php'
Line	'143'
Function	'query'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'SELECT m_name,m_table,m_type FROM cms_db_meta WHERE m_type LIKE \'SHORT_TRANS__COMCODE\' OR m_type LIKE \'LONG_TRANS__COMCODE\' OR m_type LIKE \'?SHORT_TRANS__COMCODE\' OR m_type LIKE \'?LONG_TRANS__COMCODE\'' NULL NULL true

File	'/var/www/html/sources/database.php'
Line	'123'
Function	'reload_lang_fields'
Args

File	'/var/www/html/sources/database.php'
Line	'1,259'
Function	'_general_db_init'
Args

File	'/var/www/html/sources/database.php'
Line	'1,080'
Function	'_query'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'SELECT m_name,m_table,m_type FROM cms_db_meta WHERE m_type LIKE \'SHORT_TRANS__COMCODE\' OR m_type LIKE \'LONG_TRANS__COMCODE\' OR m_type LIKE \'?SHORT_TRANS__COMCODE\' OR m_type LIKE \'?LONG_TRANS__COMCODE\'' NULL NULL true false NULL ''

File	'/var/www/html/sources/database.php'
Line	'143'
Function	'query'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'SELECT m_name,m_table,m_type FROM cms_db_meta WHERE m_type LIKE \'SHORT_TRANS__COMCODE\' OR m_type LIKE \'LONG_TRANS__COMCODE\' OR m_type LIKE \'?SHORT_TRANS__COMCODE\' OR m_type LIKE \'?LONG_TRANS__COMCODE\'' NULL NULL true

File	'/var/www/html/sources/database.php'
Line	'123'
Function	'reload_lang_fields'
Args

File	'/var/www/html/sources/database.php'
Line	'1,259'
Function	'_general_db_init'
Args

File	'/var/www/html/sources/database.php'
Line	'929'
Function	'_query'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'SELECT c_value FROM cms_config WHERE (c_name LIKE \'is_on_block_cache\') ' 1 NULL true false array ( ) ''

File	'/var/www/html/sources/database.php'
Line	'858'
Function	'query_select'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'config' array ( 0 => 'c_value', ) array ( 'c_name' => 'is_on_block_cache', ) '' 1 NULL true NULL

File	'/var/www/html/install.php'
Line	'1,167'
Function	'query_select_value_if_there'
Class	'DatabaseConnector'
Object	DatabaseConnector::__set_state(array( 'table_prefix' => 'cms_', 'connection_read' => NULL, 'connection_write' => array ( 0 => false, 1 => 'cms', 2 => 'localhost', 3 => 'postgres', 4 => 'king98', 5 => false, ), 'text_lookup_original_cache' => array ( ), 'text_lookup_cache' => array ( ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_postgresql::__set_state(array( 'cache_db' => array ( 'cms' => array ( 'localhost' => NULL, ), ), )), 'dedupe_mode' => false, ))
Type	'->'
Args	'config' 'c_value' array ( 'c_name' => 'is_on_block_cache', ) '' true

File	'/var/www/html/install.php'
Line	'190'
Function	'step_5'
Args

Whats the URL For your site? I can check it out, CentOS is free to download the ISO from Download .  Do you have a dedicated server, or are you trying to host off your home computer? Have you installed MySQL?

Hi,

I'd definitely advise against using postgresql, as we don't officially support it (i.e. we have a database driver for it, but it's unsupported). We only regularly test on MySQL, and optimise for MySQL (or MariaDB if you like), and the other drivers are really now just there for large enterprises who are insistent on standardising on just one database system, and have significant resources.
I can see from what you wrote that it didn't work too . We'll fix that bug, and I may do a little cursory testing to make sure it at least installs for the next RC.

I can see it's saying GD's not there, which is weird as php5-gd was in that apt line. Not sure what's going on there. It complained about JPEG etc, but that all comes from GD, so that's only a single issue.

Also weird that MariaDB isn't starting up, I haven't used debian in a while, not sure what's going on there.

Let us know if you're still having issues, I see you're now in a private discussion with someone here helpful .

Best,
Chris

I am logged in, will take a look.  Do you have anything using sql currently, or can I reset the password?

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Hrmmm Not a good sign, Looks like a clean box so I will remove and reinstall sql to start

Ready for installation. Follow the directions
72.6.129.19/

HardTrancid said

Ready for installation. Follow the directions
72.6.129.19/

From “Post #893”, 31st July 2016, 3:57 am

72.6.129.19/install.php

Wierd. Cannot write to adminzone/pages/comcode_custom/EN. File permissions for it (or the directory it is in) have not been set correctly.  I'm root and confirmed perms. <shrug>

On custom servers one thing that can confuse with permissions is if selinux is installed. Assuming that directory really has been given 777 permissions.

Chris why would this error be showing?
Critical error – bailing out
The top-level configuration file (_config.php) appears to be corrupt. Perhaps it was incorrectly uploaded, or a typo was made. It must be valid PHP code.

Details here are intended only for the website/system-administrator, not for regular website users.
» If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to edit the installation options (the _config.php file).

I have ran the fix perms, config.php is not writeable it says….  I have chmod the file not to sure whats going on here

i'm working on a new install right now.

it finished.

the fresh install with the root password being the one you set on the other instance.

i have not done anything except actived the eth0 and created a kmw user account for myself.
there's no apache or mysql and i have not downloaded cms or anything else.
Please go through the tutorial and note any changes or additions that you wind up needing to do so it can be replicated.

thank you!

 

When I installed it on my server, Port 80 for Apache. I didnt run into any of the issues I saw on your box.  

I installed Apache, php, mysql, tried a clean install of composr… Keeps saying directories arent writeable… I also noticed that the installation archive isnt creating all the necessary files / folders. I ran the fixperms.sh and still some directories had to be manually added or changed, I'm sorry I cant figure out why it wont installl on your server, I got mine up rather quickly on CentOS, If you want to try give it a shot, the sql master / root passwd is the one I told you earlier. Good luck (Also adjusted iptables to allow access to sql, and added both apache and sql to startup)

thanks for all your help. guess something is a bit off. not sure what it is. thanks again. i will let you know if i figure it out.  cheers!

HardTrancid said

Chris why would this error be showing?
Critical error – bailing out
The top-level configuration file (_config.php) appears to be corrupt. Perhaps it was incorrectly uploaded, or a typo was made. It must be valid PHP code.

Details here are intended only for the website/system-administrator, not for regular website users.
» If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to edit the installation options (the _config.php file).

I have ran the fix perms, config.php is not writeable it says….  I have chmod the file not to sure whats going on here

From “Post #900”, 31st July 2016, 5:44 pm

I've checked and this error message is poorly worded (which we'll fix). The most likely scenario is running Composr before going through the installer – or reuploading a blank _config.php from the manual installer after installing.

Hi,

I'm having a hard time tracking this topic, but if you want to send me root SSH details to chris@ocproducts.com, and give me permission to make whatever server-level config changes are needed, I'll do my best to get it to install.

There won't be any charge, given there's been some bugginess so far. Most likely the core issue isn't a Composr bug, but I may learn something to document anyway.