PDA

View Full Version : MySQL installing problem

n!x
23rd November 2005, 20:57
I'm following this (http://www.howtoforge.com/perfect_setup_ubuntu_5.04_p4) guide (which is great stuff), but I'm having a problem with the MySQL section.

When I run "netstat -tap" I see this line:

tcp 0 0 *:mysql *:* LISTEN -

I don't get the "2449/mysqld" as the last thing, but only a "-".
My "skip-networking" thing in "/etc/mysql/my.cnf" i commented out and MySQL restartet - but the same thing is in "netstat -tap".

Anyone has a suggestion?
till
23rd November 2005, 21:34
I'm following this (http://www.howtoforge.com/perfect_setup_ubuntu_5.04_p4) guide (which is great stuff), but I'm having a problem with the MySQL section.

When I run "netstat -tap" I see this line:

tcp 0 0 *:mysql *:* LISTEN -

I don't get the "2449/mysqld" as the last thing, but only a "-".
My "skip-networking" thing in "/etc/mysql/my.cnf" i commented out and MySQL restartet - but the same thing is in "netstat -tap".

Anyone has a suggestion?

Thats OK, if you dont encounter any other problems.

Till
n!x
23rd November 2005, 21:59
Ok, but shouldn't MySQL listen on a specific port?
n!x
23rd November 2005, 22:11
Ok, now I get another problem.

When I try this:

sudo echo 'pwcheck_method: saslauthd' >> /etc/postfix/sasl/smtpd.conf


I get a:

-bash: /etc/postfix/sasl/smtpd.conf: Permission denied
till
23rd November 2005, 23:11
Dont use sudo, you must login as root user! All steps in the howto must be done as root user.
till
23rd November 2005, 23:12
Ok, but shouldn't MySQL listen on a specific port?

MySQL listens on a specific port:

*:mysql

means that it listens on all available IP's on the mysql port.
n!x
24th November 2005, 09:35
Ok thanks till!!

I now ran into trouble again.

When I run the "telnet localhost 25" it only shows:

Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
220 server.example.com ESMTP Postfix (Ubuntu)


And nothing more happens..... It times out.

Anyone? I really need help...

/n!x
till
24th November 2005, 09:44
Have you entered:

ehlo localhost

and hit return?

After you have established the connection to your postfix mail server type

ehlo localhost

If you see the lines

250-STARTTLS

and

250-AUTH

everything is fine.