On Fri, Nov 12, 2004 at 02:56:26PM -0600, Edward Iglesias wrote:
> Somewhat along the same lines, I keep getting a mysql_connect error when
> trying to install postnuke. The Postnuke website suggests that it is a
> php configuration error. I tried changingmysql.default_host to
> 127.0.0.1 in php.ini.
The one I've seen multiple people get bitten by is forgetting to install
the php-mysql rpm. Did that to myself once too.
.../Ed
>
> Any suggestions?
>
> Edward
>
> J G wrote:
>
> >Hi Pete
> >
> >I looked at the ps -ef output and saw that mysqld had already started.
> >
> >SO <slapping forehead>, like i mentioned below, i just killed the existing
> >processes, and the restarted the safe_mysqld command and BOOM, it
> >worked.!!!!
> >
> >able to go to ./mysqladmin and create dbases now..:)
> >
> >thanks for your help...
> >
> >Pete Nesbitt <pete@xxxxxxxxx> wrote:
> >Please see the botom post.
> >
> >
> >On November 9, 2004 02:35 pm, J G wrote:
> >
> >
> >>Hi Pete
> >>
> >>here are my findings per your suggestion:
> >>
> >>-when you changed "permissions' on /var/lib/mysql to be owned by
> >>mysql, did
> >>you also ensure the dir is writeable by mysql? Isn't the group 'mysql'
> >>as not
> >>'daemon'?
> >>reply: I just changed it to 777 to be sure, and started ./bin/mysqld_safe
> >>& and still got the error.
> >>
> >>-is there anything in /var/log/mysqld.log or /var/log/messages ?
> >>reply: mysqld.log does not exist and there is nothing in dmesg. (weird)
> >>
> >>-make sure /var/log/mysqld.log is writeable by the mysql user
> >>(probably
> >>mysql)
> >>reply: there is no such log either...:)
> >>
> >>-that seems like strange place for a pid file, they usually go in
> >>/var/run
> >>reply: there is no pid file located in var/run/
> >>
> >>there is however, a "server.err" file that is generated under
> >>/var/lib/mysql. it states that port 3306 is already in use and mysql
> >>cannot
> >>be started. so maybe I will start with that one and go from there..
> >>
> >>thanks
> >>
> >>
> >>
> >>Pete Nesbitt
> >>
> >>
> >wrote:
> >
> >
> >>On November 8, 2004 04:50 pm, J G wrote:
> >>
> >>
> >>>Hi all,
> >>>
> >>>just installed Mysql binaries.
> >>>
> >>>When i try to start Mysql using the mysql_safe
> >>>command, i get the message:
> >>>
> >>>[root@palrhsrv /]# /usr/bin/mysqld_safe &
> >>>[1] 18547
> >>>[root@palrhsrv /]# Starting mysqld daemon with
> >>>databases from /var/lib/mysql
> >>>STOPPING server from pid file
> >>>/var/lib/mysql/palrhsrv.pid
> >>>041108 16:44:48 mysqld ended
> >>>
> >>>
> >>>[1]+ Done /usr/bin/mysqld_safe
> >>>
> >>>************************************
> >>>
> >>>then, when I start the command:
> >>>
> >>>[root@palrhsrv bin]# ./mysqladmin create testDB
> >>>./mysqladmin: connect to server at 'localhost' failed
> >>>error: 'Can't connect to local MySQL server through
> >>>socket '/var/lib/mysql/mysql.sock' (2)'
> >>>Check that mysqld is running and that the socket:
> >>>'/var/lib/mysql/mysql.sock' exists!
> >>>
> >>>
> >>>I looked under the var/lib/mysql and obviously the
> >>>mysql.sock does not exist.
> >>>
> >>>I changed permissions under /var/lib/mysql to chown -R
> >>>mysql and chrgp to daemon.
> >>>Still getting the same errors.
> >>>
> >>>any help?
> >>>
> >>>thanks
> >>>
> >>>
> >
> >
> >
> >HI,
> >what does your /etc/my.cnf file show. If you don't have that, look in
> >/usr/local/etc
> >
> >Just curious, why didn't you just install the rpm?
> >
> >What version of rh & mysql?
> >
> >Did you follow all the steps for the binary install? (they show about a
> >dozen steps for a generic unix-like install)
> >
> >
>
> --
> Edward Iglesias
> Integrated Library Systems Coordinator
> 504.864.7838 (work)
> 504.864.7842 (FAX)
--
Ed Wilts, RHCE
Mounds View, MN, USA
mailto:ewilts@xxxxxxxxxx
Member #1, Red Hat Community Ambassador Program
--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
