Hi Brian,
I checked boot.log and found the following message. I don't know whether
this causes the problem. Do you know what is DSO module? Do I really need
to recompile it? If so, how I can recompile it?
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_include.so uses plain Apache 1.3 API, this module might crash under
EAPI!
(please recompile it with -DEAPI)
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_autoindex.so uses plain Apache 1.3 API, this module might crash under
EAP
I! (please recompile it with -DEAPI)
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_dir.so uses plain Apache 1.3 API, this module might crash under EAPI!
(pl
ease recompile it with -DEAPI)
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_cgi.so uses plain Apache 1.3 API, this module might crash under EAPI!
(pl
ease recompile it with -DEAPI)
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_asis.so uses plain Apache 1.3 API, this module might crash under
EAPI! (p
lease recompile it with -DEAPI)
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_imap.so uses plain Apache 1.3 API, this module might crash under
EAPI! (p
lease recompile it with -DEAPI)
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_actions.so uses plain Apache 1.3 API, this module might crash under
EAPI!
(please recompile it with -DEAPI)
-----Original Message-----
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:24 AM
To: Ouyang, Sunny
Subject: Re: using myodbc for mysql database on RedHat6.2
Sunny,
What errors do you get? tail -20 (or so) on your mysql error file (mine is
located under mysql/data) to see what it is telling you. Also look (as
root) at your boot.log and messages files under /var/log to see what they
have to say about this. If I had to hazard a guess as to where the problem
lies, I'm guessing -- assuming that safe_mysqld is running -- that
permissions is what needs to be fixed. If safe_mysqld isn't running, go to
your mysql directory and then, as root, run nohup bin/safe_mysqld &. If you
get errors telling you that problems exist in writing to /tmp/mysql.sock,
chmod your /tmp dir to 777 and try starting safe_mysqld again. If this
doesn't work, I can only recommend asking the mysql list about it to see
what other recommendations people have.
-Brian
----- Original Message -----
From: "Ouyang, Sunny" <[EMAIL PROTECTED]>
To: "'Brian Warn'" <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 6:43 AM
Subject: RE: using myodbc for mysql database on RedHat6.2
Hi Brian,
Emergency. Please help. I rebooted Linux server last Saturday. Right
after that mysql database doesn't start at all. Do you know how I can start
it? Does my change on user table and db table affect all this? Please
advice the sooner the better. Thanks!
-----Original Message-----
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:32 AM
To: Ouyang, Sunny
Subject: Re: using myodbc for mysql database on RedHat6.2
Sunny,
If it were me in your position, I'd still rely on the myobc or mysql lists.
I continue to recommend providing those lists the steps that we tried and
see if anyone misses anything I have so far missed.
-Brian
----- Original Message -----
From: "Ouyang, Sunny" <[EMAIL PROTECTED]>
To: "'Warn, Brian'" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 8:41 AM
Subject: RE: using myodbc for mysql database on RedHat6.2
Hi Brian,
Thank you very much for your explanation. That makes sense. Otherwise, the
database becomes too complex. Do you know where I can find better
documentation setup myodbc? I feel frustrated. It still doesn't work. I
really appreciate your sincere help. No word I can use to express my
appreciation. Thanks!! Please let me know if you have some solution.
Thanks!
-----Original Message-----
From: Warn, Brian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:32 AM
To: Ouyang, Sunny
Subject: Re: using myodbc for mysql database on RedHat6.2
Hi Sunny,
No, you don't need to create these tables in your irl db. The mysql
database is a global (probably a better term for it, but this is how I think
of it), database used by all other databases on your server. mysql reads
the mysql db before going to any other db. By doing this, mysql reads
permissions, users, etc. so that it can grant the appropriate level of
access and so forth to users of the other databases.
-Brian
----- Original Message -----
From: "Ouyang, Sunny" <[EMAIL PROTECTED]>
To: "'Brian Warn'" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 8:22 AM
Subject: RE: using myodbc for mysql database on RedHat6.2
Hi Brian,
I have last question about it. I checked on our mysql datase server. I
found there aren't user and db tables on irl database. I am wondering
whether I should create these two tables under each individual database.
Please advise. Thanks!
-----Original Message-----
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 4:04 PM
To: Ouyang, Sunny
Subject: Re: using myodbc for mysql database on RedHat6.2
> how can I test ODBC on Linux whether it is connected well?
I assume you're asking how you tell in your linux box if you're connected
via ODBC to mysql on your linux box. If I understand you correctly, then
use netstat in linux. In the first section of the output, you'll see
something like the following:
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 128 vanguard:telnet mudduck:4227
ESTABLISHED
tcp 0 0 vanguard:mysql mudduck:4398
ESTABLISHED
tcp 0 0 vanguard:telnet mudduck:3911
ESTABLISHED
The mysql mysql entries tell you which hosts are connected. They don't tell
you if the method is ODBC, however.
-Brian
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
?(?z*.{&?((tm)],jmY(tm)ɨh&
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
