Currently I am running a program called Q3Log, which is java based, but it seems to have stopped working for some reason. (no log to show errors). Anyhow, now my only option is to run a MySql / php backend stat generator.
I have included the /var/lib/mysql/quake3server.err log as an attachment. I looked over it, but dont understand the errors.
I am running both Quake 3 servers on Slackware 9.1 based systems, fully updated and upgraded to the latest files/programs from Slackware-current.
The version of MySql that I am trying to run is: mysql Ver 12.21 Distrib 4.0.15a, for slackware-linux (i486)
I do not have safe_mysqld, but I do in fact have mysqld_safe, and when I run it I get the following:
#mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql 031230 12:53:08 mysqld ended
I did do the following (after reading through some of the docs)
<--------begin MySql Mayhem----------->
#mysql_install_db
Which gave me the following output:
Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031230 12:56:56 /usr/libexec/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h quake3server password 'new-password' See the manual for more instructions. To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command!
You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
<------------end MySql Mayhem---------------------------->
So, I do all the above, cute friggin MySql crud, that I am instructed to do.. I.E. >
/usr/bin/mysqladmin -u root password 'MY_BIG_FAT_PASSWORD' /usr/bin/mysqladmin -u root -h quake3server password 'Stupid_MySql'
which gives me the following unknown errors. >>
[EMAIL PROTECTED]:/usr# /usr/bin/mysqladmin -u root password 'MY_BIG_FAT_PASSWORD'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
So now (moving right along.. doing whilst reading) I run the following cmd.:
*#mysqld_safe --user=mysql 2>&1 >/dev/null &*
hmm.. nottta!
So then I run:
#mysql -uroot mysql
Which spews this crud:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
What kind of program is this I ask myself.. that wont even try to run, on a default Linux install.. (Slackware 9.1 even!)
So..
I do a google search for: running mysql
and end up @ http://www.linuxforum.com/forums/index.php?s=74eee1e361c3628126848736dd92f61f&showtopic=5319
Here I peek around seeing many people having the same errors I am getting. .I see something about mysql.sock, so I do a little> locate mysql.sock > which shows me zero, notta.. zilch.. .nobody is home!
Ok.. so then I click, click, click around and end up @ http://www.linuxforum.com/mysql-manual.php
(I swore I wouldn't research this very much.. and now look what I have gotten myself into!)
So here I am... http://www.linuxforum.com/mysql/manual_Installing.html#Post-installation
I run: > mysqld_safe --user=mysql &
Which gives me the following tasty information: >
Starting mysqld daemon with databases from /var/lib/mysql
[EMAIL PROTECTED]:~# Starting mysqld daemon with databases from /var/lib/mysql
031230 13:19:19 mysqld ended
Hmm... something tells me MySql needs a hammer....
Ok, so now I am very angry.. I continue to look over the info @ http://www.linuxforum.com/mysql/manual_Installing.html#Post-installation
still... CONFUSED 8-P and folks.. The mayhem continues!
now.. I am here: http://www.linuxforum.com/mysql/manual_Tutorial.html#Tutorial
I try this: mysql -h localhost -u root -p
I get this: Enter password:
I enter password and get this: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
BUT... I remember that: /usr/bin/mysqladmin -u root password 'new-password' and
/usr/bin/mysqladmin -u root -h quake3server password 'new-password'
I even tried this command: mysqladmin -u root password mypassword (with out the ' ' on each end)
Did not work.. so what am I doing this for? hmmm.... maybe a bigger hammer is needed for this project!
So ok I try this command again (literally I.E. without any changes to the syntax.. just to see what will happen)
(And.. just so you know... I am doing all of this as root.)
#mysqladmin -u root password 'new-password' < yes folks.. that line copied and pasted right to the terminal window!
Which spews.. ONCE again:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
So everything points to this stupid "mysql.sock", I really wonder what the method to their madness is over there at the dev shed where they develop mysql.. you'd think that by now.. somone would have figured out a nice big fat "WTF"? and fix this damn thing!
So once again... I am off to google and do a search for: mysql + no mysql.sock and get this page:
http://forums.devshed.com/archive/4/2001/10/2/11588
Of which tells me to do: "Go to /var/lib/mysql and do a 'chmod 755'." Which I do.. then I try to run mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql 031230 23:27:33 mysqld ended
So now I google some more and end up here:
http://forums.devshed.com/archive/4/2001/10/2/23637
I follow the suggestions there.. and still get this friggin error:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
So once again.. google time... Google search: Slackware 9.1 + mysql + no mysql.sock
hmm.. just a bunch of useless crap.. half of which isn't even in English.
Well anyhow.. I quit..
TIA
Sincerely,
-- TriKster Abacus irc.freenode.net #cllug #gentoo #linuxfriends irc.cotse.com #linux http://www.cllug.org http://www.trikster.homelinux.org http://www.trikster.homelinux.org/contact.html
031208 21:51:12 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031208 21:51:12 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031208 21:51:13 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031208 21:51:13 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 031208 21:51:14 InnoDB: Started 031208 21:51:14 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031208 21:51:14 Aborting
031208 21:51:14 InnoDB: Starting shutdown... 031208 21:51:16 InnoDB: Shutdown completed 031208 21:51:16 /usr/libexec/mysqld: Shutdown Complete 031208 21:51:16 mysqld ended 031208 21:51:19 mysqld started 031208 21:51:19 InnoDB: Started 031208 21:51:19 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031208 21:51:19 Aborting 031208 21:51:19 InnoDB: Starting shutdown... 031208 21:51:22 InnoDB: Shutdown completed 031208 21:51:22 /usr/libexec/mysqld: Shutdown Complete 031208 21:51:22 mysqld ended 031230 12:39:32 mysqld started 031230 12:39:32 InnoDB: Started 031230 12:39:33 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031230 12:39:33 Aborting 031230 12:39:33 InnoDB: Starting shutdown... 031230 12:39:35 InnoDB: Shutdown completed 031230 12:39:35 /usr/libexec/mysqld: Shutdown Complete 031230 12:39:35 mysqld ended 031230 12:53:06 mysqld started 031230 12:53:06 InnoDB: Started 031230 12:53:06 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031230 12:53:06 Aborting 031230 12:53:06 InnoDB: Starting shutdown... 031230 12:53:08 InnoDB: Shutdown completed 031230 12:53:08 /usr/libexec/mysqld: Shutdown Complete 031230 12:53:08 mysqld ended 031230 12:58:41 mysqld started 031230 12:58:42 InnoDB: Started 031230 12:58:42 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031230 12:58:42 Aborting 031230 12:58:42 InnoDB: Starting shutdown... 031230 12:58:44 InnoDB: Shutdown completed 031230 12:58:44 /usr/libexec/mysqld: Shutdown Complete 031230 12:58:44 mysqld ended 031230 13:01:03 mysqld started 031230 13:01:03 InnoDB: Started 031230 13:01:03 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031230 13:01:03 Aborting 031230 13:01:03 InnoDB: Starting shutdown... 031230 13:01:06 InnoDB: Shutdown completed 031230 13:01:06 /usr/libexec/mysqld: Shutdown Complete 031230 13:01:06 mysqld ended 031230 13:03:13 mysqld started 031230 13:03:13 InnoDB: Started 031230 13:03:13 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031230 13:03:13 Aborting 031230 13:03:13 InnoDB: Starting shutdown... 031230 13:03:16 InnoDB: Shutdown completed 031230 13:03:16 /usr/libexec/mysqld: Shutdown Complete 031230 13:03:16 mysqld ended 031230 13:07:52 mysqld started 031230 13:07:53 InnoDB: Started 031230 13:07:53 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031230 13:07:53 Aborting 031230 13:07:53 InnoDB: Starting shutdown... 031230 13:07:55 InnoDB: Shutdown completed 031230 13:07:55 /usr/libexec/mysqld: Shutdown Complete 031230 13:07:55 mysqld ended 031230 13:18:28 mysqld started 031230 13:18:28 InnoDB: Started 031230 13:18:28 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031230 13:18:28 Aborting 031230 13:18:28 InnoDB: Starting shutdown... 031230 13:18:31 InnoDB: Shutdown completed 031230 13:18:31 /usr/libexec/mysqld: Shutdown Complete 031230 13:18:31 mysqld ended 031230 13:19:19 mysqld started 031230 13:19:19 mysqld started 031230 13:19:19 Can't start server: Bind on TCP/IP port: Address already in use 031230 13:19:19 Do you already have another mysqld server running on port: 3306 ? 031230 13:19:19 Aborting 031230 13:19:19 /usr/libexec/mysqld: Shutdown Complete 031230 13:19:19 mysqld ended 031230 13:19:19 InnoDB: Started 031230 13:19:19 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031230 13:19:19 Aborting 031230 13:19:19 InnoDB: Starting shutdown... 031230 13:19:21 InnoDB: Shutdown completed 031230 13:19:21 /usr/libexec/mysqld: Shutdown Complete 031230 13:19:21 mysqld ended
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
