RE: MySQL Error#: 2002

[Stillman, Benjamin]

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

[Rick James]

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

[Jigal van Hemert]

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 1045

[Tim Thorburn]

 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 causing database to not accept threads

[Machiel Richards]

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

[Joerg Bruehe]

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

[machiel.richards]

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 causing database to not accept threads

[Benedikt Schackenberg]

 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

[Rolando Edwards]

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]

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]

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]

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 2013 Lost connection to MySQL server during query

[Darryle Steplight]

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  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

[Michael Dykman]

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  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

[Per Jessen]

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

[Michael Dykman]

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  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

[Per Jessen]

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

[Per Jessen]

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)>=''

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)>=''


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

[Michael Steinfeld]

On Mon, May 25, 2009 at 11:19 AM, Per Jessen  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]

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  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

[Per Jessen]

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

[Per Jessen]

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

[Michael Steinfeld]

just a thought: Did you run "mysql_upgrade" after the import?

On Mon, May 25, 2009 at 10:19 AM, Per Jessen  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

[Per Jessen]

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

[Per Jessen]

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 Number 1045 Access denied

[Paul Choi]

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('') 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] 
> > 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=
> 
> 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]
> 
> 
> 
> 
> -- 
> 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

[Andy Shellam]

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('') 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] 
> 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=

   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]





--
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

[Sharad]

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=
> 
> 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

[Andy Shellam]

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=

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

[AndrewMcHorney]

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 Number 1045 Access denied

[Sreekanth CHAVA]

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

[Mike Zupan]

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

[Michael Dykman]

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.

[Ananda Kumar]

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.

[Sebastian Mendel]

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

[Jerry Schwartz]

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 for Blobs

[Dan Buettner]

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 Number 1130

[Duzenbury, Rich]

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

[Shawn Green]

--- "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.


shell>mysql -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

[Duzenbury, Rich]

 

> -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

[Barry]

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

[Duzenbury, Rich]

> 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

[gerald_clark]

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

[Duzenbury, Rich]

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 
> mysq

Re: MySql Error Number 1130

[mysql]

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: %
>

Re: MySQL Error

[Barry]

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

[Gleb Paharenko]

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 logging

[Daniel Fisla]

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...

[S.Yousaf Shah]

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...

[Karalius, Joseph]

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
> > 
> > 
> &g

RE: MySql error...

[Kevin Cowley]

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 /share/mysql as my.cnf
into the var directory.

Depending exactly on your setup you should end up with
/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
> > >
> > >/

RE: MySql error...

[jschmidt]

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, 

RE: MySql error...

[Kevin Cowley]

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...

[jschmidt]

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...

[mel list_php]

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...

[mel list_php]

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 1251 / phpMyAdmin

[Logan, David (SST - Adelaide)]

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 1251 / phpMyAdmin

[Michael Stassen]

The short answer is, download the php source and add
  --with-mysql=/your/path/to/mysql
to your build options.  The long answer is in the directions in the php 
manual .

Michael
GH wrote:
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
.
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

[GH]

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
> .
> 
> 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

[Michael Stassen]

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 
.

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: 1146 in Egroupware

[Chris Ramsay]

>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: 1146 in Egroupware

[Duncan Hill]

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

[Gleb Paharenko]

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

[Michael Kruckenberg]

starofframe wrote:
Hi all,
I have a problem when I'm trying to connect to mysql server at my web hosting...
appears error message like this :
Could not connect to MySQL server! 
2002: Can't connect to local MySQL server through socket '/usr/home/greatdynamic/mysql/mysql-greatdynamic.sock' (2)

never appeared such problem before... 
I guest that I need to restart mysql (maybe mysql hang after left running all the time)..
so how to restart mysql ... I've tried this command : mysql/bin/safe_mysqld  (not work) 
You can see if mysql is running using (syntax might vary): ps -Af
If it indeed is not running many machines use a start/stop script like 
/etc/init.d/mysql to properly start and stop mysql.

If it is running maybe the configuration has changed, can you connect 
using -h ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql error file

[Luc Foisy]

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=
# - 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
el

RE: mysql error file

[Luc Foisy]

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=
# - 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"

Re: mysql error file

[Michael Stassen]

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

[Luc Foisy]

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 Stassen]

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

[Luc Foisy]

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

[Luc Foisy]

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

[Paul DuBois]

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

[Victor Medina]

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

[Chris Sanchez]

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

[Victor Medina]

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

[Mike Johnson]

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 message

[vpendleton]

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

[Heikki Tuuri]

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

[Egor Egorov]

"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

[Joshua Thomas]

> 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

[Pushpinder Singh]

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

[Joshua Thomas]

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

[Victoria Reznichenko]

"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

[Victoria Reznichenko]

"[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]]

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

[Victoria Reznichenko]

"[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@!:

[Kenneth Illingsworth]

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

[Kenneth Illingsworth]

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]

Fwd: Re: MySQL error code 1064

[Kenneth Illingsworth]

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.
--- Begin Message ---
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

[Kenneth Illingsworth]

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]

Re: MySQL error code 1064

[Kenneth Illingsworth]

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

[David Precious]

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.

[Roman Neuhauser]

# [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

[Nasser Ossareh]

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)

[Stefan Hinz, iConnect \(Berlin\)]

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 
  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

[Simon Green]

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

[Joseph Bueno]

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

[Paul DuBois]

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

[Victoria Reznichenko]

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

[Peter Goggin]

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