Unix-сокеты

Hacker · January 17, 2011, 1:08pm

ОС - Linux Ubuntu

TC-версия - 11039, b28881f6485f

нужно подключить базы мира и чаров (без реалм бд) через unix сокет

worldserver.conf

[CODE]WorldDatabaseInfo = "/var/run/mysqld/mysqld.sock;root;***;world

CharacterDatabaseInfo = "/var/run/mysqld/mysqld.sock;root;***;characters[/CODE]

etc/mysql/my.cnf

[CODE]#

The MySQL database server configuration file.

You can copy this to one of:

- “/etc/mysql/my.cnf” to set global options,

- “~/.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.

For explanations see

http://dev.mysql.com/doc/mysql/en/server-system-variables.html

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…

Remember to edit /etc/mysql/debian.cnf when changing the socket location.

[client]

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]

* Basic Settings

* IMPORTANT

If you make changes to these settings and your system uses apparmor, you may

also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.

user = mysql

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

port = 3306

basedir = /usr

datadir = /var/lib/mysql

tmpdir = /tmp

skip-external-locking

Instead of skip-networking the default is now to listen only on

localhost which is more compatible and is not less secure.

bind-address = 127.0.0.1

* Fine Tuning

key_buffer = 16M

max_allowed_packet = 16M

thread_stack = 192K

thread_cache_size = 8

This replaces the startup script and checks MyISAM tables if needed

the first time they are touched

myisam-recover = BACKUP

#max_connections = 100

#table_cache = 64

#thread_concurrency = 10

* Query Cache Configuration

query_cache_limit = 1M

query_cache_size = 16M

* Logging and Replication

Both location gets rotated by the cronjob.

Be aware that this log type is a performance killer.

As of 5.1 you can enable the log at runtime!

#general_log_file = /var/log/mysql/mysql.log

#general_log = 1

log_error = /var/log/mysql/error.log

Here you can see queries with especially long duration

#log_slow_queries = /var/log/mysql/mysql-slow.log

#long_query_time = 2

#log-queries-not-using-indexes

The following can be used as easy to replay backup logs or for replication.

note: if you are setting up a replication slave, see README.Debian about

other settings you may need to change.

#server-id = 1

#log_bin = /var/log/mysql/mysql-bin.log

expire_logs_days = 10

max_binlog_size = 100M

#binlog_do_db = include_database_name

#binlog_ignore_db = include_database_name

* InnoDB

InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.

Read the manual for more InnoDB related options. There are many!

* Security Features

Read the manual, too, if you want chroot!

chroot = /var/lib/mysql/

For generating SSL certificates I recommend the OpenSSL GUI “tinyca”.

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

* IMPORTANT: Additional settings that can override those from this file!

The files must end with ‘.cnf’, otherwise they’ll be ignored.

!includedir /etc/mysql/conf.d/[/CODE]

и при запуске такой лог:

Server.log

[CODE]2011-01-17 17:58:40 Using configuration file /root/Compiled/worldserver.conf.

2011-01-17 17:58:40 TrinityCore Rev: 11039 Release Hash: b28881f6485f (Unix, little-endian) (core-daemon)

2011-01-17 17:58:40 to stop.

2011-01-17 17:58:40 ______ __

2011-01-17 17:58:40 /__ _\ __ _/\ _

2011-01-17 17:58:40 //\ / _ __ /_\ ___ /_\ \ ,\ __ __

2011-01-17 17:58:40 \ \ /`‘__/\ \ /’ _ `/\ \ \ / /\ /\ \

2011-01-17 17:58:40 \ \ \ \ / \ \ /\ /\ \ \ \ \ _\ \ _\ \

2011-01-17 17:58:40 \ _\ _\ \ _\ _\ _\ _\ _\/`___ \

2011-01-17 17:58:40 //// ////////// `/_/> \

2011-01-17 17:58:40 C O R E /___/

2011-01-17 17:58:40 http://TrinityCore.org /__/

2011-01-17 17:58:40 ERROR: Could not connect to MySQL database at : Access denied for user ‘root’@‘localhost’ (using password: NO)

2011-01-17 17:58:40 ERROR: Could not connect to MySQL database at : Access denied for user ‘root’@‘localhost’ (using password: NO)[/CODE]

в чем собственно проблема?

SignFinder · January 17, 2011, 2:45pm

файла сокета нет, или он не на том месте, или логин пасс не подходят или еще чего.

Hacker · January 17, 2011, 4:34pm

поменял /etc/mysql/my.cnf:

[CODE][client]

port = 3306

socket = /tmp/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 = /tmp/mysqld.sock

nice = 0

[mysqld]

port=3306

socket=/tmp/mysqld.sock

set-variable = key_buffer_size=16M

set-variable = max_allowed_packet=1000M

[mysqldump]

quick

quote-names

max_allowed_packet = 16M

[mysql]

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

[isamchk]

key_buffer = 16M

* IMPORTANT: Additional settings that can override those from this file!

The files must end with ‘.cnf’, otherwise they’ll be ignored.

