mailserver? mysql? why...

Anon

ok..
i'm running an apache server, with php an mysql..
php is working fine, so far, but mysql gives me the error 2003: cannot connect to mysql server on 'localhost'.
I have no clue, what is going wrong there..
the other thing that does not work is the mail-function in php..
it tells me, failed to connect on line c:/...blahblah...mail.php.
no, i guess, there might be a problem withe the mailserver, or frankly speaking, i don't know, if a mailserver even exists..
the php.ini file is configured for SMTP=localhost..
how do i know, whether or not, there is a working mailserver installed? or does apache have one with it, anyway?
(outlook express works just fine).
well, as you see, all that crap happening is running on microsoft windows NT.
and all the help i can get, is from people, who don't know windows..
well, you gotta live, with what you have, so can anybody please help me??

here are some, i hope not so useless informations about whatsoever..:
mysql:Client API version 3.23.10-alpha
PHP Version 4.0.1pl2
ysql.allow_persistent = On mysql.max_persistent = -1
mysql.max_links = -1 mysql.default_port = 3306 mysql.default_socket

mysql.default_host = localhost mysql.default_user = mysql.default_password =

is there anything else i should change or do?
i hope anyone out there can help me.
thanks
gaia

Anon

when i try to telnet localhost on port 25 it does not connect either..
(in case that information is of any help)..

concerning mysql, i don't have any my.ini files, so does that matter? also, when i type in netstat -a i don't seem to have the server listening on port 3306..

i am really desperate, i am searching the net for any information, and not finding anything, that helps any..
would it help, just to install everything again??
hopefully anybody knows about my problem..
thanx
gaia

peterluk

On mail function question, you need to point SMTP to your ISP's smtp server at php.ini in Win32 system. Both Outlook & Outlook Express are mail client applications, not mail server.
Please make above mentioned adjustment and restart Apache server to make it effective before trying your mail scriptlet.
Happy Hacking :-)

mithril

Gaia,

First off, port 25 is the telnet port. Since you say you have no my.ini file, your server is most likely running on the mySQL default of 3306. Try telneting in on port 3306 to see if your server is in fact running (I've never tried netstat so I don't know if that would work or not). Secondly, my.cnf is also a mySQL config file. The installation process copies a template called my.cnf-default (I think, something simliar at any rate) into the root of your mySQL installation directory. It's you're running mySQL anywhere besides c:\mysql, you MUST place a copy of my.cnf on your C root and change the -=basedir=x:/path/to/mysql=- directive to reflect the installation directory. If not, mySQL will not start on WinNT/Win2K (doesn't matter on 9x though). You may find the following link useful:

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Windows

Hope this helps.

Cheers,

Geoff A. Virgo

Anon

hey, thanks a lot for your answer ;o)

well, even though apache tells me, that it's running, telnetting localhost at port 3306 does not give me a connection..

I fouund something called my-example.cnf.
that looks fine. i made a copy called my.cnf.
would it help any, to place it in C:\winnt or c:\system32 ?
mysql is installed on C:\mysql though..
do i actually have the right mysql version??

(smile)
gaia

mithril

Hey Gaia,

If you've installed mySQL to c:\mysql then you should need the c:\my.cnf file to get it up and running. As I said in the previous post, that's only if you've installed into a non-default location. What happens when you open a DOS window, cd into c:\mysql\bin, and type the command mysqld-nt? This should start your server and return you to the c:\mysql\bin> prompt. If not, you'll either get an error message or the DOS window will hang. All you trying to run mySQL as a service? If so, the commands needed to install and remove the service are:

c:\mysql\bin>mysqld-nt --install
c:\mysql\bin>mysqld-nt --remove

respectively. While I'm not sure about whether mySQL will show up in netstat results, if it's running it should show up in the Task Manager for manual starts (and possibly as a service too) or in the list of Services. You may be able to check this out and see if mySQL is actually running this way. Regarding your version, it sounds like you're using an older pre-release version. The newest version available is 3.23.38. I'd suggest upgrading to that version if it's possible. Like-wise for PHP. You first post said you're using 4.0.1pl1, while the lastest is 4.0.5. Hope this helps.

Cheers,

Geoff A. Virgo

Anon

hey, hope you are still out there..
it took me a while to answer, since i decided to update my versions first, and... well, that takes some time, when you gotta wait for your right to do so.. anyway..
i am back again, and it's still not working.
when typing mysqlc it says: cannot connect to mysql server on localhost (111)
mysql => " (10061)
mysqlshow => "
most of the other commands just have me hanging for a while and than put me back to the C:\mysql\bin prompt.
as far as i know, (whereas my knowledge is nothing to build on´;o) , i need to be able to use "mysql" to create a database.
i put a copy of my.cnf in C:...
sorry, i am probably just beeing stupid, and i guess it's kind of hard, playing the "doctor", while you cannot see the patient..tell me, when you need more information..

thanks
gaia

Anon

seems to be working now!! ;o))

with the new version, and mysqld-nt installed, i managed to start it with net start mysql and it's running!!! ;o)))
thanks @all who helped me! ;o)

gaia