externe db-conn geht net mehr

MySQL, PostgreSQL, SQLite
tobiask
Posts: 164
Joined: 2004-05-02 12:08
Location: NRW

externe db-conn geht net mehr

Post by tobiask » 2005-08-25 12:35

hi,

hab heute die my.cnf was geändert, seitdem gehen externe verbindungen zur db aber nicht mehr,

da kommt immer das jetzt:

Code: Select all

Warning: mysql_connect(): Can't connect to MySQL server on '82.165.36.79' (111) in /www/htdocs/v170129/marketing/intern/in/index.php on line 7

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /www/htdocs/v170129/marketing/intern/in/index.php on line 8

Warning: mysql_query(): Access denied for user: 'wwwrun@localhost' (Using password: NO) in /www/htdocs/v170129/marketing/intern/in/index.php on line 31

Warning: mysql_query(): A link to the server could not be established in /www/htdocs/v170129/marketing/intern/in/index.php on line 31

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/htdocs/v170129/marketing/intern/in/index.php on line 32
Zugangsdaten falsch!5e49ba8bbeb8eec88a36fb79c1226fab
die my.cnf sieht so aus:

Code: Select all

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
socket = /var/lib/mysql/mysql.sock
bind-address = 127.0.0.1
port = 3306
server-id = 1
skip-locking
skip-networking
skip-name-resolve
skip-external-locking
local-infile = 0
key_buffer_size = 64M
sort_buffer_size = 4M
read_buffer_size = 1M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
max_allowed_packet = 16M
net_buffer_length = 8K
thread_stack = 128K
thread_cache = 8
table_cache = 256
query_cache_type = 1
query_cache_size = 16M
query_cache_limit = 1M
thread_concurrency = 2
#skip-innodb

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
#no-auto-rehash
#safe-updates

[isamchk]
key_buffer_size = 64M
sort_buffer_size = 4M
read_buffer_size = 1M
write_buffer_size = 1M

[myisamchk]
key_buffer_size = 64M
sort_buffer_size = 4M
read_buffer_size = 1M
write_buffer_size = 1M

[mysqlhotcopy]
interactive-timeout

User avatar
Joe User
Project Manager
Project Manager
Posts: 11134
Joined: 2003-02-27 01:00
Location: Hamburg

Re: externe db-conn geht net mehr

Post by Joe User » 2005-08-25 12:43

Soetwas passiert nunmal, wenn man treudoof irgendwelche Dinge per C&P übernimmt, ohne die jeweilige Dokumentation gelesen und verstanden zu haben. Merke Dir Das für die Zukunft!

Lösung: bind-adress muss auf die IP des Servers gesetzt sein.
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.

tobiask
Posts: 164
Joined: 2004-05-02 12:08
Location: NRW

Re: externe db-conn geht net mehr

Post by tobiask » 2005-08-25 12:51

Joe User wrote:Soetwas passiert nunmal, wenn man treudoof irgendwelche Dinge per C&P übernimmt, ohne die jeweilige Dokumentation gelesen und verstanden zu haben. Merke Dir Das für die Zukunft!

Lösung: bind-adress muss auf die IP des Servers gesetzt sein.
sorry, hast ja recht.
habs wieder hinbekommen, trotzdem danke für die hilfe.