!includedir /etc/mysql/conf.d/[/CODE]

теперь лог такой

[CODE]Using configuration file /root/Compiled/worldserver.conf.

TrinityCore Rev: 11039 Release Hash: b28881f6485f (Unix, little-endian) (core-daemon)

to stop.

/__ _\ __ _/\ _

//\ / _ __ /_\ ___ /_\ \ ,\ __ __

\ \ /`‘__/\ \ /’ _ `/\ \ \ / /\ /\ \

\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

 \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \

  \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \

                             C O R E  /\___/

http://TrinityCore.org /__/

Opening databasepool ‘’. Async threads: 1, synch threads: 1

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Databasepool opened succesfuly. 2 total connections running.

Opening databasepool ‘’. Async threads: 1, synch threads: 2

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Databasepool opened succesfuly. 3 total connections running.

Opening databasepool ‘realmd’. Async threads: 1, synch threads: 1

MySQL client library: 5.1.49

MySQL server ver: 6.0.6-alpha-community-log

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

MySQL client library: 5.1.49

MySQL server ver: 6.0.6-alpha-community-log

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

Databasepool opened succesfuly. 2 total connections running.

Realm running as realm ID 3

Using World DB: Unknown world database.

Using creature EventAI: Unknown creature EventAI.

Will clear logs table of entries older than 1209600 seconds every 10 minutes.

Using DataDir /root/Compiled/Maps/

WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1

WORLD: VMap data directory is: /root/Compiled/Maps/vmaps

Loading Trinity strings…

Loaded 0 trinity strings. DB table trinity_string is empty. Cannot continue.

~DatabaseWorkerPool for ‘realmd’.

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘’.[/CODE]

почему он ищет файл в /var/run/mysqld/mysqld.sock?

да и /tmp/mysqld.sock я тож не нашел…

в чем проблема?

SignFinder · January 18, 2011, 10:18am

поменял /etc/mysql/my.cnf:

[CODE][client]

port = 3306

socket = /tmp/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 = /tmp/mysqld.sock

nice = 0

[mysqld]

port=3306

socket=/tmp/mysqld.sock

set-variable = key_buffer_size=16M

set-variable = max_allowed_packet=1000M

[mysqldump]

quick

quote-names

max_allowed_packet = 16M

[mysql]

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

[isamchk]

key_buffer = 16M

* IMPORTANT: Additional settings that can override those from this file!

The files must end with ‘.cnf’, otherwise they’ll be ignored.

!includedir /etc/mysql/conf.d/[/CODE]

теперь лог такой

[CODE]Using configuration file /root/Compiled/worldserver.conf.

TrinityCore Rev: 11039 Release Hash: b28881f6485f (Unix, little-endian) (core-daemon)

to stop.

/__ _\ __ _/\ _

//\ / _ __ /_\ ___ /_\ \ ,\ __ __

\ \ /`‘__/\ \ /’ _ `/\ \ \ / /\ /\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \

 \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \

  \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \

                             C O R E  /\___/
http://TrinityCore.org /__/

Opening databasepool ‘’. Async threads: 1, synch threads: 1

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Databasepool opened succesfuly. 2 total connections running.

Opening databasepool ‘’. Async threads: 1, synch threads: 2

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Could not connect to MySQL database at : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Databasepool opened succesfuly. 3 total connections running.

Opening databasepool ‘realmd’. Async threads: 1, synch threads: 1

MySQL client library: 5.1.49

MySQL server ver: 6.0.6-alpha-community-log

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

MySQL client library: 5.1.49

MySQL server ver: 6.0.6-alpha-community-log

[WARNING] MySQL client/server version mismatch; may conflict with behaviour of prepared statements.

Databasepool opened succesfuly. 2 total connections running.

Realm running as realm ID 3

Using World DB: Unknown world database.

Using creature EventAI: Unknown creature EventAI.

Will clear logs table of entries older than 1209600 seconds every 10 minutes.

Using DataDir /root/Compiled/Maps/

WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1

WORLD: VMap data directory is: /root/Compiled/Maps/vmaps

Loading Trinity strings…

Loaded 0 trinity strings. DB table trinity_string is empty. Cannot continue.

~DatabaseWorkerPool for ‘realmd’.

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘’.[/CODE]

почему он ищет файл в /var/run/mysqld/mysqld.sock?

да и /tmp/mysqld.sock я тож не нашел…

в чем проблема?

ищет по пути в конфиге тринити. файла нет-значит он или не создается или мускуль не запущен. почему не создается-читайте логи мускуля

Hacker · January 18, 2011, 11:36am

в конфиге поставлен путь /tmp/mysqld.sock, мускл запущен, а лог активировать это ведь в конфиге my.cnf выставить log=/some/path/to/log.txt?

Sun · January 19, 2011, 2:22pm

возможно ядро не может найти его где то в папках, попробуй скопируй его в папку с ядром (не уверен, но на WIndows dllку он так и не может найти, приходится копировать)

Hacker · January 19, 2011, 3:52pm

дак его вообще нет… карочи буду ковыряться если наковыряю скажу как…