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
-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]