Lieber Besucher, herzlich willkommen bei: sourceserver.info. Falls dies Ihr erster Besuch auf dieser Seite ist, lesen Sie sich bitte die Hilfe durch. Dort wird Ihnen die Bedienung dieser Seite näher erläutert. Darüber hinaus sollten Sie sich registrieren, um alle Funktionen dieser Seite nutzen zu können. Benutzen Sie das Registrierungsformular, um sich zu registrieren oder informieren Sie sich ausführlich über den Registrierungsvorgang. Falls Sie sich bereits zu einem früheren Zeitpunkt registriert haben, können Sie sich hier anmelden.
Quellcode |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
"Databases" { "driver_default" "mysql" "sourcebans" { "driver" "default" "host" "XX.XX.XX.XX" "database" "datenbankname" "user" "DB benutzer" "pass" "Passwort" //"timeout" "0" "port" "3306" } |
Zitat von »"DeaD_EyE"«
Für alle, die das Problem mit dem Verbinden der Datenbank haben, können statt der IP vom Host folgendes verwenden:
Quellcode
1 "host" "localhost:/var/run/mysqld/mysqld.sock"
Hier wird der Pfad zur Datei mysqld.sock angegeben. Das sollte helfen, wenn sich der Mysql-Server auf dem gleichen Server wie der Gameserver befindet.
Zitat von »"BMWfan"«
Wenn das jetzt mein einzigstes Problem wäre, wäre ich glücklich bei mir startet mysql gar nicht mehr
wenn ich es starten lasse steht danach failed dran.
Siehe hier:
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
Quellcode |
|
1 2 3 4 5 6 7 |
sudo tail /var/log/syslog will show you last 10 lines of syslog sudo tail -50 /var/log/syslog will show you last 50 lines of syslog (you got the point ;)) |
Quellcode |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 |
RT0035:~# tail -99 /var/log/syslog Aug 26 20:47:01 RT0035 /USR/SBIN/CRON[26761]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:47:56 RT0035 dhclient: DHCPREQUEST on eth0 to 85.14.216.4 port 67 Aug 26 20:47:56 RT0035 dhclient: DHCPACK from 85.14.216.4 Aug 26 20:47:56 RT0035 dhclient: bound to 85.14.216.90 -- renewal in 3317 seconds. Aug 26 20:48:01 RT0035 /USR/SBIN/CRON[26781]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:49:01 RT0035 /USR/SBIN/CRON[26799]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:50:01 RT0035 /USR/SBIN/CRON[26805]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:51:01 RT0035 /USR/SBIN/CRON[26823]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:52:01 RT0035 /USR/SBIN/CRON[26829]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:53:01 RT0035 /USR/SBIN/CRON[26847]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:54:01 RT0035 /USR/SBIN/CRON[26853]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:55:01 RT0035 /USR/SBIN/CRON[26871]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:56:01 RT0035 /USR/SBIN/CRON[26877]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:57:01 RT0035 /USR/SBIN/CRON[26895]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:58:01 RT0035 /USR/SBIN/CRON[26901]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 20:59:01 RT0035 /USR/SBIN/CRON[26919]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:00:01 RT0035 /USR/SBIN/CRON[26925]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:01:01 RT0035 /USR/SBIN/CRON[26945]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:02:01 RT0035 /USR/SBIN/CRON[26955]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:03:01 RT0035 /USR/SBIN/CRON[26978]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:03:11 RT0035 proftpd[26983]: connect from 200.110.242.11 (200.110.242.11) Aug 26 21:04:01 RT0035 /USR/SBIN/CRON[26985]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:05:01 RT0035 /USR/SBIN/CRON[27003]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:06:01 RT0035 /USR/SBIN/CRON[27009]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:07:01 RT0035 /USR/SBIN/CRON[27028]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:08:01 RT0035 /USR/SBIN/CRON[27034]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:09:01 RT0035 /USR/SBIN/CRON[27052]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:09:01 RT0035 /USR/SBIN/CRON[27054]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Aug 26 21:10:01 RT0035 /USR/SBIN/CRON[27068]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:11:01 RT0035 /USR/SBIN/CRON[27086]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:12:01 RT0035 /USR/SBIN/CRON[27092]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:13:01 RT0035 /USR/SBIN/CRON[27110]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:14:01 RT0035 /USR/SBIN/CRON[27116]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:15:02 RT0035 /USR/SBIN/CRON[27134]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:16:01 RT0035 /USR/SBIN/CRON[27140]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:17:01 RT0035 /USR/SBIN/CRON[27157]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Aug 26 21:17:01 RT0035 /USR/SBIN/CRON[27158]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:18:01 RT0035 /USR/SBIN/CRON[27175]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:19:01 RT0035 /USR/SBIN/CRON[27193]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:20:01 RT0035 /USR/SBIN/CRON[27199]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:21:01 RT0035 /USR/SBIN/CRON[27217]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:22:01 RT0035 /USR/SBIN/CRON[27223]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:23:01 RT0035 /USR/SBIN/CRON[27241]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:24:01 RT0035 /USR/SBIN/CRON[27247]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:25:01 RT0035 /USR/SBIN/CRON[27265]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:26:01 RT0035 /USR/SBIN/CRON[27271]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:27:01 RT0035 /USR/SBIN/CRON[27289]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:28:01 RT0035 /USR/SBIN/CRON[27295]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:29:01 RT0035 /USR/SBIN/CRON[27313]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:30:01 RT0035 /USR/SBIN/CRON[27319]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:31:01 RT0035 /USR/SBIN/CRON[27337]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:32:01 RT0035 /USR/SBIN/CRON[27342]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:33:01 RT0035 /USR/SBIN/CRON[27373]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:34:01 RT0035 /USR/SBIN/CRON[27379]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:35:01 RT0035 /USR/SBIN/CRON[27397]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:36:01 RT0035 /USR/SBIN/CRON[27403]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:37:01 RT0035 /USR/SBIN/CRON[27427]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:38:02 RT0035 /USR/SBIN/CRON[27433]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:39:01 RT0035 /USR/SBIN/CRON[27452]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:39:01 RT0035 /USR/SBIN/CRON[27453]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Aug 26 21:40:01 RT0035 /USR/SBIN/CRON[27469]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:41:01 RT0035 /USR/SBIN/CRON[27502]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:41:21 RT0035 mysqld_safe[27568]: started Aug 26 21:41:21 RT0035 mysqld[27571]: 090826 21:41:21 InnoDB: Started; log sequence number 0 43665 Aug 26 21:41:21 RT0035 mysqld[27571]: 090826 21:41:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Aug 26 21:41:21 RT0035 mysqld_safe[27583]: ended Aug 26 21:41:32 RT0035 mysqld_safe[27710]: started Aug 26 21:41:32 RT0035 mysqld[27713]: 090826 21:41:32 InnoDB: Started; log sequence number 0 43665 Aug 26 21:41:32 RT0035 mysqld[27713]: 090826 21:41:32 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Aug 26 21:41:32 RT0035 mysqld_safe[27725]: ended Aug 26 21:41:46 RT0035 /etc/init.d/mysql[27875]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Aug 26 21:41:46 RT0035 /etc/init.d/mysql[27875]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Aug 26 21:41:46 RT0035 /etc/init.d/mysql[27875]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Aug 26 21:41:46 RT0035 /etc/init.d/mysql[27875]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Aug 26 21:41:46 RT0035 /etc/init.d/mysql[27875]: Aug 26 21:42:01 RT0035 /USR/SBIN/CRON[27883]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:43:01 RT0035 /USR/SBIN/CRON[27901]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:43:13 RT0035 dhclient: DHCPREQUEST on eth0 to 85.14.216.4 port 67 Aug 26 21:43:13 RT0035 dhclient: DHCPACK from 85.14.216.4 Aug 26 21:43:13 RT0035 dhclient: bound to 85.14.216.90 -- renewal in 3280 seconds. Aug 26 21:44:01 RT0035 /USR/SBIN/CRON[27915]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:45:01 RT0035 /USR/SBIN/CRON[27933]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:46:01 RT0035 /USR/SBIN/CRON[27939]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:47:01 RT0035 /USR/SBIN/CRON[27960]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:48:01 RT0035 /USR/SBIN/CRON[27993]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:49:01 RT0035 /USR/SBIN/CRON[28013]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:50:01 RT0035 /USR/SBIN/CRON[28022]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:51:01 RT0035 /USR/SBIN/CRON[28042]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:52:01 RT0035 /USR/SBIN/CRON[28052]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:53:01 RT0035 /USR/SBIN/CRON[28077]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:54:01 RT0035 /USR/SBIN/CRON[28094]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:55:01 RT0035 /USR/SBIN/CRON[28112]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:56:01 RT0035 /USR/SBIN/CRON[28118]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:57:01 RT0035 /USR/SBIN/CRON[28137]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:58:01 RT0035 /USR/SBIN/CRON[28143]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 21:59:01 RT0035 /USR/SBIN/CRON[28161]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 22:00:01 RT0035 /USR/SBIN/CRON[28167]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 22:01:01 RT0035 /USR/SBIN/CRON[28183]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) Aug 26 22:02:01 RT0035 /USR/SBIN/CRON[28196]: (root) CMD ( php -q /home/gameserver/scripts/scheduler.php) |
Quellcode |
|
1 2 3 |
mysql_install_db --help mysql_install_db --force |