From: Jan S. <st...@an...> - 2013-05-22 10:52:07
|
Hi Longina, Am 22.05.2013 12:24, schrieb Longina Przybyszewska: > Hi, > > I run into strange problems – after rebooting openqrm node, apache > doesn’t start. > > Openqrm runs in HA setup > > Drbd/fs/ip/Mysqld started > > In apache2.log: > > [Wed May 22 10:53:57 2013] [error] [client 10.123.2.11] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > > [Wed May 22 10:53:57 2013] [error] [client 10.123.2.11] PHP Fatal > error: Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on > line 112 > > [Wed May 22 10:53:57 2013] [error] [client 10.112.9.249] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383, referer: > http://10.123.2.7/openqrm/base/index.php?base=event&event_filter=active&event_action=select&event_msg=Acknowledged%20Event%2013691453905083%3Cbr%3E > > [Wed May 22 10:53:57 2013] [error] [client 10.112.9.249] PHP Fatal > error: Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on > line 112, referer: > http://10.123.2.7/openqrm/base/index.php?base=event&event_filter=active&event_action=select&event_msg=Acknowledged%20Event%2013691453905083%3Cbr%3E > > [Wed May 22 10:53:58 2013] [error] [client 10.123.2.10] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > > Any ideas? It Hasn’t happen before – > > Mysqld is configured to have db on drbd disk /usr/share/openqrm/mysql > > /var/run/mysqld/mysqld.sock exists; is configured to be on local disk. > > I restarted node in crm maintenance-mode with ‘reboot –f’ > > End part of dmesg| less > > [ 16.159785] init: isc-dhcp-server main process ended, respawning > > [ 16.242126] init: isc-dhcp-server main process (1790) terminated with > status 1 > > [ 16.242155] init: isc-dhcp-server main process ended, respawning > > [ 16.319068] init: isc-dhcp-server main process (1797) terminated with > status 1 > > [ 16.319099] init: isc-dhcp-server main process ended, respawning > > [ 16.386298] init: isc-dhcp-server main process (1804) terminated with > status 1 > > [ 16.386324] init: isc-dhcp-server respawning too fast, stopped > > [ 16.525636] init: mysql post-start process (1514) terminated with > status 1 > > [ 16.544234] init: mysql main process (1945) terminated with status 1 > > [ 16.544263] init: mysql main process ended, respawning > > [ 17.549385] init: mysql post-start process (1946) terminated with > status 1 > > [ 17.567173] init: mysql main process (2011) terminated with status 1 > > [ 17.567201] init: mysql respawning too fast, stopped > > [ 20.282092] IPv6: ADDRCONF(NETDEV_CHANGE): ib0: link becomes ready > > If I start apache manually have again access to openqrm. what is the status of drbd-overview and /proc/drbd ? BR Jan |
From: Longina P. <lo...@sd...> - 2013-07-10 11:55:00
|
och.. I tried then webssh and it didn't work either (got window with About:blank on top and connecting to 10.123.2.x in the bottom). I rebooted finally openqrm active node and now apache doesn't start: it says (in error.log below...) I can see that resources integrated into openqrm try to reach mysql - I enabled mysql only on local 127.0.0.1 interface - may be this is the reason for my problems? Should mysqld listen on eth0:ha as well? However, I could start apache manually... /var/log/apache2/error.log ______________ [Wed Jul 10 12:55:13 2013] [error] [client 10.123.2.11] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.11] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.11] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.10] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.10] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:55:22 2013] [error] [client 10.123.2.8] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:55:22 2013] [error] [client 10.123.2.8] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 Wed Jul 10 12:53:58 2013] [error] [client 10.112.9.249] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112, referer: http://10.123.2.7/openqrm/base/index.php?plugin=sshterm&controller=sshterm-about [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.11] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.11] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.10] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.10] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:54:01 2013] [error] [client 10.123.2.8] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:54:01 2013] [error] [client 10.123.2.8] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:54:02 2013] [error] [client 10.123.2.11] PHP Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 [Wed Jul 10 12:54:02 2013] [error] [client 10.123.2.11] PHP Fatal error: Call to a member function SetFetchMode() on a non-object in /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line 112 [Wed Jul 10 12:54:05 2013] [error] [client 10.112.9.249] PHP Warning: mysql_pconnect(): Can't connect Mysql has started correct with the following config parameters, on the same active node: 130710 13:01:11 [Note] Plugin 'FEDERATED' is disabled. 130710 13:01:11 InnoDB: The InnoDB memory heap is disabled 130710 13:01:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130710 13:01:11 InnoDB: Compressed tables use zlib 1.2.3.4 130710 13:01:11 InnoDB: Initializing buffer pool, size = 128.0M 130710 13:01:11 InnoDB: Completed initialization of buffer pool 130710 13:01:11 InnoDB: highest supported file format is Barracuda. 130710 13:01:12 InnoDB: Waiting for the background threads to start 130710 13:01:13 InnoDB: 5.5.31 started; log sequence number 118423939 130710 13:01:13 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 130710 13:01:13 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 130710 13:01:13 [Note] Server socket created on IP: '127.0.0.1'. 130710 13:01:13 [Note] Event Scheduler: Loaded 0 events 130710 13:01:13 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.31-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) -------------------------- /etc/my.conf .... [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr #datadir = /var/lib/mysql datadir = /usr/share/openqrm/mysql_drbd/data tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking ... best, longina -- Longina Przybyszewska IT-Service, University of Southern Denmark, Campusvej 55, DK-5230 Odense M, Denmark Phone Direct: +45 6550 2359 -- |
From: Longina P. <lo...@sd...> - 2013-07-10 14:24:51
|
I figured out why apache doesn't start at reboot - sorry for sending garbage to mailing list . best Longina On Wed, 10 Jul 2013, Longina Przybyszewska wrote: > och.. I tried then webssh and it didn't work either (got window with > About:blank on top and connecting to 10.123.2.x in the bottom). > > I rebooted finally openqrm active node and now apache doesn't start: > it says (in error.log below...) > > I can see that resources integrated into openqrm try to reach mysql - > I enabled mysql only on local 127.0.0.1 interface - may be this is the > reason for my problems? Should mysqld listen on eth0:ha as well? > > However, I could start apache manually... > > /var/log/apache2/error.log > ______________ > [Wed Jul 10 12:55:13 2013] [error] [client 10.123.2.11] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.11] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.11] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.10] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:55:20 2013] [error] [client 10.123.2.10] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:55:22 2013] [error] [client 10.123.2.8] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:55:22 2013] [error] [client 10.123.2.8] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > > > Wed Jul 10 12:53:58 2013] [error] [client 10.112.9.249] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112, referer: > http://10.123.2.7/openqrm/base/index.php?plugin=sshterm&controller=sshterm-about > [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.11] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.11] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.10] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:54:00 2013] [error] [client 10.123.2.10] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:54:01 2013] [error] [client 10.123.2.8] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:54:01 2013] [error] [client 10.123.2.8] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:54:02 2013] [error] [client 10.123.2.11] PHP Warning: > mysql_pconnect(): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) in > /usr/share/php/adodb/drivers/adodb-mysql.inc.php on line 383 > [Wed Jul 10 12:54:02 2013] [error] [client 10.123.2.11] PHP Fatal error: > Call to a member function SetFetchMode() on a non-object in > /usr/share/openqrm/web/base/include/openqrm-database-functions.php on line > 112 > [Wed Jul 10 12:54:05 2013] [error] [client 10.112.9.249] PHP Warning: > mysql_pconnect(): Can't connect > > > Mysql has started correct with the following config parameters, on the > same active node: > > 130710 13:01:11 [Note] Plugin 'FEDERATED' is disabled. > 130710 13:01:11 InnoDB: The InnoDB memory heap is disabled > 130710 13:01:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 130710 13:01:11 InnoDB: Compressed tables use zlib 1.2.3.4 > 130710 13:01:11 InnoDB: Initializing buffer pool, size = 128.0M > 130710 13:01:11 InnoDB: Completed initialization of buffer pool > 130710 13:01:11 InnoDB: highest supported file format is Barracuda. > 130710 13:01:12 InnoDB: Waiting for the background threads to start > 130710 13:01:13 InnoDB: 5.5.31 started; log sequence number 118423939 > 130710 13:01:13 [Note] Server hostname (bind-address): '127.0.0.1'; port: > 3306 > 130710 13:01:13 [Note] - '127.0.0.1' resolves to '127.0.0.1'; > 130710 13:01:13 [Note] Server socket created on IP: '127.0.0.1'. > 130710 13:01:13 [Note] Event Scheduler: Loaded 0 events > 130710 13:01:13 [Note] /usr/sbin/mysqld: ready for connections. > Version: '5.5.31-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' > port: 3306 (Ubuntu) > > -------------------------- > /etc/my.conf > .... > [client] > port = 3306 > socket = /var/run/mysqld/mysqld.sock > > # Here is entries for some specific programs > # The following values assume you have at least 32M ram > > # This was formally known as [safe_mysqld]. Both versions are currently > parsed. > [mysqld_safe] > socket = /var/run/mysqld/mysqld.sock > nice = 0 > > [mysqld] > # > # * Basic Settings > # > user = mysql > pid-file = /var/run/mysqld/mysqld.pid > socket = /var/run/mysqld/mysqld.sock > port = 3306 > basedir = /usr > #datadir = /var/lib/mysql > datadir = /usr/share/openqrm/mysql_drbd/data > tmpdir = /tmp > lc-messages-dir = /usr/share/mysql > skip-external-locking > ... > > > > best, > longina > > -- Longina Przybyszewska IT-Service, University of Southern Denmark, Campusvej 55, DK-5230 Odense M, Denmark Phone Direct: +45 6550 2359 -- |