Mein Linux Server hat Probleme beim Connecten mit Mysql

Fabian107 · 29. Oktober 2011

Liebe User/in, ich habe einen problem und zwar habe ich ein Mysql script von Windows server Funktioniert es dennoch auf mein Linux root geht es nicht. Die Datenbank kann er von win connecteten.

Fehler:

Zitat

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_free_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_query called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_store_result called when not connected to any database.

Zitat

[12:29:30] [MySQL] Error (0): Function: mysql_num_rows called when not connected to any database.

Ich weiß nicht weiter bitte um hilfe habe Linux nur auf linux klappt es nicht.

Android · 29. Oktober 2011

Zeige uns bitte die komplette Datei "server_log.txt", danke.

POSEID0N · 29. Oktober 2011

Du musst in deinem Script (.pwn) deine MySQL Daten angeben damit er darauf connecten kann.

Fabian107 · 29. Oktober 2011

problem die datei ist zu groß hochzuladen etc. auch für pastebin nicht möglich.

@
xuNNy soweit war ich auch schon aber auf mein win geht es ja nur nicht auf linux :X

habe es mal hochgeladen:

http://www.file-upload.net/dow…40347/server_log.txt.html

Android · 29. Oktober 2011

Code

[12:29:30] Function: mysql_connect called with incorrect parameter count.

Du hast falsche Logindaten für die MySQL-Vebindung angegeben.

StyLLeZ · 29. Oktober 2011

wolltest du mir ja nicht glauben das was falsch angegeben wurde

Fabian107 · 29. Oktober 2011

//edit

Es geht immer noch nicht es kommt der gleich Fehler wie voher und daten sind zu 100% richtig auf win root geht es nur auf linux root server nicht. das ist ja das problem

Bubelbub · 29. Oktober 2011

Zitat von Fabian107

Es geht immer noch nicht es kommt der gleich Fehler wie voher und daten sind zu 100% richtig auf win root geht es nur auf linux root server nicht. das ist ja das problem

Kann es sein, dass du bei deinem Windows Server "localhost" benutzt.
Bei Linux auch "Localhost"?

Wenn du das auf Linux machst, musst du die IP Adresse vom Windows Server angeben.
Anstatt Localhost.

UND der Windows Server muss die Verbindungen vom Linux akzeptieren.

Fabian107 · 29. Oktober 2011

nein Der win greift auf datenbank die auf linux root liegen zu. Und wenn ich aber linux machen wo datenbank ist geht es nicht habe auch schon andere datenbanken versucht.

HT-Servers · 29. Oktober 2011

Wenn ich es jetzt richtig verstehe lässt dein Linux Server keine Mysql Verbindungen zu. Ist das Richtig?

Fabian107 · 29. Oktober 2011

Doch mein Windows server kann ja drauf zugreifen auf die datenbank die auf mein Linux root ist nur wenn ich es von linux root aus machen will sprich localhost sagt er mir die errors.

Bubelbub · 29. Oktober 2011

Dann ist dein MySQL Socket bestimmt falsch.
Geb mal anstatt "Localhost" einfach die IP deines Linux Servers ein.

Fabian107 · 29. Oktober 2011

Habe ich auch schon versucht das klappt aber auch nicht.

Bubelbub · 29. Oktober 2011

Hast du kein...
http://deineserverip/phpmyadmin

Wo du dich einfach manuell einloggen kannst.

Vielleicht Navicat? SQLYog? Oder irgendwas.
Du musst es doch manuell schaffen.

Sonst mach TeamViewer und ich helf dir einfach schnell.

HT-Servers · 29. Oktober 2011

Das ähnliche Problem hatte ein Kunde kürzlich auch bei uns.

Es lag in den Mysql Server Einstellungen, es war eine Blockade drin, was keine Verbindungen zu ließ.

Fabian107 · 29. Oktober 2011

HT-Server das lustige an der sache ist ja das mein Windows root darauf zu greifen kann und mein linux root nicht ? wenn wie stelle ich blockade rau?

@ blu wir haben plesk

HT-Servers · 29. Oktober 2011

Zitat von Fabian107

HT-Server das lustige an der sache ist ja das mein Windows root darauf zu greifen kann und mein linux root nicht ? wenn wie stelle ich blockade rau?

in der my.cnf

Fabian107 · 29. Oktober 2011

was genau muss man da austellen

HT-Servers · 29. Oktober 2011

Weiß ich jetzt auch nicht mehr genau, zeig mal was drin steht

Fabian107 · 29. Oktober 2011

Das meine Config ;):

Code

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html


# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock


# Here is entries for some specific programs
# The following values assume you have at least 32M ram


# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0


[mysqld]
local-infile=0
#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit	= 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem






[mysqldump]
quick
quote-names
max_allowed_packet	= 16M


[code=sql]
#no-auto-rehash	# faster start of mysql but no tab completition


[isamchk]
key_buffer		= 16M


#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Alles anzeigen