Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql problem
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo on AMD64
View previous topic :: View next topic  
Author Message
databusx
n00b
n00b


Joined: 31 Mar 2006
Posts: 27

PostPosted: Sun Sep 03, 2006 9:43 am    Post subject: mysql problem Reply with quote

Hi !

I have a strange problem with my mysql! i have tryed many things without results.
when i start the service is all fine , no errors.
when i try to change anything in database using the php scripts + mysql i got always this error :

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 133

Warning: mysql_db_query(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 136

Warning: mysql_db_query(): A link to the server could not be established in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 136

Warning: mysql_connect(): Lost connection to MySQL server during query in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 148

Warning: mysql_db_query(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 150

Warning: mysql_db_query(): A link to the server could not be established in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 150

I have this working fine but now give that error. Its update and change the record in database but always give the error.

my.cnf

# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v 1.3 2006/02/01 20:25:56 vivo Exp $

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/run/mysqld/mysqld-500.sock

[mysql]
character-sets-dir=utf8
default-character-set=utf8

[mysqladmin]
character-sets-dir=utf8
default-character-set=utf8

[mysqlcheck]
character-sets-dir=utf8
default-character-set=utf8

[mysqldump]
character-sets-dir=utf8
default-character-set=utf8

[mysqlimport]
character-sets-dir=utf8
default-character-set=utf8

[mysqlshow]
character-sets-dir=utf8
default-character-set=utf8

[myisamchk]
character-sets-dir=utf8

[myisampack]
character-sets-dir=utf8

# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err

# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
character-set-server = utf8
default-character-set = utf8
user = mysql
port = 3306
socket = /var/run/mysqld/mysqld-500.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
#skip-locking
#skip-innodb
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
language = /usr/share/mysql/english

#security:
#using "localhost" in connects use sockets by default
#skip-networking
bind-address = 127.0.0.1

log-bin
server-id = 1

# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# you need debug use flag enabled to use this ones.
# if needed uncomment them, start the server and issue
# #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
# this will show you *exactly* what's appening in your server ;)

#log = /tmp/mysqld.sql
#gdb
#debug = d:t:i:o,/tmp/mysqld.trace
#one-thread

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# The following is the InnoDB configuration
# if you wish to disable innodb instead
# uncomment just the next line
#skip-innodb
#
# the rest of the innodb config follows:
# don't eat too much memory, we're trying to be safe on 64Mb boxes.
# you might want to bump this up a bit on boxes with more RAM
innodb_buffer_pool_size = 16M
# this is the default, increase if you have lots of tables
innodb_additional_mem_pool_size = 2M
#
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
# and upstream wants things to be under /var/lib/mysql/, so that's the route
# we have to take for the moment
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path = ibdata1:10M:autoextend
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size = 5M
# this is the default, increase if you have very large transactions.
innodb_log_buffer_size = 8M
# this is the default, and won't hurt you.
# you shouldn't need to tweak it.
set-variable = innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

#vim: set tabstop=4 :
#vim: set shiftwidth=4 :


I accept any sugestion!
Thanks!
Back to top
View user's profile Send private message
SinoTech
Advocate
Advocate


Joined: 20 Mar 2004
Posts: 2579
Location: Neunkirchen / Saarland / Germany

PostPosted: Sun Sep 03, 2006 9:54 am    Post subject: Re: mysql problem Reply with quote

databusx wrote:

[...]
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/linbak/webserver/udrcf.com/fotobombeiro/quadro/index_perfil_ok.php on line 133
[...]


databusx wrote:

[...]
my.cnf
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v 1.3 2006/02/01 20:25:56 vivo Exp $

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/run/mysqld/mysqld-500.sock
[...]

Think it is enough to change this line
Code:

socket                  = /var/run/mysqld/mysqld-500.sock

to this
Code:

socket                  = /var/run/mysqld/mysqld.sock

Cheers,

Sino
_________________
Help to answer the unanswered
Back to top
View user's profile Send private message
databusx
n00b
n00b


Joined: 31 Mar 2006
Posts: 27

PostPosted: Sun Sep 03, 2006 11:58 am    Post subject: Reply with quote

Thanks!

how can i not see that :( ... i am blind my god!

sorry m8 and thanks again.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo on AMD64 All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot 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