Hi,
Okay, ill remove the extra log then.
The problem isnt that the socket doesn't get created, its that it randomly
disappears when mysql has been running for weeks already. So, /tmp's
permissions are correct, and everything works for a undecided amount of
time, then it just disappears and mysql
Hi,
I dont know about network, but I know using php we cant access anything in
MySQL once the file is gone. When it happens again, ill be sure to check
network.
Cheers
Ian
On Fri, Feb 29, 2008 at 12:54 PM, Sebastian Mendel <[EMAIL PROTECTED]>
wrote:
> Ian schrieb:
> > Hi,
> >
> > I wouldnt have
Ian schrieb:
Hi,
I wouldnt have thought so but whenever that file is missing and try the
stop/restart it just sits at the waiting for pids part of the stop loop
(where it lists the pids), and it never stops the server - i have left it
for over an hour and it never stops - just keeps on in the st
Hi,
I wouldnt have thought so but whenever that file is missing and try the
stop/restart it just sits at the waiting for pids part of the stop loop
(where it lists the pids), and it never stops the server - i have left it
for over an hour and it never stops - just keeps on in the stop loop.
Cheer
Ian schrieb:
Hi,
I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
/tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysql and
restart it causing db corruptions as there is no other way of telling it to
stop once that file has gone. I have tried to find any r
Hi,
Okay, I have added that and will wait and see when it happens again if there
is anything in that log. Just out of interest, does that log show anything
different to the /var/db/mysql/hostnameofunit.err file ?
Cheers
Ian
On Thu, Feb 28, 2008 at 8:44 PM, Vidal Garza <[EMAIL PROTECTED]> wrote:
Hi,
No, there is nothing in there cleaning /tmp. Mind you, further investigating
there are still some temp files in there from last year - so the directory
isnt getting wiped clean.
Thanks :)
On Fri, Feb 29, 2008 at 3:36 AM, Steve Bernacki <[EMAIL PROTECTED]>
wrote:
> Does the system in questio
Does the system in question have some type of "/tmp" cleaner script that
might be removing the socket file? Check /etc/crontab and root's crontab
(crontab -l)
Steve
Its for test.
put the log file on my.cnf and tellus what going on
my.cnf
...
log-error=/var/db/mysql/Server_Error.log
Ian escribió:
Hi,
We use the following sh script to start (its the default one when installed)
cat /usr/local/etc/rc.d/mysql-server.sh
#!/bin/sh
#
# $FreeBSD: ports/databases
Hi,
We use the following sh script to start (its the default one when installed)
cat /usr/local/etc/rc.d/mysql-server.sh
#!/bin/sh
#
# $FreeBSD: ports/databases/mysql50-server/files/mysql-server.sh.in,v
1.32006/03/07 16:25:00 ale Exp $
#
# PROVIDE: mysql
# REQUIRE: LOGIN
# KEYWORD: shutdown
#
#
how do you start up?
you can start up from scrip.
#!/bin/sh
id="02"
ip="192.168.0.42"
sockfile="/tmp/mysql$id.sock"
user="mysql"
datdir="/var/db/mysql$id"
port="3306"
/bin/sh /usr/local/bin/mysqld_safe --user=$user --datadir=$datdir
--bind-address=$ip --port=$port --sock=$sockfile &
Ian esc
ysql/bin/mysqld: Shutdown Complete
041110 20:33:42 mysqld ended
Though i can't find any mysqld running on my computer.
Can someone helps ?
Thanks, kenji.
Message du 10/11/04 14:06
De : "Michael Stassen" <[EMAIL PROTECTED]>
A : [EMAIL PROTECTED]
Copie à : [EMAIL PROTECTED]
an someone helps ?
Thanks, kenji.
> Message du 10/11/04 14:06
> De : "Michael Stassen" <[EMAIL PROTECTED]>
> A : [EMAIL PROTECTED]
> Copie à : [EMAIL PROTECTED]
> Objet : Re: /tmp/mysql.sock disappeared on mac 10.3
>
> The socket file is created by mysqld when it
Hello.
Check if another copy of mysqld process is running
(may be it runs with lost mysql.sock file?).
Check also permissions for .err file. And be sure you are starting MySQL as
root, because it will suid to the user you have specified.
See:
http://dev.mysql.com/doc/mysql/en/Startin
The socket file is created by mysqld when it starts, and goes away when
mysqld shuts down. That is, you have no socket file because mysqld is not
running, not the other way around.
You appear to be trying to start mysqld as OS user admin. Normally, only
root has the power make the switch to u
.
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com]
Sent: Monday, November 11, 2002 1:48 PM
To: Adolfo Bello
Cc: Black, Kelly W [PCS]; Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
There is a cleanup script run via cron that removes files from
l Lists <[EMAIL PROTECTED]>
|
| Subject: RE: /tmp/mysql.sock question (newbie)
|
>-
mysql.sock /tmp/mysql.sock
and things seem to work fine.
~K Black
-Original Message-
From: Adolfo Bello [mailto:adolfobello@;bisapi.com]
Sent: Monday, November 11, 2002 1:32 PM
To: Black, Kelly W [PCS]
Cc: Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
I am also a newbi
I am also a newbie so don't misunderstand my question. Is there any
performance or functionality reason to change mysql.sock location?
Adolfo
On Mon, 2002-11-11 at 14:37, Black, Kelly W [PCS] wrote:
You can do this in /etc/my.cnf
~K Black
-Original Message-
From:
You can do this in /etc/my.cnf
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com]
Sent: Monday, November 11, 2002 10:05 AM
To: [EMAIL PROTECTED]
Subject: /tmp/mysql.sock question (newbie)
Hello all, I would like to change where the /tmp/mysql.sock file get
> I copied my.cnf to /etc and /var/db/mysql
> and made a file mysql.sock in tmp (/tmp/mysql.sock)
>
> What do I put in mysql.sock?
Nothing. The server creates it when it starts up. Read the docs.
sql, query
-
Before posting,
adam,
Tuesday, June 04, 2002, 7:55:23 PM, you wrote:
the mysql.sock file is automatically created when mysqld is started.
please check your configuration (/etc/my.cnf) and your mysql daemon ... :D
>>>
>>
>> a> Thanks. However, something's still wrong.
>>
>> a> Restarted the daemon
OK got this sorted in the end, by putting a soft link in to the /tmp
folder pointing to the /var/lib - thanks one and all.
Adam
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find
Egor Egorov wrote:
> adam,
>
> Tuesday, June 04, 2002, 12:05:30 PM, you wrote:
>
>>>the mysql.sock file is automatically created when mysqld is started.
>>>please check your configuration (/etc/my.cnf) and your mysql daemon ... :D
>>>
>>
>
> a> Thanks. However, something's still wrong.
>
> a
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find an
>>archived version of the mailing list, or a fix to my problem. Using
>>Linux Mandrake 8.2.
>>
>>It's the problem with mysql.
adam,
Tuesday, June 04, 2002, 12:05:30 PM, you wrote:
>>
>> the mysql.sock file is automatically created when mysqld is started.
>> please check your configuration (/etc/my.cnf) and your mysql daemon ... :D
>>
a> Thanks. However, something's still wrong.
a> Restarted the daemon - /usr/sbin/s
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find an
>>archived version of the mailing list, or a fix to my problem. Using
>>Linux Mandrake 8.2.
>>
>>It's the problem with mysql.
On Tue, 04 Jun 2002 08:04:01 +0100
adam <[EMAIL PROTECTED]> wrote:
> Apologies for posting such a basic query, but I couldn't find an
> archived version of the mailing list, or a fix to my problem. Using
> Linux Mandrake 8.2.
>
> It's the problem with mysql.sock, which I've tried to make the /
> A better solution would be to do it in /etc/my.cnf, so that it will be
> system-wide.
BINGO!!! That did it!
The only additional question I have at this point, then, is what to do
about
my scenario where I want to run 3.22 and 3.23 concurrently on a box where
the user will be the same for
> create a .my.cnf in the home directory of the user that will be running
> the clients, and enter a
> [client]
>
> paragraph that defines the socket.
A better solution would be to do it in /etc/my.cnf, so that it will be
system-wide for the database.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 2
create a .my.cnf in the home directory of the user that will be running
the clients, and enter a
[client]
paragraph that defines the socket.
BW wrote:
> Ed,
>
>
>> 1. Is MySQL actually running?
>
> Yes.
>
>
>> 2. If so, where is it putting mysql.sock?
>
> It is putting it into /raid/mysq
Ed,
> 1. Is MySQL actually running?
Yes.
> 2. If so, where is it putting mysql.sock?
It is putting it into /raid/mysql/data/mysql41.sock -- I specified this
location in the socket variable(?) in both [client] and [mysqld] sections of
the my.cnf file. my.cnf is located in /raid/mysql/data; there
BW (ST) ([EMAIL PROTECTED]) writes:
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/path/to/socket in both [client] and [mysqld]
> sections of my.cnf, and I've tried to edit safe_mysqld directly with this
> path. In all cases, the mysql ser
Well, this is a client error, not a server error.
What client is this?
Maybe you have another my.cnf in the data directory,
or possibly a .my.cnf file in your home directory.
BW (ST) wrote:
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/pa
Yes, I gave it 644 permissions.
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: "BW (ST)" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:58 AM
Subject: RE: 'tmp/m
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/path/to/socket in both [client] and [mysqld]
> sections of my.cnf, and I've tried to edit safe_mysqld directly with this
> path. In all cases, the mysql server appears to start (no error messag
sarahana schrieb am Freitag, 3. August 2001, 03:07:31:
> If mysql is shown when runnnig phpinfo() - does it mean that its installed,
> and if yes, why this error?
this only shows that php is compiled with mysql support.
> thanks, what needs to ben done?
I assume you work under win.
You need t
I've had this happen (" Can't connect to local MySQL server") at the
command line when I forgot to specify a host, so mysql assumes localhost.
Check your host argument.
On Thu, 2 Aug 2001, sarahana wrote:
> If mysql is shown when runnnig phpinfo() - does it mean that its installed,
> and if yes
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
> I couldn't fine this mentioned in the archives, so I hope someone has seen
> this before:
>
> I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
>
> There is still server process (sleeping), and there is still
On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote:
> Do you have a cron job that's cleaning up your socket file along with
> whatever other garbage it's cleaning up?
Nope. As I said in my original mail:
> I don't have a cronjob, or any other external process that scrubs /tmp.
I'm wa
Do you have a cron job that's cleaning up your socket file along with
whatever other garbage it's cleaning up?
- Original Message -
From: "Brian Reichert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 4:42
Subject: Re: /tmp
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote:
> I've seen it after installing two versions of MySQL on one server.
> I forgot to set another location for the second MySQL process
> before starting it with /bin/safe_mysqld. The result was that the
> socket was removed by the secon
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
> I couldn't fine this mentioned in the archives, so I hope someone has seen
> this before:
>
> I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
>
> There is still server process (sleeping), and there is still
43 matches
Mail list logo
