mysqld cannot start.
Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Could anyone take a look at the error log? Thanks a lot! T -- 121112 13:00:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ 121112 13:00:59 [ERROR] Use --lc-messages-dir without language specific part instead. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys' 121112 13:00:59 InnoDB: The InnoDB memory heap is disabled 121112 13:00:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121112 13:00:59 InnoDB: Compressed tables use zlib 1.2.3.4 121112 13:00:59 InnoDB: Initializing buffer pool, size = 128.0M 121112 13:00:59 InnoDB: Completed initialization of buffer pool 121112 13:00:59 InnoDB: highest supported file format is Barracuda. 121112 13:00:59 InnoDB: Waiting for the background threads to start 121112 13:01:00 InnoDB: 1.1.8 started; log sequence number 1595675 121112 13:01:00 [ERROR] Aborting 121112 13:01:00 InnoDB: Starting shutdown... 121112 13:01:00 InnoDB: Shutdown completed; log sequence number 1595675 121112 13:01:00 [Note] 121112 13:01:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121112 13:03:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 121112 13:03:49 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 121112 13:03:49 InnoDB: The InnoDB memory heap is disabled 121112 13:03:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121112 13:03:49 InnoDB: Compressed tables use zlib 1.2.3.4 121112 13:03:49 InnoDB: Initializing buffer pool, size = 128.0M 121112 13:03:49 InnoDB: Completed initialization of buffer pool 121112 13:03:49 InnoDB: highest supported file format is Barracuda. 121112 13:03:49 InnoDB: Waiting for the background threads to start 121112 13:03:50 InnoDB: 1.1.8 started; log sequence number 1595675 121112 13:03:50 [ERROR] Aborting 121112 13:03:50 InnoDB: Starting shutdown... 121112 13:03:50 InnoDB: Shutdown completed; log sequence number 1595675 121112 13:03:50 [Note] 121112 13:03:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Re: mysqld cannot start.
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys Check the permissions of all the dirs in that path: /usr, /usr/local, /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x access to all of them. 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Don't know what platform you're on, but on my Mac I had this issue, and I got around it by starting the server with: --lc-messages-dir=/usr/local/mysql/share/ On CentOS and RHEL I did not have this issue. HTH- larry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysqld cannot start.
Hi, Larry, Thanks a lot for the reply! On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell larry.mart...@gmail.comwrote: On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys Check the permissions of all the dirs in that path: /usr, /usr/local, /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x access to all of them. I already did so. It's weird... From the log, it seems that mysqld encountered some problem when reading the messagefile. But the file does exist with permission. 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Don't know what platform you're on, but on my Mac I had this issue, and I got around it by starting the server with: --lc-messages-dir=/usr/local/mysql/share/ I'm working on Ubuntu-12.04. Yes, the configuration parameter is set as /usr/local/mysql/data/ (see the error message). I tried your setting but this time mysqld tells me 121112 13:46:28 [ERROR] bin/mysqld: unknown variable 'lc-message-dir=/usr/local/mysql/share/' 121112 13:46:28 [ERROR] Aborting What a mess... On CentOS and RHEL I did not have this issue. HTH- larry Probably I shall go to GDB to understand what's happening here... Great thanks! T -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Re: mysqld cannot start.
On Mon, Nov 12, 2012 at 1:47 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, Larry, Thanks a lot for the reply! On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell larry.mart...@gmail.comwrote: On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys Check the permissions of all the dirs in that path: /usr, /usr/local, /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x access to all of them. I already did so. It's weird... From the log, it seems that mysqld encountered some problem when reading the messagefile. But the file does exist with permission. 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Don't know what platform you're on, but on my Mac I had this issue, and I got around it by starting the server with: --lc-messages-dir=/usr/local/mysql/share/ I'm working on Ubuntu-12.04. Yes, the configuration parameter is set as /usr/local/mysql/data/ (see the error message). I tried your setting but this time mysqld tells me 121112 13:46:28 [ERROR] bin/mysqld: unknown variable 'lc-message-dir=/usr/local/mysql/share/' 121112 13:46:28 [ERROR] Aborting What a mess... Oh, the above error message is caused by my typo. Yes, I set --lc-messages-dir=/usr/local/mysql/share/, and everything's ok... The latter error message (i.e., messagefile) is the chain reaction caused by the previous one (lc-messages-dir) which confused me. Thanks a lot, Larry! Tianyin On CentOS and RHEL I did not have this issue. HTH- larry Probably I shall go to GDB to understand what's happening here... Great thanks! T -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
mysql for os x 10.6 (64bit) cannot start service
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache. The installation went smoothly but the service just cannot be started.* **
Re: mysql for os x 10.6 (64bit) cannot start service
Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu elim@gmail.com wrote: *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache. The installation went smoothly but the service just cannot be started.* ** -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1* mac at mysql.com) On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote: *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache. The installation went smoothly but the service just cannot be started.* **
Re: mysql for os x 10.6 (64bit) cannot start service
Yes, there is an icon. I can open the preference but the start service button cannot do the job On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. **
Re: mysql for os x 10.6 (64bit) cannot start service
I have version 5.5.17 MySQL Community Server (GPL) on my Mac. On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu elim@gmail.com wrote: The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1* mac at mysql.com) On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote: *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache. The installation went smoothly but the service just cannot be started.* ** -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service button cannot do the job What is in the mysql error log? On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
Thanks Larry and Darryle for your help Where the error log should be? On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.comwrote: On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service button cannot do the job What is in the mysql error log? On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. **
Re: mysql for os x 10.6 (64bit) cannot start service
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote: Thanks Larry and Darryle for your help Where the error log should be? http://dev.mysql.com/doc/refman/5.0/en/error-log.html On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.com wrote: On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service button cannot do the job What is in the mysql error log? On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
-rw-r--r-- 1 rootwheel 17987 Dec 17 09:01 COPYING -rw-r--r-- 1 rootwheel 7371 Dec 17 09:01 INSTALL-BINARY -rw-r--r-- 1 rootwheel 2552 Dec 17 09:01 README drwxr-xr-x 46 rootwheel 1564 Dec 17 09:01 bin drwxr-x--- 8 _mysql wheel272 Feb 29 10:36 data drwxr-xr-x 4 rootwheel136 Dec 17 09:01 docs drwxr-xr-x 35 rootwheel 1190 Dec 17 09:01 include drwxr-xr-x 22 rootwheel748 Feb 29 10:33 lib drwxr-xr-x 4 rootwheel136 Dec 17 09:01 man drwxr-xr-x 15 rootwheel510 Dec 17 09:01 mysql-test drwxr-xr-x 3 rootwheel102 Dec 17 09:01 scripts drwxr-xr-x 35 rootwheel 1190 Dec 17 09:01 share drwxr-xr-x 29 rootwheel986 Dec 17 09:01 sql-bench drwxr-xr-x 16 rootwheel544 Dec 17 09:01 support-files I found the MySQL document is often difficult to read, but a web search indicates that should in data directory, but I cannot even cd to that directory (sudo is not good enough!) On Wed, Feb 29, 2012 at 10:33 AM, Larry Martell larry.mart...@gmail.comwrote: On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote: Thanks Larry and Darryle for your help Where the error log should be? http://dev.mysql.com/doc/refman/5.0/en/error-log.html On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.com wrote: On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service button cannot do the job What is in the mysql error log? On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. **
Re: mysql for os x 10.6 (64bit) cannot start service
Are you looking in /usr/local/mysql/data ? You should see a username.err file. You might have to sudo to open the file just do sudo tail -f FILENAME or sudo taill -f /path/to/filename/ . On Wed, Feb 29, 2012 at 1:00 PM, Elim Qiu elim@gmail.com wrote: -rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYING -rw-r--r-- 1 root wheel 7371 Dec 17 09:01 INSTALL-BINARY -rw-r--r-- 1 root wheel 2552 Dec 17 09:01 README drwxr-xr-x 46 root wheel 1564 Dec 17 09:01 bin drwxr-x--- 8 _mysql wheel 272 Feb 29 10:36 data drwxr-xr-x 4 root wheel 136 Dec 17 09:01 docs drwxr-xr-x 35 root wheel 1190 Dec 17 09:01 include drwxr-xr-x 22 root wheel 748 Feb 29 10:33 lib drwxr-xr-x 4 root wheel 136 Dec 17 09:01 man drwxr-xr-x 15 root wheel 510 Dec 17 09:01 mysql-test drwxr-xr-x 3 root wheel 102 Dec 17 09:01 scripts drwxr-xr-x 35 root wheel 1190 Dec 17 09:01 share drwxr-xr-x 29 root wheel 986 Dec 17 09:01 sql-bench drwxr-xr-x 16 root wheel 544 Dec 17 09:01 support-files I found the MySQL document is often difficult to read, but a web search indicates that should in data directory, but I cannot even cd to that directory (sudo is not good enough!) On Wed, Feb 29, 2012 at 10:33 AM, Larry Martell larry.mart...@gmail.comwrote: On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote: Thanks Larry and Darryle for your help Where the error log should be? http://dev.mysql.com/doc/refman/5.0/en/error-log.html On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.com wrote: On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service button cannot do the job What is in the mysql error log? On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. ** -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu elim@gmail.com wrote: -rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYING -rw-r--r-- 1 root wheel 7371 Dec 17 09:01 INSTALL-BINARY -rw-r--r-- 1 root wheel 2552 Dec 17 09:01 README drwxr-xr-x 46 root wheel 1564 Dec 17 09:01 bin drwxr-x--- 8 _mysql wheel 272 Feb 29 10:36 data drwxr-xr-x 4 root wheel 136 Dec 17 09:01 docs drwxr-xr-x 35 root wheel 1190 Dec 17 09:01 include drwxr-xr-x 22 root wheel 748 Feb 29 10:33 lib drwxr-xr-x 4 root wheel 136 Dec 17 09:01 man drwxr-xr-x 15 root wheel 510 Dec 17 09:01 mysql-test drwxr-xr-x 3 root wheel 102 Dec 17 09:01 scripts drwxr-xr-x 35 root wheel 1190 Dec 17 09:01 share drwxr-xr-x 29 root wheel 986 Dec 17 09:01 sql-bench drwxr-xr-x 16 root wheel 544 Dec 17 09:01 support-files I found the MySQL document is often difficult to read, but a web search indicates that should in data directory, but I cannot even cd to that directory (sudo is not good enough!) Is the sudo succeeding? If it is, then there's no reason you shouldn't be able to cd into that dir. If not, then you're going to have to be able to get root privileges on your own machine. Alternatively, you could explicitly set the location of the error log in your mysql config file (my.cnf) , to a location you can access, e.g. log-error=/tmp/mysqld.log put it under [mysqld] and [mysqld_safe] On Wed, Feb 29, 2012 at 10:33 AM, Larry Martell larry.mart...@gmail.com wrote: On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote: Thanks Larry and Darryle for your help Where the error log should be? http://dev.mysql.com/doc/refman/5.0/en/error-log.html On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.com wrote: On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote: Yes, there is an icon. I can open the preference but the start service button cannot do the job What is in the mysql error log? On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com wrote: Do you see a MySql icon under System Preferences Other ? That's how I start MySql on my Mac. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
If you are going to use su to officially switch to the root users just make sure you do su - with the dash. On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 29.02.2012 19:20, schrieb Larry Martell: Is the sudo succeeding? If it is, then there's no reason you shouldn't be able to cd into that dir. If not, then you're going to have to be able to get root privileges on your own machine. Alternatively, you could explicitly set the location of the error log in your mysql config file (my.cnf) , to a location you can access, e.g. log-error=/tmp/mysqld.log put it under [mysqld] and [mysqld_safe] but you would have still NO PERMISSIONS to that logfile because it is owned by mysqld and a normal user has usually no permissions to daemon-logs especially because /tmp has normally 1777 - everybody can write but after create a file only the owner is allowed to access it why not using su to REALLY switch to root? -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
I created (or activated) the root account and now I see the error log: sh-3.2# cat miniMac.local.err 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 120229 10:36:09 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'plugin' is read only 120229 10:36:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120229 10:36:09 InnoDB: Initializing buffer pool, size = 8.0M 120229 10:36:09 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 120229 10:36:09 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 120229 10:36:09 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 120229 10:36:09 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 120229 10:36:10 InnoDB: Started; log sequence number 0 0 120229 10:36:10 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/miniMac.local.pid' (Errcode: 13) 120229 10:36:10 [ERROR] Can't start server: can't create PID file: Permission denied 120229 10:36:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/miniMac.local.pid ended On Wed, Feb 29, 2012 at 12:35 PM, Darryle Steplight dstepli...@gmail.comwrote: If you are going to use su to officially switch to the root users just make sure you do su - with the dash. On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 29.02.2012 19:20, schrieb Larry Martell: Is the sudo succeeding? If it is, then there's no reason you shouldn't be able to cd into that dir. If not, then you're going to have to be able to get root privileges on your own machine. Alternatively, you could explicitly set the location of the error log in your mysql config file (my.cnf) , to a location you can access, e.g. log-error=/tmp/mysqld.log put it under [mysqld] and [mysqld_safe] but you would have still NO PERMISSIONS to that logfile because it is owned by mysqld and a normal user has usually no permissions to daemon-logs especially because /tmp has normally 1777 - everybody can write but after create a file only the owner is allowed to access it why not using su to REALLY switch to root? -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
Looks like 5.1.61 mac installer messed up the privilege setting... But how to fix it? I remember the server account is mysql, not _mysql What do you got? And how to fix it? Thanks On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote: I created (or activated) the root account and now I see the error log: sh-3.2# cat miniMac.local.err 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 120229 10:36:09 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'plugin' is read only 120229 10:36:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120229 10:36:09 InnoDB: Initializing buffer pool, size = 8.0M 120229 10:36:09 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 120229 10:36:09 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 120229 10:36:09 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 120229 10:36:09 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 120229 10:36:10 InnoDB: Started; log sequence number 0 0 120229 10:36:10 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/miniMac.local.pid' (Errcode: 13) 120229 10:36:10 [ERROR] Can't start server: can't create PID file: Permission denied 120229 10:36:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/miniMac.local.pid ended On Wed, Feb 29, 2012 at 12:35 PM, Darryle Steplight dstepli...@gmail.comwrote: If you are going to use su to officially switch to the root users just make sure you do su - with the dash. On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 29.02.2012 19:20, schrieb Larry Martell: Is the sudo succeeding? If it is, then there's no reason you shouldn't be able to cd into that dir. If not, then you're going to have to be able to get root privileges on your own machine. Alternatively, you could explicitly set the location of the error log in your mysql config file (my.cnf) , to a location you can access, e.g. log-error=/tmp/mysqld.log put it under [mysqld] and [mysqld_safe] but you would have still NO PERMISSIONS to that logfile because it is owned by mysqld and a normal user has usually no permissions to daemon-logs especially because /tmp has normally 1777 - everybody can write but after create a file only the owner is allowed to access it why not using su to REALLY switch to root? -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql for os x 10.6 (64bit) cannot start service
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote: I created (or activated) the root account and now I see the error log: sh-3.2# cat miniMac.local.err 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 120229 10:36:09 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'plugin' is read only 120229 10:36:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120229 10:36:09 InnoDB: Initializing buffer pool, size = 8.0M 120229 10:36:09 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 120229 10:36:09 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 120229 10:36:09 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 120229 10:36:09 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 120229 10:36:10 InnoDB: Started; log sequence number 0 0 120229 10:36:10 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/miniMac.local.pid' (Errcode: 13) 120229 10:36:10 [ERROR] Can't start server: can't create PID file: Permission denied 120229 10:36:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/miniMac.local.pid ended What are the permissions on /usr/local/mysql/data? How are you starting mysql? On my mac, I made my data dir 777 (cause I'm the only one who uses it). And I don't start mysql from the preferences, I start it with 'sudo mysqld_safe' On Wed, Feb 29, 2012 at 12:35 PM, Darryle Steplight dstepli...@gmail.comwrote: If you are going to use su to officially switch to the root users just make sure you do su - with the dash. On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 29.02.2012 19:20, schrieb Larry Martell: Is the sudo succeeding? If it is, then there's no reason you shouldn't be able to cd into that dir. If not, then you're going to have to be able to get root privileges on your own machine. Alternatively, you could explicitly set the location of the error log in your mysql config file (my.cnf) , to a location you can access, e.g. log-error=/tmp/mysqld.log put it under [mysqld] and [mysqld_safe] but you would have still NO PERMISSIONS to that logfile because it is owned by mysqld and a normal user has usually no permissions to daemon-logs especially because /tmp has normally 1777 - everybody can write but after create a file only the owner is allowed to access it why not using su to REALLY switch to root? -- -- May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: help! mysqld cannot start!
It doesn't particularly say, but this: 120116 19:15:29 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number 1595675 suggests to me that there's still junk from a previous install around. You might want to clean that up. - Original Message - From: mantianyu mantia...@gmail.com To: mysql@lists.mysql.com Sent: Monday, 16 January, 2012 12:37:07 PM Subject: help! mysqld cannot start! I have download the Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive binary edition and I installed it all followed the INSTALL_BINARY but at last step I start the service by run sudo bin/mysqld_safe --user=mysql I got following error message cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to '/var/log/mysql/error.log'. 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended and I check the error.log file it shows that 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:28 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 120116 19:15:28 [Note] Plugin 'FEDERATED' is disabled. 120116 19:15:28 InnoDB: The InnoDB memory heap is disabled 120116 19:15:28 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 120116 19:15:28 InnoDB: Compressed tables use zlib 1.2.3 120116 19:15:28 InnoDB: Using Linux native AIO 120116 19:15:28 InnoDB: Initializing buffer pool, size = 128.0M 120116 19:15:28 InnoDB: Completed initialization of buffer pool 120116 19:15:28 InnoDB: highest supported file format is Barracuda. 120116 19:15:28 InnoDB: Waiting for the background threads to start 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number 1595675 120116 19:15:29 [ERROR] Aborting 120116 19:15:29 InnoDB: Starting shutdown... 120116 19:15:30 InnoDB: Shutdown completed; log sequence number 1595675 120116 19:15:30 [Note] 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended every step I followed the INSTALL_BINARY file why it still can't start? who can help me? thanks! -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: help! mysqld cannot start!
2012/01/16 19:37 +0800, mantianyu but at last step I start the service by run sudo bin/mysqld_safe --user=mysql I got following error message cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to '/var/log/mysql/error.log'. Your means of starting does not show where the MySQL own files are. The flag -b (--basedir) is used for that. It works also to start mysqld in the directory where the default my.cnf was left. If that has everything that MySQL needs, it works also to start with --defaults-file=/my.cnf--the four dots stand for the rest of the full pathname. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: help! mysqld cannot start!
On Mon, Jan 16, 2012 at 4:37 AM, mantianyu mantia...@gmail.com wrote: I have download the Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive binary edition and I installed it all followed the INSTALL_BINARY but at last step I start the service by run sudo bin/mysqld_safe --user=mysql I got following error message cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to '/var/log/mysql/error.log'. 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended and I check the error.log file it shows that 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:28 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 120116 19:15:28 [Note] Plugin 'FEDERATED' is disabled. 120116 19:15:28 InnoDB: The InnoDB memory heap is disabled 120116 19:15:28 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 120116 19:15:28 InnoDB: Compressed tables use zlib 1.2.3 120116 19:15:28 InnoDB: Using Linux native AIO 120116 19:15:28 InnoDB: Initializing buffer pool, size = 128.0M 120116 19:15:28 InnoDB: Completed initialization of buffer pool 120116 19:15:28 InnoDB: highest supported file format is Barracuda. 120116 19:15:28 InnoDB: Waiting for the background threads to start 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number 1595675 120116 19:15:29 [ERROR] Aborting 120116 19:15:29 InnoDB: Starting shutdown... 120116 19:15:30 InnoDB: Shutdown completed; log sequence number 1595675 120116 19:15:30 [Note] 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended every step I followed the INSTALL_BINARY file why it still can't start? who can help me? thanks! I had the same issue, and I solved it by starting the server with this command line option: --lc-messages-dir=/usr/local/mysql/share/ HTH, -larry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
still cannot start MySQL
I'm still having a problem starting MySQL. I get the following message: Unable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' I've check the /etc/mysql/my.cnf and the sock file is supposed to load in '/var/run/mysqld. Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm still having a problem starting MySQL./DIV DIVI get the following message:/DIV DIVUnable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' /DIV DIVI've check the /etc/mysql/my.cnf and the sock file is supposed to load in '/var/run/mysqld./DIV DIVnbsp;/DIV DIVThanks/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: still cannot start MySQL
Jon Miller wrote: I'm still having a problem starting MySQL. I get the following message: Unable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' I've check the /etc/mysql/my.cnf and the sock file is supposed to load in '/var/run/mysqld. Thanks Start the server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start MySQL under Win2000
You must not install 5.0 over 4.1, put it somewhere else. Also, instead of naming the service MySQL both times, call it something else (i.e. MySQL41 and MySQL50). If you use the Windows installer distribution, it is one of the options; if you are doing it by hand then you already know how to name the services whatever you like. HTH. Octavian Rasnita wrote: Hi, Is it possible to install 2 versions of MySQL on the same computer? I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a time. I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine, however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first. When I try to: net start mysql (where mysql is the name of MySQL 4.1 service) or tried to start the service from the Windows management console (Services), the following error appears: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly. Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start MySQL under Win2000
From: Stephen Cook [EMAIL PROTECTED] Subject: Re: Cannot start MySQL under Win2000 You must not install 5.0 over 4.1, put it somewhere else. Also, instead of naming the service MySQL both times, call it something else (i.e. MySQL41 and MySQL50). If you use the Windows installer distribution, it is one of the options; if you are doing it by hand then you already know how to name the services whatever you like. HTH. I have installed MySQL 4.1 in e:\mysql and MySQL 5.0 in e:\mysql5. MySQL 4.1 service name is mysql and MySQL 5.0 service name is mysql5, so they are 2 totally separate programs. However, I want them both use the same port, because I will run only one of them in a certain moment, and not both, so there should be no conflict. I want this because I want to test the speed difference between MySQL 4 and MySQL 5 and I don't want to make any change in the program, but change only the service that listen to MySQL port... However, I've just read that the port should be different, even though I don't know why, and maybe this is the reason I cannot start MySQL 4 even if MySQL 5 is stopped. Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start MySQL under Win2000
Octavian Rasnita [EMAIL PROTECTED] wrote on 12/02/2005 10:39:16 AM: From: Stephen Cook [EMAIL PROTECTED] Subject: Re: Cannot start MySQL under Win2000 You must not install 5.0 over 4.1, put it somewhere else. Also, instead of naming the service MySQL both times, call it something else (i.e. MySQL41 and MySQL50). If you use the Windows installer distribution, it is one of the options; if you are doing it by hand then you already know how to name the services whatever you like. HTH. I have installed MySQL 4.1 in e:\mysql and MySQL 5.0 in e:\mysql5. MySQL 4.1 service name is mysql and MySQL 5.0 service name is mysql5, so they are 2 totally separate programs. However, I want them both use the same port, because I will run only one of them in a certain moment, and not both, so there should be no conflict. I want this because I want to test the speed difference between MySQL 4 and MySQL 5 and I don't want to make any change in the program, but change only the service that listen to MySQL port... However, I've just read that the port should be different, even though I don't know why, and maybe this is the reason I cannot start MySQL 4 even if MySQL 5 is stopped. Thank you. Teddy They only need to use different ports if they are both running at the same time. The documentation describes how to set up multiple, simultaneously operating MySQL servers. As you describe it, you should be able to get them both running (one at a time) on the default port of 3306. The moment you try to allow both of them to bind to that socket at the same time, one of them will puke (usually the one you are just starting) so make sure that one is completely down before you start the other. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Cannot start MySQL under Win2000
Hi, Is it possible to install 2 versions of MySQL on the same computer? I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a time. I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine, however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first. When I try to: net start mysql (where mysql is the name of MySQL 4.1 service) or tried to start the service from the Windows management console (Services), the following error appears: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly. Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start MySQL under Win2000
Hello. Basic instructions are available at: http://lists.mysql.com/mysql/115620 Search in archives at http://lists.mysql.com/mysql for more examples. Octavian Rasnita wrote: Hi, Is it possible to install 2 versions of MySQL on the same computer? I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a time. I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine, however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first. When I try to: net start mysql (where mysql is the name of MySQL 4.1 service) or tried to start the service from the Windows management console (Services), the following error appears: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly. Thank you. Teddy -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t 050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050810 20:26:52 mysqld ended -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
Thanks for your reply. I confirmed that user and group, mysql, exists and performed the chown as instructed but same thing. Here is my log again after I did this: 050810 23:18:09 mysqld started 050810 23:18:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050810 23:18:09 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050810 23:18:09 InnoDB: Flushing modified pages from the buffer pool... 050810 23:18:09 InnoDB: Started; log sequence number 0 43634 050810 23:18:09 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.h ost' doesn't exist 050810 23:18:09 mysqld ended Michael. Pinter Tibor (tibyke) wrote: check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
Hello. Check that mysql_install_db filled mysql database in the same directory as your datadir. See: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html Gobi [EMAIL PROTECTED] wrote: Thanks for your reply. I confirmed that user and group, mysql, exists and performed the chown as instructed but same thing. Here is my log again after I did this: 050810 23:18:09 mysqld started 050810 23:18:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050810 23:18:09 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050810 23:18:09 InnoDB: Flushing modified pages from the buffer pool... 050810 23:18:09 InnoDB: Started; log sequence number 0 43634 050810 23:18:09 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.h ost' doesn't exist 050810 23:18:09 mysqld ended Michael. Pinter Tibor (tibyke) wrote: check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
I find that I can start mysqld by using the --skip-grant-tables option but as soon as I run mysqld without that option, it dies again. I did try running mysql_install_db --user=mysql but when I did mysqlshow mysql, it was empty. Any ideas on how to proceed? Thanks, Michael. Gleb Paharenko wrote: Hello. Check that mysql_install_db filled mysql database in the same directory as your datadir. See: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
Never mind. I figured it out. I had to run the install_db script as mysql user. Gobi wrote: I find that I can start mysqld by using the --skip-grant-tables option but as soon as I run mysqld without that option, it dies again. I did try running mysql_install_db --user=mysql but when I did mysqlshow mysql, it was empty. Any ideas on how to proceed? Thanks, Michael. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot start mysqld
I installed mysql from the following rpm packages: mysql-4.1.10a-2.RHEL4.1 mysql-server-4.1.10a-2.RHEL4.1 I tried running 'mysqld start' and the server said startup failed. Here is the mysq.log: 050810 20:26:48 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050810 20:26:49 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050810 20:26:50 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050810 20:26:51 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050810 20:26:52 InnoDB: Started; log sequence number 0 0 050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050810 20:26:52 mysqld ended Appreciate any help with this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysql due to possibly a bug
Privet! file: './mysql/host.frm' (errno: 13) perror 13 OS error code 13: Permission denied Change the owner of /var/lib/mysql to 'mysql' user. Please next time post your messages to the list, the probability of helpful answers increases in several times :) On Tue, 31 May 2005 07:03:48 +0200 Dobroe vremja sutok. Vot eshe dannye s togo komjutera gde mysql ne hochet zapuskatsea: [EMAIL PROTECTED] mouse $ cat /etc/hosts # /etc/hosts: This file describes a number of hostname-to-address # mappings for the TCP/IP subsystem. It is mostly # used at boot time, when no name servers are running. # On small systems, this file can be used instead of a # named name server. Just add the names, addresses # and any aliases to this file... # $Header: /home/cvsroot/gentoo-src/rc-scripts/etc/hosts,v 1.8 2003/08/04 20:12:25 azarah Exp $ # 127.0.0.1 localhost 192.168.1.111 mouse mynetwork.mouseware.com 192.168.1.1 router mynetwork.mouseware.com router # IPV6 versions of localhost and co #::1 ip6-localhost ip6-loopback #fe00::0 ip6-localnet #ff00::0 ip6-mcastprefix #ff02::1 ip6-allnodes #ff02::2 ip6-allrouters #ff02::3 ip6-allhosts [EMAIL PROTECTED] mouse $ cat /etc/mysql/my.cnf # /etc/mysql/my.cnf: The global mysql configuration file. # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.0.14-r1,v 1.2 2004/07/18 02:47:43 dragonheart Exp $ # # This file can be simultaneously placed in three places: # 1. /etc/mysql/my.cnf to set global options. # 2. /var/lib/mysql/my.cnf to set server-specific options. # 3. ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of them. # # The following values assume you have at least 32M RAM! [client] #password = my_password port= 3306 socket = /var/run/mysqld/mysqld.sock [safe_mysqld] err-log = /var/log/mysql/mysql.err [mysqld] #skip-innodb user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock log-error = /var/log/mysql/mysqld.err # If set, mysql logs all queries(general query log). This will be deprecated in # 5.0. This logs all queries, even error queries and is slow. # log = /var/log/mysql/mysql.log # # If you really need logging, use rather binary logging. Especially when doing # replication. Read # file:/usr/share/doc/mysql-*/manual.html.gz#Replication # You can use PURGE MASTER LOGS TO '$hostname-bin.010' to get rid of old logs # from $hostname-bin.01 up to $hostname-bin.09 while the slave server is # running. # Before doing that, check which logfile slave curently uses by running # mysql SHOW SLAVE STATUS # To list logfiles on master do: # mysql SHOW MASTER LOGS # Then use PURGE for those not needed anymore only! Never remove the files # manually! # # Also consult RESET MASTER and RESET SLAVE commands before doing any changes # mysql RESET MASTER - Deletes all binary logs listed in the index # file, resetting the binlog index file to be empty. # mysql RESET SLAVE - Makes the slave forget its replication position in # the master logs. # mysql SET SQL_LOG_BIN=0 - this turns off logging (execute on MASTER only) # mysql SET SQL_LOG_BIN=1 - this turns on logging (execute on MASTER only) # # log-bin # set-variable = binlog-do-db=non_existant # set-variable = binlog-ignore-db=database_name # # server-id has to unique for each master or slave in your network, # lets use last number from IP address # server-id = 207 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K # keep secure by default! bind-address= 127.0.0.1 # bind-address= 192.168.1.111 port= 3306 # this can make it even more secure: #skip-networking [mysqldump] quick set-variable= max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable= key_buffer=16M [EMAIL PROTECTED] mouse $ cat /var/log/mysql/mysqld.err 050531 18:10:17 InnoDB: Started 050531 18:10:17 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 050531 18:10:17 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 050531 18:10:17 Aborting 050531 18:10:17 InnoDB: Starting shutdown... 050531 18:10:19 InnoDB: Shutdown completed 050531 18:10:19 /usr/sbin/mysqld: Shutdown Complete 050531 18:12:44 /usr/sbin/mysqld:
Re: Cannot start mysql due to possibly a bug
Hello. Are you sure that mysqld uses /etc/mysql/my.cnf? See: http://dev.mysql.com/doc/mysql/en/option-files.html I suggest you to use official binaries and perform installation according to the following: http://dev.mysql.com/doc/mysql/en/installing-binary.html Mouse Doctor X [EMAIL PROTECTED] wrote: Nice time of the day. I apologize I am writing on this address because didn't find START NEW THREAD on mailing lists page. The problem is this: I have the freshest version of Gentoo Linux, and mysql within it. Just didn't modify /etc/mysql/my.cnf, commenting only one line: skip-innodb. Have read about first mysql startup, and launched mysql_install_db as root. All went ok. Then, /etc/init.d/mysql start, started ok. When giving first command: /usr/bin/mysqladmin -u root -h my_host password 'new-password', it sends me somewhere saying: /usr/bin/mysqladmin: connect to server at 'my_host' failed error: 'Lost connection to MySQL server during query' When inspecting /var/log/mysql/mysqld.err log file, find there that /var/mysql.frm is not found. ... out of comment. Also, when stopping mysql, it refuses to be stopped. Help! Thanks in advance -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot start mysql due to possibly a bug
Nice time of the day. I apologize I am writing on this address because didn't find START NEW THREAD on mailing lists page. The problem is this: I have the freshest version of Gentoo Linux, and mysql within it. Just didn't modify /etc/mysql/my.cnf, commenting only one line: skip-innodb. Have read about first mysql startup, and launched mysql_install_db as root. All went ok. Then, /etc/init.d/mysql start, started ok. When giving first command: /usr/bin/mysqladmin -u root -h my_host password 'new-password', it sends me somewhere saying: /usr/bin/mysqladmin: connect to server at 'my_host' failed error: 'Lost connection to MySQL server during query' When inspecting /var/log/mysql/mysqld.err log file, find there that /var/mysql.frm is not found. ... out of comment. Also, when stopping mysql, it refuses to be stopped. Help! Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
{Spam?} Cannot start replication - can someone help?
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to replicate one database on server5 to server 8. I did the whole proceedure as recommended in http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set Up Replication I setup the GRANT statement on server5 for the slave. mysql SHOW GRANTS FOR [EMAIL PROTECTED]; +--- ---+ | Grants for [EMAIL PROTECTED] | +--- ---+ | GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'server8'@'MyServer8IP' IDENTIFIED BY PASSWORD 'xxx' | +--- ---+ 1 row in set (0.00 sec) But when I stop and start the slave, I get: 050316 8:56:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.04' at position 79, relay log './server8-relay-bin.01' position: 4 050316 8:56:42 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Unknown MySQL server host 'server5.picado.com' (1)' errno: 2005 retry-time: 60 retries: 86400 When I try from the command line, I get it to work without problem: [EMAIL PROTECTED] mysql]# mysql -h server5.domain.com -u server8 -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.10-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Both /etc/my.cnf files are listed below [EMAIL PROTECTED] mysql]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M skip-networking sort_buffer=2M log-bin server-id=2 log-slave-updates log-warnings replicate-ignore-db=mysql replicate-do-db=anguillaguide [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [EMAIL PROTECTED] mysql]# cat /etc/my.cnf [mysqld] old-passwords max_connections = 500 key_buffer = 16M myisam_sort_buffer_size = 64M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 3M table_cache = 1500 thread_cache_size = 128 wait_timeout = 14400 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 skip-innodb log-bin=mysql-bin server-id=1 [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M Chris Mason Anguilla -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: {Spam?} Cannot start replication - can someone help?
Chris Mason wrote: I have two servers, server5.mydomain.com and server8.mydomain.com. I want to replicate one database on server5 to server 8. I did the whole proceedure as recommended in http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set Up Replication I setup the GRANT statement on server5 for the slave. mysql SHOW GRANTS FOR [EMAIL PROTECTED]; +--- ---+ | Grants for [EMAIL PROTECTED] | +--- ---+ | GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'server8'@'MyServer8IP' IDENTIFIED BY PASSWORD 'xxx' | +--- ---+ 1 row in set (0.00 sec) But when I stop and start the slave, I get: 050316 8:56:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.04' at position 79, relay log './server8-relay-bin.01' position: 4 050316 8:56:42 [ERROR] Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Unknown MySQL server host 'server5.picado.com' (1)' errno: 2005 retry-time: 60 retries: 86400 When I try from the command line, I get it to work without problem: [EMAIL PROTECTED] mysql]# mysql -h server5.domain.com -u server8 -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.1.10-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql You have master set to server5.picado.com, not server5.domain.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start 4.1.3 on Debian Linux
Hello Michael, On Thursday 08 July 2004 23:58, Michael Johnson wrote: I just tried installing 4.1.3 on my development machine today. To my dismay, I couldn't get it to start properly. I was upgrading from 4.1.2, which I installed identically to the procedure below. On to the actual problem. When I started MySQL the first time I used '/etc/init.d/mysql start'. mysqld_safe was started and just sat there, eating CPU cycles. I couldn't connect at all. I checked the error log and found the log information that follows. I also tried manually starting the server. The results were the same but I discovered that mysqld_safe was continually trying to start processes and failing, apparently with the error show below. I could not find anything, after a fairly extensive search, that even hinted to a problem like this. I downloaded the debug version of the server, but installing it is a bit more complex that I'd like to do at the moment, especially if someone has an easy fix. To install the server, I downloaded the RPMs, converted them to DEBs for debian with the alien package, and used dpkg to install them. This update procedure has worked since 4.1.0. I remember at some point I did have to run a conversion program for permissions, but I don't believe that was necesary with this update. I am running a current (as of 2004-06-08 12:00-0500) installation of Debian testing/sarge. Does anyone have any ideas or pointers? I think this is a bug#4407 http://bugs.mysql.com/bug.php?id=4407 Could you please check that the patch from the links fixes this problem for you? cut New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=0 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Resolved backtrace: 0x808bd47 handle_segfault + 423 0x82c79d8 pthread_sighandler + 184 0x82c8f47 __pthread_unlock + 103 0x82ca2ca pthread_rwlock_rdlock + 234 0x826eef4 mi_rnext + 148 0x80fae2a index_next__9ha_myisamPc + 42 0x80e6789 __11GRANT_TABLEP8st_tableT1 + 1641 0x80e80fe grant_init__FP3THD + 526 0x808d389 main + 697 0x82d74f4 __libc_start_main + 212 0x8048101 _start + 33 -- Michael Johnson [EMAIL PROTECTED] Internet Application Programmer, Pitsco, Inc. +++ Opinions expressed are my own, not my employer's +++ -- Sergey S. Kostyliov [EMAIL PROTECTED] Jabber ID: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot start 4.1.3 on Debian Linux
I just tried installing 4.1.3 on my development machine today. To my dismay, I couldn't get it to start properly. I was upgrading from 4.1.2, which I installed identically to the procedure below. On to the actual problem. When I started MySQL the first time I used '/etc/init.d/mysql start'. mysqld_safe was started and just sat there, eating CPU cycles. I couldn't connect at all. I checked the error log and found the log information that follows. I also tried manually starting the server. The results were the same but I discovered that mysqld_safe was continually trying to start processes and failing, apparently with the error show below. I could not find anything, after a fairly extensive search, that even hinted to a problem like this. I downloaded the debug version of the server, but installing it is a bit more complex that I'd like to do at the moment, especially if someone has an easy fix. To install the server, I downloaded the RPMs, converted them to DEBs for debian with the alien package, and used dpkg to install them. This update procedure has worked since 4.1.0. I remember at some point I did have to run a conversion program for permissions, but I don't believe that was necesary with this update. I am running a current (as of 2004-06-08 12:00-0500) installation of Debian testing/sarge. Does anyone have any ideas or pointers? Thanks, Michael Crash log: Number of processes running now: 0 040708 10:16:10 mysqld restarted 040708 10:16:10 Warning: Asked for 196608 thread stack, but got 126976 040708 10:16:11 Warning: Can't open time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 80383 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x859ae38 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfffeb08, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x808bd47 0x82c79d8 0x82c8f47 0x82ca2ca 0x826eef4 0x80fae2a 0x80e6789 0x80e80fe 0x808d389 0x82d74f4 0x8048101 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=0 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Resolved backtrace: 0x808bd47 handle_segfault + 423 0x82c79d8 pthread_sighandler + 184 0x82c8f47 __pthread_unlock + 103 0x82ca2ca pthread_rwlock_rdlock + 234 0x826eef4 mi_rnext + 148 0x80fae2a index_next__9ha_myisamPc + 42 0x80e6789 __11GRANT_TABLEP8st_tableT1 + 1641 0x80e80fe grant_init__FP3THD + 526 0x808d389 main + 697 0x82d74f4 __libc_start_main + 212 0x8048101 _start + 33 -- Michael Johnson [EMAIL PROTECTED] Internet Application Programmer, Pitsco, Inc. +++ Opinions expressed are my own, not my employer's +++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot start MySQL (errno 13)
Hi all, I have been working on getting MySQL going all day. Initially I had it working but had problems with mysqladmin. Figured that one out shutdown the server and tried to restart but I now have an error. This is what I found in my errorlog. In looking at the documentation I think I have to do something with UMASK? I read what it said but I'm still not sure exactly what I'm supposed to do. 031010 09:11:54 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031010 9:11:54 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031010 9:11:56 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031010 9:11:57 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 031010 9:12:03 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 031010 15:38:47 /usr/sbin/mysqld: Normal shutdown 031010 15:38:48 InnoDB: Starting shutdown... 031010 15:38:49 InnoDB: Shutdown completed 031010 15:38:49 /usr/sbin/mysqld: Shutdown Complete 031010 15:38:49 mysqld ended 031010 15:40:36 mysqld started 031010 15:40:36 InnoDB: Started 031010 15:40:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031010 15:40:36 Aborting 031010 15:40:36 InnoDB: Starting shutdown... 031010 15:40:39 InnoDB: Shutdown completed 031010 15:40:39 /usr/sbin/mysqld: Shutdown Complete 031010 15:40:39 mysqld ended = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Cannot start MySQL (errno 13)
Are you using symlinks? - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Carol Andrejak [mailto:[EMAIL PROTECTED] --Sent: Friday, October 10, 2003 1:04 PM --To: mysql --Subject: Cannot start MySQL (errno 13) -- --Hi all, -- --I have been working on getting MySQL going all day. --Initially I had it working but had problems with --mysqladmin. Figured that one out shutdown the server --and tried to restart but I now have an error. This is --what I found in my errorlog. In looking at the --documentation I think I have to do something with --UMASK? I read what it said but I'm still not sure --exactly what I'm supposed to do. -- --031010 09:11:54 mysqld started --InnoDB: The first specified data file ./ibdata1 did --not exist: --InnoDB: a new database to be created! --031010 9:11:54 InnoDB: Setting file ./ibdata1 size --to 10 MB --InnoDB: Database physically writes the file full: --wait... --031010 9:11:56 InnoDB: Log file ./ib_logfile0 did --not exist: new to be created --InnoDB: Setting log file ./ib_logfile0 size to 5 MB --InnoDB: Database physically writes the file full: --wait... --031010 9:11:57 InnoDB: Log file ./ib_logfile1 did --not exist: new to be created --InnoDB: Setting log file ./ib_logfile1 size to 5 MB --InnoDB: Database physically writes the file full: --wait... --InnoDB: Doublewrite buffer not found: creating new --InnoDB: Doublewrite buffer created --InnoDB: Creating foreign key constraint system tables --InnoDB: Foreign key constraint system tables created --031010 9:12:03 InnoDB: Started --/usr/sbin/mysqld: ready for connections. --Version: '4.0.15-standard' socket: --'/var/lib/mysql/mysql.sock' port: 3306 --031010 15:38:47 /usr/sbin/mysqld: Normal shutdown -- --031010 15:38:48 InnoDB: Starting shutdown... --031010 15:38:49 InnoDB: Shutdown completed --031010 15:38:49 /usr/sbin/mysqld: Shutdown Complete -- --031010 15:38:49 mysqld ended -- --031010 15:40:36 mysqld started --031010 15:40:36 InnoDB: Started --031010 15:40:36 Fatal error: Can't open privilege --tables: Can't find file: './mysql/host.frm' (errno: --13) --031010 15:40:36 Aborting -- --031010 15:40:36 InnoDB: Starting shutdown... --031010 15:40:39 InnoDB: Shutdown completed --031010 15:40:39 /usr/sbin/mysqld: Shutdown Complete -- --031010 15:40:39 mysqld ended -- --= -- -- Carol Andrejak -- Webmaster -- Delaware State University -- Grossley Hall Rm. 1 -- 302-857-7045 -- -- -- -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot start server after replacing data directory files
Description: followed instructions in manual to remove existing files in data directory and replace. on doing so, get errors when i try to start using sudo safe_mysqld --user=mysql . error log reads: --- 021210 17:05:07 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 021210 17:05:08 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021210 17:05:08 mysqld ended --- reason for trying to regenerate files: hostname in mac os x gives strange results - so mysql used a temporary dhcp identifier, because i wasn't aware of this peculiarity. obviously this caused problems. after giving sudo hostname 127.0.0.1, i tried to regenerate the files and restart the server. then the errors. more generally, should one configure hostname to 127.0.0.1 in the /etc/hostconfig file? How-To-Repeat: just as described above and in the relevant section of the manual. Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none X| licence | email support | extended email support ] Synopsis: cannot start server after replacing data directory files Severity: Priority: Category: mysql Class: Release: mysql-3.23.53-entropy.ch (http://www.entropy.ch/software/macosx/mysql/) Environment: System: Darwin 127.0.0.1 6.2 Darwin Kernel Version 6.2: Tue Nov 5 22:00:03 PST 2002; root:xnu/xnu-344.12.2.obj~1/RELEASE_PPC Power Macintosh powerpc Mac OS X: 10.2; perl 5.8.0 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs Thread model: posix Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 20020420 (prerelease) Compilation info: CC='gcc' CFLAGS='-DHAVE_BROKEN_REALPATH -lncurses' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Dec 2 17:03 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --libdir=/usr/local/mysql/lib --includedir=/usr/local/mysql/include --with-named-z-libs=/usr/local/libz.a --with-innodb --with-server-suffix=-entropy.ch --with-comment=http://www.entropy.ch/software/macosx/mysql/ --with-mysqld-user=mysql --enable-assembler 'CFLAGS=-DHAVE_BROKEN_REALPATH -lncurses' 'CFLAGS=-DHAVE_BROKEN_REALPATH -lncurses' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)
magnus, Monday, April 15, 2002, 9:04:10 PM, you wrote: mllDescription: mll I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then mll moved the data directory to a file server so it will be part of daily backups (/proj/webamt/rel/mysqldb). I followed the steps in the INSTALL-BINARY file for the non-standard location. mll I changed all permissions and ownership as described in the doc - modified and copied the startup script, support-files/mysql.server to /etc/init.d and made symbolic links in rc2.d. Then mll (as root) I ran 'scripts/mysql_install_db --datadir=/proj/webamt/rel/mysqldb' and then 'bin/safe_mysqld --user=mysql --datadir=/proj/webamt/rel/mysqldb ' and the following error was reported in mll the log file (/proj/webamt/rel/mysqldb/amthq2.err): mll 020415 11:33:39 mysqld started mll 020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) mll 020415 11:33:39 mysqld ended Error code 13 means that your *nix user has no permissions on MySQL data dir. Try: chown -R mysql.mysql /proj/webamt/rel/mysqldb -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)
Description: I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then moved the data directory to a file server so it will be part of daily backups (/proj/webamt/rel/mysqldb). I followed the steps in the INSTALL-BINARY file for the non-standard location. I changed all permissions and ownership as described in the doc - modified and copied the startup script, support-files/mysql.server to /etc/init.d and made symbolic links in rc2.d. Then (as root) I ran 'scripts/mysql_install_db --datadir=/proj/webamt/rel/mysqldb' and then 'bin/safe_mysqld --user=mysql --datadir=/proj/webamt/rel/mysqldb ' and the following error was reported in the log file (/proj/webamt/rel/mysqldb/amthq2.err): 020415 11:33:39 mysqld started 020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020415 11:33:39 mysqld ended How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Magnus Larsson Organization: Ericsson Amplifier Technologies Inc. 49 Wireless Blvd. Hauppauge, NY 11788 USA MySQL support: none Synopsis: Startup/config truoble Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.47 (Official MySQL binary) Environment: Sun Netra T1 (Ultra-SPARC), 1 GB RAM, 64 GB HDD; Solaris 8 (64-bit); /data/mysql/3.23.47/SunOS_5.8 (install dir); /proj/webamt/rel/mysqldb (database dir); LD_LIBRARY_PATH /data/mysql/0/SunOS_5.8/lib:/data/webserver/1.0.1/SunOS_5.8/lib:/usr/lib:/usr/local/lib:/usr/dt/lib:/usr/openwin/lib:/usr/ccs/lib:/usr/share/lib System: SunOS amthq2 5.8 Generic_108528-09 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /data/webserver/1.0.1/SunOS_5.8/bin/perl /data/webserver/1.0.1/SunOS_5.8/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759400 Jul 30 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 3 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Jul 30 2001 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759400 Jul 30 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 3 2001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Jul 30 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start Mysql on Windowx XP
I just installed MySQL-3.23/mysql-3.23.49-win.zip from www.mysql.com Then opened it. But I still could not run mysql..it looks like it could not find the server. Where is the remote server? Anyway, see below how I was struggling.. C:\mysqlcd\mysql\bin C:\mysql\binmysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306' == C:\mysql\binmysql ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) C:\mysql\binmysql -root ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) C:\mysql\binmysqlshow mysqlshow: Can't connect to MySQL server on 'localhost' (10061) Alan
I cannot start my server.
guo, Tuesday, February 19, 2002, 1:49:50 AM, you wrote: gl Dear Sir/Madam, gl I install mysql on my computer but it did not work. after installing the gl rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't gl start my server, after I ran mysql_install_db and safe_mysqld gl commands. I list the relevant information and I use the mysqlbug script to gl collect the relevant information . gl mysql's version : gl mysql-3.23.22-6.i386.rpm gl mysql-server-3.23.22-6.i386.rpm gl mysql-devel-3.23.22-6.i386.rpm gl my computer: AMD Athlon Processor gl cpu: 1.2GHz gl mem:256M gl operating system: red hat linux 7.0 gl kernel : 2.2.16-22 [skip] gl while I find some information from /var/lib/mysql/localhost.localdomain.err, gl the file localhost.localdomain.err's contents: gl 020215 17:31:02 mysqld started gl 020215 17:31:02 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' gl (errno: 13) $ perror 13 Error code 13: Permission denied Please, check your permissions on mysql data dir. gl 020215 17:31:02 mysqld ended gl but I find the 'host.frm' file is in the directory: gl /var/lib/mysql/mysql gl in my /etc directory, there is only a configure file named: my.conf and the gl file's length is zero. there is no file named : my.cnf or mf.cnf. gl I tried to copy one of the config file my-medium.cnf to the /etc directory gl and renamed to both my.cnf and mf.cnf, it still did not work. gl Best regards; gl Leon -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I cannot start my server.
Dear Sir/Madam, I install mysql on my computer but it did not work. after installing the rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't start my server, after I ran mysql_install_db and safe_mysqld commands. I list the relevant information and I use the mysqlbug script to collect the relevant information . mysql's version : mysql-3.23.22-6.i386.rpm mysql-server-3.23.22-6.i386.rpm mysql-devel-3.23.22-6.i386.rpm my computer: AMD Athlon Processor cpu: 1.2GHz mem:256M operating system: red hat linux 7.0 kernel : 2.2.16-22 after intalling the above packages, I run the following command: [root@localhost rpm]# mysql_install_db Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain -p password 'new-password' See the manual for more instructions. Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://www.mysql.com/license.htmy. then I run the following command: [root@localhost rpm]# safe_mysqld [1] 1284 [root@localhost rpm]# Starting mysqld daemon with databases from /var/lib/mysql 020216 16:16:33 mysqld ended while I find some information from /var/lib/mysql/localhost.localdomain.err, the file localhost.localdomain.err's contents: 020215 17:31:02 mysqld started 020215 17:31:02 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020215 17:31:02 mysqld ended but I find the 'host.frm' file is in the directory: /var/lib/mysql/mysql in my /etc directory, there is only a configure file named: my.conf and the file's length is zero. there is no file named : my.cnf or mf.cnf. I tried to copy one of the config file my-medium.cnf to the /etc directory and renamed to both my.cnf and mf.cnf, it still did not work. mysqlbug's information SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.22-beta (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jan 30 01:12 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 31 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 31 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 31 2000 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql Best regards; Leon _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To
cannot start mysqld
Description: How-To-Repeat: Fix: Submitter-Id: imamferianto Originator:root Organization: unsoed MySQL support: none Synopsis: cannot start mysqld Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.0-alpha (Official MySQL RPM) Environment: machine=i386,os=linux, target=local,library=i dont know (red-hat) System: Linux belajar.dghe.or.id 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 May 7 2001 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4686077 Aug 31 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 31 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 31 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start the server after restart.
Hello.. Friends I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to startet i can do it first time, but if i have to restart the server. I cannot start it again, why? i come with this error. w3# safe_mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot start the server after restart.
We would need to know what operating system you are using, that would be helpful in telling you what steps to take to fix it. Make sure that you put a space and a after that command so that you don't get your terminal stuck. As for your problem of starting the darn thing, there are two possiblities I can think of, you might be suffering from one or both (these suggestions assume that you are using Linux, since that is what I know, so if you are not, tough cookies for not telling what you are using): 1. I would say that it seems like you installed it with a tar file, and it didn't make properly. I would install with an rpm if you can, and you are using an outdated version anyway, so it is suggestable. 2. I can't say I can recognize the missing file, but if it is not from MySQL, it is most likely from a GNU C library or some other vitally important operating system library, since hose are the only other things that the MySQL server depends on. If you have been screwing with those files or if they have been corrupted, I'm surprised that you aren't having otehr problems. If you have a Linux Rescue Disk or your installation CD, you may be able to copy missing files directly off of there or extract them from an rpm on the CD. You will also be able to download updated versions of RPMs for your libraries from the RedHat site or another Linux packager. --On Saturday, June 23, 2001 09:27 +0100 Tomas Norre [EMAIL PROTECTED] wrote: Hello.. Friends I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to startet i can do it first time, but if i have to restart the server. I cannot start it again, why? i come with this error. w3# safe_mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SV: Cannot start the server after restart.
Sorry, never heard of it. I thouth OpenBSD was just one of those web development packages that they throw MySQL into. Some of what I said still applies, except I don't know whether or not you can use RPMs. --On Saturday, June 23, 2001 21:06 +0100 Tomas Norre [EMAIL PROTECTED] wrote: We would need to know what operating system you are using, that would be helpful in telling you what steps to take to fix it. As you can see i wrote OpenBSD 2.9 as operation System. --On Saturday, June 23, 2001 09:27 +0100 Tomas Norre [EMAIL PROTECTED] wrote: Hello.. Friends I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to startet i can do it first time, but if i have to restart the server. I cannot start it again, why? i come with this error. w3# safe_mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start 3.23.39 - system limits?
Description: While starting mysqld, mysqld stops with default values from support-files/my-medium.cnf. I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you asked in the $hostname.err to make a bug report. ;-) My compile time flags you have in my previous posts to bugs@ list under the thread make test fails' - to be onest, I removed two site-specific options like -I/software/@sys/usr/local/include and same for libs. How-To-Repeat: root# ulimit -a; /usr/local/mysql/bin/safe_mysqld --user=mysql core file size (blocks) unlimited data seg size (kbytes) 1048576 file size (blocks) unlimited max memory size (kbytes)152220 open files 200 pipe size (512 bytes) 20 stack size (kbytes) 65536 cpu time (seconds) unlimited max user processes 170 virtual memory (kbytes) 1048576 [2] 253026 root# Starting mysqld daemon with databases from /usr/local/mysql/var 010622 09:21:20 mysqld ended [2]- Done/usr/local/mysql/bin/safe_mysqld --user=mysql root# root# cat $hostname.err 010622 09:21:19 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=16773120 record_buffer=131072 sort_buffer=524280 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 010622 09:21:20 mysqld ended Fix: Submitter-Id: submitter ID Originator:Super-User Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: mysqld doesn't start Severity: Priority: Category: mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) Environment: System: IRIX nmrindy 6.5 01101244 IP22 Some paths: /usr/sbin/perl /software/@sys/usr/local/bin/make /software/@sys/usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/mips-sgi-irix6.5/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='cc' CFLAGS='-O3 -n32 -TARG:platform=IP22' CXX='CC' CXXFLAGS='-O3 -n32 -TARG:platform=IP22' LDFLAGS='' LIBC: -r-xr-xr-t 1 root sys 2362688 Mar 13 14:40 /lib/libc.so.1 lrwxr-xr-x 1 root sys19 Jan 1 2000 /usr/lib/libc.so - ../../lib/libc.so.1 lrwxr-xr-x 1 root sys19 Jan 1 2000 /usr/lib/libc.so.1 - ../../lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db --with-innodb --with-charset=czech --with-extra-charsets=latin1 --with-libwrap --with-named-curses-libs=/software/@sys/usr/local/lib/libncurses.a Perl: This is perl, version 5.004_04 built for irix-n32 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start 3.23.39 - system limits?
Description: While starting mysqld, mysqld stops with default values from support-files/my-medium.cnf. I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you asked in the $hostname.err to make a bug report. ;-) My compile time flags you have in my previous posts to bugs@ list under the thread make test fails' - to be onest, I removed two site-specific options like -I/software/@sys/usr/local/include and same for libs. How-To-Repeat: root# ulimit -a; /usr/local/mysql/bin/safe_mysqld --user=mysql core file size (blocks) unlimited data seg size (kbytes) 1048576 file size (blocks) unlimited max memory size (kbytes)152220 open files 200 pipe size (512 bytes) 20 stack size (kbytes) 65536 cpu time (seconds) unlimited max user processes 170 virtual memory (kbytes) 1048576 [2] 253026 root# Starting mysqld daemon with databases from /usr/local/mysql/var 010622 09:21:20 mysqld ended [2]- Done/usr/local/mysql/bin/safe_mysqld --user=mysql root# root# cat $hostname.err 010622 09:21:19 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=16773120 record_buffer=131072 sort_buffer=524280 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 010622 09:21:20 mysqld ended Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Super-User Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: mysqld doesn't start Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: IRIX nmrindy 6.5 01101244 IP22 Some paths: /usr/sbin/perl /software/@sys/usr/local/bin/make /software/@sys/usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/mips-sgi-irix6.5/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='cc' CFLAGS='-O3 -n32 -TARG:platform=IP22' CXX='CC' CXXFLAGS='-O3 -n32 -TARG:platform=IP22' LDFLAGS='' LIBC: -r-xr-xr-t 1 root sys 2362688 Mar 13 14:40 /lib/libc.so.1 lrwxr-xr-x 1 root sys19 Jan 1 2000 /usr/lib/libc.so - ../../lib/libc.so.1 lrwxr-xr-x 1 root sys19 Jan 1 2000 /usr/lib/libc.so.1 - ../../lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db --with-innodb --with-charset=czech --with-extra-charsets=latin1 --with-libwrap --with-named-curses-libs=/software/@sys/usr/local/lib/libncurses.a Perl: This is perl, version 5.004_04 built for irix-n32 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot start 3.23.39 - system limits?
Hi,
some more notes:
when using strace to trace the startup, I see some strange errors:
read(198, test -z \$defaults\\n then\n..., 1024) = 1024
xstat(2, /usr/local/mysql/var/data/mysql, 0xe0a31d0) = -1 ENOENT (No such file or
directory)
xstat(2, ./share/mysql/english/errmsg.sys, 0xe0a31d0) = -1 ENOENT (No such file or
directory)
xstat(2, ./bin/mysqld, 0xe0a31d0) = -1 ENOENT (No such file or directory)
xstat(2, ./var/mysql/db.frm, 0xe0a31d0) = -1 ENOENT (No such file or directory)
xstat(2, ./share/mysql/english/errmsg.sys, 0xe0a31d0) = -1 ENOENT (No such file or
directory)
xstat(2, ./libexec/mysqld, 0xe0a31d0) = -1 ENOENT (No such file or directory)
xstat(2, /usr/local/mysql/libexec/mysqld-max, 0xe0a31d0) = -1 ENOENT (No such file
or directory)
read(198, print_defaults=\./bin/my_print..., 1024) = 1024
xstat(2, ./bin/my_print_defaults, 0xe0a31d0) = -1 ENOENT (No such file or directory)
xstat(2, /usr/local/mysql/bin/my_print_defaults, {st_mode=01750311, st_size=0, ...})
= 0
I configured mysql with default-charrset=czech and additional-charset=latin1, so maybe
it's correct that
those files which are missing shouldn't be really there...:
xstat(2, /usr/local/mysql/share/mysql/charsets/big5.conf, 0x7fff28b0) = -1 ENOENT
(No such file or directory)
xstat(2, /usr/local/mysql/share/mysql/charsets/ujis.conf, 0x7fff28b0) = -1 ENOENT
(No such file or directory)
xstat(2, /usr/local/mysql/share/mysql/charsets/sjis.conf, 0x7fff28b0) = -1 ENOENT
(No such file or directory)
xstat(2, /usr/local/mysql/share/mysql/charsets/tis620.conf, 0x7fff28b0) = -1 ENOENT
(No such file or directory)
xstat(2, /usr/local/mysql/share/mysql/charsets/euc_kr.conf, 0x7fff28b0) = -1 ENOENT
(No such file or directory)
xstat(2, /usr/local/mysql/share/mysql/charsets/gb2312.conf, 0x7fff28b0) = -1 ENOENT
(No such file or directory)
xstat(2, /usr/local/mysql/share/mysql/charsets/gbk.conf, 0x7fff28b0) = -1 ENOENT (No
such file or directory)
SIGSEGV:
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] getmountid(0x7fff1911, 0x7fff1cf8) = 0
[pid 253453] lxstat(2, ../../../../../software, {st_mode=0200, st_size=0, ...}) = 0
[pid 253453] close(5) = 0
[pid 253453] open(../../../../../.., O_RDONLY|O_NONBLOCK) = 5
[pid 253453] fcntl(5, F_SETFD, FD_CLOEXEC) = 0
[pid 253453] fxstat(2, 5, {st_mode=0200, st_size=0, ...}) = 0
[pid 253453] fxstat(2, 5, {st_mode=0200, st_size=0, ...}) = 0
[pid 253453] close(5) = 0
[pid 253453] readlink(/software/usr/local/mysql/var/master.info, 0x7fff1de0, 1025) =
-1 ENOENT (No such file or directory)
[pid 253453] xstat(2, ./master.info, 0x7fff2c28) = -1 ENOENT (No such file or
directory)
[pid 253453] open(./, O_RDONLY|O_NONBLOCK) = 5
[pid 253453] fcntl(5, F_SETFD, FD_CLOEXEC) = 0
[pid 253453] fxstat(2, 5, {st_mode=S_IFSOCK|S_ISUID|020400507, st_size=0, ...}) = 0
[pid 253453] ngetdents(0x5, 0x104607f0, 0x4000, 0x7fff1c70) = 648
[pid 253453] close(5) = 0
[pid 253453] xstat(2, ./nmrindy-bin.013, 0x7fff2340) = -1 ENOENT (No such file or
directory)
[pid 253453] open(./nmrindy-bin.013, O_WRONLY|O_APPEND|O_CREAT, 0660) = 5
[pid 253453] lseek(5, 0, SEEK_CUR) = 0
[pid 253453] open(./nmrindy-bin.index, O_RDWR|O_APPEND|O_CREAT, 0660) = 6
[pid 253453] time() = 993203999
[pid 253453] lseek(5, 0, SEEK_SET) = 0
[pid 253453] write(5, \376bin\37\0273;\1\1\0\0\0E\0\0\0..., 73) = 73
[pid 253453] write(6, ./nmrindy-bin.013, 17) = 17
[pid 253453] write(6, \n, 1) = 1
[pid 253453] --- SIGSEGV (Segmentation fault) ---
[pid 253453] write(2, mysqld got signal , 18) = 18
[pid 253453] write(2, 11;\nThis, 8) = 8
[pid 253453] write(2, could be because you hit a bug, 221) = 221
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
[EMAIL PROTECTED] Faculty of Science, The Charles University
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start.
Hello.. Friends I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to startet i can do it first time, but if i have to restart the server. I cannot start it again, why? i come with this error. w3# safe_mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start.
Hello.. Friends I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to startet i can do it first time, but if i have to restart the server. I cannot start it again, why? i come with this error. w3# safe_mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL suddenly shutdown and cannot start up again.
Hi all, My RedHat 6.1 + MySQL 3.22.32 server box has some rare thing happens today. This box is sitting on the 192 network. It allows a cgi program to run select and update SQL statement, which triggered by the Internet. This box was received a lot of query this afternoon. Suddenly, it(redhat) reboot itself (I did not send any halt command to it). After it restarted mysqld was not start as usual reboot (runlevel 3, mysqld startup by default). I have to manually start mysqld by typing in ./S99mysql start. After that, everything works like normal. Not even crashed the table. I have checked the server box and its log. It does not look like it has hacked by someone. I checked the power supply and everything work fine, the UPS is protecting this server and also we have no black out here. I have spent the whole afternoon to read the server logs and hope to fine something. However, it has never indicated any problem or any Mysql error on the box. Do you have the same experience before? If yes, please share your experience with me. Thank you. Kind Regards, Fear Host.err - 000529 22:39:12 /usr/sbin/mysqld: Normal shutdown 000529 22:39:12 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Mon May 29 22:39:12 CST 2000 mysqld started on Mon May 29 22:41:43 CST 2000 /usr/sbin/mysqld: ready for connections 000530 13:17:06 /usr/sbin/mysqld: Normal shutdown 000530 13:17:06 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Tue May 30 13:17:06 CST 2000 mysqld started on Tue May 30 19:38:27 CST 2000 /usr/sbin/mysqld: ready for connections mysqld started on Tue May 15 00:38:11 CST 2001 /usr/sbin/mysqld: ready for connections Number of processes running now: 0 mysqld restarted on Tue May 15 00:38:14 CST 2001 010515 0:38:14 Can't start server: Bind on TCP/IP port: Address already in use 010515 0:38:14 Do you already have another mysqld server running on port: 3306 ? 010515 0:38:14 Aborting mysqld ended on Tue May 15 00:38:14 CST 2001 mysqld started on Tue May 15 02:39:30 CST 2001 /usr/sbin/mysqld: ready for connections - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot Start The Server after fresh Installation
Sir, I have downloaded the binary stable version of MySQL from the site www.mysql.com.The package I downloaded is .. mysql-3.23.37-pc-linux-gnu-i686.tar.gz After unzipping and untaring,I entered then directory mysql-3.23.37-pc-linux-gnu-i686 and then i executed the ./configure command which made the necessary installations and then i executed the followin commands.. #bin/safe_mysqld --user Starting mysqld daemon with databases from /home/mysql/mysql-3.23.37-pc-linux-gnu-i686/data/ mysql ended So , it sounds that the mysql daemon started by itself and then eneded by itself.So, please help me to get through this problem... Arijit But here the I got stuck because the response which i got is something like this.. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cannot Start The Server after fresh Installation
On Wed, 25 Apr 2001, arijit das wrote: Sir, I have downloaded the binary stable version of MySQL from the site www.mysql.com.The package I downloaded is .. mysql-3.23.37-pc-linux-gnu-i686.tar.gz After unzipping and untaring,I entered then directory mysql-3.23.37-pc-linux-gnu-i686 and then i executed the ./configure command which made the necessary installations and then i executed the followin commands.. #bin/safe_mysqld --user '--user' parameter needs argument. #bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /home/mysql/mysql-3.23.37-pc-linux-gnu-i686/data/ mysql ended So , it sounds that the mysql daemon started by itself and then eneded by itself.So, please help me to get through this problem... Arijit But here the I got stuck because the response which i got is something like this.. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot start logging.
Hi. I have a 3.23.22 test db running on Linux 6.2. I am able to start the database in log mode. I also have a 3.23.28 production db running on Linux 6.2. When I start this database in log mode, there is no indication that logging is running. There are no log name.index or log name.nnn files anywhere. Do you have any idea what I can check to figure out why logging is not working? Thank you. Brent Turley Insight Enterprises Tempe, Arizona
