The postmaster is a Postgres daemon, and pg_shadow is the user table for
postgres.
Clint
From: Michael Stassen <[EMAIL PROTECTED]>
To: Alex Majora <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: mysql.sock file exists, but still cannot connect to server
Date: Wed, 19 Jan 2005 17:42:34 -0500
Alex Majora wrote:
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't
start up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok
creating template1 database in
/var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
What is this? These messages do not appear to have come from mysql.
There's something you haven't told us. What is RemoteManagement/RMDB? Is
this something you run by hand, or something automated?
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster
-D /var/db/RemoteManagement/RMDB/rmdb.data
or
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl
-D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start
LOG: database system was shut down at 2005-01-19 12:36:29 PST
LOG: checkpoint record is at 0/71524
LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 1744; next oid: 16766
LOG: database system is ready
ERROR: To use passwords, you have to revoke permissions on pg_shadow so
normal users cannot read the passwords. Try 'REVOKE ALL ON "pg_shadow"
FROM PUBLIC'.
Have you tried doing what it says here?
MySQL seems to be running:
649 ?? S 0:00.02
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster
-D /var/db/RemoteManagement/RMDB/rmdb.data
That doesn't appear to be mysql.
When I run MySQLManager, I get this error message:
2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db
installation failed, probably due to bad hostname; trying again with force
option.
ERROR: 1064 You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to use
near
'????????????????????????????????????????????????????????????????????????????????'
at line 1
That certainly seems to be a message (syntax error) from mysql.
050119 12:37:34 Aborting
050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete
Not sure why, but mysqld just shut down.
When I type "mysql" at the command line, I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Are you sure mysqld is running? You got a shutdown message right before
this.
...yet the file exists:
srwxrwxrwx 1 mysql wheel 0 19 Jan 12:35 mysql.sock
Well, that should mean mysqld is running. Two things:
1) Use ps to make sure there's a mysqld process (ps -aux | grep mysqld).
2) Check the permissions on /tmp (actually, /private/tmp under OS X). Some
OS X updates have changed /tmp permissions in the past.
Any ideas about what to do? I've reinstalled the mySQL package, but it
didn't change things.
Thanks!
Alex
Michael
--
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]