RE: MySQL Error#: 2002
Assuming you copied and pasted the error, it looks like the host made a typo in the config file: '/var/lib/myswl/mysql.sock' Should probably be mysql, not myswl. -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, March 18, 2013 3:32 PM To: Patrice Olivier-Wilson; mysql@lists.mysql.com Subject: RE: MySQL Error#: 2002 Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Monday, March 18, 2013 12:05 PM To: mysql@lists.mysql.com Subject: MySQL Error#: 2002 I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- 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 Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LBI may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: MySQL Error#: 2002
Check directory permissions, and check out the 'answers' in here: http://forums.mysql.com/read.php?10,284776,284936 -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Monday, March 18, 2013 12:05 PM To: mysql@lists.mysql.com Subject: MySQL Error#: 2002 I have about 60 websites based on mysql and php. Suddenly they have all gone blank, just white pages. The files are still on the server and I can see the tables in all the databases via myphpadmin interfact. I'm not getting any response from hosting gods yet. When I try to connect to server via Dreamweaver, the error message is: MySQL Error#: 2002 Can't connect to local MySQL server through socket '/var/lib/myswl/mysql.sock'(111). I have one site that uses a different IP number that that site is ok. My static sites, ie, no database inclusion, are ok. Any ideas what to look for, most appreciated. Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com Everything will be alright in the end, so if it is not alright, it is not yet the end. - Quote from movie: The Best Exotic Marigold Hotel -- 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: MySQL Error 1045
Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen . On 9/20/2010 10:58 PM, Tim Thorburn wrote: Hello, A few days ago I ran into Error 1045 when attempting to add a new database user to my development machine. The error only occurred when trying to connect to the database as a new user which I found a little odd. After searching Google I discovered that this error is caused by a timeout - I should probably mention that my development machine is Win7 Ultimate 64-bit; I was using MySQL 5.1.45. Any thoughts on what I can do now? TIA, -Tim
Re: MySQL Error 1045
Hi, On 21-9-2010 5:25, Tim Thorburn wrote: Ignore that ... it's amazing how you can solve problems with enough caffeine and enough time away from a computer screen . It's also amazing how frustrating it is for those who are searching for the problem you mentioned to only find threads with 'solutions' such as ignore this, found it myself, never mind, solved, etc. -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql error causing database to not accept threads
Hi! Machiel Richards wrote: [[...]] We received an error on a MySQL database this morning which caused it to be unavailable for connections. Error: ERROR 1135 (0): Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug [[...]] You don't say anything about the MySQL version you are running, or your platform. I hope this here will help you, though: | u...@h:~ fgrep 11 /usr/include/asm-generic/errno-base.h | #define EAGAIN 11 /* Try again */ | u...@h:~ man pthread_create | PTHREAD_CREATE(3P) POSIX Programmer's Manual PTHREAD_CREATE(3P) | | | | NAME |pthread_create - thread creation | | [[...]] | | ERRORS |The pthread_create() function shall fail if: | |EAGAIN The system lacked the necessary resources to create another thread, or the system-imposed | limit on the total number of threads in a process {PTHREAD_THREADS_MAX} would be exceeded. | | [[...]] Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz Amtsgericht Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Mysql error causing database to not accept threads
Hi Joerg Thank you very much for the response. I found an answer this morning (about 15 minutes ago) where the server's Thread cache was used up and the amount of max connections exceeded causing the same error. We have not yet been able to establish the source of the amount of connections though. Machiel Richards MySQL DBA Relational Database Consulting -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: 30 June 2010 10:53 AM To: mysql@lists.mysql.com Cc: Machiel Richards Subject: Re: Mysql error causing database to not accept threads Hi! Machiel Richards wrote: [[...]] We received an error on a MySQL database this morning which caused it to be unavailable for connections. Error: ERROR 1135 (0): Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug [[...]] You don't say anything about the MySQL version you are running, or your platform. I hope this here will help you, though: | u...@h:~ fgrep 11 /usr/include/asm-generic/errno-base.h | #define EAGAIN 11 /* Try again */ | u...@h:~ man pthread_create | PTHREAD_CREATE(3P) POSIX Programmer's Manual PTHREAD_CREATE(3P) | | | | NAME |pthread_create - thread creation | | [[...]] | | ERRORS |The pthread_create() function shall fail if: | |EAGAIN The system lacked the necessary resources to create another thread, or the system-imposed | limit on the total number of threads in a process {PTHREAD_THREADS_MAX} would be exceeded. | | [[...]] Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz Amtsgericht Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql error causing database to not accept threads
Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these, and if each connection uses the full buffers, thats close to 200GB! You should adjust these to cater to the maximum number of connections expected. Did you try to check how much free memory you have when the problem occurs? Am 29.06.2010 10:17, schrieb Machiel Richards: ERROR 1135 (0): Can't create a new thread -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Mysql error causing database to not accept threads
Hi Yes, we did check the amount of free O/S memory and this was the same as during normal operating times when the system is working. Even the load averages on the system was very low. At the moment of this incident there was only 300 odd connections from the website where there are usually about 2000 + connections. As stated, the only other process running at that stage was the oracle import process, however after speaking to the person who implemented the imports scripts / process it was stated that this import makes one single connection and then imports relevant data within a single transaction. This import runs every 30 minutes so the amount of data being import is not that much and have not increased drastically so I am not yet sue as to where else to look. The only log created was that there was that no more threads could be created, even when trying to shutdown the MySQL database. I am not sure whether this could make a difference, however, but the server also runs an oracle database on the same server (not the database being imported from, only a slave oracle database)... I have also checked the ulimit settings and it seems that all the options in forums found thus far has been set to unlimited or to more than what is being suggested. Machiel Richards -Original Message- From: Benedikt Schackenberg [mailto:schackenb...@termindoc.de] Sent: 29 June 2010 10:57 AM To: mysql@lists.mysql.com Subject: Re: Mysql error causing database to not accept threads Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these, and if each connection uses the full buffers, thats close to 200GB! You should adjust these to cater to the maximum number of connections expected. Did you try to check how much free memory you have when the problem occurs? Am 29.06.2010 10:17, schrieb Machiel Richards: ERROR 1135 (0): Can't create a new thread -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=machiel.richa...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MySQL error
If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the [mysqld] section skip_innodb Then do the following service mysql stop rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01] service mysql start This will totally and cleanly disable InnoDB on the DB server Give it a try !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: malki.cymbali...@weizmann.ac.il [mailto:malki.cymbali...@weizmann.ac.il] Sent: Monday, June 08, 2009 10:02 AM To: mysql@lists.mysql.com Cc: shlomit.af...@weizmann.ac.il Subject: MySQL error We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. We stopped MySQL and started it again and everything seems to be working. However, we would like to understand what happened. The strange thing here is that we are not using InnoDB tables so we don't understand why we are getting InnoDB errors and what it is trying to do with the ibdata1 file. We do have an ibdata1 file and ib_logfile files. Could it be that we are using InnoDB tables and we don't realize it? Could we have made a mistake somewhere? Is there a way to check this? Can we erase these files? Any help will be appreciated. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: malki.cymbali...@weizmann.ac.il -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 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=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x4514, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1355140 = INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' thd-thread_id=1493537 The context is the same as previously, except the query: INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' This is not exactly reproducable, but it is fairly predictable - happens every morning towards 0600 - I have an archive job starting at 0500. For the last three days, the query has been roughly the same, except the 'example.com' varies. Is there nothing I can do to attempt to diagnose crashes such as this? Still no suggestions? /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: [snip] It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 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=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x4514, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1355140 = INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' thd-thread_id=1493537 The context is the same as previously, except the query: INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' It's getting to be a bit annoying - not all our apps were written to be able to handle the database connection disappearing at any time. Yes, they should have been, but it is a pretty unusual situation after all. Is there nothing I can do to attempt to diagnose crashes such as this? /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: 090525 6:04:35 - 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=6442450944 read_buffer_size=258048 max_used_connections=43 max_connections=100 threads_connected=26 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 6367855 Kbytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x7fa6fc0173e0 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=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x41a6, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1340aa0 = SELECT domain,domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)='2009-05-25 00:00:00' thd-thread_id=434983 /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I think it took 6-8 hours. and what kind of job was running at the time it went down. The job executing the SQL mentioned in the log ran on another server. It is a SELECT running from the command line (in a Makefile). I'm not sure what else to tell you. Having the server go away mid-query generally does mean you have run into a bug of some sort but, more often than not, you were doing something ill-advised at the time. The setup has been running for at least two years with no such problems. Let me know what other info would be interesting. best regards Per Jessen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
just a thought: Did you run mysql_upgrade after the import? On Mon, May 25, 2009 at 10:19 AM, Per Jessen p...@computer.org wrote: Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I think it took 6-8 hours. and what kind of job was running at the time it went down. The job executing the SQL mentioned in the log ran on another server. It is a SELECT running from the command line (in a Makefile). I'm not sure what else to tell you. Having the server go away mid-query generally does mean you have run into a bug of some sort but, more often than not, you were doing something ill-advised at the time. The setup has been running for at least two years with no such problems. Let me know what other info would be interesting. best regards Per Jessen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mikeisgr...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. best regards Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? Is there anything else which runs against this database at night? crons? Could you post the script that you are running to give some context to the statement which winds up in your error log? Considering that you did use mysqldump to manually inject your data, cross-version incompatibilities are pretty much out of the question. - michael On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. I suspect that will solve your issue. Keep me posted. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mikeisgr...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. Is there anything else which runs against this database at night? crons? Yes, lots of stuff. Cron-jobs, jobs submitted by daemons, etc. Could you post the script that you are running to give some context to the statement which winds up in your error log? I'm generating a zonefile for rbldnsd with entries from my table since midnight. Entries from before midnight are put in a main-table, entries after are in this regular diff. The statement is this: SELECT domain,domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)='midnight' Tonight it will be changed to: (single domain, not domain,domain) SELECT domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)='midnight' Additional context: The server is brandnew, an HP Proliant with dual quad-core Xeons and 10Gb RAM. The filesystem is JFS on hardware RAID6. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. I've also just run the query manually a couple of times, no problems. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. I would be tempted to put the hardware through a stress test. I know that's not much help. - michael On Mon, May 25, 2009 at 12:02 PM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. I've also just run the query manually a couple of times, no problems. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. Shouldn't/wouldn't the filesystem complain first? There is a lot of activity on the filesystem, mysql is just a tiny part of it. I would be tempted to put the hardware through a stress test. I know that's not much help. I really have no reason to suspect the hardware. It's new, but it's been running in burn-in mode for about a month (although not with much load, mostly idling). I might as well suspect the mysql build and try upgrading to a newer one. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
The issues that we saw only came to light under stress. The application I am referring to ran under a fair bit of load at the best of times but it was during sustained spikes that the flaws in our driver made themselves apparent. Mind you, we weren't using JFS, so I'm not sure how that would have reacted. - michael On Mon, May 25, 2009 at 12:19 PM, Per Jessen p...@computer.org wrote: Michael Dykman wrote: Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. Shouldn't/wouldn't the filesystem complain first? There is a lot of activity on the filesystem, mysql is just a tiny part of it. I would be tempted to put the hardware through a stress test. I know that's not much help. I really have no reason to suspect the hardware. It's new, but it's been running in burn-in mode for about a month (although not with much load, mostly idling). I might as well suspect the mysql build and try upgrading to a newer one. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT INTERACTIVE_TIMEOUT WAIT_TIMEOUT NET_WRITE_TIMEOUT NET_READ_TIMEOUT MAX_CONNECT_ERRORS On Mon, May 25, 2009 at 3:06 AM, Per Jessen p...@computer.org wrote: This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. The application is running remotely on 32bit using mysql library from version 5.0.67. I've been googling quite a bit, but haven't really found anything of any use. I've checked the two configurations, and they are the same. Can anyone help point me in the right direction? Thanks. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Darryle Steplight wrote: Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT INTERACTIVE_TIMEOUT WAIT_TIMEOUT NET_WRITE_TIMEOUT NET_READ_TIMEOUT MAX_CONNECT_ERRORS Hi Darryle I did notice references to some of those when I was googling, but because I didn't change any settings in my migration except up the key_buffer space, I didn't really pay much attention. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Error Number 1045 Access denied
Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
Alternatively you can try this if the box is unix/linux : sudo mysqld_safe --skip-grant-tables --user=root mysql -u root Change your root password Restart mysql after this. Cheers Sharad Andy Shellam wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- 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]
Re: MySQL Error Number 1045 Access denied
FYI, I don't think this was sent to the list, forgive me if it was and I didn't see it. Andy -- You probably don't have to reinstall it. If you never gave root a password, just login as Andy says below and, when prompted for the password, just press the ENTER key. Unless you gave root a password and forgot it, you should find yourself in the mysql program. Enter something like: update mysql.user set password = password('new pwd') where user = 'root'; flush privileges; There are other ways to change a pwd, but I use that since it's easier for me to remember one way. Jim On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
If you are desperate, you can also start mysqld with --skip-grant-tables option. Then use mysql, update root password using the update statement that Jim wrote about. -Paul On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote: FYI, I don't think this was sent to the list, forgive me if it was and I didn't see it. Andy -- You probably don't have to reinstall it. If you never gave root a password, just login as Andy says below and, when prompted for the password, just press the ENTER key. Unless you gave root a password and forgot it, you should find yourself in the mysql program. Enter something like: update mysql.user set password = password('new pwd') where user = 'root'; flush privileges; There are other ways to change a pwd, but I use that since it's easier for me to remember one way. Jim On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Andrew, I think he means re-install MySQL and provide a root password (you said when you originally installed it that you didn't give it a password.) After you've done this, try mysql from the command-line explicitly telling it to use the user root: mysql --user=root --password The --password here tells mysql to prompt you for a password, or alternatively you can provide the password on the command-line too: mysql --user=root --password=password Once you can login via the command-line there's no reason why the Admin GUI shouldn't be able to login too. Regards, Andy Quoting AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Andy Shellam Business Systems Architect Network Mail NetServe Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul Choi [EMAIL PROTECTED]
Re: MySQL Error Number 1045 Access denied
Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA
Re: MySQL Error Number 1045 Access denied
How does one done this? At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote: Hi Andrew As per your Question , you can test with the below solution :- Try to reconfigure MySQL by providing the root password and then try to run the administer GUI. This should solve the problem. CHAVA On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney [EMAIL PROTECTED]wrote: Hello I am still getting the MySQL Error Number 1045 Access denied error message when running the adminstrator gui. I attempted to start mysql from the dos command line via mysql and I am getting the following. ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO). I am logging in as root, locahost and no password because I did not enter one when I installed the software. I will be changing that. For the command line I just entered mysql and a return. How can I fix this. I am off for the week and I would like to get this working so I can create a database or 2. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Sreekanth CHAVA No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.6.4/1616 - Release Date: 8/16/2008 5:12 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error
Have you had any errors in the last 2 weeks? Have you restarted your server in the last 2 weeks? Your problem might just be a symptom of no problem at all. - michael On 8/20/07, Brown, Charles [EMAIL PROTECTED] wrote: Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error
A common issue a lot of people have is this rm logfile if the mysql server is still accessing that file it will not continue to write to that file again till mysql is restarted if that was the case the proper way to clear a log and keep the server running is cp /dev/null logfile On 8/20/07, Brown, Charles [EMAIL PROTECTED] wrote: Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error.
very wisely taken topic mysql error. ... Ananda Kumar schrieb: [...] I cleared some old bin-logs and when i restart mysql using mysqld_safe [...] InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070620 21:51:09 InnoDB: Unable to open the first data file InnoDB: Error in opening /data/mysql/ibdata1 070620 21:51:09 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! did you do the above mentioned? remove old ibdata file? also check permissions -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error.
Hi Sebastian, I did not remove any ibdata files. They are present. regards anandkl On 6/21/07, Sebastian Mendel [EMAIL PROTECTED] wrote: very wisely taken topic mysql error. ... Ananda Kumar schrieb: [...] I cleared some old bin-logs and when i restart mysql using mysqld_safe [...] InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /data/mysql/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 070620 21:51:09 InnoDB: Unable to open the first data file InnoDB: Error in opening /data/mysql/ibdata1 070620 21:51:09 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! did you do the above mentioned? remove old ibdata file? also check permissions -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error for Blobs
max_allowed_packet is the maximum size of a single SQL statement. It's a setting on the server, as well as for the mysql command line interface. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB. You can adjust this setting in the server config files (my.cnf or my.ini). I do not know if you need to adjust anything in Navicat, ODBC, Query Browser or Access - sorry! Dan On 11/16/06, C K [EMAIL PROTECTED] wrote: I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?. Access and Query browser simple gives error as MySQL has gone away? Why? please help. Also please give a solution if we have to insert images/Other Objects of size more than 1 MB what we have to do using ODBC driver with/without MS Access VB.net? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error for Blobs
When a query exceeds the size of the maximum allowed packet, mysqld closes the connection. It assumes something has gone wrong with the client. There are two max_allowed_packet variables, one for the server and one for the client. This is documented in section A.2.9 of the documentation http://www.mysql.org/doc/refman/4.1/en/packet-too-large.html Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 12:46 PM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: MySQL Error for Blobs I got an error while entering an BMP image of 1.7MB size in a mediumblob field through MS Access 2003 with MyODBC 3.51.12 on Windows XP SP2 also with MySQL Query Browser and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger than Max_allowed_packet bytes'. What this means?. Access and Query browser simple gives error as MySQL has gone away? Why? please help. Also please give a solution if we have to insert images/Other Objects of size more than 1 MB what we have to do using ODBC driver with/without MS Access VB.net? Thanks CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
Wow, I found the problem! I think this may be a bug. In my case, I've got three instances running on ports 3306, 3307, and 3320. On the local machine, I connect to them via mysql -p --port-3306 --host=localhost mysql -p --port-3307 --host=localhost mysql -p --port-3320 --host=localhost Except that connecting to port 3307 doesn't really happen. It seems that the command line client connects to the main instance via the default socket when the host is not specified, or is the value localhost. So, even though I've specified the host and port, I wind up connecting to the main instance. I found this out by stopping the main instance on 3306, and then I issue: LX09:/etc # mysql --port=3307 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) LX09:/etc # mysql --port=3307 --host=localhost ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) LX09:/etc # mysql --port=3307 --host=127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. LX09:/etc # mysql --port=3307 --host=nnn.nnn.nnn.nnn -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Note that /var/lib/mysql/mysql.sock is the socket associated with the main instance, not the alternates. It seems that if I *specify* a port, then mysql ought to use that port. It only seems to be an issue when not specifying a --host, or when using the value 'localhost'. It's a bit terrifying because during all my testing, I am thinking I am connected to the correct instance, when in fact, I was not. It will be very easy to blow away the main instance data by mistake. Can I somehow convince the mysql command line client to use the specified parms, rather than the (incorrect) socket? Thank you. Regards, Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 6:00 PM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 When you are trying to connect to port 3307, for example, are you specifying that port from your remote machine? Or are you connecting to the mysqld listening on port 3306? You could try shutting down the server listening on port 3306, and then connecting to port 3307. See if the error message changes or goes away. shell# mysql -h host_name -u root -px --port=3307 I think you may need to specify the absolute IP address in the user table, instead of a wildcard '%'. See if this helps. Use your root username and password in place of 'tommy'. I did not want to mess up my root user account! Use the IP address of your remote machine you want to connect to mysql with, in place of 10.0.0.5. mysql create user 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql grant all on *.* - to 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql select * from user where user = 'tommy' \G ** 1. row * Host: 10.0.0.5 User: tommy Password: snipped Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: N References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 1 row in set (0.00 sec) HTH Keith In theory, theory and practice are the same; in practice they are not. On Wed, 12 Apr 2006, Duzenbury, Rich wrote: To: mysql@lists.mysql.com From: Duzenbury, Rich [EMAIL PROTECTED] Subject: MySql Error Number 1130 Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p --port=3306 mysql -p --port=3307 mysql -p --port=3320 I have always been able to connect remotely from my workstation to the base server on 3306. My problem is that I cannot connect remotely to either of the new additional instances running on 3307 or 3320. Anytime I attempt to do so, I receive MySQL Error Number 1130, Host
Re: MySql Error Number 1130
Duzenbury, Rich wrote: Wow, I found the problem! I think this may be a bug. In my case, I've got three instances running on ports 3306, 3307, and 3320. On the local machine, I connect to them via mysql -p --port-3306 --host=localhost mysql -p --port-3307 --host=localhost mysql -p --port-3320 --host=localhost Except that connecting to port 3307 doesn't really happen. It seems that the command line client connects to the main instance via the default socket when the host is not specified, or is the value localhost. So, even though I've specified the host and port, I wind up connecting to the main instance. I found this out by stopping the main instance on 3306, and then I issue: LX09:/etc # mysql --port=3307 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) LX09:/etc # mysql --port=3307 --host=localhost ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (2) localhost means socket. LX09:/etc # mysql --port=3307 --host=127.0.0.1 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. LX09:/etc # mysql --port=3307 --host=nnn.nnn.nnn.nnn -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Note that /var/lib/mysql/mysql.sock is the socket associated with the main instance, not the alternates. It seems that if I *specify* a port, then mysql ought to use that port. It only seems to be an issue when not specifying a --host, or when using the value 'localhost'. It's a bit terrifying because during all my testing, I am thinking I am connected to the correct instance, when in fact, I was not. It will be very easy to blow away the main instance data by mistake. Can I somehow convince the mysql command line client to use the specified parms, rather than the (incorrect) socket All of the above is the correct and documented behavior. This is covered in the manual, and can be found many times in the archives. Thank you. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Error Number 1130
Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich Wasn't it something like on local machines MySQL doesn't open a socket port because it works directly in program and not going the loop out of mysql and back in through the socket? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
-Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich Wasn't it something like on local machines MySQL doesn't open a socket port because it works directly in program and not going the loop out of mysql and back in through the socket? I'm not sure I understand your statement. It's wise to use a unix domain socket where possible because they perform better than network sockets. However, it's misleading for the mysql client to ignore a command line directive as important as --port or --host without warning. Especially since this can cause connection to the wrong instance. Another way this would have been made more obvious is if the welcome message in the client were a bit more descriptive. Currently, I see 'Your mysql connection id is 2 to server version: 5.0.18-standard-log'. Perhaps the client should indicate the socket or ip/port that was actually used in the welcome message. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
--- Duzenbury, Rich [EMAIL PROTECTED] wrote: -Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 9:41 AM To: mysql@lists.mysql.com Subject: Re: MySql Error Number 1130 Duzenbury, Rich wrote: localhost means socket. Hmm, I don't believe it does. localhost is a DNS shortcut to the IP address of the local machine. If that is how mysql wants to treat things, then it should issue an error message on connect because --host=localhost and --port=anything would then be mutually exclusive. Thanks. Regards, Rich Wasn't it something like on local machines MySQL doesn't open a socket port because it works directly in program and not going the loop out of mysql and back in through the socket? I'm not sure I understand your statement. It's wise to use a unix domain socket where possible because they perform better than network sockets. However, it's misleading for the mysql client to ignore a command line directive as important as --port or --host without warning. Especially since this can cause connection to the wrong instance. Another way this would have been made more obvious is if the welcome message in the client were a bit more descriptive. Currently, I see 'Your mysql connection id is 2 to server version: 5.0.18-standard-log'. Perhaps the client should indicate the socket or ip/port that was actually used in the welcome message. Thanks. Regards, Rich I couldn't find it with a quick trip through the docs but I seem to remember that using a single period for your host name will force an election to either use the socket or use the IP stack. I'm sorry but I don't remember which way it forces the client to connect but I do know it's only for local connections. shellmysql -u -p -h. -P3307 HTH! Shawn Green Database Administrator Unimin Corporation - Spruce Pine __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql Error Number 1130
Interesting. I have never heard of that option. LX09:/home/rduz/backup # mysql -p -h. --port=3307 Enter password: ERROR 2005 (HY000): Unknown MySQL server host '.' (1) Perhaps it no longer functions? Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql Error Number 1130
When you are trying to connect to port 3307, for example, are you specifying that port from your remote machine? Or are you connecting to the mysqld listening on port 3306? You could try shutting down the server listening on port 3306, and then connecting to port 3307. See if the error message changes or goes away. shell# mysql -h host_name -u root -px --port=3307 I think you may need to specify the absolute IP address in the user table, instead of a wildcard '%'. See if this helps. Use your root username and password in place of 'tommy'. I did not want to mess up my root user account! Use the IP address of your remote machine you want to connect to mysql with, in place of 10.0.0.5. mysql create user 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql grant all on *.* - to 'tommy'@'10.0.0.5' - identified by '12345'; Query OK, 0 rows affected (0.00 sec) mysql select * from user where user = 'tommy' \G ** 1. row * Host: 10.0.0.5 User: tommy Password: snipped Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: N References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 1 row in set (0.00 sec) HTH Keith In theory, theory and practice are the same; in practice they are not. On Wed, 12 Apr 2006, Duzenbury, Rich wrote: To: mysql@lists.mysql.com From: Duzenbury, Rich [EMAIL PROTECTED] Subject: MySql Error Number 1130 Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p --port=3306 mysql -p --port=3307 mysql -p --port=3320 I have always been able to connect remotely from my workstation to the base server on 3306. My problem is that I cannot connect remotely to either of the new additional instances running on 3307 or 3320. Anytime I attempt to do so, I receive MySQL Error Number 1130, Host 'nnn.nnn.nnn.nnn' is not allowed to connect to this MySQL server. I've been googling and reading manuals all day, and haven't made a dent. User Table *** 1. row *** Host: % User: root Password: (redacted) Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 *** 2. row *** Host: localhost User: root Password: (redacted) Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 db Table: *** 1. row *** Host: % Db: mysql User: root Select_priv: Y Insert_priv: Y
Re: MySQL Error
john simms wrote: Hello MySQL! Hello User! At last! It has taken a couple of days - but, I have, at last, found you. *hides* haha, you think so ... You have invaded my computer without being requested, or invited. Did i? Man, my schedules are really weird nowadays. Whenever I try to access a local (to my home) message board, I get a black 'page' on my monitor screen with the above message (MySQL Error) on the top left of the black page. Local message board? Ethernet one or really local like 127.0.0.1? I guess the font color is white because otherwise it would be hard to read , er and it's not usually a fault of MySQL it also could be bad coded PHP/JSP whatever your board is written in causing that Error. What Error are you exactly getting? It is driving me NUTS!! I want it off. But how do I remove it? Tried a rubber? Advice and step-by-step guidance/instructions please? 1. Give us more info about the MySQL version, Type of Board and any other Info you can get helping find that Error causing Problem. 2. Adress us as Humans not as a software 3. Let somone else, who might have knowledge of coding, have a look at it. Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again
Hello. MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again Check the character set of fields in you tables with 'SHOW CREATE TABLE' statement. I recommend you to test if the problem remains in 4.1.14 version, because the similar bug was fixed in 4.1.11. See: http://bugs.mysql.com/bug.php?id=6519 Jeff Kolber [EMAIL PROTECTED] wrote: I recently converted the entire database to utf8 - made sure all the connections are utf8 etc -- made php use utf8 - set the doctype on the page to utf8 -- when I run the same query in the mysql monitor it runs fine - when apache/php run it it fails to deal with the collation. the data was converted via mysqldump to text file and reimporting changing all tables/database to utf. fwiw: the query looks like this: ( SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , 'meetings' panel_name FROM meetings where ( meetings.parent_id= '63301596-6175-1b89-75df-431283170495' AND meetings.parent_type='Opportunities' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(CONCAT(jt0.first_name , ' '), CONCAT(jt0.last_name , ' ')) contact_name, tasks.contact_id , tasks.date_due , tasks.parent_id , tasks.parent_type , tasks.time_due , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 where ( tasks.parent_id= '63301596-6175-1b89-75df-431283170495' AND tasks.parent_type='Opportunities' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , calls.date_start , calls.parent_id , calls.parent_type , calls.time_start , 'calls' panel_name FROM calls where ( calls.parent_id= '63301596-6175-1b89-75df-431283170495' AND calls.parent_type='Opportunities' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) and in this case it doesn't return anything - which is correct given the data. we are using: mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i386) Server characterset:utf8 Db characterset:utf8 Client characterset:utf8 Conn. characterset:utf8 I've seen some stuff that versions before 4.1.11 suffered from collation issues - is this likely to my case or can anyone see some other path through this - we have a single production database that we are very reluctant to update at this time. should i just switch back to latin1 ? thanks mysql list - you guys rock, lost in translation Jeff -- 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: MySql error...
From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- 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]
RE: MySql error...
If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- 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] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql error...
True. I forgot to mention, when doing the normal install from the tar, the files/databases for mysql and test both refused to create, although I see no error message indicating that. I believe that the root issue has something to do with the permissions during the make install. //jjs -Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- 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] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL
RE: MySql error...
If you downloaded the source tar and built Mysql doing a make/make install then you won't have a database. To create the baseline databases you need to run mysql_install_db which creates the mysql and test databases under the var directory. Its also worth copying one of the .cnf files from prefix/share/mysql as my.cnf into the var directory. Depending exactly on your setup you should end up with prefix/bin /include /info /share /lib /libexec /man /mysql-test /var/mysql /test Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 17:40 To: Kevin Cowley; mysql@lists.mysql.com Subject: RE: MySql error... True. I forgot to mention, when doing the normal install from the tar, the files/databases for mysql and test both refused to create, although I see no error message indicating that. I believe that the root issue has something to do with the permissions during the make install. //jjs -Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- 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
RE: MySql error...
Also, check to make sure the partition where your log directory is (ie. /var) isn't full. Move, compress, or delete some of the old logs, then restart mysql server. Reconfigure your log rotation scheme to avoid this in the future. HTH, Joey ~~ Joseph Karalius Research Associate - Bioinformatics Molecular Markers and Applied Genomics Seminis Vegetable Seeds, Inc 37437 State Highway 16 Woodland, CA 95695-9353 530-669-6131 joseph.karalius (a) seminis dot com ~~ -Original Message- From: Kevin Cowley [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:12 AM To: mysql@lists.mysql.com Subject: RE: MySql error... If you're starting the process as a non-system user then the var directory and anything under it should be owned/writable by that user. If you're starting it as root then the var directory should be owned/writable by mysql:daemon. If you don't have the Mysql user setup then the mysqld daemon won't run. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] -Original Message- From: jschmidt [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 16:44 To: 'mel list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- 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] ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible
RE: MySql error...
Thankx to all, I have solved the problem, the problem was with the permissions.We have to give the ownership of the mysql directory to mysql user and the run the configuration file. Regards, --Yousaf yousaf jschmidtYousaf Hi, I don't have an answer for you yet - but I encountered exactly the same situation with one of my systems last weekend. Unfortunately, the error file sheds no light at all on the situation. In my case: [EMAIL PROTECTED] mysql]# cat JackFish.intechgra.com.err 050304 07:30:36 mysqld started 050304 07:30:37 mysqld ended I downloaded a full binary distribution and it will fire right up using the files/directories in the tar. That being the case I came to the conclusion that this is a permissions problem of some kind, but didn't take it any further as this is a non-critical issue for me right now. Good luck with it. John J. Schmidt VP Technology/Principal intechgra Database System Specialists mailto:[EMAIL PROTECTED] www.intechgra.com -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:10 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: MySql error... Hi, Have a look in the error file which is in mysql/data and called hostname.err to have more information on why it is shutting down. With that info you usually can find more help on the mysql website. Good luck! From: S.Yousaf Shah [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySql error... Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT) Hi, I have installed mysql on my system using tar file. But when i start mysql it generates following error and shuts down. Plz help me out to run the MySql server as i have important data on it. [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld Starting mysqld daemon with databases from /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data STOPPING server from pid file /home/Yousaf/mysql-standard-4.0.21-pc-linux-i686/data/GDI.pid 050308 07:58:36 mysqld ended Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Regards, Syed Yousaf Shah. Bit-3B. Nust Institute of Information Technology. NIIT Distributed Grid Computing Research Group. Web Wizard Nust Institute of Information Technology. Chaklala Scheme 3 Rawalpindi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error logging
Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to connect to database: Access denied for user 'root'@'localhost' (using password: NO) Now for dropped sockets/connections you need to enable logging for this kind of thing in your connector and/or pooling software. I don't think this exists on the server side as it is not so simple to determine the actual cause. Let's say your router/switch drops connections, to server this looks like TCP socket timeouts and eventually will try to close the connection as such, but was it dropped or was it just left open and not closed properly by the client. This is why it makes sense to track these things in your data connector/pooling, with your kind of load you should have this kind of connection tracing/logging enabled in the client side and/or middle tier anyway. Just my $0.02 worth. -Daniel. -Original Message- From: Michael Loftis [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 2:45 PM To: mysql@lists.mysql.com Subject: mysql error logging OK I've honestly banged my head against everying, but as far as I can tell MySQL has *NO* real logging support. You have three options, log everything as text, log all queries as binary, or nothing. What I want/NEED is connection logging and some sort of ERROR logging. I'm getting an increasingly large amount of client connections that get apparently dropped during queries to the mysql server (error 2013) but the timeout issue is not possible (first it's default hour long timeout, secondly the connections are NOT persistent) Is there anything that can be done to get mysql to log the errors as they occur with the clients? Or to get it to log when it opens/closes a connection with the client and the disposition of that connection? Something would be better than what it does now which is all-or-nothing. Makes diagnosing anything impossible since I'm handling ~2k queries/sec. We have a binary log (necessary for our slave replica) and aren't under any load crunch nor I/O crunch on the DB drives, we're not experiencing ANY performance issues, just theres a goodly number of these connection dropped by server messages being reported. There has *GOT* to be SOME sort of useful logging in MySQL without having to turn on *full* text logging, which completely kills the server. All I need are connect/disconnect and disconnect reasons, I also *NEED* authentication failures but the thing doesn't log those EITHER. I'm starting to have a hard time believing I'm the only one complaining about this so I must be missing something, but the only logging options I've found cause full logging which can not be done. MySQL Version is 4.0.23 -- Michael Loftis Modwest Operations Manager GPG/PGP -- 0xE736BD7E 5144 6A2D 977A 6651 DFBE 1462 E351 88B9 E736 BD7E -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] !DSPAM:422e00ff75662101317344! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error 1251 / phpMyAdmin
I don't know much about the windows side of things so these are the only resources I could find. From the http://www.phpadmin.net site FAQ [1.17a] I cannot connect to the MySQL server. It always returns the error message, Client does not support authentication protocol requested by server; consider upgrading MySQL client You tried to access MySQL with an old MySQL client library. The version of your MySQL client library can be checked in your phpinfo() output. In general, it should have at least the same minor version as your server - as mentioned in FAQ 1.17. The only way to fix this problem is manually compiling php and its MySQL extension against a current MySQL client library. If you still face this problem, please compile your MySQL client library against the same or a newer MySQL release. From the http://www.php.net site mysql_connect function, while not exactly the same version, the same problem occurs. maybe you have seen this (using PHP 4.3.9 and MySQL client/server 4.1) Error w/ php: mysql_connect(): Client does not support authentication protocol Solution: mysql -u root-p SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD('password'); It is clearly that this is a bug in PHP's mysql module, perhaps it will be upgraded in the next version Resource: http://forums.mysql.com/read.php?11,6400,6701#msg-6701 Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: GH [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 February 2005 3:12 AM To: mysql@lists.mysql.com; php-general; PHP DB Subject: MySQL Error 1251 / phpMyAdmin I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- 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]
Re: MySQL Error: 1146 in Egroupware
On Thursday 20 January 2005 13:47, Shahzad, Saleem might have typed: Hi, I am using egroupware and in the calendar on a specific day and event I click on the link but MySQL gives me the following error Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) This is nothing to do with MySQL - you installed eGroupware incorrectly by the looks. Suggest RTM of the eGroupware install docs again. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error: 1146 in Egroupware
Database error: Invalid SQL: SELECT * FROM phpgw_links WHERE (link_app1 = 'calendar' AND link_id1 = '5') OR (link_app2 = 'calendar' AND link_id2 = '5') ORDER BY link_lastmod DESC mysql Error: 1146 (Table 'egroupware.phpgw_links' doesn't exist) That would indicate to me 2 possibilities: 1) Database 'egroupware' has a different name or does not exist, or 2) Table phpgw_links has a different name or does not exist As Duncan said, maybe the EGW install was incorrect... cheers Chris Ramsay - Web Developer - The Danwood Group Ltd. T: +44 (0) 1522 834482 F: +44 (0) 1522 884488 e: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] w: http://www.danwood.co.uk - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error
Hello. Such errors often occurs when you already have installed MySQL service. freshm4n [EMAIL PROTECTED] wrote: I got a mysql-4.1.8-win.zip,when installed,i got a error:Cannot create Windows service for MySQL.Error:0~~How to solve?thanks~~ :) sorry for my poor english~~ -- 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: mysql error file
So I am guessing this is not a bug, and that I will have to modify the script myself? -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 4:34 PM To: Michael Stassen; MYSQL-List (E-mail) Subject: RE: mysql error file Michael wrote: mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it oes when you tell it to start? Michael I briefly looked in there. This is the same script it uses to start MySQL, and was installed with the rpm of MySQL. I would think it should come with all available options already... To me, it doesn't look like it even reads that option from the my.cnf file. It doesn't look like its reading any option from mysqld_safe group. Pasting the whole thing, so I don't have to work with file attaching. #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # MySQL daemon start/stop script. # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. # When this is done the mysql server will be started when the machine is # started and shut down when the systems goes down. # Comments to support chkconfig on RedHat Linux # chkconfig: 2345 90 90 # description: A very fast and reliable SQL database engine. # Comments to support LSB init script conventions ### BEGIN INIT INFO # Provides: mysql # Required-Start: $local_fs $network $remote_fs # Required-Stop: $local_fs $network $remote_fs # Default-Start: 3 5 # Default-Stop: 3 5 # Short-Description: start and stop MySQL # Description: MySQL is a very fast and reliable SQL database engine. ### END INIT INFO # If you install MySQL on some other places than /, then you # have to do one of the following things for this script to work: # # - Run this script from within the MySQL installation directory # - Create a /etc/my.cnf file with the following information: # [mysqld] # basedir=path-to-mysql-installation-directory # - Add the above to any other configuration file (for example ~/.my.ini) # and copy my_print_defaults to /usr/bin # - Add the path to the mysql-installation-directory to the basedir variable # below. # # If you want to affect other MySQL variables, you should make your changes # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. basedir= # The following variables are only set for letting mysql.server find things. # Set some defaults datadir=/var/lib/mysql pid_file= if test -z $basedir then basedir=/ bindir=/usr/bin else bindir=$basedir/bin fi PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin export PATH if test -z $pid_file then pid_file=$datadir/`/bin/hostname`.pid else case $pid_file in /* ) ;; * ) pid_file=$datadir/$pid_file ;; esac fi mode=$1# start or stop parse_arguments() { for arg do case $arg in --basedir=*) basedir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --datadir=*) datadir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --pid-file=*) pid_file=`echo $arg | sed -e 's/^[^=]*=//'` ;; esac done } # Get arguments from the my.cnf file, # groups [mysqld] [mysql_server] and [mysql.server] if test -x ./bin/my_print_defaults then print_defaults=./bin/my_print_defaults elif test -x $bindir/my_print_defaults then print_defaults=$bindir/my_print_defaults elif test -x $bindir/mysql_print_defaults then print_defaults=$bindir/mysql_print_defaults else # Try to find basedir in /etc/my.cnf conf=/etc/my.cnf print_defaults= if test -r $conf then subpat='^[^=]*basedir[^=]*=\(.*\)$' dirs=`sed -e /$subpat/!d -e 's//\1/' $conf` for d in $dirs do d=`echo $d | sed -e 's/[ ]//g'` if test -x $d/bin/my_print_defaults then print_defaults=$d/bin/my_print_defaults break fi if test -x $d/bin/mysql_print_defaults then print_defaults=$d/bin/mysql_print_defaults break fi done fi # Hope it's in the PATH ... but I doubt it test -z $print_defaults print_defaults=my_print_defaults fi parse_arguments `$print_defaults mysqld mysql_server mysql.server` # Safeguard (relative paths, core dumps..) cd $basedir case $mode in 'start') # Start daemon if test -x $bindir/safe_mysqld then # Give extra arguments to mysqld with the my.cnf file. This script may # be overwritten at next upgrade. $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi else echo Can't execute $bindir/safe_mysqld from dir $basedir fi ;; 'stop') # Stop daemon. We use a signal here to avoid having to know the # root password. if test -s $pid_file then mysqld_pid=`cat $pid_file` echo Killing mysqld with pid $mysqld_pid kill $mysqld_pid # mysqld should remove
RE: mysql error file
I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section My log file is still writing to $HOSTNAME.err Is me /etc/my.cnf file wrong in some way? You might want to use [mysqld_safe] rather than [mysql_safe]. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error file
I hade it misconfigured (wrong param name prior to MySQL 4.0) Doc Quote http://dev.mysql.com/doc/mysql/en/Error_log.html Beginning with MySQL 4.0.10, you can specify where mysqld stores the error log file with the option --log-error[=file_name]. If no file_name value is given, mysqld uses the name `'hostname'.err' and writes the file in the data directory. (Prior to MySQL 4.0.10, the Windows error log name is `mysql.err'.) If you execute FLUSH LOGS the error log will be renamed with a suffix of -old and mysqld creates a new empty log file. In older MySQL versions on Unix, error log handling was done by mysqld_safe which redirected the error file to 'hostname'.err. You could change this filename by specifying a --err-log=filename option to mysqld_safe. End Doc Quote I changed it to what it should be according to the documentation and again it writes to $HOSTNAME.err [mysqld_safe] --err-log=/usr/data/mysql/mysql.err I am restaring MySQL with: /etc/rc.d/init.d/mysql stop /etc/rc.d/init.d/mysql start mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) RedHat 9.0 What I am seeing with ps -axw 14683 pts/0S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/usr/data/mysql --pid-file=/usr/data/mysql/mysql.pid 14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql --user=mysql --pid-file=/usr/data/mysql/mysql.pid -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 9:12 AM To: Paul DuBois; MYSQL-List (E-mail) Subject: RE: mysql error file I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section My log file is still writing to $HOSTNAME.err Is me /etc/my.cnf file wrong in some way? You might want to use [mysqld_safe] rather than [mysql_safe]. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- 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]
Re: mysql error file
Note (see ps output) that you are using safe_mysqld, rather than mysqld_safe, as you have mysql 3.23.58. Hence, you need to change [mysqld_safe] to [safe_mysqld] in your my.cnf. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html. Michael Luc Foisy wrote: I hade it misconfigured (wrong param name prior to MySQL 4.0) Doc Quote http://dev.mysql.com/doc/mysql/en/Error_log.html Beginning with MySQL 4.0.10, you can specify where mysqld stores the error log file with the option --log-error[=file_name]. If no file_name value is given, mysqld uses the name `'hostname'.err' and writes the file in the data directory. (Prior to MySQL 4.0.10, the Windows error log name is `mysql.err'.) If you execute FLUSH LOGS the error log will be renamed with a suffix of -old and mysqld creates a new empty log file. In older MySQL versions on Unix, error log handling was done by mysqld_safe which redirected the error file to 'hostname'.err. You could change this filename by specifying a --err-log=filename option to mysqld_safe. End Doc Quote I changed it to what it should be according to the documentation and again it writes to $HOSTNAME.err [mysqld_safe] --err-log=/usr/data/mysql/mysql.err I am restaring MySQL with: /etc/rc.d/init.d/mysql stop /etc/rc.d/init.d/mysql start mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) RedHat 9.0 What I am seeing with ps -axw 14683 pts/0S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/usr/data/mysql --pid-file=/usr/data/mysql/mysql.pid 14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql --user=mysql --pid-file=/usr/data/mysql/mysql.pid -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 9:12 AM To: Paul DuBois; MYSQL-List (E-mail) Subject: RE: mysql error file I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section My log file is still writing to $HOSTNAME.err Is me /etc/my.cnf file wrong in some way? You might want to use [mysqld_safe] rather than [mysql_safe]. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error file
Actually, that didn't change anything. Still writing to $HOSTNAME.err -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 12:03 PM To: Luc Foisy Cc: Paul DuBois; MYSQL-List (E-mail) Subject: Re: mysql error file Note (see ps output) that you are using safe_mysqld, rather than mysqld_safe, as you have mysql 3.23.58. Hence, you need to change [mysqld_safe] to [safe_mysqld] in your my.cnf. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html. Michael Luc Foisy wrote: I hade it misconfigured (wrong param name prior to MySQL 4.0) Doc Quote http://dev.mysql.com/doc/mysql/en/Error_log.html Beginning with MySQL 4.0.10, you can specify where mysqld stores the error log file with the option --log-error[=file_name]. If no file_name value is given, mysqld uses the name `'hostname'.err' and writes the file in the data directory. (Prior to MySQL 4.0.10, the Windows error log name is `mysql.err'.) If you execute FLUSH LOGS the error log will be renamed with a suffix of -old and mysqld creates a new empty log file. In older MySQL versions on Unix, error log handling was done by mysqld_safe which redirected the error file to 'hostname'.err. You could change this filename by specifying a --err-log=filename option to mysqld_safe. End Doc Quote I changed it to what it should be according to the documentation and again it writes to $HOSTNAME.err [mysqld_safe] --err-log=/usr/data/mysql/mysql.err I am restaring MySQL with: /etc/rc.d/init.d/mysql stop /etc/rc.d/init.d/mysql start mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) RedHat 9.0 What I am seeing with ps -axw 14683 pts/0S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/usr/data/mysql --pid-file=/usr/data/mysql/mysql.pid 14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql --user=mysql --pid-file=/usr/data/mysql/mysql.pid -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 9:12 AM To: Paul DuBois; MYSQL-List (E-mail) Subject: RE: mysql error file I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section My log file is still writing to $HOSTNAME.err Is me /etc/my.cnf file wrong in some way? You might want to use [mysqld_safe] rather than [mysql_safe]. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql error file
Hmm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it does when you tell it to start? Michael Luc Foisy wrote: Actually, that didn't change anything. Still writing to $HOSTNAME.err -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 12:03 PM To: Luc Foisy Cc: Paul DuBois; MYSQL-List (E-mail) Subject: Re: mysql error file Note (see ps output) that you are using safe_mysqld, rather than mysqld_safe, as you have mysql 3.23.58. Hence, you need to change [mysqld_safe] to [safe_mysqld] in your my.cnf. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html. Michael Luc Foisy wrote: I hade it misconfigured (wrong param name prior to MySQL 4.0) Doc Quote http://dev.mysql.com/doc/mysql/en/Error_log.html Beginning with MySQL 4.0.10, you can specify where mysqld stores the error log file with the option --log-error[=file_name]. If no file_name value is given, mysqld uses the name `'hostname'.err' and writes the file in the data directory. (Prior to MySQL 4.0.10, the Windows error log name is `mysql.err'.) If you execute FLUSH LOGS the error log will be renamed with a suffix of -old and mysqld creates a new empty log file. In older MySQL versions on Unix, error log handling was done by mysqld_safe which redirected the error file to 'hostname'.err. You could change this filename by specifying a --err-log=filename option to mysqld_safe. End Doc Quote I changed it to what it should be according to the documentation and again it writes to $HOSTNAME.err [mysqld_safe] --err-log=/usr/data/mysql/mysql.err I am restaring MySQL with: /etc/rc.d/init.d/mysql stop /etc/rc.d/init.d/mysql start mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686) RedHat 9.0 What I am seeing with ps -axw 14683 pts/0S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/usr/data/mysql --pid-file=/usr/data/mysql/mysql.pid 14712 pts/0S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/usr/data/mysql --user=mysql --pid-file=/usr/data/mysql/mysql.pid -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 9:12 AM To: Paul DuBois; MYSQL-List (E-mail) Subject: RE: mysql error file I changed mysql_safe to mysqld_safe and it is still sending the error output to $HOSTNAME.err -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:17 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: mysql error file At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section My log file is still writing to $HOSTNAME.err Is me /etc/my.cnf file wrong in some way? You might want to use [mysqld_safe] rather than [mysql_safe]. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error file
Michael wrote: mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it oes when you tell it to start? Michael I briefly looked in there. This is the same script it uses to start MySQL, and was installed with the rpm of MySQL. I would think it should come with all available options already... To me, it doesn't look like it even reads that option from the my.cnf file. It doesn't look like its reading any option from mysqld_safe group. Pasting the whole thing, so I don't have to work with file attaching. #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # MySQL daemon start/stop script. # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. # When this is done the mysql server will be started when the machine is # started and shut down when the systems goes down. # Comments to support chkconfig on RedHat Linux # chkconfig: 2345 90 90 # description: A very fast and reliable SQL database engine. # Comments to support LSB init script conventions ### BEGIN INIT INFO # Provides: mysql # Required-Start: $local_fs $network $remote_fs # Required-Stop: $local_fs $network $remote_fs # Default-Start: 3 5 # Default-Stop: 3 5 # Short-Description: start and stop MySQL # Description: MySQL is a very fast and reliable SQL database engine. ### END INIT INFO # If you install MySQL on some other places than /, then you # have to do one of the following things for this script to work: # # - Run this script from within the MySQL installation directory # - Create a /etc/my.cnf file with the following information: # [mysqld] # basedir=path-to-mysql-installation-directory # - Add the above to any other configuration file (for example ~/.my.ini) # and copy my_print_defaults to /usr/bin # - Add the path to the mysql-installation-directory to the basedir variable # below. # # If you want to affect other MySQL variables, you should make your changes # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. basedir= # The following variables are only set for letting mysql.server find things. # Set some defaults datadir=/var/lib/mysql pid_file= if test -z $basedir then basedir=/ bindir=/usr/bin else bindir=$basedir/bin fi PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin export PATH if test -z $pid_file then pid_file=$datadir/`/bin/hostname`.pid else case $pid_file in /* ) ;; * ) pid_file=$datadir/$pid_file ;; esac fi mode=$1# start or stop parse_arguments() { for arg do case $arg in --basedir=*) basedir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --datadir=*) datadir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --pid-file=*) pid_file=`echo $arg | sed -e 's/^[^=]*=//'` ;; esac done } # Get arguments from the my.cnf file, # groups [mysqld] [mysql_server] and [mysql.server] if test -x ./bin/my_print_defaults then print_defaults=./bin/my_print_defaults elif test -x $bindir/my_print_defaults then print_defaults=$bindir/my_print_defaults elif test -x $bindir/mysql_print_defaults then print_defaults=$bindir/mysql_print_defaults else # Try to find basedir in /etc/my.cnf conf=/etc/my.cnf print_defaults= if test -r $conf then subpat='^[^=]*basedir[^=]*=\(.*\)$' dirs=`sed -e /$subpat/!d -e 's//\1/' $conf` for d in $dirs do d=`echo $d | sed -e 's/[ ]//g'` if test -x $d/bin/my_print_defaults then print_defaults=$d/bin/my_print_defaults break fi if test -x $d/bin/mysql_print_defaults then print_defaults=$d/bin/mysql_print_defaults break fi done fi # Hope it's in the PATH ... but I doubt it test -z $print_defaults print_defaults=my_print_defaults fi parse_arguments `$print_defaults mysqld mysql_server mysql.server` # Safeguard (relative paths, core dumps..) cd $basedir case $mode in 'start') # Start daemon if test -x $bindir/safe_mysqld then # Give extra arguments to mysqld with the my.cnf file. This script may # be overwritten at next upgrade. $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi else echo Can't execute $bindir/safe_mysqld from dir $basedir fi ;; 'stop') # Stop daemon. We use a signal here to avoid having to know the # root password. if test -s $pid_file then mysqld_pid=`cat $pid_file` echo Killing mysqld with pid $mysqld_pid kill $mysqld_pid # mysqld should remove the pid_file when it exits, so wait for it. sleep 1 while [ -s $pid_file -a $flags != aa ] do [ -z $flags ] echo Wait for mysqld to exit\c || echo .\c flags=a$flags
Re: mysql error file
At 10:10 -0400 4/7/04, Luc Foisy wrote: I have the following in my /etc/my.cnf [mysqld] datadir=/usr/data/mysql pid-file=/usr/data/mysql/mysql.pid socket=/usr/data/mysql/mysql.sock user=mysql [mysql_safe] log-error=/usr/data/mysql/mysql.err [client] socket=/usr/data/mysql/mysql.sock I tried originally to put the log-error= in the [mysqld] section and it errored out, believe I read somewhere then that it should be in the [mysql_safe] section My log file is still writing to $HOSTNAME.err Is me /etc/my.cnf file wrong in some way? You might want to use [mysqld_safe] rather than [mysql_safe]. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error grant tables, help
HI! Sorry for taking so much time to answer, i been away of town!. Glad to hear it worked! =) Best Regards! On Mon, 2004-03-15 at 12:43, Chris Sanchez wrote: Hola, I made 4 changes and it worked. changed 3306 and mysql.sock for both client and server, now it works fine. Those two options killed so much of my time. I followed the instructions line by line and there was never any mention of changing the default my.cnf file. Gracias, Chris -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: Saturday, March 13, 2004 10:37 AM To: Chris Sanchez; [EMAIL PROTECTED] Subject: Re: mysql error grant tables, help Hi! try to look at your my.cnf you haven't config it correctly! At 05:54 p.m. 12/03/2004, Chris Sanchez wrote: get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant and got the same thing. how do i fix? mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10. 8 Saludos, _ ____ __ ___ ___ _ | | ___ _ _ ___ | | _._ _ _ _ __ | \ \ _ _ / __| . || | _| |_ || | |_ || |_ | || ' || | |\ \/| || | |\__ \| | || |_ \__/___||__/ ___||___||_||_|_|`___|/\_\|_|_|_|`_. |___/`___\|___| ___' Victor Medina M Java - Linux - MySQL [EMAIL PROTECTED] geek by nature, linux by choice -- _ ____ __ ___ ___ _ | | ___ _ _ ___ | | _._ _ _ _ __ | \ \ _ _ / __| . || | _| |_ || | |_ || |_ | || ' || | |\ \/| || | |\__ \| | || |_ \__/___||__/ ___||___||_||_|_|`___|/\_\|_|_|_|`_. |___/`___\|___| ___' Victor Medina M Java - Linux - MySQL [EMAIL PROTECTED] geek by nature, linux by choice Everything is permissible but not everything is beneficial. Everything is permissible, but not everything is constructive. I Corinthians 10:23
RE: mysql error grant tables, help
Hola, I made 4 changes and it worked. changed 3306 and mysql.sock for both client and server, now it works fine. Those two options killed so much of my time. I followed the instructions line by line and there was never any mention of changing the default my.cnf file. Gracias, Chris -Original Message- From: Victor Medina [mailto:[EMAIL PROTECTED] Sent: Saturday, March 13, 2004 10:37 AM To: Chris Sanchez; [EMAIL PROTECTED] Subject: Re: mysql error grant tables, help Hi! try to look at your my.cnf you haven't config it correctly! At 05:54 p.m. 12/03/2004, Chris Sanchez wrote: get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant and got the same thing. how do i fix? mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10. 8 Saludos, _ ____ __ ___ ___ _ | | ___ _ _ ___ | | _._ _ _ _ __ | \ \ _ _ / __| . || | _| |_ || | |_ || |_ | || ' || | |\ \/| || | |\__ \| | || |_ \__/___||__/ ___||___||_||_|_|`___|/\_\|_|_|_|`_. |___/`___\|___| ___' Victor Medina M Java - Linux - MySQL [EMAIL PROTECTED] geek by nature, linux by choice
Re: mysql error grant tables, help
Hi! try to look at your my.cnf you haven't config it correctly! At 05:54 p.m. 12/03/2004, Chris Sanchez wrote: get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant and got the same thing. how do i fix? mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10. 8 Saludos, _ ____ __ ___ ___ _ | | ___ _ _ ___ | | _._ _ _ _ __ | \ \ _ _ / __| . || | _| |_ || | |_ || |_ | || ' || | |\ \/| || | |\__ \| | || |_ \__/___||__/ ___||___||_||_|_|`___|/\_\|_|_|_|`_. |___/`___\|___| ___' Victor Medina M Java - Linux - MySQL [EMAIL PROTECTED] geek by nature, linux by choice
Re: Mysql error message
Are you able to start the MySQL server? Is there anything being logged to the hostname.err log? Original Message On 2/3/04, 7:23:50 PM, vincent.gueu [EMAIL PROTECTED] wrote regarding Mysql error message: I've installed mysql under Linux and what I do, I always have this number of error message :040204. Please I need your help! Thank u Vinx Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,34/mn) ; tél : 08 92 68 13 50 (0,34/mn) -- 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]
RE: Mysql error message
From: vincent.gueu [mailto:[EMAIL PROTECTED] I've installed mysql under Linux and what I do, I always have this number of error message :040204. Please I need your help! Thank u I have no idea what your problem is, but I'd be amused if you had the number 040205 tomorrow (those being today's and tomorrow's dates, respectively). Can you elaborate on the problem? Where do you get this error? -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql error
Don, the InnoDB text below is only a help message, not an error, and is not dangerous. It is not associated with the timeout problems you have on Fedora. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Don Matlock [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 06, 2004 2:07 AM Subject: Mysql error Hi all, Larry Brown tried to help me out with this one (much appreciated Larry), anyways, when I start up fedora I get this error from mysql that says it has timed out...it still works, but this error shows up in the mysql logs: 040104 18:38:37 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 /usr/libexec/mysqld: ready for connections Everytime I restart fedora this is the log that is made. Mysql is still working as my phpBB2 dateabase is still functioning...but it is annoying. When I set fedora to run at run lvl 3 instead of 5...Mysql and apache stop working all together (the reason I know this is I wanted to stop X from starting every time I booted up...wanted it to boot into a text start up). Anyways...anythoughts on how I might be able to remedy this error...Larry suggested I check the rc.d files and see if mysql is pre-maturely starting...but I really don't know what to look for in those areas:( Anyways...any thoughts are greatly appreciated. Don -- 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]
Re: mysql error
Alex E.Wintermann [EMAIL PROTECTED] wrote: MySQL 4.1.0-alpha-max-nt phpMyAdmin 2.5.4 /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY `id` (`id`) ) TYPE=InnoDB CHARSET=cp1251; INSERT INTO `sp_tovar_vid` VALUES (1, 0, 'string 1', ''); INSERT INTO `sp_tovar_vid` VALUES (2, 1, 'string 2', ''); INSERT INTO `sp_tovar_vid` VALUES (3, 2, 'string 3', ''); INSERT INTO `sp_tovar_vid` VALUES (4, 0, 'string 4', ''); INSERT INTO `sp_tovar_vid` (`id`,`id_tovar_vid`,`name`,`description`) VALUES ('','0','',''); UPDATE `sp_tovar_vid` SET `id` = '0' WHERE `id` = LAST_INSERT_ID() LIMIT 1 ; /* END DUMP */ /* BEGIN QUERY */ SELECT t1.`id`, CONCAT(if(t3.`name`='','',CONCAT(t3.`name`,' - ')),if(t2.`name`='','',CONCAT(t2.`name`,' - ')),t1.`name`) AS col1, t1.`description` FROM`sp_tovar_vid` AS t1, `sp_tovar_vid` AS t2, `sp_tovar_vid` AS t3 WHERE t1.`id_tovar_vid`=t2.`id` AND t2.`id_tovar_vid`=t3.`id` AND col1'string' ORDER BY col1; /* END QUERY */ QUESTION: why ERROR caused: #1054 - Unknown column 'col1' in 'where clause' You can't use column alias in the WHERE clause. Use HAVING instead: http://www.mysql.com/doc/en/Problems_with_alias.html result wanted ++--+-+ | id | col1 | description | ++--+-+ | 1 | string 1 | | | 2 | string 1 - string 2 | | | 3 | string 1 - string 2 - string 3 | | | 4 | string 4 | | ++--+-+ 4 rows in set (0.00 sec) /**/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: MySQL Error
Several possibilites: 1) Your password for user 'master2' is wrong; 2) master2 doesn't have the proper GRANT rights to do what you want; 3) master2 doesn't exist. Check the mySQL manual. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- -Original Message- From: Pushpinder Singh [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 12:14 PM To: [EMAIL PROTECTED] Subject: MySQL Error Hello All, I am trying to import data from a text file into MySQL. I am using phpMyAdmin to control the database. When I try to execute the query I keep getting this error. Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Can anyone throw some light on this. Thanks in advance Pushpinder Singh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error
Thanks Josh, I wish that were the case.. I am already inside phpMyAdmin and I can manually edit and add new records. However when I try to add records from a file I keep getting the same error. If the user master2 did nto exist or have the required GRANT rights, then I wud not have been able to get into the database itslef in the first place. Thanks again though. Any ideas ? Pushpinder On Wednesday, December 10, 2003, at 12:16 PM, Joshua Thomas wrote: 1) Your password for user 'master2' is wrong; 2) master2 doesn't have the proper GRANT rights to do what you want; 3) master2 doesn't exist.
RE: MySQL Error
If the user master2 did nto exist or have the required GRANT rights, then I wud not have been able to get into the database itslef in the first place. Thanks again though. Any ideas ? If you read the GRANT section of the mySQL manual (http://www.mysql.com/doc/en/GRANT.html) you'll see that you can grant only use of SELECT, or SELECT and UPDATE, and so forth. Your import may be using an option you don't have the correct GRANT rights for. Please review the manual, check your current GRANT rights for your user, adjust as necessary, and let us know how it goes. Cheers, Joshua Thomas
Re: mysql error
vikas kamble [EMAIL PROTECTED] wrote: I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or access database it's given me following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Please guide me what should i do. even i try to instal nushere tool on R.H. 9.0. but not able to connect mysql server. Is MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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: MySQL ERROR in LOAD DATA
I use a CPanel Shared hosting environment where MySQL user is not permitted with FILE privilege. Please help me by telling what is the alternate process to LOAD DATA from a text data file to MySQL table. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL ERROR in LOAD DATA
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I use a CPanel Shared hosting environment where MySQL user is not permitted with FILE privilege. Please help me by telling what is the alternate process to LOAD DATA from a text data file to MySQL table. You can use LOAD DATA LOCAL. In this case user doesn't need FILE privilege, but this command should be enabled. For more info look at: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html Note: file should be located on the client box. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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: MySQL ERROR in LOAD DATA
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I am currently using MySQL 4.0.14-standard along with PHP 4.3.2 in Apache 1.3.28. I have written following code to upload some data from the hosting directory to database table. But LOAD DATA statement always fails. I have checked the same SQL using Sql-Front. It is showing Access denied. But table is creating, data is not loading using same connection. User must have FILE privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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: MySQL error code 1064:K@N@!:
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an application - ng. Could there be a problem with my ODBC driver? Here is its description: MySQL ODBC 3.51 Driver DSN. It is running on an old WinNT box with SP6a applied, and accessing a MySQL server running on a virtual RedHat v7.2 server. I have been able to do any selects I want ok. This is my first attempt to insert. David Precious [EMAIL PROTECTED] 07/25/03 11:54 AM On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: I cannot seem to find this in the MYSQL Reference. Are there other places I should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- 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]
Re: MySQL error code 1064
On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: I cannot seem to find this in the MYSQL Reference. Are there other places I should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error code 1064
I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:05AM I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- 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]
Re: MySQL error code 1064
I found the following by performing a google search: 1602 Btree unpacked page size (from header) does not match size loaded from disk Not sure what this means, but still looking for a better error reference. The link found in the google search was: http://www.clarionmag.com/cmag/v1/v1n1tpserrorcodes.html Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:07 AM I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- 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]
Fwd: Re: MySQL error code 1064
I found a syntax error which caused the 1602 error and corrected it. I am now back to struggling with the '1064 - You have...' error. Unfortunately, I have been unable to find any reference to this particular error. ---BeginMessage--- I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. Kenneth Illingsworth [EMAIL PROTECTED] 07/25/03 08:05AM I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. The ODBC connector performs its function in the application without any errors. Thanks in advance for any direction you can give. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error code 1064
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an application - ng. Could there be a problem with my ODBC driver? Here is its description: MySQL ODBC 3.51 Driver DSN. It is running on an old WinNT box with SP6a applied, and accessing a MySQL server running on a virtual RedHat v7.2 server. I have been able to do any selects I want ok. This is my first attempt to insert. David Precious [EMAIL PROTECTED] 07/25/03 11:54 AM On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: I cannot seem to find this in the MYSQL Reference. Are there other places I should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It would have been saying You have an error in your SQL syntax near It occurred on a submitted insert statement originating in an application. The insert statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error Log problem.
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400: [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe [5] 703 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030618 11:50:09 mysqld ended [5]Done sudo ./bin/mysqld_safe Can u tell me how/ where to view the error logs...? As always: in the manual. :) Or, in your mysqld datadir. It's called `hostname`.err by default. -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL error
Create a symlink for mysqld.sock in /tmp. ln -s /path/to/your/mysql.sock /tmp This should resolve the problem in over 90% of the cases. once this is fixed it is likely that you have other problems. but we'll discuss them when we get there ;-) --- Mike [EMAIL PROTECTED] wrote: Hi All Running FreeBSD 4.7 MySQL 3.23. When trying to run or start MySQL I get 030201 16:32:59 Can't start server : Bind on unix socket: Permission denied 030201 16:32:59 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030201 16:32:59 Aborting 030201 16:32:59 /usr/local/libexec/mysqld: Shutdown Complete 030201 16:32:59 mysqld ended I have removed and reinstalled Mysql, checked permissions, made sure nothing else is running on that port tried safe_mysqld and still got the same error. Any hints would be great! SQL DATABASE Mike Benzel [EMAIL PROTECTED] for NT Linux-Palm-CASL Support Cross Platform Messaging and TDataSet Components: TAstaPDADataSets Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE,Linux PDA's) ASTA Technology Group http://www.astatech.com ASTAWireless http://www.astawireless.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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: MySQL error (Errcode: 13)
Dhanashri, ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 ) Error on rename of '.\etime\timesheet.MYI' to '.\etime\#sql2-64c-19.MYI' (Errcode: 13) I had the same kind of problem with ALTER TABLE and MySQL 4.0.5 under Win2K. Errorcode 13 means it's a permission problem. I never solved this problem, but it disappeared an never returned after I upgraded to 4.0.5. I you do not want to upgrade to version 4 (for whatever reason, as it runs stable as rock), you might want to use the workaround I used: CREATE TABLE timesheetCopy SELECT * FROM timesheet; DROP TABLE timesheet; RENAME TABLE timesheetCopy TO timesheet; ALTER TABLE timesheet ADD phase_desc VARCHAR(50); For some strange reason, I never encountered permission errors with copied tables, only with the original ones. My phpMySQL version is 3.23.55-nt Well, that's rather your MySQL version. See above what I said about upgrading. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Dhanashri Peramanu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 27, 2003 10:25 PM Subject: MySQL error (Errcode: 13) Anybody have an idea about the following error (Errcode: 13)? I am simply trying to add one more field in the table timesheet. My phpMySQL version is 3.23.55-nt Thanks. -Dhanashri Peramanu -- -- -- -- -- Error SQL-query : ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 ) MySQL said: Error on rename of '.\etime\timesheet.MYI' to '.\etime\#sql2-64c-19.MYI' (Errcode: 13) -- -- -- -- - - 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
RE: Mysql Error
The error that you have is normally that MySQL in not running. If it is running then MySQL client can not find the sock file. I should not think you will have to reinstall. Simon -Original Message- From: Daniel Florian [mailto:[EMAIL PROTECTED]] Sent: 15 January 2003 13:11 To: [EMAIL PROTECTED] Subject: Mysql Error When I try to connect to the MySql server on localhost I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I am not quite sure what this means. I am running Mac OS X 10.2.3. Before I upgraded from 10.1, I had no problems, but now am unable to connect at all. Is it possible to remove MySql (and how do I go about it) so that I can reinstall it again? Sorry if these are stupid questions, but I can't seem to find how to uninstall MySql in the manual. Thanks -- Daniel Florian [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] (work) - 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
Re: MySQL - ERROR 2003: Can't connect
Clive Grigg wrote: Hi. I am new to this and can't get started because I receive the error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). o/s : WindowsXP. Any ideas? Thanks, Clive. Hi, I don't use MySQL on Windows so I can't really help you; however, have you checked the manual ? This page: http://www.mysql.com/doc/en/Can_not_connect_to_server.html may be useful, there are some comments on error 2003 from users at the bottom of this page. Hope this helps -- Joseph Bueno - 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: MySQL Error
At 13:15 +0300 10/11/02, Victoria Reznichenko wrote: Abhi, Thursday, October 10, 2002, 8:30:43 PM, you wrote: A I am not able to connect mysql server after executing this command A ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O A sort_buffer=4M -O read_buffer_size=1M The probable problem here is that read_buffer_size is called record_buffer prior to MySQL 4.0.3. A [repository@shoggoth bin]$ ./mysql -u root A ERROR 2002: Can't connect to local MySQL server through socket A '/tmp/mysql.sock' (2) [skip] A but my process is running. I have tryed to restart also but unable to A restart mysql server successifully. A mysql show processlist; A +---+--+---+-+-+--+- A -+--+ A | Id| User | Host | db | Command | Time | A State A | Info | A +---+--+---+-+-+--+- A -+--+ A | 19509 | root | localhost | mysql | Sleep | 481 A | A | NULL | A | 19532 | root | localhost | DS_data | Query | 0| A NULL A | show processlist | A | 19547 | root | localhost | DS_data | Query | 39 | Copying to tmp A table on A disk | select distinct name_server1 from tbl_raw_zone_file limit 10 | A +---+--+---+-+-+--+- A -+--+ A The error (2002) Can't connect to ... normally means that there isn't a A MySQL server running on the system or A that you are using a wrong socket file or TCP/IP port when trying to A connect to the mysqld server. A Error Log A - A 021010 10:30:41 mysqld started A No variable match for: -O 'read_buffer_size=1M' A /usr/local/mysql/libexec/mysqld Ver 3.23.49 for pc-linux-gnu on i686 A Use '--help' or '--no-defaults --help' for a list of available o A I am using mysql version 3.23 A mysql select version(); A +-+ A | version() | A +-+ A | 3.23.49-log | A +-+ A 1 row in set (0.00 sec) A ptions A 021010 10:30:41 mysqld ended ^ But error log shows that MySQL didn't start. Do you have another MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
re: MySQL Error
Abhi, Thursday, October 10, 2002, 8:30:43 PM, you wrote: A I am not able to connect mysql server after executing this command A ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O A sort_buffer=4M -O read_buffer_size=1M A [repository@shoggoth bin]$ ./mysql -u root A ERROR 2002: Can't connect to local MySQL server through socket A '/tmp/mysql.sock' (2) [skip] A but my process is running. I have tryed to restart also but unable to A restart mysql server successifully. A mysql show processlist; A +---+--+---+-+-+--+- A -+--+ A | Id| User | Host | db | Command | Time | A State A | Info | A +---+--+---+-+-+--+- A -+--+ A | 19509 | root | localhost | mysql | Sleep | 481 A | A | NULL | A | 19532 | root | localhost | DS_data | Query | 0| A NULL A | show processlist | A | 19547 | root | localhost | DS_data | Query | 39 | Copying to tmp A table on A disk | select distinct name_server1 from tbl_raw_zone_file limit 10 | A +---+--+---+-+-+--+- A -+--+ A The error (2002) Can't connect to ... normally means that there isn't a A MySQL server running on the system or A that you are using a wrong socket file or TCP/IP port when trying to A connect to the mysqld server. A Error Log A - A 021010 10:30:41 mysqld started A No variable match for: -O 'read_buffer_size=1M' A /usr/local/mysql/libexec/mysqld Ver 3.23.49 for pc-linux-gnu on i686 A Use '--help' or '--no-defaults --help' for a list of available o A I am using mysql version 3.23 A mysql select version(); A +-+ A | version() | A +-+ A | 3.23.49-log | A +-+ A 1 row in set (0.00 sec) A ptions A 021010 10:30:41 mysqld ended ^ But error log shows that MySQL didn't start. Do you have another MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
Re: Mysql Error
I have installed the php-mysql package and can now connect to the database. There is however another error which i do not undertand. Warning: No MySQL-Link resource supplied in /usr/local/www/vantweststamps/databaselogin.php on line 15 Connected successfully These pages all work without error on my win98 machine with apache, mysql and php. Is there any documentation whoich lists all of these error conditions ans suggests ways of solving them? Regards Peter Goggin - Original Message - From: Thomas Seifert [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 12:28 AM Subject: Re: Mysql Error if I remember right, there is a php-mysql*rpm package for redhat which corrects this problem. Thomas On Wed, 25 Sep 2002 23:23:07 +1000 Peter Goggin [EMAIL PROTECTED] wrote: The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 10:30 PM Subject: Re: Mysql Error Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 - 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: Mysql Error
Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Mysql Error
The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 10:30 PM Subject: Re: Mysql Error Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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