Liferay install

Sep 28, 2007 12:00pm

ctdh 4 post(s)

Hi thanks for the great selection of stacks. I have been trying out the Liferay Linux stack which seems to go quite nicely until it tries to start up mysql – (there is already a version of mysql v4.1 on 3306 so I opted for 3305 during the setup). Not sure if you can offer any guidance…

Installing
0% ___ 50% ___ 100%
########################################Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password ‘new-password’
./bin/mysqladmin -u root -h ip-68-178-159-97.ip.secureserver.net password ‘new-password’
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
useradd: user mysql exists
/usr/local/liferay-0.9.3/mysql/../ctlscript.sh : mysql started
A mysqld process already exists

Error: There has been an error.
Error running /usr/local/liferay-0.9.3/mysql/bin/mysql -h 127.0.0.1 -P 3305 -u
root -pxxmypasswordwasinherexx -S ../tmp/mysql.sock -e “CREATE DATABASE liferay_bitnami;”
: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
Press [Enter] to continue : ERROR 2002 (HY000): Can’t connect to local MySQL ser ver through socket ’/usr/local/liferay-0.9.3/mysql/tmp/mysql.sock’ (2)
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/usr/loc al/liferay-0.9.3/mysql/tmp/mysql.sock’ (2)
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/usr/loc al/liferay-0.9.3/mysql/tmp/mysql.sock’ (2)

Sep 28, 2007 2:45pm

Pieter Administrator 18 post(s)

Hi.

Just a quick note to let you know that we are taking a look at the issue.

Pieter

Sep 29, 2007 12:39pm

beltran Administrator 371 post(s)

Hi.

Thanks for the feedback. We have released a new version of BitNami Liferay Stack that this issue is fixed.
In case you have any more comments, please do not hesitate to let us know.

Oct 2, 2007 12:58pm

ctdh 4 post(s)

Hi Beltran
Thanks for the patch.. I am now getting a slightly different error msg, any suggestions to the cause much appreciated:

Installing
0% ___ 50% ___ 100%
########################################/home/debignoc/liferay-0.9.4/mysql/scripts/ctl.s
h : mysql  started
Starting mysqld daemon with databases from /home/debignoc/liferay-0.9.4/mysql/data
STOPPING server from pid file /home/debignoc/liferay-0.9.4/mysql/data/ip-my-server.ip
.secureserver.net.pid
071002 06:02:59  mysqld ended

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/li
feray-0.9.4/mysql/tmp/mysql.sock’ (2)
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/li
feray-0.9.4/mysql/tmp/mysql.sock’ (2)
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/li
feray-0.9.4/mysql/tmp/mysql.sock’ (2)

Error: There has been an error.
Error running /home/debignoc/liferay-0.9.4/mysql/bin/mysql -h localhost -P 3005
-u root -pxxmypasswordwasinherexx -S ../tmp/mysql.sock -e “CREATE DATABASE
liferay_bitnami;” : ERROR 2002 (HY000): Can’t connect to local MySQL server
through socket ’../tmp/mysql.sock’ (2)
Press [Enter] to continue : [debignoc@ip-my-server~]$

Oct 2, 2007 1:13pm

antonio Administrator 485 post(s)

Hi ctdh,

Are you by a chance installing the stack as the root user? One of the other developers is currently taking a look into the issue. If you can, please send us your mysql log (antonio at bitnami dot org) so that we can check it to see what can be happening :)

PS: By the way, if you don’t mind I’m moving this post to the Liferay subforum

Oct 2, 2007 4:14pm

beltran Administrator 371 post(s)

Hi ctdh,

We’ve tried to reproduce the issue but we have not obtained any error during installation. If you can, please send us the file /home/debignoc/liferay-0.9.4/mysql/data/mysqld.log or you can try to connect to database:

$ home/debignoc/liferay-0.9.4/mysql/bin/mysql -h localhost -P 3005
-u root -pxxmypasswordwasinherexx -S /home/debignoc/liferay-0.9.4/mysql/tmp/mysql.sock

Thanks in advance.

Oct 2, 2007 8:44pm

ctdh 4 post(s)

Hi Beltran
I have sent the mysqld.log to Antonio
When I try the connection as you suggest I get the following error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/liferay-0.9.4/mysql/tmp/mysql.sock’ (2)
Charles

Oct 3, 2007 6:59am

antonio Administrator 485 post(s)

I’ll put the log here in case anyone is having the same problem:

071002 06:02:58 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
071002 6:02:58 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
071002 6:02:58 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
071002 6:02:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Cannot create doublewrite buffer: you must
InnoDB: increase your buffer pool size.
InnoDB: Cannot continue operation.
071002 06:02:59 mysqld ended
071002 06:30:41 mysqld started
071002 6:30:41 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
071002 6:30:41 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 8204.
InnoDB: Doing recovery: scanned up to log sequence number 0 8204
InnoDB: Page directory corruption: supremum not pointed to
071002 6:30:41 InnoDB: Page dump in ascii and hex (16384 bytes):

I have been investigating the issue, it may be related to
not having enough free memory. Could you check that out along with the
permissions in the mysql folder and all its subfolders?

Oct 28, 2007 3:11pm

ctdh 4 post(s)

Hi Antonio

Thanks for your help the other week I have re-provisioned the server with 512Mb (as per the min req spec!) and run the latest stack (4.3.3). mysql and tomcat all start up ok but there is no sign of the web app when I browse to it.

Charles

Oct 30, 2007 11:40am

antonio Administrator 485 post(s)

It seems that the default port we use (8080) doesn’t work. Using a different port solves the problem

