thr3ads.net - Rails - error connecting to mysql [Sep 2008]

If this information is useful, please help other people find it:
Share via:

Adolf Charles

2008-Sep-03 18:27 UTC

error connecting to mysql

i was trying to setup an application checked  out from svnin my local
machine. i managed to do  all that is required except when it came to
the step of creating databases for the application, when i tried to
connect to mysql i got this error

ERROR 2002 (HY000): Can''t connect to local MySQL server through socket
''/var/lib/mysql/mysql.sock'' (2)

i have spent more than 5 hours trying to solve this without any success.

your help please

thanks
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-03 18:35 UTC

head link

Re: error connecting to mysql

On Wed, 2008-09-03 at 20:27 +0200, Adolf Charles wrote:> i was trying to setup an application checked  out from svnin my local
> machine. i managed to do  all that is required except when it came to
> the step of creating databases for the application, when i tried to
> connect to mysql i got this error
> 
> ERROR 2002 (HY000): Can''t connect to local MySQL server through
socket
> ''/var/lib/mysql/mysql.sock'' (2)
> 
> i have spent more than 5 hours trying to solve this without any success.
> 
> your help please----
remembering that you''re running Fedora...

is mysqld service running?

service mysqld status

can you connect via command line as the user/password in
config/database.yml ?

mysql -U $USER_IN_DATABSE.YML -p 

Craig


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-03 18:47 UTC

head link

Re: error connecting to mysql

Craig White wrote:> On Wed, 2008-09-03 at 20:27 +0200, Adolf Charles wrote:
>> your help please
> ----
> remembering that you''re running Fedora...
> 
> is mysqld service running?
> 
> service mysqld status
> 
> hi craig,
this is what i got after  service mysqld status

[root@localhost /]# service mysqld status
mysqld dead but subsys locked

and   mysql -U $USER_IN_DATABSE.YML -p  gives


[root@localhost /]# mysql -U  -p
Enter password:
ERROR 2002 (HY000): Can''t connect to local MySQL server through socket 
''/var/lib/mysql/mysql.sock'' (2)
[root@localhost /]#

what should i do please?

thanks
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-03 19:14 UTC

head link

Re: ****[Rails] Re: error connecting to mysql

On Wed, 2008-09-03 at 20:47 +0200, Adolf Charles wrote:> Craig White wrote:
> > On Wed, 2008-09-03 at 20:27 +0200, Adolf Charles wrote:
> >> your help please
> > ----
> > remembering that you''re running Fedora...
> > 
> > is mysqld service running?
> > 
> > service mysqld status
> 
> > 
> > hi craig,
> 
> this is what i got after  service mysqld status
> 
> [root@localhost /]# service mysqld status
> mysqld dead but subsys locked----
that means it''s not running (at least to me)

try ''service mysqld restart''

and see if it stays started and if you then can connect as below
----> 
> and   mysql -U $USER_IN_DATABSE.YML -p  gives
> 
> 
> [root@localhost /]# mysql -U  -p
> Enter password:
> ERROR 2002 (HY000): Can''t connect to local MySQL server through
socket
> ''/var/lib/mysql/mysql.sock'' (2)
> [root@localhost /]#
> 
> what should i do please?
> 
> thanks

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-03 19:33 UTC

head link

Re: ****[Rails] Re: error connecting to mysql

