Søg
Avatar billede themaster Nybegynder
06. juni 2004 - 21:33 Der er 14 kommentarer og
1 løsning

fejl 2002 i mysql på debian-server

Hej Exp's
1. Når jeg restarter min /etc/init.d/mysql kommer følgende fejl i loggen.

040606 21:31:05  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:05  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:05  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:05  mysqld started
/usr/sbin/mysqld: ERROR: unknown variable 'key_buffer          = 16M'
040606 21:31:06  mysqld ended

040606 21:31:06  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:07  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:08  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:10  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:11  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
040606 21:31:12  Error at /etc/init.d/mysql\n^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Hvad er der galt??

2. Jeg kan heller ikke få phpMyAdmin eller MySQLCC til at connecte fra netværk/internet. Se http://pma.themaster.dk for at se fejlen.

Hvad er der galt??

//themaster
Avatar billede dennismp Nybegynder
06. juni 2004 - 21:44 #1
Hvordan ser din my.cnf ud?

Kig efter [mysqld] under denne sektion bør du kunne finde socket = ..
Kan du finde den? Hvordan ser den ud?

Min ser sådan her ud:
socket          = /var/run/mysqld/mysqld.sock
Avatar billede themaster Nybegynder
06. juni 2004 - 22:23 #2
her er min my.cnf

#
# 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]
err-log        = /var/log/mysql/mysql.err
socket          = /var/run/mysqld/mysqld.sock

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. 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-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
set-variable    = key_buffer            = 16M
set-variable    = max_allowed_packet    = 1M
set-varible    = 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
max_allowed_packet      = 1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M
Avatar billede dennismp Nybegynder
06. juni 2004 - 22:53 #3
findes directory'et:  /var/run/mysqld/
og filen:  /var/run/mysqld/mysqld.sock
Avatar billede dennismp Nybegynder
06. juni 2004 - 22:53 #4
har du kigget i din mysql error log?
Avatar billede themaster Nybegynder
06. juni 2004 - 22:59 #5
det jeg har postet i toppen er fra mysql-error-log.
/var/run/mysql/ findes,
men mysqld.sock findes ikke
Avatar billede dennismp Nybegynder
06. juni 2004 - 23:01 #6
Ah beklager :).

er det en slåfejl at du har skrevet /var/run/mysql/ (uden d til sidst) ?

Hvilke rettigheder har du på dit /var/run/mysqld/ dir?
Avatar billede themaster Nybegynder
06. juni 2004 - 23:11 #7
1 drwxr-xr-x    2 mysql    root          48 Jun  6 21:29 mysqld
Avatar billede themaster Nybegynder
06. juni 2004 - 23:13 #8
ja, det er en slåfejl
Avatar billede dennismp Nybegynder
06. juni 2004 - 23:34 #9
Jeg er ved at løbe tør for idéer.

/usr/sbin/mysqld: ERROR: unknown variable 'key_buffer          = 16M'

har du rette denne fejl?

Jeg tror du bare skal rette:
[isamchk]
key_buffer              = 16M
til
[isamchk]
set_variable = key_buffer              = 16M

og evt denne typo:
set-varible    = thread_stack          = 128K
til
set-variable    = thread_stack          = 128K

Men jeg tvivler på at det gør den store forskel.
Avatar billede themaster Nybegynder
06. juni 2004 - 23:37 #10
her var lige en lille fejl til...dette var ved reload af /etc/init.d/mysql

Reloading MySQL database server: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Avatar billede dennismp Nybegynder
06. juni 2004 - 23:44 #11
Du kan få min my.cnf og se om du kan se andre forskelle.
min mysql --version siger:
mysql  Ver 12.22 Distrib 4.0.18, for pc-linux-gnu (i686)
-- my.cnf
#
# 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
[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]
err-log        = /var/log/mysql/mysql.err
socket          = /var/run/mysqld/mysqld.sock

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. Both location gets rotated by the cronjob.
#log            = /var/log/mysql/mysql.log
log            = /var/log/mysql.log
basedir        = /usr
datadir        = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
# The skip-networkin 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      =1M
thread_stack            =128K

#my stuff
#wait_timeout            =600
max_connections        =200
interactive_timeout    =600

#
# 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
max_allowed_packet=1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer      = 16M
Avatar billede themaster Nybegynder
07. juni 2004 - 00:21 #12
jeg genstartede lige server (jeg sider ikke hjemme, men laver at over ssh) og nu virker det sku....næsten da

lige en lille sidste ting..hvordan får jeg den til at godtage udefra kommende connections??

//themaster
Avatar billede dennismp Nybegynder
07. juni 2004 - 00:38 #13
Når du opretter brugerne i din mysql database, der angiver du en host. Hvis denne host ikke passer med den ip/domæne folk connecter fra får de en permission denied. Jeg tror nok den defaulter til at være localhost (og maskinens eget navn - ikke hele domænet).. Du kan jo prøve at rette host til "der de nu connecter fra" eller bruge % (wildcard, accepterer alt).
Avatar billede themaster Nybegynder
07. juni 2004 - 00:43 #14
ok....thx....ligger du lige et svar så kommer der lidt pint...thx 4 hjælpen...

//themaster
Avatar billede dennismp Nybegynder
07. juni 2004 - 00:45 #15
Det var så lidt.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
SQL kurser
Computerworld tilbyder specialiserede kurser i database-management
Se alle SQL kurser

Flere spørgsmål fra MySQL kategorien

Titel Indlæg Oprettet Seneste aktivitet
Problemer med Æ, Ø og Å ved søgning Af cht22 i MySQL 6 01/05/202512:30 01/05/202517:22
Kan ikke få forbindelse til min database Af KurtG i MySQL 5 20/03/202520:07 21/03/202513:10
Kan jeg lave en "søg og erstat" i databasen Af a3-seo.dk i MySQL 4 28/12/202407:53 29/12/202404:41
Auto Faktura.. Af SommerFyr i MySQL 21 13/08/202415:08 15/08/202417:54
Hjemmeside med bruger login Af FennekTheFox i MySQL 3 22/06/202411:29 29/06/202409:13
Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Opret Log ind

Du kan også logge ind via nedenstående tjenester

Alle kategorier på Eksperten
Seneste spørgsmål Seneste aktivitet
I dag 07:57 Pludselig begyndte min computer at larme Af lenej i PC
I går 17:28 Tekst format i Kodevinduet Af per2edb i Access
I går 16:55 Et pludselig opstået ikon på skrivebordet Af ErikHg i Windows
I går 10:32 Asus R565 legetøj Af Svend_J i PC
01/1118:59 Ang fifa 26 til Ps5 Af made18 i Andet software
White papers
Flere white papers »