Sep 28, 2007 12:00pm ctdh 4 post(s)	Hi thanks for the great selection of stacks. I have been trying out the Liferay Linux stack which seems to go quite nicely until it tries to start up mysql – (there is already a version of mysql v4.1 on 3306 so I opted for 3305 during the setup). Not sure if you can offer any guidance… `Installing 0% ___ 50% ___ 100% ########################################Installing MySQL system tables... OK Filling help tables... OK` To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password ‘new-password’ ./bin/mysqladmin -u root -h ip-68-178-159-97.ip.secureserver.net password ‘new-password’ See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com useradd: user mysql exists /usr/local/liferay-0.9.3/mysql/../ctlscript.sh : mysql started A mysqld process already exists Error: There has been an error. Error running /usr/local/liferay-0.9.3/mysql/bin/mysql -h 127.0.0.1 -P 3305 -u root -pxxmypasswordwasinherexx -S ../tmp/mysql.sock -e “CREATE DATABASE liferay_bitnami;” : ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111) Press [Enter] to continue : ERROR 2002 (HY000): Can’t connect to local MySQL ser ver through socket ’/usr/local/liferay-0.9.3/mysql/tmp/mysql.sock’ (2) ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/usr/loc al/liferay-0.9.3/mysql/tmp/mysql.sock’ (2) ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/usr/loc al/liferay-0.9.3/mysql/tmp/mysql.sock’ (2)

Sep 28, 2007 2:45pm Pieter Administrator 18 post(s)	Hi. Just a quick note to let you know that we are taking a look at the issue. Pieter

Sep 29, 2007 12:39pm beltran Administrator 371 post(s)	Hi. Thanks for the feedback. We have released a new version of BitNami Liferay Stack that this issue is fixed. In case you have any more comments, please do not hesitate to let us know.

Oct 2, 2007 12:58pm ctdh 4 post(s)	Hi Beltran Thanks for the patch.. I am now getting a slightly different error msg, any suggestions to the cause much appreciated: `Installing 0% ___ 50% ___ 100% ########################################/home/debignoc/liferay-0.9.4/mysql/scripts/ctl.s h : mysql started Starting mysqld daemon with databases from /home/debignoc/liferay-0.9.4/mysql/data STOPPING server from pid file /home/debignoc/liferay-0.9.4/mysql/data/ip-my-server.ip .secureserver.net.pid 071002 06:02:59 mysqld ended` ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/li feray-0.9.4/mysql/tmp/mysql.sock’ (2) ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/li feray-0.9.4/mysql/tmp/mysql.sock’ (2) ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/li feray-0.9.4/mysql/tmp/mysql.sock’ (2) Error: There has been an error. Error running /home/debignoc/liferay-0.9.4/mysql/bin/mysql -h localhost -P 3005 -u root -pxxmypasswordwasinherexx -S ../tmp/mysql.sock -e “CREATE DATABASE liferay_bitnami;” : ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’../tmp/mysql.sock’ (2) Press [Enter] to continue : [debignoc@ip-my-server~]$

Oct 2, 2007 1:13pm antonio Administrator 485 post(s)	Hi ctdh, Are you by a chance installing the stack as the root user? One of the other developers is currently taking a look into the issue. If you can, please send us your mysql log (antonio at bitnami dot org) so that we can check it to see what can be happening :) PS: By the way, if you don’t mind I’m moving this post to the Liferay subforum

Oct 2, 2007 4:14pm beltran Administrator 371 post(s)	Hi ctdh, We’ve tried to reproduce the issue but we have not obtained any error during installation. If you can, please send us the file /home/debignoc/liferay-0.9.4/mysql/data/mysqld.log or you can try to connect to database: $ home/debignoc/liferay-0.9.4/mysql/bin/mysql -h localhost -P 3005 -u root -pxxmypasswordwasinherexx -S /home/debignoc/liferay-0.9.4/mysql/tmp/mysql.sock Thanks in advance.

Oct 2, 2007 8:44pm ctdh 4 post(s)	Hi Beltran I have sent the mysqld.log to Antonio When I try the connection as you suggest I get the following error: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/home/debignoc/liferay-0.9.4/mysql/tmp/mysql.sock’ (2) Charles

Oct 3, 2007 6:59am antonio Administrator 485 post(s)	I’ll put the log here in case anyone is having the same problem: 071002 06:02:58 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 071002 6:02:58 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait… 071002 6:02:58 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 071002 6:02:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB: Doublewrite buffer not found: creating new InnoDB: Cannot create doublewrite buffer: you must InnoDB: increase your buffer pool size. InnoDB: Cannot continue operation. 071002 06:02:59 mysqld ended 071002 06:30:41 mysqld started 071002 6:30:41 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 071002 6:30:41 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 8204. InnoDB: Doing recovery: scanned up to log sequence number 0 8204 InnoDB: Page directory corruption: supremum not pointed to 071002 6:30:41 InnoDB: Page dump in ascii and hex (16384 bytes): I have been investigating the issue, it may be related to not having enough free memory. Could you check that out along with the permissions in the mysql folder and all its subfolders?

Oct 28, 2007 3:11pm ctdh 4 post(s)	Hi Antonio Thanks for your help the other week I have re-provisioned the server with 512Mb (as per the min req spec!) and run the latest stack (4.3.3). mysql and tomcat all start up ok but there is no sign of the web app when I browse to it. Charles

Oct 30, 2007 11:40am antonio Administrator 485 post(s)	It seems that the default port we use (8080) doesn’t work. Using a different port solves the problem

Voices