Dear visitor, welcome to sourceserver.info. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.
Administrator
Location: Flensburg
Occupation: Industrieelektroniker
wcf.user.option.userOption53: Nein
Source code |
|
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" } |
Administrator
Location: Flensburg
Occupation: Industrieelektroniker
wcf.user.option.userOption53: Nein
Quoted from ""DeaD_EyE""
Für alle, die das Problem mit dem Verbinden der Datenbank haben, können statt der IP vom Host folgendes verwenden:
Source code
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.
Administrator
Location: Flensburg
Occupation: Industrieelektroniker
wcf.user.option.userOption53: Nein
Quoted from ""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!
Source code |
|
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 ;)) |
Source code |
|
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) |
Source code |
|
1 2 3 |
mysql_install_db --help mysql_install_db --force |