Mysql Installation Problem

General discussion forum for the Zend Server
djodu69
Posts: 1
Joined: Thu Nov 12, 2009 5:30 pm

Mysql Installation Problem

Post by djodu69 » Thu Nov 12, 2009 5:33 pm

Hello,

I installed Zend Server CE on Snow Leopard.
But i have a problem when i want to start Mysql server.
I have this error : sudo /usr/local/zend/bin/zendctl.sh start-mysql
Starting MySQL
. ERROR! Manager of pid-file quit without updating file.

I don't what to do ??

thank you in advance

Djo

jonbjork
Posts: 1
Joined: Sun Apr 12, 2009 3:59 pm

Re: Mysql Installation Problem

Post by jonbjork » Mon Nov 16, 2009 11:58 am

I have the same problem.
Please Zend can't you put some effort in fixing Zend Server CE for Snow Leopard!?

/Jonas

smithdg
Posts: 41
Joined: Sun Mar 22, 2009 3:32 am

Re: Mysql Installation Problem

Post by smithdg » Mon Nov 16, 2009 10:32 pm

I am having the same problem as well.

massimilianoc
Posts: 699
Joined: Thu Mar 12, 2009 11:58 am

Re: Mysql Installation Problem

Post by massimilianoc » Tue Nov 17, 2009 12:35 pm

Are you working with Zend Server CE 4.0.6 (which was released yesterday evening)?

If not, please try installing 4.0.6 and let us know the outcomes.

Thanks for the cooperation.
Best regards,
Massi.

dodig
Posts: 26
Joined: Thu Mar 05, 2009 2:53 pm

Re: Mysql Installation Problem

Post by dodig » Wed Nov 18, 2009 2:57 pm

This problem is due to mysql PID file being hostname based.
For example, if I change from wired to wireless network or go to completely different network, hostname on my MacBook Pro changes.
That is why zendctl.sh can't find the mysql PID file. You either have to connect to the network you were on when mysql was started and stop it with zendctl.sh or kill it manually.
I think this is ZendServer bug, and it should be fixed either by not having hostname based mysql PID file or by remembering the PID file name on start and then using that for stoping the mysql.
Best regards,
Goran Dodig

EDIT:
Now I realized, this is a different problem I'm refering to - it's related to not being able to stop mysql server.
Your question was refering to not being able to start it.

massimilianoc
Posts: 699
Joined: Thu Mar 12, 2009 11:58 am

Re: Mysql Installation Problem

Post by massimilianoc » Thu Nov 19, 2009 4:05 pm

By default, Zend Server communicates with MySQL through socket, which of course, works on any network your machine is connected to.

You must have changed something in the configurations, or maybe there is another instance of MySQL interfering.

Could you elaborate more on how you got to this point?
Best regards,
Massi.

smithdg
Posts: 41
Joined: Sun Mar 22, 2009 3:32 am

Re: Mysql Installation Problem

Post by smithdg » Thu Nov 19, 2009 6:25 pm

This now works GREAT! Thanks, guys, I have installed it on two different computers with 10.6 with no problems. Keep up the good work.

efrancis76
Posts: 6
Joined: Sun Nov 22, 2009 9:43 am

Re: Mysql Installation Problem

Post by efrancis76 » Sun Nov 22, 2009 9:47 am

The problem persist on my computer:

specs:
- newly downloaded and installed zend server CE 4.0.6 with php 5.3
- snow leopard 10.6.2
- no changes to mysql settings
- changed apache to listen at port 80 instead of 10088, no other changes
- no other mysql running

When running: ./zendctl.sh start-mysql

Starting MySQL
. ERROR! Manager of pid-file quit without updating file.


And when running: ./zendctl.sh status

Apache is up and running.. [OK]
/usr/local/zend/mysql/bin/mysql.server: line 418: pidof: command not found
ERROR! MySQL is not running
[22.11.2009 09:48:12 SYSTEM] watchdog for lighttpd is running.
[22.11.2009 09:48:12 SYSTEM] lighttpd is running.
[22.11.2009 09:48:12 SYSTEM] watchdog for java_daemon is running.
[22.11.2009 09:48:12 SYSTEM] java_daemon is running.


Any help would be greatly appreciated.

jess04
Posts: 628
Joined: Thu Jan 15, 2009 3:37 pm

Re: Mysql Installation Problem

Post by jess04 » Sun Nov 22, 2009 3:27 pm

Hello,

