Nach neisntallation falscher Socket Pfad

MySQL, PostgreSQL, SQLite
recoilmaster
Posts: 188
Joined: 2003-10-02 10:35

Nach neisntallation falscher Socket Pfad

Post by recoilmaster » 2003-12-18 21:38

Hi !

Ich hab Mysql neu isntallier. Dadurch sit die ymsqld.socket nun in tmp und nicht mehr in var/run. allerdings haben alle Programme die ich neu installieren will die var/runmysqld.socket drinnen *_*

Wie bekomm ich das geändert ?

Danke

Bye Nils

darkspirit
Posts: 553
Joined: 2002-10-05 16:39
Location: D'dorf

Re: Nach neisntallation falscher Socket Pfad

Post by darkspirit » 2003-12-18 21:43

Editiere die my.cnf und passe den Pfad zum Socket an.

recoilmaster
Posts: 188
Joined: 2003-10-02 10:35

Re: Nach neisntallation falscher Socket Pfad

Post by recoilmaster » 2003-12-18 21:55

Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/apache2/htdocs/includes/db.php on line 5
Es konnte keine Verbindung zur Datenbank hergestellt werden!

etc/mysql/my.cnf editiert

oder muss sie in etc ?

oxygen
Posts: 2138
Joined: 2002-12-15 00:10
Location: Bergheim

Re: Nach neisntallation falscher Socket Pfad

Post by oxygen » 2003-12-18 21:58

Kommt drauf an, normalerweise in /etc
achte drauf das du die my.cnf auch an der richtigen Stelle editierst, also unterhalb von [mysqld].

recoilmaster
Posts: 188
Joined: 2003-10-02 10:35

Re: Nach neisntallation falscher Socket Pfad

Post by recoilmaster » 2003-12-18 22:25

Code: Select all

# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password	= my_password
port		= 3306
socket		= /tmp/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[safe_mysqld]
err-log		= /usr/local/mysql/share/mysql/german/errmsg.sys

[mysqld]
user		= mysql
pid-file	= /tmp/mysqld.pid
socket		= /tmp/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/local/mysql
datadir		= /usr/local/mysql
tmpdir		= /tmp
language	= /usr/local/mysql/share/mysql/german/
skip-locking
#
# 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
set-variable	= key_buffer=16M
set-variable	= max_allowed_packet=1M
set-variable	= thread_stack=128K
#
# 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

[mysqldump]
quick
set-variable	= max_allowed_packet=1M

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

[isamchk]
set-variable	= key_buffer=16M

Code: Select all

031219  0:24:04  Fatal error: Can't open privilege tables: Tabelle 'mysql.host' existiert nicht
031219  0:24:04  Aborting

031219  0:24:04  ./mysqld: Shutdown ausgeführt.

Code: Select all

test@debian:/usr/local/mysql/scripts$ ./mysql_install_db
./mysql_install_db: my_print_defaults: command not found
Didn't find ./bin/mysqld

Code: Select all

test@debian:/usr/local/mysql/bin$ ./mysql_setpermission
Password for user  to connect to MySQL:
Can't make a connection to the mysql server.
 The error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at ./mysql_setpermission line 70, <STDIN> line 1.
[/quote]

flo
Posts: 2223
Joined: 2002-07-28 13:02
Location: Berlin

Re: Nach neisntallation falscher Socket Pfad

Post by flo » 2003-12-18 22:55

bei mir folgendermaßen:

Code: Select all

host:~# ls -lisa /tmp/mysql.sock
... srwxrwxrwx    1 mysql    mysql ... /tmp/mysql.sock
host:~# ls -lisa /var/run/mysqld/
... lrwxrwxrwx    1 root     root ... mysqld.sock -> /tmp/mysql.sock

Grüße,

flo.

recoilmaster
Posts: 188
Joined: 2003-10-02 10:35

Re: Nach neisntallation falscher Socket Pfad

Post by recoilmaster » 2003-12-19 00:01

Ho !

Hat wer noch ne funzende mc.cnf von Debian apt-get Installation. Er erstellt das nimmer bei apt-get *_*

Bekomm den Salat nach apt-get

Code: Select all

Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld...failed.
Ein Blick in die Log Datei.

Code: Select all

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
031219  2:04:15  /usr/sbin/mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root -p password 'new-password'
/usr/bin/mysqladmin -u root -h debian -p password 'new-password'
See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
031219  2:04:15  /usr/sbin/mysqld: Shutdown Complete

Ich schätze mal der Fehler kommt wegen der fehlenden my.cnf *_*

Wer eine hat bitte an recoilmaster@freenet.de

DANKE!

Bye Nils