LAMP stack Wordpress Module Installation MySQL Issue

sean_cornell 2017-04-02 17:45:08 UTC #1

Hi guys,

This is driving me a bit insane... i've today installed the Wordpress module on your LAMP stack 3 times with out issue. As soon as i start the 4th install, and i'm prompted for the MySQL admin password (which I know 100% is correct) the insall fails unable to connect to MySQL.

I can 'sudo mysql -u root -p' and the password works as expected

Here is the bitrock_installer log output:

Log started 04/02/2017 at 17:20:19
Preferred installation mode : qt
Trying to init installer in mode qt
Trying to init installer in mode qt
Trying to init installer in mode gtk
Trying to init installer in mode xwindow
Trying to init installer in mode text
Mode text successfully initialized
Executing /opt/bitnami/mysql/bin/mysql -u root -p**** -P3306 -hlocalhost -e "show databases;"

Script exit code:

Script output:

Script stderr:

Unknown error while running /opt/bitnami/mysql/bin/mysql -u root -p**** -P3306 -hlocalhost -e "show databases;"

Is there a 3 module limit?

Any help is greatly appreciated!

Thanks,

Sean

tomasp 2017-04-04 12:58:55 UTC #2

Hello Sean,

I guess you are following this guide to install several wordpress instances in the same stack. Am I right?

There should not be any limit by default so you should be able to install the 4th wordpress module. Could you check if the services are running before start the installation? You can use the following command:

$ sudo /opt/bitnami/ctlscript.sh status

If they are running and you get the same error, could you please send us the mysql error log? It is located at /opt/bitnami/mysql/data/mysqld.log

Regards,
Tomas

sean_cornell 2017-04-04 13:22:31 UTC #3

Hi Tomas,

Thanks for coming back to me!

I just tried the installer again with the same unsuccessful results. I confirmed all the services are running - I should note the other 3 sites are operating perfectly.

The log /opt/bitnami/mysql/data/mysqld.log is currently empty, however i do see a gz file from the 2nd... which when I download and open is also empty...

tomasp 2017-04-05 11:37:29 UTC #4

Hello,

That is really weird. I just tried and I stopped at the 5ht module. No issues found.

Can you try this command manually?

 $ /opt/bitnami/mysql/bin/mysql -u root -pYOUR_ROOT_PASSWORD -P3306 -hlocalhost -e "show databases;"

Please remember to edit the placeholder YOUR_ROOT_PASSWORD for your real value.

Could you also run the following command to check the content of your mariadb data folder? The log file should not be empty so maybe it was created with a different name.

$ ls -alhrt /opt/bitnami/mysql/data/

Regards,
Tomas

sean_cornell 2017-04-08 10:54:13 UTC #5

Hi Tom,

I had tested the MySQL connectivity and it is all fine. That command executes as expected:

sean_cornell 2017-04-08 10:54:46 UTC #6

Contents of data folder:

sean_cornell 2017-04-08 11:10:00 UTC #7

Some more info on the particular stack:

[MySQL]
mysql_port=3306
mysql_host=localhost
mysql_root_directory=/opt/bitnami/mysql
mysql_binary_directory=/opt/bitnami/mysql/bin
mysql_data_directory=/opt/bitnami/mysql/data
mysql_configuration_directory=/opt/bitnami/mysql
mysql_arguments=-u root -S /opt/bitnami/mysql/tmp/mysql.sock
mysql_socket=/opt/bitnami/mysql/tmp/mysql.sock
mysql_version=5.6.34
mysql_database_type=mysql
[PHP]
php_fpm_socket=/opt/bitnami/php/var/run/www.sock
php_binary_directory=/opt/bitnami/php/bin
php_configuration_directory=/opt/bitnami/php/etc
php_extensions_directory=/opt/bitnami/php/lib/php/extensions
php_version=5.6.27
[General]
installdir=/opt/bitnami
base_stack_name=Bitnami LAMP Stack
base_stack_key=lampstack
base_stack_version=5.6.27-0
base_stack_platform=linux-x64
base_stack_service=
require_root_privileges=1

and the command I am running:

sudo ./bitnami-wordpress-4.7.3-0-module-linux-x64-installer.run --wordpress_instance_name builders

sean_cornell 2017-04-08 11:19:02 UTC #8

I got it to work... I have no idea what I did though! I've a couple to add to I will see if I can replicate the fix

Basically the main difference from when it wasn't working is that when I entered the MySQL root password it could been seen as clear text, when it was hidden it worked as expected.

I think I simply pressed the enter key several times in quick succession in frustration..

tomasp 2017-04-10 10:56:16 UTC #9

We are glad that you were able to fix the issue. If you have any other questions, please do not hesitate to let us know.

Tomas

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!