Please "netstat --numeric-hosts --notrim --programs -u -t -l" In my first answer i forgot the -l
Without we get active connections, but we want the listening
tcp-services where somewhere must by mysqld
the easiest test is however
> [harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.
> 5.5.10-log�K]qC7,t'��a4~Agb949^QXmysql_native_password
if there is no connection we should find out why
debug simply the web-app user on a local terminal
to get error messages with more details as "failed"
> [harry@srv-rhsoft:~]$ mysql -h 127.0.0.1 -u myuser -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
> password: NO)
this example says more as "failed" bceause we see that connection
is possible but authentication fails
Am 02.04.2011 18:21, schrieb xPol:
> Reindl Harald wrote:
>
>> please do not only post outputs, read them and try to understand
>> before press send - "not all processes could be identified, non-owned
>> process info will not be shown, you would have to be root to see it all."
>> in the ouptput says that all afterwards is useless
>>
>> "netstat --numeric-hosts --notrim --programs -u -t -l" as ROOT on the
>> machine where mysql is running! alterante: "telnet 127.0.0.1 3306"
>
> sorry, i have re-enterd the command as root - here incuded
>
>>
>> "/mnt/etc/my.cnf" is really your active mysql-config?
>> normally "/etc/my.cnf" is used, even if /etc/ is a own
>> disk/partition you should never mount it as /mnt/etc/
>> and managing with symlinks - mount it directly to /etc
>>
>
> you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that
> file system to compare with /etc/my.cnf
> They are the same, however.
>
> Here included also /etc/mysqlaccess.conf
>
>> i would assume something like "skip-networking" in your
>> config if connection fails
>
> it is there, but commented out:
> /etc/my.cnf:#skip-networking
>
>>
>> anyways this mysql-config ma contain some includes
>> because the line "!include_dir /etc/mysql"
>>
> /
> That dir contains: /etc/mysql/default_plugins.cnf
> its contents is here included
>
> thank you
> ----p
>
> 1-----
> % ° netstat --numeric-hosts --notrim --programs -u -t
>
> ~ (18:09-Sat 2)
> Active Internet connections (w/o servers)
> Proto Recv-Q Send-Q Local Address Foreign Address State
>
> PID/Program name
> tcp 0 0 10.121.243.241:60577 74.125.232.149:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:54207 74.125.232.114:www-http
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:49545 85.86.166.196:7168
> TIME_WAIT -
> tcp 0 0 10.121.243.241:53173 74.125.232.150:https
> TIME_WAIT -
> tcp 0 0 127.0.0.1:50793 127.0.0.1:48856
> ESTABLISHED 6752/npviewer.bin
> tcp 0 0 127.0.0.1:57336 127.0.0.1:48856
> ESTABLISHED 6752/npviewer.bin
> tcp 0 0 10.121.243.241:39556 209.85.227.189:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:60576 74.125.232.149:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:39551 209.85.227.189:https
> TIME_WAIT -
> tcp 0 0 10.121.243.241:41089 83.233.30.55:ipsec-nat-t
> TIME_WAIT -
> tcp 0 0 10.121.243.241:39550 209.85.227.189:https
> TIME_WAIT -
> tcp 0 0 10.121.243.241:52758 83.51.48.124:44909
> TIME_WAIT -
> tcp 0 0 127.0.0.1:52722 127.0.0.1:48856
> ESTABLISHED 6752/npviewer.bin
> tcp 0 0 127.0.0.1:48856 127.0.0.1:52722
> ESTABLISHED 6767/GoogleTalkPlug
> tcp 0 0 10.121.243.241:39555 209.85.227.189:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:35365 82.56.169.37:19907
> TIME_WAIT -
> tcp 0 0 10.121.243.241:57283 80.91.229.10:nntp
> ESTABLISHED 12106/knodec10783.s
> tcp 0 0 10.121.243.241:44552 74.125.232.150:https
> ESTABLISHED 6252/firefox
> tcp 0 0 127.0.0.1:48856 127.0.0.1:50793
> ESTABLISHED 6767/GoogleTalkPlug
> tcp 0 0 127.0.0.1:48856 127.0.0.1:57336
> ESTABLISHED 6767/GoogleTalkPlug
>
> 2 ----
> (xpol) % ° cat /etc/mysqlaccess.conf | grep -v "^#"
>
> ~ (18:20-Sat 2)
>
>
> #$Param{'host'} = '';
> $Param{'user'} = 'nobody';
> $Param{'db'} = 'test';
> $Param{'password'} = 'foobar';
> $Param{'debug'} = 0;
>
> if ($CMD) {
> $Param{'superuser'} = 'root';
> $Param{'rhost'} = 'localhost';
> $Param{'spassword'} = '';
> $Param{'brief'} = 1;
> }
>
> if ($CGI) {
> $Param{'superuser'} = 'root';
> $Param{'rhost'} = 'localhost';
> $Param{'spassword'} = '';
> $Param{'table'} = 1;
> }
>
> 1; #to make require happy
>
> 3------
> (xpol) % ° cat /etc/mysql/default_plugins.cnf
>
> ~ (18:20-Sat 2)
> [server]
> plugin-load=blackhole=ha_blackhole.so
> plugin-load=federated=ha_federated.so
> plugin-load=archive=ha_archive.so
>
> -----
>
>
--
Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
signature.asc
Description: OpenPGP digital signature