Can it be that you changed permissions on /usr/local/zend/mysql/data?

Please run:

Code: Select all

# ls -ald /usr/local/zend/mysql/data
Should be similar to:

Code: Select all

drwxr-x---  11 zend  wheel  374 Nov 22 16:19 /usr/local/zend/mysql/data
Also:

Code: Select all

# ls -al /usr/local/zend/mysql/data/*
Which should output something along the lines of:

Code: Select all

-rw-r--r--   1 zend  wheel       905 Nov 22 16:08 /usr/local/zend/mysql/data/config.ini
-rw-rw----   1 zend  wheel   5242880 Nov 22 16:19 /usr/local/zend/mysql/data/ib_logfile0
-rw-rw----   1 zend  wheel   5242880 Nov 22 16:18 /usr/local/zend/mysql/data/ib_logfile1
-rw-rw----   1 zend  wheel  10485760 Nov 22 16:19 /usr/local/zend/mysql/data/ibdata1
-rw-r--r--   1 zend  wheel      2460 Nov 22 16:08 /usr/local/zend/mysql/data/my.cnf
drwxr-x---  71 zend  wheel      2414 Nov 22 16:18 /usr/local/zend/mysql/data/mysql
-rw-rw----   1 zend  wheel      3442 Nov 22 16:19 /usr/local/zend/mysql/data/qa-imac.zend.net.err
-rw-rw----   1 zend  wheel         6 Nov 22 16:19 /usr/local/zend/mysql/data/qa-imac.zend.net.pid
drwxr-x---   2 zend  wheel        68 Nov 22 16:08 /usr/local/zend/mysql/data/test
And paste the output here, should be:
May the source be with you,

Jess Portnoy

efrancis76
Posts: 6
Joined: Sun Nov 22, 2009 9:43 am

Re: Mysql Installation Problem

Post by efrancis76 » Sun Nov 22, 2009 5:16 pm

I didn't change any permissions, well not at first anyway. Afterwards I did in order to see the my.cnf file from Finder. But I put everything back the way it was, and the problem persists:

Code: Select all

sh-3.2# ls -ald /usr/local/zend/mysql/data
drwxr-x---  10 zend  wheel  340 Nov 22 10:16 /usr/local/zend/mysql/data

sh-3.2# ls -al /usr/local/zend/mysql/data/*
-rw-r--r--  1 zend  wheel       905 Nov 15 10:27 /usr/local/zend/mysql/data/config.ini
-rw-rw----  1 zend  wheel   5242880 Nov 22 10:16 /usr/local/zend/mysql/data/ib_logfile0
-rw-rw----  1 zend  wheel   5242880 Nov 21 20:12 /usr/local/zend/mysql/data/ib_logfile1
-rw-rw----  1 zend  wheel  10485760 Nov 21 20:12 /usr/local/zend/mysql/data/ibdata1
-rw-rw----  1 zend  wheel     10673 Nov 22 10:16 /usr/local/zend/mysql/data/mac-pro.fritz.box.err
-rw-r--r--  1 zend  wheel      2460 Nov 15 10:27 /usr/local/zend/mysql/data/my.cnf

/usr/local/zend/mysql/data/mysql:
total 0
drwxr-x---   2 zend  wheel   68 Nov 15 10:27 .
drwxr-x---  10 zend  wheel  340 Nov 22 10:16 ..

/usr/local/zend/mysql/data/test:
total 0
drwxr-x---   2 zend  wheel   68 Nov 15 10:27 .
drwxr-x---  10 zend  wheel  340 Nov 22 10:16 ..
Also interesting is the *.err file in data. Whenever I try to run mysql, I get the following:

Code: Select all

091122 17:09:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/zend/mysql/data
091122 17:09:07 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/zend/mysql/data/ is case insensitive
091122 17:09:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/zend/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
091122 17:09:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
091122 17:09:07  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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
091122 17:09:07  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
091122 17:09:07  InnoDB: Started; log sequence number 0 44233
091122 17:09:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
091122 17:09:07 mysqld_safe mysqld from pid file /usr/local/zend/mysql/data/mac-pro.fritz.box.pid ended
I tried to run mysql_upgrade as it says in this log file. The result is the following:

Code: Select all

sh-3.2# ./mysql_upgrade
Looking for 'mysql' as: ./mysql
Looking for 'mysqlcheck' as: ./mysqlcheck
Running 'mysqlcheck with default connection arguments
./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
sh-3.2# 

Post Reply