Craig White wrote:> On Wed, 2008-09-03 at 20:47 +0200, Adolf Charles wrote:
>> 
>> 
>> [
> try ''service mysqld restart''
> 
> and see if it stays started and if you then can connect as below
> ----
it does not want to stay started it timed out as soon as i started the 
service

this is what i got after  service mysqld restart

[root@localhost /]# service mysqld restart
Stopping MySQL:                                            [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@localhost /]#
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-03 19:52 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysql

On Wed, 2008-09-03 at 21:33 +0200, Adolf Charles wrote:> Craig White wrote:
> > On Wed, 2008-09-03 at 20:47 +0200, Adolf Charles wrote:
> >> 
> >> 
> >> [
> > try ''service mysqld restart''
> > 
> > and see if it stays started and if you then can connect as below
> > ----
> 
> it does not want to stay started it timed out as soon as i started the 
> service
> 
> this is what i got after  service mysqld restart
> 
> [root@localhost /]# service mysqld restart
> Stopping MySQL:                                            [FAILED]
> Timeout error occurred trying to start MySQL Daemon.
> Starting MySQL:                                            [FAILED]
> [root@localhost /]#----
that would seem to be your problem...logs are your friend

take a look at /var/log/mysqld.log

Craig


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-03 20:03 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

sorry for this but am not that good in linux, that''s why am asking   a 
lot of questions.


/var/log/mysqld.log


080903 16:20:18  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080903 16:20:18  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080903 16:20:19  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080903 16:20:20  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080903 16:20:24  InnoDB: Started; log sequence number 0 0
080903 16:20:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: ''5.0.45''  socket:
''/var/lib/mysql/mysql.sock''  port: 3306
Source distribution
A mysqld process already exists at  Wed Sep 3 20:56:28 EAT 2008
A mysqld process already exists at  Wed Sep 3 20:57:34 EAT 2008
080903 21:00:02 [Note] /usr/libexec/mysqld: Normal shutdown

080903 21:00:03 [ERROR] bdb:  log_archive: DB_ARCH_ABS: No such file or 
directory
080903 21:00:03  InnoDB: Starting shutdown...
080903 21:00:08  InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:00:08 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:00:08  mysqld ended

080903 21:00:52  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080903 21:00:52  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080903 21:00:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080903 21:01:02  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080903 21:01:09  InnoDB: Started; log sequence number 0 0
080903 21:01:10 [ERROR] Can''t start server : Bind on unix socket: 
Permission denied
080903 21:01:10 [ERROR] Do you already have another mysqld server 
running on socket: /var/lib/mysql/mysql.sock ?
080903 21:01:10 [ERROR] Aborting

080903 21:01:10  InnoDB: Starting shutdown...
080903 21:01:13  InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:01:13 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:01:13  mysqld ended

080903 21:05:24  mysqld started
080903 21:05:27  InnoDB: Started; log sequence number 0 43655
080903 21:05:27 [ERROR] Can''t start server : Bind on unix socket: 
Permission denied
080903 21:05:27 [ERROR] Do you already have another mysqld server 
running on socket: /var/lib/mysql/mysql.sock ?
080903 21:05:27 [ERROR] Aborting

080903 21:05:27  InnoDB: Starting shutdown...
080903 21:05:29  InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:05:29 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:05:29  mysqld ended

080903 21:16:40  mysqld started
080903 21:16:44  InnoDB: Started; log sequence number 0 43655
080903 21:16:45 [ERROR] Can''t start server : Bind on unix socket: 
Permission denied
080903 21:16:45 [ERROR] Do you already have another mysqld server 
running on socket: /var/lib/mysql/mysql.sock ?
080903 21:16:45 [ERROR] Aborting

080903 21:16:45  InnoDB: Starting shutdown...
080903 21:16:46  InnoDB: Shutdown completed; log sequence number 0 43655
080903 21:16:46 [Note] /usr/libexec/mysqld: Shutdown complete

080903 21:16:46  mysqld ended

080903 22:26:39  mysqld started
080903 22:26:41  InnoDB: Started; log sequence number 0 43655
080903 22:26:42 [ERROR] Can''t start server : Bind on unix socket: 
Permission denied
080903 22:26:42 [ERROR] Do you already have another mysqld server 
running on socket: /var/lib/mysql/mysql.sock ?
080903 22:26:42 [ERROR] Aborting

080903 22:26:42  InnoDB: Starting shutdown...
080903 22:26:46  InnoDB: Shutdown completed; log sequence number 0 43655
080903 22:26:46 [Note] /usr/libexec/mysqld: Shutdown complete

080903 22:26:46  mysqld ended




-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-03 20:15 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

you must have done something untoward...

try these commands as root

service mysqld stop
rm /var/lib/mysql/mysql.sock
service mysqld start

and see if it stays running

Craig

On Wed, 2008-09-03 at 22:03 +0200, Adolf Charles wrote:> sorry for this but am not that good in linux, that''s why am asking
a
> lot of questions.
> 
> 
> /var/log/mysqld.log
> 
> 
> 080903 16:20:18  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 080903 16:20:18  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 080903 16:20:19  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 080903 16:20:20  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 080903 16:20:24  InnoDB: Started; log sequence number 0 0
> 080903 16:20:27 [Note] /usr/libexec/mysqld: ready for connections.
> Version: ''5.0.45''  socket:
''/var/lib/mysql/mysql.sock''  port: 3306
> Source distribution
> A mysqld process already exists at  Wed Sep 3 20:56:28 EAT 2008
> A mysqld process already exists at  Wed Sep 3 20:57:34 EAT 2008
> 080903 21:00:02 [Note] /usr/libexec/mysqld: Normal shutdown
> 
> 080903 21:00:03 [ERROR] bdb:  log_archive: DB_ARCH_ABS: No such file or 
> directory
> 080903 21:00:03  InnoDB: Starting shutdown...
> 080903 21:00:08  InnoDB: Shutdown completed; log sequence number 0 43655
> 080903 21:00:08 [Note] /usr/libexec/mysqld: Shutdown complete
> 
> 080903 21:00:08  mysqld ended
> 
> 080903 21:00:52  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 080903 21:00:52  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 080903 21:00:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 080903 21:01:02  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 080903 21:01:09  InnoDB: Started; log sequence number 0 0
> 080903 21:01:10 [ERROR] Can''t start server : Bind on unix socket: 
> Permission denied
> 080903 21:01:10 [ERROR] Do you already have another mysqld server 
> running on socket: /var/lib/mysql/mysql.sock ?
> 080903 21:01:10 [ERROR] Aborting
> 
> 080903 21:01:10  InnoDB: Starting shutdown...
> 080903 21:01:13  InnoDB: Shutdown completed; log sequence number 0 43655
> 080903 21:01:13 [Note] /usr/libexec/mysqld: Shutdown complete
> 
> 080903 21:01:13  mysqld ended
> 
> 080903 21:05:24  mysqld started
> 080903 21:05:27  InnoDB: Started; log sequence number 0 43655
> 080903 21:05:27 [ERROR] Can''t start server : Bind on unix socket: 
> Permission denied
> 080903 21:05:27 [ERROR] Do you already have another mysqld server 
> running on socket: /var/lib/mysql/mysql.sock ?
> 080903 21:05:27 [ERROR] Aborting
> 
> 080903 21:05:27  InnoDB: Starting shutdown...
> 080903 21:05:29  InnoDB: Shutdown completed; log sequence number 0 43655
> 080903 21:05:29 [Note] /usr/libexec/mysqld: Shutdown complete
> 
> 080903 21:05:29  mysqld ended
> 
> 080903 21:16:40  mysqld started
> 080903 21:16:44  InnoDB: Started; log sequence number 0 43655
> 080903 21:16:45 [ERROR] Can''t start server : Bind on unix socket: 
> Permission denied
> 080903 21:16:45 [ERROR] Do you already have another mysqld server 
> running on socket: /var/lib/mysql/mysql.sock ?
> 080903 21:16:45 [ERROR] Aborting
> 
> 080903 21:16:45  InnoDB: Starting shutdown...
> 080903 21:16:46  InnoDB: Shutdown completed; log sequence number 0 43655
> 080903 21:16:46 [Note] /usr/libexec/mysqld: Shutdown complete
> 
> 080903 21:16:46  mysqld ended
> 
> 080903 22:26:39  mysqld started
> 080903 22:26:41  InnoDB: Started; log sequence number 0 43655
> 080903 22:26:42 [ERROR] Can''t start server : Bind on unix socket: 
> Permission denied
> 080903 22:26:42 [ERROR] Do you already have another mysqld server 
> running on socket: /var/lib/mysql/mysql.sock ?
> 080903 22:26:42 [ERROR] Aborting
> 
> 080903 22:26:42  InnoDB: Starting shutdown...
> 080903 22:26:46  InnoDB: Shutdown completed; log sequence number 0 43655
> 080903 22:26:46 [Note] /usr/libexec/mysqld: Shutdown complete
> 
> 080903 22:26:46  mysqld ended
> 
> 
> 
> 

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-03 20:26 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

still not working,   this  is  what i got

[root@localhost /]# service mysqld stop
Stopping MySQL:                                            [FAILED]
[root@localhost /]# rm /var/lib/mysql/mysql.sock
rm: cannot remove `/var/lib/mysql/mysql.sock'': No such file or
directory
[root@localhost /]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@localhost /]#

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-03 20:40 UTC

head link

Re: [Rails] Re: [Rails] Re: [Rails] Re: error connecting to mysq

On Wed, 2008-09-03 at 22:26 +0200, Adolf Charles wrote:> 
> still not working,   this  is  what i got
> 
> [root@localhost /]# service mysqld stop
> Stopping MySQL:                                            [FAILED]
> [root@localhost /]# rm /var/lib/mysql/mysql.sock
> rm: cannot remove `/var/lib/mysql/mysql.sock'': No such file or
directory
> [root@localhost /]# service mysqld start
> Timeout error occurred trying to start MySQL Daemon.
> Starting MySQL:                                            [FAILED]
> [root@localhost /]#----
what is output of the following commands...

ls -ld /var/lib/mysql
ls -l /var/lib/mysql

Craig


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

heimdull

2008-Sep-03 20:42 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

I would like to see your my.cnf... Just remember that MySQL looks for
the file in these locations:

/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

In that order...

But looking at your log file I think this is your issue:

080903 22:26:42 [ERROR] Can''t start server : Bind on unix socket:
Permission denied


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-03 20:52 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

this is the  content of  /etc/my.cnf


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

the rest of the  files  have  nothing in  them
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

heimdull

2008-Sep-03 22:07 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

What is the permissions on /var/lib/mysql ? the mysql user is going to
need access to this directory.

run chown -R mysql:mysql /var/lib/mysql



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-04 05:18 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

heimdull wrote:> What is the permissions on /var/lib/mysql ? the mysql user is going to
> need access to this directory.
> 
> run chown -R mysql:mysql /var/lib/mysql
it doesn''t give any output just another prompt i.e


[root@localhost /]# chown -R mysql:mysql /var/lib/mysql
[root@localhost /]#

is there anything else that i have to do?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-04 05:22 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

On Thu, 2008-09-04 at 07:18 +0200, Adolf Charles wrote:> heimdull wrote:
> > What is the permissions on /var/lib/mysql ? the mysql user is going to
> > need access to this directory.
> > 
> > run chown -R mysql:mysql /var/lib/mysql
> 
> it doesn''t give any output just another prompt i.e
> 
> 
> [root@localhost /]# chown -R mysql:mysql /var/lib/mysql
> [root@localhost /]#
> 
> is there anything else that i have to do?----
try restarting mysqld service and see if it keeps running, otherwise,
answer my earlier questions

Craig


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-04 05:29 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Craig White wrote:> On Thu, 2008-09-04 at 07:18 +0200, Adolf Charles wrote:
>> [root@localhost /]#
>> 
>> is there anything else that i have to do?
> ----
> try restarting mysqld service and see if it keeps running, otherwise,
> answer my earlier questions
> 
> Craig
Hi craig,

mysqld server does not want to keep on running  when started  this is 
what i get

[root@localhost /]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@localhost /]#


and  i  thought  i  answered all of  your  questions can you please be 
more specific on the question that you want to be answered?

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-04 05:29 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

> ----
> try restarting mysqld service and see if it keeps running, otherwise,
> answer my earlier questions
> 
> Craig
Hi craig,

mysqld server does not want to keep on running  when started  this is 
what i get

[root@localhost /]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
[root@localhost /]#


and  i  thought  i  answered all of  your  questions can you please be 
more specific on the question that you want to be answered?

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

heimdull

2008-Sep-04 06:09 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Maybe see if this gives a better output:

# mysqld -umysql --verbose --datadir=/var/lib/mysql


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-04 06:36 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

heimdull wrote:> Maybe see if this gives a better output:
> 
> # mysqld -umysql --verbose --datadir=/var/lib/mysql
here  is the  output of  mysqld -umysql --verbose 
--datadir=/var/lib/mysql

[root@localhost /]# mysqld -umysql --verbose --datadir=/var/lib/mysql
bash: mysqld: command not found

anything else please?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Adolf Charles

2008-Sep-04 08:01 UTC

head link

Re: [Rails] Re: [Rails] Re: error connecting to mysq

what if i unistall mysql  and then re-install it will this  help to 
solve this problem
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-04 14:23 UTC

head link

Re: [Rails] Re: [Rails] Re: [Rails] Re: error connecting to mysq

On Thu, 2008-09-04 at 10:01 +0200, Adolf Charles wrote:> what if i unistall mysql  and then re-install it will this  help to 
> solve this problem----
no - if you have no data to speak of in mysql, it may be useful to
delete it all and start over.

but first - since you don''t seem eager to look back, I''ll ask
one last
time...

what is output of

ls -ld /var/lib/mysql
ls -l /var/lib/mysql

Craig


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

heimdull

2008-Sep-04 15:43 UTC

head link

Mysqld not starting on fedora

How did you install Mysql? since it looks like mysqld is not in your
path something is not right....

do you have mysql in your path?

# which mysql

or try to find mysqld with

# find / -name mysqld

and the two ls commands from Craig would be nice too...

maybe you have more than one mysql on this server

On Sep 3, 11:36 pm, Adolf Charles
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> heimdull wrote:
> > Maybe see if this gives a better output:
>
> > # mysqld -umysql --verbose --datadir=/var/lib/mysql
>
> here  is the  output of  mysqld -umysql --verbose
> --datadir=/var/lib/mysql
>
> [root@localhost /]# mysqld -umysql --verbose --datadir=/var/lib/mysql
> bash: mysqld: command not found
>
> anything else please?
> --
> Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Craig White

2008-Sep-04 16:36 UTC

head link

Re: ****[Rails] Mysqld not starting on fedora

On Thu, 2008-09-04 at 08:43 -0700, heimdull wrote:> How did you install Mysql? since it looks like mysqld is not in your
> path something is not right....
> 
> do you have mysql in your path?
> 
> # which mysql
> 
> or try to find mysqld with
> 
> # find / -name mysqld
> 
> and the two ls commands from Craig would be nice too...
> 
> maybe you have more than one mysql on this server
> ----
just as an fyi to heimdull...

fedora uses /usr/bin/mysqld_safe as it''s daemon and /etc/init.d/mysqld
as the startup script

It does seem possible that he has installed a separate copy of mysql but
if he has, he hasn''t given us any indication of that.

Craig




--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

heimdull

2008-Sep-04 19:11 UTC

head link

Re: ****[Rails] Mysqld not starting on fedora

Craig:

The mysqld_safe script is just a nanny/startup script that starts the
mysqld (Mysql server) and make sure that this process is running. If
mysqld dies or is killed mysqld_safe will restart that process. By
using the mysqld executable directly you get more output to the screen
that should be helpf

Adolf:

After thinking about this more do you have SELinux running? I have
seen that to be an issue in the past where the mysqld process is
denied access to its .sock file.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reasonably Related Threads

Search for more apparently analagous threads

Rails - Sep 2008 - error connecting to mysql

error connecting to mysql

Re: error connecting to mysql

Re: error connecting to mysql

Re: ****[Rails] Re: error connecting to mysql

Re: ****[Rails] Re: error connecting to mysql

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysql

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Re: ****[Rails] Re: ****[Rails] Re: ****[Rails] Re: error connecting to mysq

Mysqld not starting on fedora

Re: ****[Rails] Mysqld not starting on fedora

Re: ****[Rails] Mysqld not starting on fedora

Reasonably Related Threads

Re: [Rails] Re: [Rails] Re: error connecting to mysql

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: error connecting to mysq

Re: [Rails] Re: [Rails] Re: [Rails] Re: error connecting to mysq