MySQL ON PPC....

[sundeep.kumara]

hi all,

I am a newbie .....I have compiled the source code of mysql-4.1.9 on
PPC-Linux

Its not giving any errors during configure,make or make install.

But,when i try to start the server using mysqld_safe...its throwing
error like this..

Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/hostname.pid
050820 00:09:01 mysqld ended
What is the Problem...?

and when i execute ./mysql Its giving Error Like this.......
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

Can anyone help me...regarding these issues....

Thanks In Advance.

Regards,
Sundeep.

[Bill Karwin]

su************@wipro.com wrote:

hi all,

I am a newbie .....I have compiled the source code of mysql-4.1.9 on
PPC-Linux

Its not giving any errors during configure,make or make install.

But,when i try to start the server using mysqld_safe...its throwing
error like this..

Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/hostname.pid
050820 00:09:01 mysqld ended

Mysqld failed to start for some reason. Perhaps some file has the wrong
permissions mode, or some other problem. Are you trying to start
mysqld_safe when running as root or as a non-superuser?

Look in mysqld's log file for further details about the cause. The
location of the log file is usually in <DATADIR>/<HOSTNAME>.err, next to
the pid file. So in your case it is probably
/usr/local/mysql/var/<HOSTNAME>.err.

Regards,
Bill K.

[sundeep.kumara]

Bill Karwin wrote:

su************@wipro.com wrote:

hi all,

I am a newbie .....I have compiled the source code of mysql-4.1.9 on
PPC-Linux

Its not giving any errors during configure,make or make install.

But,when i try to start the server using mysqld_safe...its throwing
error like this..

Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/hostname.pid
050820 00:09:01 mysqld ended

Mysqld failed to start for some reason. Perhaps some file has the wrong
permissions mode, or some other problem. Are you trying to start
mysqld_safe when running as root or as a non-superuser?

Look in mysqld's log file for further details about the cause. The
location of the log file is usually in <DATADIR>/<HOSTNAME>.err, next to
the pid file. So in your case it is probably
/usr/local/mysql/var/<HOSTNAME>.err.

Regards,
Bill K.

Hi Bill,

Thanks for ur Response
050819 23:59:20 mysqld started
050819 23:59:20 [ERROR] Can't start server : Bind on unix socket:
Permission denied
050819 23:59:20 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
050819 23:59:20 [ERROR] Aborting

050819 23:59:20 [Note] /usr/local/mysql/libexec/mysqld: Shutdown
complete

050819 23:59:20 mysqld ended

050820 00:01:15 mysqld started
050820 0:01:15 [ERROR] Can't start server : Bind on unix socket:
Permission denied
050820 0:01:15 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
050820 0:01:15 [ERROR] Aborting

050820 0:01:15 [Note] /usr/local/mysql/libexec/mysqld: Shutdown
complete

050820 00:01:15 mysqld ended

050820 00:09:01 mysqld started
050820 0:09:01 [ERROR] Can't start server : Bind on unix socket:
Permission denied
050820 0:09:01 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
050820 0:09:01 [ERROR] Aborting

050820 0:09:01 [Note] /usr/local/mysql/libexec/mysqld: Shutdown
complete

050820 00:09:01 mysqld ended

050820 00:31:51 mysqld started
050820 0:31:52 [ERROR] Can't start server : Bind on unix socket:
Permission denied
050820 0:31:52 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
050820 0:31:52 [ERROR] Aborting

050820 0:31:52 [Note] /usr/local/mysql/libexec/mysqld: Shutdown
complete

050820 00:31:52 mysqld ended

executing all these commands in root user mode only...
No mysql server is already running....i checked with "ps ef"

I couldn't figure out what the problem is.......

Thanks in Advance,
Regards,
Sundeep.

[Bill Karwin]

su************@wipro.com wrote:

050819 23:59:20 [ERROR] Can't start server : Bind on unix socket:
Permission denied
050819 23:59:20 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
050819 23:59:20 [ERROR] Aborting

executing all these commands in root user mode only...
No mysql server is already running....i checked with "ps ef"

Is there an existing file /tmp/mysql.sock?
If there is no mysqld running, it should be safe to remove such a file
with "rm". Sometimes a hiccup occurs, and if mysqld didn't start or
stop properly, it might leave that file there by accident. You can
remove it.

