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"
"/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
i would assume something like "skip-networking" in your
config if connection fails
anyways this mysql-config ma contain some includes
because the line "!include_dir /etc/mysql"
Am 02.04.2011 17:36, schrieb xPol:
> Reindl Harald wrote:
>
>> Did you make any change in the my.cnf?
>> What does "netstat --numeric-hosts --notrim --programs -u -t" say?
>> What is the content of your my.cnf?
>>
>
> Here incluede
>
> thank you
> ----p
>
> --
> (xpol) % netstat --numeric-hosts --notrim --programs -u -t
>
> ~ (17:32-Sat 2)
> (Not all processes could be identified, non-owned process info
> will not be shown, you would have to be root to see it all.)
> 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:38315 74.125.77.109:smtp
> 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:53924 74.125.232.152:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:53925 74.125.232.152:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:53894 74.125.232.152:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:35673 209.85.227.189:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:35672 209.85.227.189:https
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:48554 209.85.149.105:www-http
> ESTABLISHED 6252/firefox
> tcp 0 0 10.121.243.241:35666 209.85.227.189:https
> TIME_WAIT -
> tcp 0 0 10.121.243.241:35667 209.85.227.189:https
> TIME_WAIT -
> tcp 0 0 10.121.243.241:53926 74.125.232.152:https
> ESTABLISHED 6252/firefox
> 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 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
> tcp 0 0 10.121.243.241:54324 80.91.229.10:nntp
> ESTABLISHED 11402/knodeo10783.s
>
> ---
> (xpol) % cat /mnt/etc/my.cnf | grep -v "^#"
>
> ~ (17:34-Sat 2)
>
> [client]
> port = 3306
> socket = /var/run/mysql/mysql.sock
>
>
> [mysqld]
> port = 3306
> socket = /var/run/mysql/mysql.sock
> datadir = /var/lib/mysql
> skip-locking
> key_buffer_size = 16M
> max_allowed_packet = 1M
> table_open_cache = 64
> sort_buffer_size = 512K
> net_buffer_length = 8K
> read_buffer_size = 256K
> read_rnd_buffer_size = 512K
> myisam_sort_buffer_size = 8M
>
>
> log-bin=mysql-bin
>
> binlog_format=mixed
>
> server-id = 1
>
>
>
>
> [safe_mysqld]
> log-error = /var/log/mysql/mysqld.log
> socket = /var/run/mysql/mysql.sock
>
> !include_dir /etc/mysql
>
> [mysqldump]
> socket = /var/run/mysql/mysql.sock
> quick
> max_allowed_packet = 16M
>
> [mysql]
> no-auto-rehash
>
> [myisamchk]
> key_buffer_size = 20M
> sort_buffer_size = 20M
> read_buffer = 2M
> write_buffer = 2M
>
> [mysqlhotcopy]
> interactive-timeout
>
> [mysqld_multi]
> mysqld = /usr/bin/mysqld_safe
> mysqladmin = /usr/bin/mysqladmin
> log = /var/log/mysqld_multi.log
>
>
>
>
>
>
> -----
>
>
--
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/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
