[Snort-users] Mysql running?

Nicolas Ho class933 at ...131...
Thu Nov 8 17:43:03 EST 2001


hi larry,

i got the same prob as well :( but i managed to get it
solve :) to answer ur question, nope it is not running
at all. to prove, run:

# ps -ef | grep mysql

first of all, for your info, i installed mysql in
/usr/local so do remember to adjust the paths. 
the prob lies with the permission settings. now, if u
check out the log file, u will see this:

# cd /usr/local/var
# less localhost.localdomain.err
011104 16:06:19  mysqld started
011104 16:06:20  /usr/local/libexec/mysqld: Can't
create/write to file '/usr/local/v
ar/localhost.localdomain.pid' (Errcode: 13)
011104 16:06:20  /usr/local/libexec/mysqld: Can't find
file: './mysql/host.frm' (err
no: 13)
011104 16:06:20  /usr/local/libexec/mysqld: Error on
delete of '/usr/local/var/local
host.localdomain.pid' (Errcode: 13)
011104 16:06:20  mysqld ended

now if u look at the permission for the
/usr/local/var, u will see:

# ls -la /usr/local
drwx-----  4 root root 4096 Nov  4 21:33 var

there are a couple of ways to resolve this such as.
wat i did was this:
# cd /usr/local
# chgrp mysql var
# chmod 750 var
# ls -la /usr/local
drwxr-x--- 4 root mysql 4096 Nov  4 21:33 var

this should now work:
# /usr/local/src/mysql-3.23.43/scripts/safe_mysqld &
[1] 948
# Starting mysqld daemon with databases from
/usr/local/var
# ps -ef | grep mysql
mysql 961 948 1 17:52 pts/0    00:00:00
/usr/local/libexec/mysqld --base
mysql 963 961 0 17:52 pts/0    00:00:00
/usr/local/libexec/mysqld --base
mysql 964 963 0 17:52 pts/0    00:00:00
/usr/local/libexec/mysqld --base

hope it works for u n hv fun :)

cheers!
heemeng

> Mysql question:
> 
> 
> I start it with:
> Cd /usr ; /usr/bin/safe_mysql &
> 
> When I start mysql is responds with
> 
> [root at ...4035...]#Starting mysqld with dtabase from
/var/lib/mysql
> 011108 12:59:20 mysqld ended
> 
> @ (this is a black promts that just sits here until
I hit return)
> 
> Does this above means its running??????
> 
> If I hit return, it says
> 
> [1]+ Done         /usr/bin/safe_mysqld
> 
> Larry

_______________________________________________
Snort-users mailing list
Snort-users at lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts
http://uk.my.yahoo.com




More information about the Snort-users mailing list