Another problem may be that your mysqld is trying to start as a
dedicated user/group "mysql"/"mysql". Did you create this user and group?
See instructions regarding the user and group id to run mysql at:
http://dev.mysql.com/doc/mysql/en/in...ng-binary.html
I know you compiled MySQL from source, but the result is that you now
have a binary, so some of the runtime configuration in that web page is
relevant. :-)

Regards,
Bill K.

[Mike A.]

On Fri, 19 Aug 2005 10:38:16 -0700, Bill Karwin wrote:

su************@wipro.com wrote:

050819 23:59:20 [ERROR] Can't start server : Bind on unix socket:
Permission denied
050819 23:59:20 [ERROR] Do you already have another mysqld server
running on socket: /tmp/mysql.sock ?
050819 23:59:20 [ERROR] Aborting

executing all these commands in root user mode only...
No mysql server is already running....i checked with "ps ef"

Is there an existing file /tmp/mysql.sock?
If there is no mysqld running, it should be safe to remove such a file
with "rm". Sometimes a hiccup occurs, and if mysqld didn't start or
stop properly, it might leave that file there by accident. You can
remove it.

Another problem may be that your mysqld is trying to start as a
dedicated user/group "mysql"/"mysql". Did you create this user and group?
See instructions regarding the user and group id to run mysql at:
http://dev.mysql.com/doc/mysql/en/in...ng-binary.html
I know you compiled MySQL from source, but the result is that you now
have a binary, so some of the runtime configuration in that web page is
relevant. :-)

Regards,
Bill K.

Yes, he needs to delete the /tmp/mysql.sock file.

#rm -f /tmp/mysql.sock

Also, when starting mysqld as root, use the --user switch to specify the
user who will own the process (typically 'mysql'):

#mysqld --user mysql &

The user/group mysql must both exist as you said, and the data directories
should have rwx permissions for the mysql user (only). For example, if
his data directory is /usr/local/mysql/data/ :

#chown -R mysql:mysql /usr/local/mysql/data
#chmod -R 700 /usr/local/mysql/data

Then it should work.
Mike A.
MySQL 4.1.13a on FreeBSD 5.4

[sundeep.kumara]

hi Mike and Bill,

Thanks for your response.

I followed your Instructions i.e; creating mysql user and running with
--user=mysql.

But, Now its giving error Like..

sh> bin/mysqld_safe --user=mysql &
[1] 1247
bash-2.05# Starting mysqld daemon with databases from
/usr/local/mysql/data

bin/mysqld_safe: eval: line 1: syntax error near unexpected token
`--pid-file=/usr/local/mysql/data/(n'

bin/mysqld_safe: eval: line 1: `nice --5 nohup
/usr/local/mysql/bin/mysqld
--defaults-extra-file=/usr/local/mysql/data/my.cn'

STOPPING server from pid file /usr/local/mysql/data/(none).pid
050821 19:13:30 mysqld ended

Thanks in Advance.

Regards,
Sundeep.

[sundeep.kumara]

hi ,

I have solved one issue out of that error ....
hostname is needed to be set.

Now for
../bin/mysqld_safe
error is:
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/hostname.pid
050821 20:12:56 mysqld ended

and for ./bin/mysql
../bin/mysql: error while loading shared libraries:
libmysqlclient.so.14: cannot open shared object file: No such file or
directory.

but that file is present in usr/local/mysql/lib/ directory.

I couldn't figure out what the problem is.....

Thanks in Advance.

Regards,
Sundeep.

[Bill Karwin]

su************@wipro.com wrote:

./bin/mysql: error while loading shared libraries:
libmysqlclient.so.14: cannot open shared object file: No such file or
directory.

but that file is present in usr/local/mysql/lib/ directory.

I couldn't figure out what the problem is.....

I think you can solve this by editing /etc/ld.so.conf, adding the
/usr/local/mysql/lib directory as a line in that conf file, and then run
"/sbin/ldconfig" (while logged in as root) to refresh the linker cache.

See more info on ldconfig here:
http://enterprise.linux.com/article..../05/15/1115252

Regards,
Bill K.

[sundeep.kumara]

hi Bill,

Thanks for your Suggestions.

It's the problem with that ldconf only...

My problem is solved ....now mysql is running.....

Once Again Thank you for your help........
Bye.
Regards,
Sundeep.