urgently need help for Site off-line error
dear drupal support,i installed and configure my drupal site in local ubuntu pc. it has been working fine, but after i reboot the pc, it shows the below error message and can never login to the site to browse the pages. Site off-line The site is currently not available due to technical problems. Please try again later. Thank you for your understanding. ------------------------------ If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook<http://drupal.org/node/258>, or contact your hosting provider. i login to OS and run mysql, but got the "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" error message. i try to login though phpmyadmin, but couldn't login there as well. in the /var/log/apache2/error.log file, there is below output: [Wed Nov 03 21:23:25 2010] [notice] Apache/2.2.14 (Ubuntu) DAV/2 mod_fcgid/2.3.4 PHP/5.3.2-1ubuntu4.5 with Suhosin-Patch mod_ruby/1.2.6 Ruby/1.8.7(2010-01-10) mod_ssl/2.2.14 OpenSSL/0.9.8k configured -- resuming normal operations [Wed Nov 03 21:24:17 2010] [error] [client 192.168.35.103] PHP Fatal error: Call to undefined function _system_theme_data() in /var/www/includes/theme.inc on line 481 [Wed Nov 03 21:24:20 2010] [error] [client 192.168.35.103] File does not exist: /var/www/favicon.ico in the /var/log/mysql/error.log file, there is below output: 101103 22:35:28 [Note] Plugin 'FEDERATED' is disabled. 101103 22:35:28 InnoDB: Started; log sequence number 0 44233 101103 22:35:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist it is much appreciated if you can help with this. thanks, qiubo su
Sounds like MySQL didn't start when you rebooted. Type: sudo /etc/init.d/mysql start In a terminal and see what happens. Jamie Holly http://www.intoxination.net http://www.hollyit.net On 11/3/2010 6:09 AM, Qiubo Su (David Su) wrote:
dear drupal support,
i installed and configure my drupal site in local ubuntu pc. it has been working fine, but after i reboot the pc, it shows the below error message and can never login to the site to browse the pages.
Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.
------------------------------------------------------------------------
If you are the maintainer of this site, please check your database settings in the |settings.php| file and ensure that your hosting provider's database server is running. For more help, see the handbook <http://drupal.org/node/258>, or contact your hosting provider.
i login to OS and run mysql, but got the "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" error message.
i try to login though phpmyadmin, but couldn't login there as well.
in the /var/log/apache2/error.log file, there is below output:
[Wed Nov 03 21:23:25 2010] [notice] Apache/2.2.14 (Ubuntu) DAV/2 mod_fcgid/2.3.4 PHP/5.3.2-1ubuntu4.5 with Suhosin-Patch mod_ruby/1.2.6 Ruby/1.8.7(2010-01-10) mod_ssl/2.2.14 OpenSSL/0.9.8k configured -- resuming normal operations [Wed Nov 03 21:24:17 2010] [error] [client 192.168.35.103] PHP Fatal error: Call to undefined function _system_theme_data() in /var/www/includes/theme.inc on line 481 [Wed Nov 03 21:24:20 2010] [error] [client 192.168.35.103] File does not exist: /var/www/favicon.ico
in the /var/log/mysql/error.log file, there is below output:
101103 22:35:28 [Note] Plugin 'FEDERATED' is disabled. 101103 22:35:28 InnoDB: Started; log sequence number 0 44233 101103 22:35:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
it is much appreciated if you can help with this.
thanks, qiubo su
hello drupal support team, thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again. root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) On Thu, Nov 4, 2010 at 1:34 AM, Jamie Holly <hovercrafter@earthlink.net>wrote:
Sounds like MySQL didn't start when you rebooted. Type:
sudo /etc/init.d/mysql start
In a terminal and see what happens.
Jamie Hollyhttp://www.intoxination.net http://www.hollyit.net
On 11/3/2010 6:09 AM, Qiubo Su (David Su) wrote:
dear drupal support, i installed and configure my drupal site in local ubuntu pc. it has been working fine, but after i reboot the pc, it shows the below error message and can never login to the site to browse the pages. Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding. ------------------------------
If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook<http://drupal.org/node/258>, or contact your hosting provider.
i login to OS and run mysql, but got the "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" error message. i try to login though phpmyadmin, but couldn't login there as well.
in the /var/log/apache2/error.log file, there is below output:
[Wed Nov 03 21:23:25 2010] [notice] Apache/2.2.14 (Ubuntu) DAV/2 mod_fcgid/2.3.4 PHP/5.3.2-1ubuntu4.5 with Suhosin-Patch mod_ruby/1.2.6 Ruby/1.8.7(2010-01-10) mod_ssl/2.2.14 OpenSSL/0.9.8k configured -- resuming normal operations [Wed Nov 03 21:24:17 2010] [error] [client 192.168.35.103] PHP Fatal error: Call to undefined function _system_theme_data() in /var/www/includes/theme.inc on line 481 [Wed Nov 03 21:24:20 2010] [error] [client 192.168.35.103] File does not exist: /var/www/favicon.ico
in the /var/log/mysql/error.log file, there is below output:
101103 22:35:28 [Note] Plugin 'FEDERATED' is disabled. 101103 22:35:28 InnoDB: Started; log sequence number 0 44233 101103 22:35:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
it is much appreciated if you can help with this.
thanks, qiubo su
-- [ Drupal support list | http://lists.drupal.org/ ]
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M. -- Michel 'ZioBudda' Morelli michel@ziobuddalabs.it Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN: michel@ziobuddalabs.it JABBER: michel@ziobuddalabs.it
dear drupal support, "/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already. but after run /etc/init.d/mysql start, still got below output Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql mysql start/running run mysql, still got below output as well ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) tail -10f /var/log/mysql/error.log, still got the same error 101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist by the way, the server use dynamic IP address and the /etc/network/interfaces is as below auto lo iface lo inet loopback On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it>wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel 'ZioBudda' Morelli michel@ziobuddalabs.it Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_buddahttp://www.ziodrupal.net MSN: michel@ziobuddalabs.it JABBER: michel@ziobuddalabs.it
The log is telling you that the users table doesn't exist. I don't know how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like apt-get install --reinstall mysql-server On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> JABBER:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>
hello Christopher, i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)". i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error. i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem. On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones@partialflow.com
wrote:
The log is telling you that the users table doesn't exist. I don't know how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to
an
Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto: michel@ziobuddalabs.it> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <MSN%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
JABBER:michel@ziobuddalabs.it <JABBER%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
-- [ Drupal support list | http://lists.drupal.org/ ]
Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to: (1) Turn off the firewall (2) Try to make your connection (3) Regardless of the outcome of (2), immediately turn the firewall back on. -- Mike
From: Qiubo Su (David Su) <qiubosu@gmail.com> To: support@drupal.org; cjones@partialflow.com Sent: Thu, November 4, 2010 1:59:15 PM Subject: Re: [support] urgently need help for Site off-line error
helloChristopher,
i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones@partialflow.com> wrote:
The log is telling you that the users table doesn't exist. I don't know
how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it
<mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>
Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> JABBER:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>
--
[ Drupal support list | http://lists.drupal.org/ ]
Check the memory assigned to the VM and make sure it is enough to start all the processes. If it turns out that this is the case, you should be able to allocate additional memory for that VM process in its configuration. What is the base system? Victor On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <jm_hannon@yahoo.com> wrote:
Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to:
(1) Turn off the firewall (2) Try to make your connection (3) Regardless of the outcome of (2), immediately turn the firewall back on.
-- Mike
*From:* Qiubo Su (David Su) <qiubosu@gmail.com> *To:* support@drupal.org; cjones@partialflow.com *Sent:* Thu, November 4, 2010 1:59:15 PM *Subject:* Re: [support] urgently need help for Site off-line error
hello Christopher,
i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones < cjones@partialflow.com> wrote:
The log is telling you that the users table doesn't exist. I don't know how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to
an
Upstart job, you may also use the start(8) utility, e.g. start
mysql
start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto: michel@ziobuddalabs.it> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <MSN%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
JABBER:michel@ziobuddalabs.it <JABBER%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
hello victor, i did notice this and update the base memory RAM to 1G. it is ubuntu 10.0.4. On Fri, Nov 5, 2010 at 11:23 AM, Victor Kane <victorkane@gmail.com> wrote:
Check the memory assigned to the VM and make sure it is enough to start all the processes.
If it turns out that this is the case, you should be able to allocate additional memory for that VM process in its configuration.
What is the base system?
Victor
On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <jm_hannon@yahoo.com>wrote:
Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to:
(1) Turn off the firewall (2) Try to make your connection (3) Regardless of the outcome of (2), immediately turn the firewall back on.
-- Mike
*From:* Qiubo Su (David Su) <qiubosu@gmail.com> *To:* support@drupal.org; cjones@partialflow.com *Sent:* Thu, November 4, 2010 1:59:15 PM *Subject:* Re: [support] urgently need help for Site off-line error
hello Christopher,
i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones < cjones@partialflow.com> wrote:
The log is telling you that the users table doesn't exist. I don't know how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli < michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this
again.
root@quicksu-desktop:/var/www/sites/all/modules#
/etc/init.d/mysql
start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted
to an
Upstart job, you may also use the start(8) utility, e.g. start
mysql
start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto: michel@ziobuddalabs.it> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <MSN%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
JABBER:michel@ziobuddalabs.it <JABBER%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
netstat -a shows open or waiting connections. Run this to see if mysql or port 3306 is in the list. nmap will show open ports on a server Could be permissions issues. Sounds like mysql might be running already. What does the following command show show? ps aux |grep mysql|grep -v grep If it returns anything mysql already started up Google is usually the place I look to solve crazy mysql issues. http://www.linuxforums.org/forum/servers/41668-mysql-problems-_-solved-_.htm... http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000... On Thu, Nov 4, 2010 at 3:41 PM, Qiubo Su (David Su) <qiubosu@gmail.com> wrote:
hello victor,
i did notice this and update the base memory RAM to 1G.
it is ubuntu 10.0.4.
On Fri, Nov 5, 2010 at 11:23 AM, Victor Kane <victorkane@gmail.com> wrote:
Check the memory assigned to the VM and make sure it is enough to start all the processes. If it turns out that this is the case, you should be able to allocate additional memory for that VM process in its configuration. What is the base system? Victor
On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <jm_hannon@yahoo.com> wrote:
Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to:
(1) Turn off the firewall (2) Try to make your connection (3) Regardless of the outcome of (2), immediately turn the firewall back on.
-- Mike
From: Qiubo Su (David Su) <qiubosu@gmail.com> To: support@drupal.org; cjones@partialflow.com Sent: Thu, November 4, 2010 1:59:15 PM Subject: Re: [support] urgently need help for Site off-line error
hello Christopher,
i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones@partialflow.com> wrote:
The log is telling you that the users table doesn't exist. I don't know how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto:
hello drupal support team,
thanks for your reply. i tried /etc/init.d/mysql start and it is ok for the database, however, after i reboot the pc and run /etc/init.d/mysql start as below, it doesn't work again. thanks for your help with this again.
root@quicksu-desktop:/var/www/sites/all/modules# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql start: Job is already running: mysql
root@quicksu-desktop:/var/www/sites/all/modules# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>
JABBER:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
hello erik, below are the results a) to e) by running the commands: a) root@quicksu-desktop:/home/quicksu# netstat -a | grep mysql b) root@quicksu-desktop:/home/quicksu# netstat -a | grep 3006 c) root@quicksu-desktop:/home/quicksu# nmap localhost Starting Nmap 5.00 ( http://nmap.org ) at 2010-11-05 12:19 NZDT Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost (127.0.0.1): Not shown: 996 closed ports PORT STATE SERVICE 21/tcp open ftp 80/tcp open http 443/tcp open https 631/tcp open ipp Nmap done: 1 IP address (1 host up) scanned in 0.42 seconds d) root@quicksu-desktop:/home/quicksu# nmap -A -T4 localhost Starting Nmap 5.00 ( http://nmap.org ) at 2010-11-05 12:21 NZDT Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost (127.0.0.1): Not shown: 996 closed ports PORT STATE SERVICE VERSION 21/tcp open ftp vsftpd 2.2.2 80/tcp open http Apache httpd 2.2.14 ((Ubuntu)) | robots.txt: has 36 disallowed entries (15 shown) | /includes/ /misc/ /modules/ /profiles/ /scripts/ | /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt | /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt |_ /MAINTAINERS.txt |_ html-title: Site off-line | Drupal 443/tcp open http Apache httpd 2.2.14 ((Ubuntu)) | robots.txt: has 36 disallowed entries (15 shown) | /includes/ /misc/ /modules/ /profiles/ /scripts/ | /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt | /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt |_ /MAINTAINERS.txt |_ html-title: Site off-line | Drupal 631/tcp open ipp CUPS 1.4 No exact OS matches for host (If you know what OS is running on it, see http://nmap.org/submit/ ). TCP/IP fingerprint: OS:SCAN(V=5.00%D=11/5%OT=21%CT=1%CU=30003%PV=N%DS=0%G=Y%TM=4CD34015%P=i686- OS:pc-linux-gnu)SEQ(SP=CA%GCD=1%ISR=CC%TI=Z%CI=Z%II=I%TS=8)SEQ(SP=CA%GCD=2% OS:ISR=CC%TI=Z%CI=Z%II=I%TS=8)OPS(O1=M400CST11NW6%O2=M400CST11NW6%O3=M400CN OS:NT11NW6%O4=M400CST11NW6%O5=M400CST11NW6%O6=M400CST11)WIN(W1=8000%W2=8000 OS:%W3=8000%W4=8000%W5=8000%W6=8000)ECN(R=Y%DF=Y%T=40%W=8018%O=M400CNNSNW6% OS:CC=Y%Q=)T1(R=Y%DF=Y%T=40%S=O%A=S+%F=AS%RD=0%Q=)T2(R=N)T3(R=Y%DF=Y%T=40%W OS:=8000%S=O%A=S+%F=AS%O=M400CST11NW6%RD=0%Q=)T4(R=Y%DF=Y%T=40%W=0%S=A%A=Z% OS:F=R%O=%RD=0%Q=)T5(R=Y%DF=Y%T=40%W=0%S=Z%A=S+%F=AR%O=%RD=0%Q=)T6(R=Y%DF=Y OS:%T=40%W=0%S=A%A=Z%F=R%O=%RD=0%Q=)T7(R=Y%DF=Y%T=40%W=0%S=Z%A=S+%F=AR%O=%R OS:D=0%Q=)U1(R=Y%DF=N%T=40%IPL=164%UN=0%RIPL=G%RID=G%RIPCK=G%RUCK=G%RUD=G)I OS:E(R=Y%DFI=N%T=40%CD=S) Network Distance: 0 hops Service Info: OS: Unix OS and Service detection performed. Please report any incorrect results at http://nmap.org/submit/ . Nmap done: 1 IP address (1 host up) scanned in 30.47 seconds e) root@quicksu-desktop:/home/quicksu# ps aux | grep mysql | grep -v grep On Fri, Nov 5, 2010 at 11:52 AM, Erik Saline <erik.saline@gmail.com> wrote:
netstat -a shows open or waiting connections. Run this to see if mysql or port 3306 is in the list. nmap will show open ports on a server
Could be permissions issues.
Sounds like mysql might be running already. What does the following command show show?
ps aux |grep mysql|grep -v grep
If it returns anything mysql already started up
Google is usually the place I look to solve crazy mysql issues.
http://www.linuxforums.org/forum/servers/41668-mysql-problems-_-solved-_.htm...
http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000...
On Thu, Nov 4, 2010 at 3:41 PM, Qiubo Su (David Su) <qiubosu@gmail.com> wrote:
hello victor,
i did notice this and update the base memory RAM to 1G.
it is ubuntu 10.0.4.
On Fri, Nov 5, 2010 at 11:23 AM, Victor Kane <victorkane@gmail.com> wrote:
Check the memory assigned to the VM and make sure it is enough to start all the processes. If it turns out that this is the case, you should be able to allocate additional memory for that VM process in its configuration. What is the base system? Victor
On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <jm_hannon@yahoo.com> wrote:
Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to:
(1) Turn off the firewall (2) Try to make your connection (3) Regardless of the outcome of (2), immediately turn the firewall back on.
-- Mike
From: Qiubo Su (David Su) <qiubosu@gmail.com> To: support@drupal.org; cjones@partialflow.com Sent: Thu, November 4, 2010 1:59:15 PM Subject: Re: [support] urgently need help for Site off-line error
hello Christopher,
i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002
(HY000):
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones@partialflow.com> wrote:
The log is telling you that the users table doesn't exist. I don't
know
how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote:
dear drupal support,
"/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have "bind-address" set to localhost and "socket" is set to /var/run/mysqld/mysqld.sock already.
but after run /etc/init.d/mysql start, still got below output
Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the restart(8) utility, e.g. restart mysql
mysql start/running
run mysql, still got below output as well
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
tail -10f /var/log/mysql/error.log, still got the same error
101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
by the way, the server use dynamic IP address and the /etc/network/interfaces is as below
auto lo iface lo inet loopback
On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli <michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it>> wrote:
Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto: > hello drupal support team, > > thanks for your reply. > i tried /etc/init.d/mysql start and it is ok for the database, > however, after i reboot the pc and run /etc/init.d/mysql start as > below, it doesn't work again. thanks for your help with this > again. > > root@quicksu-desktop:/var/www/sites/all/modules# > /etc/init.d/mysql > start > > Rather than invoking init scripts through /etc/init.d, use the > service(8) > utility, e.g. service mysql start > > Since the script you are attempting to invoke has been converted > to an > > Upstart job, you may also use the start(8) utility, e.g. start > mysql > start: Job is already running: mysql > > root@quicksu-desktop:/var/www/sites/all/modules# mysql > ERROR 2002 (HY000): Can't connect to local MySQL server through > socket '/var/run/mysqld/mysqld.sock' (2) Hi, try to see if "/var/run/mysqld/" exist. Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is set to localhost and if "socket" is set to /var/run/mysqld/mysqld.sock.
M.
-- Michel'ZioBudda' Morellimichel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN:michel@ziobuddalabs.it <MSN%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
JABBER:michel@ziobuddalabs.it <JABBER%3Amichel@ziobuddalabs.it> <mailto: michel@ziobuddalabs.it>
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Here's what nmap gives on my system: PORT STATE SERVICE 22/tcp open ssh . . . 3306/tcp open mysql -- Mike
From: Qiubo Su (David Su) <qiubosu@gmail.com> To: support@drupal.org; erik.saline@gmail.com Sent: Thu, November 4, 2010 4:27:20 PM Subject: Re: [support] urgently need help for Site off-line error
hello erik,
below are the results a) to e) by running the commands:
a) root@quicksu-desktop:/home/quicksu# netstat -a | grep mysql
b) root@quicksu-desktop:/home/quicksu# netstat -a | grep 3006
c) root@quicksu-desktop:/home/quicksu# nmap localhost
Starting Nmap 5.00 ( http://nmap.org ) at 2010-11-05 12:19 NZDT Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost (127.0.0.1): Not shown: 996 closed ports PORT STATE SERVICE 21/tcp open ftp 80/tcp open http 443/tcp open https 631/tcp open ipp
Nmap done: 1 IP address (1 host up) scanned in 0.42 seconds
d) root@quicksu-desktop:/home/quicksu# nmap -A -T4 localhost
Starting Nmap 5.00 ( http://nmap.org ) at 2010-11-05 12:21 NZDT Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost (127.0.0.1): Not shown: 996 closed ports PORT STATE SERVICE VERSION 21/tcp open ftp vsftpd 2.2.2 80/tcp open http Apache httpd 2.2.14 ((Ubuntu)) | robots.txt: has 36 disallowed entries (15 shown) | /includes/ /misc/ /modules/ /profiles/ /scripts/ | /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt | /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt |_ /MAINTAINERS.txt |_ html-title: Site off-line | Drupal 443/tcp open http Apache httpd 2.2.14 ((Ubuntu)) | robots.txt: has 36 disallowed entries (15 shown) | /includes/ /misc/ /modules/ /profiles/ /scripts/ | /sites/ /themes/ /CHANGELOG.txt /cron.php /INSTALL.mysql.txt | /INSTALL.pgsql.txt /install.php /INSTALL.txt /LICENSE.txt |_ /MAINTAINERS.txt |_ html-title: Site off-line | Drupal 631/tcp open ipp CUPS 1.4 No exact OS matches for host (If you know what OS is running on it, see http://nmap.org/submit/ ). TCP/IP fingerprint: OS:SCAN(V=5.00%D=11/5%OT=21%CT=1%CU=30003%PV=N%DS=0%G=Y%TM=4CD34015%P=i686- OS:pc-linux-gnu)SEQ(SP=CA%GCD=1%ISR=CC%TI=Z%CI=Z%II=I%TS=8)SEQ(SP=CA%GCD=2% OS:ISR=CC%TI=Z%CI=Z%II=I%TS=8)OPS(O1=M400CST11NW6%O2=M400CST11NW6%O3=M400CN OS:NT11NW6%O4=M400CST11NW6%O5=M400CST11NW6%O6=M400CST11)WIN(W1=8000%W2=8000 OS:%W3=8000%W4=8000%W5=8000%W6=8000)ECN(R=Y%DF=Y%T=40%W=8018%O=M400CNNSNW6% OS:CC=Y%Q=)T1(R=Y%DF=Y%T=40%S=O%A=S+%F=AS%RD=0%Q=)T2(R=N)T3(R=Y%DF=Y%T=40%W OS:=8000%S=O%A=S+%F=AS%O=M400CST11NW6%RD=0%Q=)T4(R=Y%DF=Y%T=40%W=0%S=A%A=Z% OS:F=R%O=%RD=0%Q=)T5(R=Y%DF=Y%T=40%W=0%S=Z%A=S+%F=AR%O=%RD=0%Q=)T6(R=Y%DF=Y OS:%T=40%W=0%S=A%A=Z%F=R%O=%RD=0%Q=)T7(R=Y%DF=Y%T=40%W=0%S=Z%A=S+%F=AR%O=%R OS:D=0%Q=)U1(R=Y%DF=N%T=40%IPL=164%UN=0%RIPL=G%RID=G%RIPCK=G%RUCK=G%RUD=G)I OS:E(R=Y%DFI=N%T=40%CD=S)
Network Distance: 0 hops Service Info: OS: Unix
OS and Service detection performed. Please report any incorrect results at http://nmap.org/submit/ . Nmap done: 1 IP address (1 host up) scanned in 30.47 seconds
e) root@quicksu-desktop:/home/quicksu# ps aux | grep mysql | grep -v grep
On Fri, Nov 5, 2010 at 11:52 AM, Erik Saline <erik.saline@gmail.com> wrote:
netstat -a shows open or waiting connections. Run this to see if
mysql or port 3306 is in the list. nmap will show open ports on a server
Could be permissions issues.
Sounds like mysql might be running already. What does the following command show show?
ps aux |grep mysql|grep -v grep
If it returns anything mysql already started up
Google is usually the place I look to solve crazy mysql issues.
http://www.linuxforums.org/forum/servers/41668-mysql-problems-_-solved-_.htm... http://www.linuxforums.org/forum/red-hat-fedora-linux/31155-error-2002-hy000...
On Thu, Nov 4, 2010 at 3:41 PM, Qiubo Su (David Su) <qiubosu@gmail.com> wrote:
hello victor,
i did notice this and update the base memory RAM to 1G.
it is ubuntu 10.0.4.
On Fri, Nov 5, 2010 at 11:23 AM, Victor Kane <victorkane@gmail.com> wrote:
Check the memory assigned to the VM and make sure it is enough to start all the processes. If it turns out that this is the case, you should be able to allocate additional memory for that VM process in its configuration. What is the base system? Victor
On Thu, Nov 4, 2010 at 7:05 PM, Michael Hannon <jm_hannon@yahoo.com> wrote:
Are you sure this isn't some kind of a firewall issue? A simple, but slightly dangerous, test would be to:
(1) Turn off the firewall (2) Try to make your connection (3) Regardless of the outcome of (2), immediately turn the firewall back on.
-- Mike
From: Qiubo Su (David Su) <qiubosu@gmail.com> To: support@drupal.org; cjones@partialflow.com Sent: Thu, November 4, 2010 1:59:15 PM Subject: Re: [support] urgently need help for Site off-line error
hello Christopher,
i run apt-get install --reinstall mysql-server and start /etc/init.d/mysql start, but still got the same error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)".
i even create /var/run/mysqld/mysqld.sock file and then restart mysql, but the mysqld.sock file disappear and get the same error.
i got this problem when i finished install/configure drupal site and make it up and running, can browse the drupal site, loging from phpmyadmin, run /etc/init.d/mysql start without any issue, log to mysql from command line without any issue, then i restart the VM (use VM for this), then got the above problem.
On Fri, Nov 5, 2010 at 3:24 AM, Christopher M. Jones <cjones@partialflow.com> wrote:
The log is telling you that the users table doesn't exist. I don't know how you installed mysql, or what distro you are using. If you installed using a package management tool then an administrative user should have been created. Review your installation process and make sure that all the necessary databases and tables are there, including the one mentioned in your logs. If you're using apt / dpkg and friends on a debian system, then you might try something like
apt-get install --reinstall mysql-server
On 11/03/2010 07:56 PM, Qiubo Su (David Su) wrote: > dear drupal support, > > "/var/run/mysqld/" does exists. edit */etc/mysql/my.cnf* file to have > "bind-address" set to localhost and "socket" is set to > /var/run/mysqld/mysqld.sock already. > > but after run /etc/init.d/mysql start, still got below output > > Rather than invoking init scripts through /etc/init.d, use the > service(8) > utility, e.g. service mysql restart > > Since the script you are attempting to invoke has been converted to an > Upstart job, you may also use the restart(8) utility, e.g. restart > mysql > > mysql start/running > > run mysql, still got below output as well > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) > > tail -10f /var/log/mysql/error.log, still got the same error > > 101104 12:41:09 [Note] Plugin 'FEDERATED' is disabled. > 101104 12:41:09 InnoDB: Started; log sequence number 0 44233 > 101104 12:41:09 [ERROR] Fatal error: Can't open and lock privilege > tables: Table 'mysql.user' doesn't exist > > by the way, the server use dynamic IP address and the > /etc/network/interfaces is as below > > auto lo > iface lo inet loopback > > > On Thu, Nov 4, 2010 at 12:11 PM, Michel Morelli > <michel@ziobuddalabs.it > <mailto:michel@ziobuddalabs.it>> wrote: > > Il 03/11/2010 21:35, Qiubo Su (David Su) ha scritto: >> hello drupal support team, >> >> thanks for your reply. >> i tried /etc/init.d/mysql start and it is ok for the database, >> however, after i reboot the pc and run /etc/init.d/mysql start as >> below, it doesn't work again. thanks for your help with this >> again. >> >> root@quicksu-desktop:/var/www/sites/all/modules# >> /etc/init.d/mysql >> start >> >> Rather than invoking init scripts through /etc/init.d, use the >> service(8) >> utility, e.g. service mysql start >> >> Since the script you are attempting to invoke has been converted >> to an >> >> Upstart job, you may also use the start(8) utility, e.g. start >> mysql >> start: Job is already running: mysql >> >> root@quicksu-desktop:/var/www/sites/all/modules# mysql >> ERROR 2002 (HY000): Can't connect to local MySQL server through >> socket '/var/run/mysqld/mysqld.sock' (2) > Hi, try to see if "/var/run/mysqld/" exist. > Try to edit */etc/mysql/my.cnf* file and see if "bind-address" is > set to localhost and if "socket" is set to > /var/run/mysqld/mysqld.sock. > > M. > > -- > Michel'ZioBudda' Morellimichel@ziobuddalabs.it > <mailto:michel@ziobuddalabs.it> > Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) > Telefono: 0200619074 > Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 > > http://www.ziobudda.net ICQ: 58351764 > http://www.ziobuddalabs.it Skype: zio_budda > http://www.ziodrupal.net > MSN:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> > > JABBER:michel@ziobuddalabs.it <mailto:michel@ziobuddalabs.it> > > -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP. Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM. Nick Sent from my BlackBerry® wireless device -----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com> Sender: support-bounces@drupal.org Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org>; <cjones@partialflow.com> Reply-To: support@drupal.org Subject: Re: [support] urgently need help for Site off-line error -- [ Drupal support list | http://lists.drupal.org/ ]
But what mystifies me is that quiuboso says it was running fine before he rebooted. 1. How much memory in the Ubuntu base machine? 2. Is the VM Ubuntu too? It has 1 GB? 3. The VM effectively has a LAMP stack installed together with Drupal? On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden <nick@thewebtailor.co.uk>wrote:
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP.
Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM.
Nick Sent from my BlackBerry® wireless device
-----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com> Sender: support-bounces@drupal.org Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org>; <cjones@partialflow.com> Reply-To: support@drupal.org Subject: Re: [support] urgently need help for Site off-line error
-- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]
On Fri, Nov 5, 2010 at 10:36 PM, Victor Kane <victorkane@gmail.com> wrote:
But what mystifies me is that quiuboso says it was running fine before he rebooted.
1. How much memory in the Ubuntu base machine? 2.5G 2. Is the VM Ubuntu too? Yes It has 1 GB? Yes 3. The VM effectively has a LAMP stack installed together with Drupal? No LAMP, I installed PHP, Apache, MySql manually
On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden <nick@thewebtailor.co.uk>wrote:
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP.
Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM.
Nick Sent from my BlackBerry® wireless device
-----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com> Sender: support-bounces@drupal.org Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org>; <cjones@partialflow.com> Reply-To: support@drupal.org Subject: Re: [support] urgently need help for Site off-line error
-- [ Drupal support list | http://lists.drupal.org/ ] --
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
I'm late to this issue. What I'm reporting likely has nothing to do with the issue... *but just in case*... and others should know about this anyway: *backup_migrate module v. 2.3 with table-locking turned on will crash mysql on your server.* * * There is a patch, but 2.3 is still the recommended release: http://drupal.org/node/952584 Shai On Fri, Nov 5, 2010 at 6:13 AM, Qiubo Su (David Su) <qiubosu@gmail.com>wrote:
On Fri, Nov 5, 2010 at 10:36 PM, Victor Kane <victorkane@gmail.com> wrote:
But what mystifies me is that quiuboso says it was running fine before he rebooted.
1. How much memory in the Ubuntu base machine? 2.5G 2. Is the VM Ubuntu too? Yes It has 1 GB? Yes 3. The VM effectively has a LAMP stack installed together with Drupal? No LAMP, I installed PHP, Apache, MySql manually
On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden <nick@thewebtailor.co.uk>wrote:
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP.
Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM.
Nick Sent from my BlackBerry® wireless device
-----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com> Sender: support-bounces@drupal.org Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org>; <cjones@partialflow.com> Reply-To: support@drupal.org Subject: Re: [support] urgently need help for Site off-line error
-- [ Drupal support list | http://lists.drupal.org/ ] --
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Quiubu Su, "LAMP" stands for Linux+Apache+MySQL+PHP. So yes, you have a LAMP stack. Since you say you have created the socket file by hand, it may be that permissions got screwed up. This would not explain why the problem happened in the first place, unless you had done something else before you rebooted that might have changed permissions on one of that file's parent directories. If the socket file is not getting created by the mysql init script then this is a likely cause. If this doesn't help, Quiubu Su, then your problem is officially out of my league, and I commend your soul to more capable hands. However, I can still suggest that you google the error you're getting, and see if you can find clues from more general sources. At the end of the day this doesn't really appear to be a Drupal issue but a Linux / MySQL one. Sorry I couldn't help you more. On 11/05/2010 08:38 AM, Shai Gluskin wrote:
I'm late to this issue. What I'm reporting likely has nothing to do with the issue... /but just in case/... and others should know about this anyway:
*backup_migrate module v. 2.3 with table-locking turned on will crash mysql on your server.* * * There is a patch, but 2.3 is still the recommended release: http://drupal.org/node/952584
Shai
On Fri, Nov 5, 2010 at 6:13 AM, Qiubo Su (David Su) <qiubosu@gmail.com <mailto:qiubosu@gmail.com>> wrote:
On Fri, Nov 5, 2010 at 10:36 PM, Victor Kane <victorkane@gmail.com <mailto:victorkane@gmail.com>> wrote:
But what mystifies me is that quiuboso says it was running fine before he rebooted.
1. How much memory in the Ubuntu base machine? 2.5G 2. Is the VM Ubuntu too? Yes It has 1 GB? Yes 3. The VM effectively has a LAMP stack installed together with Drupal? No LAMP, I installed PHP, Apache, MySql manually
On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden <nick@thewebtailor.co.uk <mailto:nick@thewebtailor.co.uk>> wrote:
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP.
Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM.
Nick Sent from my BlackBerry® wireless device
-----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com <mailto:qiubosu@gmail.com>> Sender: support-bounces@drupal.org <mailto:support-bounces@drupal.org> Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org <mailto:support@drupal.org>>; <cjones@partialflow.com <mailto:cjones@partialflow.com>> Reply-To: support@drupal.org <mailto:support@drupal.org> Subject: Re: [support] urgently need help for Site off-line error
-- [ Drupal support list | http://lists.drupal.org/ ] --
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
It is customary for four engineers travelling in a Fiat 147 that refuses to start, to pull over to the side of the road as best they can, and stop the car. Then, they all get out. And get in again, and, turning the ignition key surely but slowly, the car starts. Make a new VM, install a LAMP stack using any well documented method, install phpmyadmin using apt-get, and after making sure phpmyadmin works, restore your Drupal site and report back. On Fri, Nov 5, 2010 at 12:28 PM, Christopher M. Jones < cjones@partialflow.com> wrote:
Quiubu Su, "LAMP" stands for Linux+Apache+MySQL+PHP. So yes, you have a LAMP stack.
Since you say you have created the socket file by hand, it may be that permissions got screwed up. This would not explain why the problem happened in the first place, unless you had done something else before you rebooted that might have changed permissions on one of that file's parent directories. If the socket file is not getting created by the mysql init script then this is a likely cause.
If this doesn't help, Quiubu Su, then your problem is officially out of my league, and I commend your soul to more capable hands. However, I can still suggest that you google the error you're getting, and see if you can find clues from more general sources. At the end of the day this doesn't really appear to be a Drupal issue but a Linux / MySQL one. Sorry I couldn't help you more.
On 11/05/2010 08:38 AM, Shai Gluskin wrote:
I'm late to this issue. What I'm reporting likely has nothing to do with the issue... /but just in case/... and others should know about this anyway:
*backup_migrate module v. 2.3 with table-locking turned on will crash mysql on your server.* * * There is a patch, but 2.3 is still the recommended release: http://drupal.org/node/952584
Shai
On Fri, Nov 5, 2010 at 6:13 AM, Qiubo Su (David Su) <qiubosu@gmail.com <mailto:qiubosu@gmail.com>> wrote:
On Fri, Nov 5, 2010 at 10:36 PM, Victor Kane <victorkane@gmail.com <mailto:victorkane@gmail.com>> wrote:
But what mystifies me is that quiuboso says it was running fine before he rebooted.
1. How much memory in the Ubuntu base machine? 2.5G 2. Is the VM Ubuntu too? Yes It has 1 GB? Yes 3. The VM effectively has a LAMP stack installed together with Drupal? No LAMP, I installed PHP, Apache, MySql manually
On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden <nick@thewebtailor.co.uk <mailto:nick@thewebtailor.co.uk>> wrote:
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP.
Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM.
Nick Sent from my BlackBerry® wireless device
-----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com <mailto:qiubosu@gmail.com>> Sender: support-bounces@drupal.org <mailto:support-bounces@drupal.org> Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org <mailto:support@drupal.org>>; <cjones@partialflow.com <mailto:cjones@partialflow.com>> Reply-To: support@drupal.org <mailto:support@drupal.org> Subject: Re: [support] urgently need help for Site off-line error
-- [ Drupal support list | http://lists.drupal.org/ ] --
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
dear support team, a) i updated my drupal site with update.php. the updated was successful and the page displayed is fine, but after update in the middle of the page, got the below error output. - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Notice*: *Undefined index: player* in *flowplayer_swftools_methods()*(line *26* of */var/www/sites/all/modules/swftools/flowplayer/flowplayer.module *). - *Notice*: *Undefined index: page callback* in * page_manager_search_menu_alter()* (line *74* of * /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/ctools/page_manager/plugins/tasks/search.inc *). - *Notice*: *Undefined index: page callback* in * page_manager_search_menu_alter()* (line *74* of * /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/ctools/page_manager/plugins/tasks/search.inc *). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *213* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *216* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *217* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). - : in (line of ). b) in the home page, i.e. www.mysite.com, the page is displayed fine, but in the top area of the page, got the below error output. Notice: Trying to get property of non-object in /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/content_profile/modules/content_profile_tokens.module on line 30 Notice: Trying to get property of non-object in /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/content_profile/modules/content_profile_tokens.module on line 31 Notice: Trying to get property of non-object in /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/content_profile/modules/content_profile_tokens.module on line 30 Notice: Trying to get property of non-object in /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/content_profile/modules/content_profile_tokens.module on line 31 Notice: Trying to get property of non-object in /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/content_profile/modules/content_profile_tokens.module on line 30 Notice: Trying to get property of non-object in /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/content_profile/modules/content_profile_tokens.module on line 31 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/payment/uc_payment/uc_payment.module on line 153 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_file/uc_file.module on line 688 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_roles/uc_roles.module on line 592 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_stock/uc_stock.module on line 152 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_store/uc_store.module on line 454 Notice: Undefined variable: values in /var/www/sites/all/modules/versioncontrol/includes/versioncontrol.rules.inc on line 95 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/payment/uc_payment/uc_payment.module on line 153 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_file/uc_file.module on line 688 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_roles/uc_roles.module on line 592 Notice: Undefined variable: values in /var/www/sites/all/modules/ubercart/uc_stock/uc_stock.module on line 152 Notice: Undefined variable: values in /var/www/sites/all/modules/versioncontrol/includes/versioncontrol.rules.inc on line 95 Notice: Undefined index: package in /var/www/sites/all/modules/presentation/presentation.plugins.inc on line 63 c) in the home page, www.mysite.com, the page is displayed fine, but in the content block area, have the below error output - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Notice*: *Undefined index: player* in *flowplayer_swftools_methods()*(line *26* of */var/www/sites/all/modules/swftools/flowplayer/flowplayer.module *). - *Notice*: *Undefined index: page callback* in * page_manager_search_menu_alter()* (line *74* of * /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/ctools/page_manager/plugins/tasks/search.inc *). - *Notice*: *Undefined index: page callback* in * page_manager_search_menu_alter()* (line *74* of * /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/ctools/page_manager/plugins/tasks/search.inc *). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: title* in *admin_menu_link_build()* (line * 52* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: title* in *admin_menu_link_build()* (line * 52* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: title* in *admin_menu_link_build()* (line * 52* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: title* in *admin_menu_link_build()* (line * 52* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Undefined index: path* in *admin_menu_link_build()* (line * 53* of */var/www/sites/all/modules/admin_menu/admin_menu.inc*). - *Notice*: *Array to string conversion* in *t()* (line *945* of * /var/www/includes/common.inc*). - *Notice*: *Array to string conversion* in *t()* (line *945* of * /var/www/includes/common.inc*). - *Notice*: *Undefined variable: recipe_plaintext_example* in * recipe_plaintext_recipeio()* (line *31* of * /var/www/sites/all/modules/recipe/plugins/recipe_plaintext.module*). - *Notice*: *Undefined variable: recipe_plaintext_example* in * recipe_plaintext_recipeio()* (line *31* of * /var/www/sites/all/modules/recipe/plugins/recipe_plaintext.module*). - *Notice*: *Undefined variable: recipe_plaintext_example* in * recipe_plaintext_recipeio()* (line *31* of * /var/www/sites/all/modules/recipe/plugins/recipe_plaintext.module*). - *Notice*: *Undefined index: type* in * rules_core_action_transform_info()* (line *323* of * /var/www/sites/all/modules/rules/rules/modules/rules.rules.inc*). - *Notice*: *Undefined index: type* in * rules_core_action_transform_info()* (line *323* of * /var/www/sites/all/modules/rules/rules/modules/rules.rules.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *213* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *216* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *217* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: link* in *update_xml_parser->end()* (line * 257* of */var/www/modules/update/update.fetch.inc*). - The chosen language(*en*) is not supported by the translation server * https://translate.openatrium.com*. Alternatively you can download a translation file and drop it into * translations/en.po*. - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Warning*: *mb_substr() expects parameter 1 to be string, array given*in *drupal_substr()* (line *479* of */var/www/includes/unicode.inc*). - *Notice*: *Undefined index: player* in *flowplayer_swftools_methods()*(line *26* of */var/www/sites/all/modules/swftools/flowplayer/flowplayer.module *). - *Notice*: *Undefined index: page callback* in * page_manager_search_menu_alter()* (line *74* of * /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/ctools/page_manager/plugins/tasks/search.inc *). - *Notice*: *Undefined index: page callback* in * page_manager_search_menu_alter()* (line *74* of * /var/www/sites/all/modules/atrium-1-0-beta8/profiles/openatrium/modules/contrib/ctools/page_manager/plugins/tasks/search.inc *). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: module* in *_menu_router_build()* (line * 2437* of */var/www/includes/menu.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Warning*: *mysqli_real_escape_string() expects parameter 2 to be string, array given* in *db_escape_string()* (line *323* of * /var/www/includes/database.mysqli.inc*). - *Notice*: *Undefined index: type* in * rules_core_action_transform_info()* (line *323* of * /var/www/sites/all/modules/rules/rules/modules/rules.rules.inc*). - *Notice*: *Undefined index: configurable* in *actions_synchronize()*(line *323* of */var/www/includes/actions.inc*). - *Notice*: *Undefined index: type* in * rules_core_action_transform_info()* (line *323* of * /var/www/sites/all/modules/rules/rules/modules/rules.rules.inc*). - *Notice*: *Undefined index: type* in * rules_core_action_transform_info()* (line *323* of * /var/www/sites/all/modules/rules/rules/modules/rules.rules.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *213* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *216* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Notice*: *Undefined index: api* in *_ctools_features_get_info()* (line *217* of * /var/www/sites/all/modules/features/includes/features.ctools.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *theme_admin_drilldown_menu_item_link()* (line *120* of * /var/www/sites/all/modules/admin/theme/theme.inc*). - *Warning*: *strpos() expects parameter 1 to be string, array given* in *l()* (line *1607* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *l()* (line *1608* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *theme_admin_drilldown_menu_item_link()* (line *120* of * /var/www/sites/all/modules/admin/theme/theme.inc*). - *Warning*: *strpos() expects parameter 1 to be string, array given* in *l()* (line *1607* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *l()* (line *1608* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *theme_admin_drilldown_menu_item_link()* (line *120* of * /var/www/sites/all/modules/admin/theme/theme.inc*). - *Warning*: *strpos() expects parameter 1 to be string, array given* in *l()* (line *1607* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *l()* (line *1608* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *theme_admin_drilldown_menu_item_link()* (line *120* of * /var/www/sites/all/modules/admin/theme/theme.inc*). - *Warning*: *strpos() expects parameter 1 to be string, array given* in *l()* (line *1607* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *l()* (line *1608* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *theme_admin_drilldown_menu_item_link()* (line *120* of * /var/www/sites/all/modules/admin/theme/theme.inc*). - *Warning*: *strpos() expects parameter 1 to be string, array given* in *l()* (line *1607* of */var/www/includes/common.inc*). - *Warning*: *strip_tags() expects parameter 1 to be string, array given*in *l()* (line *1608* of */var/www/includes/common.inc*). - *Notice*: *Undefined variable: position* in *include()* (line *5* of * /var/www/sites/all/themes/fusion/fusion_core/block.tpl.php*). - *Notice*: *Undefined variable: recipe_plaintext_example* in * recipe_plaintext_recipeio()* (line *31* of * /var/www/sites/all/modules/recipe/plugins/recipe_plaintext.module*). - *Notice*: *Undefined variable: recipe_plaintext_example* in * recipe_plaintext_recipeio()* (line *31* of * /var/www/sites/all/modules/recipe/plugins/recipe_plaintext.module*). - *Notice*: *Undefined variable: position* in *include()* (line *5* of * /var/www/sites/all/themes/fusion/fusion_core/block.tpl.php*). - *Notice*: *Undefined variable: blocks* in *jquerymenu_block()* (line * 146* of */var/www/sites/all/modules/jquerymenu/jquerymenu.module*). - *Notice*: *Trying to get property of non-object* in * project_usage_project_page_link_alter()* (line *167* of * /var/www/sites/all/modules/project/usage/project_usage.module*). - *Notice*: *Trying to get property of non-object* in * project_release_views_data()* (line *272* of * /var/www/sites/all/modules/project/release/views/project_release.views.inc *). - *Notice*: *Trying to get property of non-object* in * xmpp_relationships_user_relationships()* (line *73* of * /var/www/sites/all/modules/xmppframework/contrib/xmpp_relationships/xmpp_relationships.module *). - *Notice*: *Undefined index: values* in * user_relationship_invites_form_alter()* (line *44* of * /var/www/sites/all/modules/user_relationships/user_relationship_invites/user_relationship_invites.module *). - *Notice*: *Trying to get property of non-object* in * xmpp_relationships_user_relationships()* (line *73* of * /var/www/sites/all/modules/xmppframework/contrib/xmpp_relationships/xmpp_relationships.module *). - *Notice*: *Undefined variable: default_relationship* in * user_relationships_ui_request_form()* (line *30* of * /var/www/sites/all/modules/user_relationships/user_relationships_ui/user_relationships_ui.forms.inc *). - *Notice*: *Undefined index: * in *user_relationships_ui_request_form()*(line *30* of * /var/www/sites/all/modules/user_relationships/user_relationships_ui/user_relationships_ui.forms.inc *). - *Notice*: *Undefined index: #type* in * template_preprocess_search_block_form()* (line *1137* of * /var/www/sites/all/modules/atrium-1-0-beta8/modules/search/search.module* ). d) it is much appreciated if anyone can help with this. On Sat, Nov 6, 2010 at 4:32 AM, Victor Kane <victorkane@gmail.com> wrote:
It is customary for four engineers travelling in a Fiat 147 that refuses to start, to pull over to the side of the road as best they can, and stop the car.
Then, they all get out. And get in again, and, turning the ignition key surely but slowly, the car starts.
Make a new VM, install a LAMP stack using any well documented method, install phpmyadmin using apt-get, and after making sure phpmyadmin works, restore your Drupal site and report back.
On Fri, Nov 5, 2010 at 12:28 PM, Christopher M. Jones < cjones@partialflow.com> wrote:
Quiubu Su, "LAMP" stands for Linux+Apache+MySQL+PHP. So yes, you have a LAMP stack.
Since you say you have created the socket file by hand, it may be that permissions got screwed up. This would not explain why the problem happened in the first place, unless you had done something else before you rebooted that might have changed permissions on one of that file's parent directories. If the socket file is not getting created by the mysql init script then this is a likely cause.
If this doesn't help, Quiubu Su, then your problem is officially out of my league, and I commend your soul to more capable hands. However, I can still suggest that you google the error you're getting, and see if you can find clues from more general sources. At the end of the day this doesn't really appear to be a Drupal issue but a Linux / MySQL one. Sorry I couldn't help you more.
On 11/05/2010 08:38 AM, Shai Gluskin wrote:
I'm late to this issue. What I'm reporting likely has nothing to do with the issue... /but just in case/... and others should know about this anyway:
*backup_migrate module v. 2.3 with table-locking turned on will crash mysql on your server.* * * There is a patch, but 2.3 is still the recommended release: http://drupal.org/node/952584
Shai
On Fri, Nov 5, 2010 at 6:13 AM, Qiubo Su (David Su) <qiubosu@gmail.com <mailto:qiubosu@gmail.com>> wrote:
On Fri, Nov 5, 2010 at 10:36 PM, Victor Kane <victorkane@gmail.com <mailto:victorkane@gmail.com>> wrote:
But what mystifies me is that quiuboso says it was running fine before he rebooted.
1. How much memory in the Ubuntu base machine? 2.5G 2. Is the VM Ubuntu too? Yes It has 1 GB? Yes 3. The VM effectively has a LAMP stack installed together with Drupal? No LAMP, I installed PHP, Apache, MySql manually
On Fri, Nov 5, 2010 at 12:05 AM, Nick Holden <nick@thewebtailor.co.uk <mailto:nick@thewebtailor.co.uk>> wrote:
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP.
Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM.
Nick Sent from my BlackBerry® wireless device
-----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com <mailto:qiubosu@gmail.com>> Sender: support-bounces@drupal.org <mailto:support-bounces@drupal.org> Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org <mailto:support@drupal.org>>; <cjones@partialflow.com <mailto:cjones@partialflow.com>> Reply-To: support@drupal.org <mailto:support@drupal.org> Subject: Re: [support] urgently need help for Site off-line error
-- [ Drupal support list | http://lists.drupal.org/ ] --
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Some versions of MySQL default to only allowing local connections to the server. It's not clear from what you've written if, when you 'use a VM for this', the drupal install and the MySQL server are both on the VM. If not, you might need to alter the MySQL config to allow connections over the network from another machine. Not only that but you might need to change the GRANT command issued during the drupal set up, because if you grant permissions to a user @ a certain machine or IP those permissions do not apply if the user (in this case the drupal system) connects from a different machine or IP. Hope that helps. I'm away from my desk so can't give exact advice, but that's what struck me when you mentioned using a VM. Nick Sent from my BlackBerry® wireless device -----Original Message----- From: "Qiubo Su \(David Su\)" <qiubosu@gmail.com> Sender: support-bounces@drupal.org Date: Fri, 5 Nov 2010 09:59:15 To: <support@drupal.org>; <cjones@partialflow.com> Reply-To: support@drupal.org Subject: Re: [support] urgently need help for Site off-line error -- [ Drupal support list | http://lists.drupal.org/ ]
participants (9)
-
Christopher M. Jones -
Erik Saline -
Jamie Holly -
Michael Hannon -
Michel Morelli -
Nick Holden -
Qiubo Su (David Su) -
Shai Gluskin -
Victor Kane