 |
Server Help
Community forums for Subgame, ASSS, and bots
|
| Author |
Message |
k0zy
Server Help Squatter
Gender:
Joined: Jan 11 2003
Posts: 571
Location: Germany
Offline
|
 Posted: Tue Jan 04, 2005 2:23 pm Post subject: Can't connect to local MySQL server |
 |
 |
|
|
I can't get ASSS to connect to my MySQL server.
When I start it the log says:
I <mysql> connecting to mysql db on localhost, user asss, db asss
W <mysql> connect failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) |
I'm sure MySQL is running.
I checked wiith ps ax and I can connect to it via mysql-command line and phpmyadmin, as well as some websites use it.
Here's my modules.conf
;; db stuff:
database:mysql
;database:aliasdb |
And my global.conf
[mysql]
hostname=localhost
user=asss
password=xxx
database=asss |
username and password, as well as the database are correct.
Is it a bug, is mysql disabled or did I forget something?
Bob Dole.. Bob Dole... Bob Dole...... bob dole.... bob... dole....
_________________
It's a shark! Oh my god! Unbelievable! |
|
| Back to top |
|
 |
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.
Age:38
Gender:
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
|
| Posted: Tue Jan 04, 2005 3:00 pm Post subject: |
|
|
|
|
I think you forgot something, check in /etc/mysql/my.cnf if the socket is actually set to /tmp/mysql.sock.
On Unix/Linux there are two different ways to connect to the mysqld, by using networking and by using a socket and obviously your version of ASSS uses a socket.
Although, when I was using ASSS I think it used networking. 
Make sure
| Quote: | [client]
socket = /tmp/mysql.sock |
and
| Quote: | [mysqld]
socket = /tmp/mysql.sock |
in /etc/mysql/my.cnf.
Or, if possible, set ASSS's socket attempt to the value found in the /etc/mysql/my.cnf.
Edit: Oops, it's not /etc/my.cnf, but /etc/mysql/my.cnf indeed.
Last edited by Solo Ace on Tue Jan 04, 2005 3:57 pm, edited 1 time in total |
|
| Back to top |
|
|
k0zy
Server Help Squatter
Gender:
Joined: Jan 11 2003
Posts: 571
Location: Germany
Offline
|
| Posted: Tue Jan 04, 2005 3:49 pm Post subject: |
|
|
|
|
| Quote: | #
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.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.
#
# 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...
[client]
#password = my_password
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]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
# Both location gets rotated by the cronjob.
#log = /var/log/mysql.log
log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# The skip-networking option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
#
# Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt
# 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
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M |
I dont know much about my.cnf.
It was in /etc/mysql/my.cnf
Is everything ok here?
Bob Dole.. Bob Dole... Bob Dole...... bob dole.... bob... dole.... |
|
| Back to top |
|
|
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.
Age:38
Gender:
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline
|
| Posted: Tue Jan 04, 2005 4:10 pm Post subject: |
|
|
|
|
Oh yeah, it's /etc/mysql/my.cnf, updated in previous post.
Okay, I think this should be the correct version (my changes are bold and blue, as you can see I commented your versions of the settings).
| Quote: | #
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.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.
#
# 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...
[client]
#password = my_password
port = 3306
# Previous value, just for when the current setting doesn't work:
#socket = /var/run/mysqld/mysqld.sock
socket = /tmp/mysql.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]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
# Previous value, just for when the current setting doesn't work:
#socket = /var/run/mysqld/mysqld.sock
socket = /tmp/mysql.sock
port = 3306
# Both location gets rotated by the cronjob.
#log = /var/log/mysql.log
log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# The skip-networking option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
#
# Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt
# 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
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M |
But uhm, I could be completely wrong here. |
|
| Back to top |
|
|
k0zy
Server Help Squatter
Gender:
Joined: Jan 11 2003
Posts: 571
Location: Germany
Offline
|
| Posted: Tue Jan 04, 2005 5:02 pm Post subject: |
|
|
|
|
Tanks Solo 
It works now.
I had to edit the php.ini, too afterwards to use the /tmp/mysql.socket socket.
I'm playing around with asss now
Bob Dole.. Bob Dole... Bob Dole...... bob dole.... bob... dole.... |
|
| Back to top |
|
|
|
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
Software by php BB © php BB Group
Server Load: 54 page(s) served in previous 5 minutes. |
FAQ
Search
Memberlist
Usergroups
Statistics
Register
Profile
Login to check your private messages
Login
All In One "Map/Settings/Lvz/Modu... 
