mysqld.sock' (2) QMYSQL: Unable to connect

задавайте Ваши вопросы
Правила форума
СНАЧАЛА ПОЛЬЗУЙТЕСЬ ПОИСКОМ!!!

При обращении просим Вас сразу указывать:
Вашу ОСь? Видео? Звук? DirectX? Логи Мамбл, Мурмур?
Это поможет быстрей и более точно ответить на Ваши вопросы.
Ответить
bender
Сообщения: 2
Зарегистрирован: 23 мар 2011, 16:09

mysqld.sock' (2) QMYSQL: Unable to connect

Сообщение bender »

murmur.log

20:48:52.396 Caught SIGTERM, exiting
<W>2011-10-24 20:48:52.400 Killing running servers
<F>2011-10-24 20:48:52.401 Lost connection to SQL Database: Reconnect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect
<W>2011-10-24 20:59:54.401 Initializing settings from /var/www/mumble/server/murmur.ini (basepath /var/www/mumble/server)
<W>2011-10-24 20:59:54.412 OpenSSL: OpenSSL 0.9.8o 01 Jun 2010
<W>2011-10-24 20:59:54.452 SSL: Added CA certificates from '/etc/ssl/certs/ca-certificates.crt'
<W>2011-10-24 20:59:54.479 SSL: Adding recommended CA UTN-USERFirst-Client Authentication and Email
<C>2011-10-24 20:59:54.479 WARNING: You are running murmurd as root, without setting a uname in the ini file. This might be a security risk.
<W>2011-10-24 20:59:54.526 Resource limits were 0 0
<W>2011-10-24 20:59:54.546 Successfully dropped capabilities

выделил жирным ошибку, может кто сталкивался.

10 дней работает, потом отваливаеться, ребутаю сервер все поднимаеться, сервер на Дебиане 6

B0nuse
Site Admin
Сообщения: 1588
Зарегистрирован: 27 июл 2009, 08:58
Благодарил (а): 40 раз
Поблагодарили: 363 раза
Контактная информация:

Re: mysqld.sock' (2) QMYSQL: Unable to connect

Сообщение B0nuse »

Похоже, что у Вас падает MySQL база. С ней и разбирайтесь.
Или перейдите на использование SQLite.
Мы в Telegramm https://t.me/mumbleru
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news :rtfm:

Изображение <--- Хочешь себе такой? Читай тут

Mistral
Сообщения: 3
Зарегистрирован: 28 мар 2011, 11:42
Поблагодарили: 1 раз

Re: Упарвление MurMur

Сообщение Mistral »

Огромная просьба помочь, с данной проблемой:
Вопрос.
У меня приложение ругается при попытке подцепиться к базе: ServerDB: Failed initialization: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect

Использую стандартный коннектор: QMYSQL

Сокет: /var/run/mysqld/mysqld.sock (получил по запросу cat /etc/my.cnf | grep sock)

Mistral
Сообщения: 3
Зарегистрирован: 28 мар 2011, 11:42
Поблагодарили: 1 раз

Re: Упарвление MurMur

Сообщение Mistral »

Эта ошибка решается изменением конфига.
Вместо localhost нужно указать 127.0.0.1 в настройках расположения базы.

ANTIKLAN
Сообщения: 24
Зарегистрирован: 20 фев 2011, 04:04

Re: murmur & MySQL

Сообщение ANTIKLAN »

Всем привет!
Появилась новая проблема. Есть сервер Mumble на Ubuntu 12.04 база обслуживается MySQL. И сервер БД и голосовой сервер работают на одной машине. Проблема вот в чем: при перезагрузке голосовой сервер не запускается самостоятельно и его приходится запускать вручную. В логе загрузки следующее:

<W>2012-07-28 21:55:31.106 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2012-07-28 21:55:31.106 OpenSSL: OpenSSL 1.0.1 14 Mar 2012
<W>2012-07-28 21:55:31.267 SSL: Adding recommended CA UTN-USERFirst-Client Authentication and Email
<F>2012-07-28 21:55:31.270 ServerDB: Failed initialization: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect

Я связываю это с тем что на момент попытки подключения голосового сервера к БД сервер БД еще не успевает запуститься. Что тогда нужно сделать чтобы правильно настроить запуск. Спасибо за ответы.

ApPosum
Сообщения: 2
Зарегистрирован: 04 дек 2012, 00:06

Не подключается к БД

Сообщение ApPosum »

Помогите пожалуйста ребят.. Поднял сервер на debian... На нем поднял web сервер с ispmanager, она соответсвенно подняла под себя и mysql и php и так далее...Создал нового пользователя добавил его в группу sudo и под ним поставил пакет mumble-server...Решил значит привязать это всё не к родной БД а к mysql...Всё в бил всё в порядке,сервер murmur запустился, но после рестарта сервера murmur не запускается....Вот лог mumble-server.log

Код: Выделить всё

<W>2014-04-04 19:01:59.002 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:01:59.003 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 19:01:59.192 ServerDB: Opened SQLite database /var/lib/mumble-server/mumble-server.sqlite
<W>2014-04-04 19:01:59.193 Generating new tables...
<W>2014-04-04 19:01:59.426 DBus registration succeeded
<W>2014-04-04 19:01:59.428 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 19:01:59.603 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 19:02:00.046 1 => Server listening on [::]:64738
<W>2014-04-04 19:02:00.298 1 => Generating new server certificate.
<W>2014-04-04 19:02:01.241 1 => Announcing server via bonjour
<W>2014-04-04 19:02:01.367 1 => Not registering server as public
<W>2014-04-04 19:02:01.367 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 19:06:45.614 Caught SIGTERM, exiting
<W>2014-04-04 19:06:45.614 Killing running servers
<W>2014-04-04 19:06:45.792 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 19:06:45.926 1 => Removed Ice Authenticator 
<W>2014-04-04 19:06:46.060 1 => Stopped announcing server via bonjour
<W>2014-04-04 19:06:46.186 1 => Stopped
<W>2014-04-04 19:06:46.186 Shutting down
<W>2014-04-04 19:06:46.186 MurmurIce: Shutdown complete
<W>2014-04-04 19:06:46.217 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:06:46.218 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 19:06:46.281 ServerDB: Opened SQLite database /var/lib/mumble-server/mumble-server.sqlite
<W>2014-04-04 19:06:46.285 DBus registration succeeded
<W>2014-04-04 19:06:46.287 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 19:06:46.315 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 19:06:46.495 1 => Server listening on [::]:64738
<W>2014-04-04 19:06:46.637 1 => Announcing server via bonjour
<W>2014-04-04 19:06:46.781 1 => Not registering server as public
<W>2014-04-04 19:06:46.782 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 19:11:18.914 Caught SIGTERM, exiting
<W>2014-04-04 19:11:18.914 Killing running servers
<W>2014-04-04 19:11:19.049 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 19:11:19.192 1 => Removed Ice Authenticator 
<W>2014-04-04 19:11:19.334 1 => Stopped announcing server via bonjour
<W>2014-04-04 19:11:19.485 1 => Stopped
<W>2014-04-04 19:11:19.485 Shutting down
<W>2014-04-04 19:11:19.486 MurmurIce: Shutdown complete
<W>2014-04-04 19:11:33.381 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:11:33.382 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 19:11:33.452 DBus registration succeeded
<W>2014-04-04 19:11:33.454 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 19:11:33.486 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 19:11:33.698 1 => Server listening on [::]:64738
<W>2014-04-04 19:11:33.782 1 => Generating new server certificate.
<W>2014-04-04 19:11:34.141 1 => Announcing server via bonjour
<W>2014-04-04 19:11:34.208 1 => Not registering server as public
<W>2014-04-04 19:11:34.208 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 19:12:42.522 Caught SIGTERM, exiting
<W>2014-04-04 19:12:42.522 Killing running servers
<W>2014-04-04 19:12:42.588 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 19:12:42.655 1 => Removed Ice Authenticator 
<W>2014-04-04 19:12:42.713 1 => Stopped announcing server via bonjour
<W>2014-04-04 19:12:42.780 1 => Stopped
<W>2014-04-04 19:12:42.780 Shutting down
<W>2014-04-04 19:12:42.781 MurmurIce: Shutdown complete
<W>2014-04-04 19:12:42.824 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:12:42.824 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 19:12:42.895 DBus registration succeeded
<W>2014-04-04 19:12:42.896 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 19:12:42.924 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 19:12:43.005 1 => Server listening on [::]:64738
<W>2014-04-04 19:12:43.064 1 => Announcing server via bonjour
<W>2014-04-04 19:12:43.122 1 => Not registering server as public
<W>2014-04-04 19:12:43.122 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<W>2014-04-04 19:12:52.055 1 => <1:(-1)> New connection: [fe80::7429:2596:7c0:9d2c]:62689
<W>2014-04-04 19:12:52.147 1 => <1:(-1)> Connection closed: The remote host closed the connection [1]
<W>2014-04-04 19:12:53.907 1 => <2:(-1)> New connection: [fe80::7429:2596:7c0:9d2c]:62690
<W>2014-04-04 19:12:53.982 1 => <2:(-1)> Client version 1.2.4 (Win: 1.2.4)
<W>2014-04-04 19:12:54.033 1 => <2:Superuser(-1)> Rejected connection from [fe80::7429:2596:7c0:9d2c]:62690: Wrong certificate or password for existing user
<W>2014-04-04 19:12:54.083 1 => <2:Superuser(-1)> Connection closed:  [-1]
<W>2014-04-04 19:12:56.924 1 => <3:(-1)> New connection: [fe80::7429:2596:7c0:9d2c]:62691
<W>2014-04-04 19:12:57.000 1 => <3:(-1)> Client version 1.2.4 (Win: 1.2.4)
<W>2014-04-04 19:12:57.050 1 => Starting voice thread
<W>2014-04-04 19:12:57.100 1 => CELT codec switch ffffffff80000010 0 (prefer ffffffff80000010) (Opus 1)
<W>2014-04-04 19:12:57.209 1 => <3:SuperUser(0)> Authenticated
<W>2014-04-04 19:13:00.775 1 => <3:SuperUser(0)> Connection closed: The remote host closed the connection [1]
<W>2014-04-04 19:13:00.825 1 => Ending voice thread
<C>2014-04-04 19:13:14.384 Caught SIGTERM, exiting
<W>2014-04-04 19:13:14.384 Killing running servers
<W>2014-04-04 19:13:14.705 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 19:13:14.905 1 => Removed Ice Authenticator 
<F>2014-04-04 19:13:14.906 Lost connection to SQL Database: Reconnect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect
<W>2014-04-04 19:14:01.173 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:14:01.215 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<F>2014-04-04 19:14:04.511 ServerDB: Failed initialization: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect
<W>2014-04-04 19:26:46.996 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:26:46.996 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 19:26:47.096 DBus registration succeeded
<W>2014-04-04 19:26:47.118 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 19:26:47.815 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 19:26:47.897 1 => Server listening on [::]:64738
<W>2014-04-04 19:26:47.964 1 => Announcing server via bonjour
<W>2014-04-04 19:26:48.031 1 => Not registering server as public
<W>2014-04-04 19:26:48.031 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 19:26:55.692 Caught SIGTERM, exiting
<W>2014-04-04 19:26:55.692 Killing running servers
<W>2014-04-04 19:26:55.764 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 19:26:55.831 1 => Removed Ice Authenticator 
<W>2014-04-04 19:26:55.898 1 => Stopped announcing server via bonjour
<W>2014-04-04 19:26:55.965 1 => Stopped
<W>2014-04-04 19:26:55.965 Shutting down
<W>2014-04-04 19:26:55.991 MurmurIce: Shutdown complete
<W>2014-04-04 19:26:56.035 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:26:56.035 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 19:26:56.106 DBus registration succeeded
<W>2014-04-04 19:26:56.108 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 19:26:56.135 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 19:26:56.198 1 => Server listening on [::]:64738
<W>2014-04-04 19:26:56.257 1 => Announcing server via bonjour
<W>2014-04-04 19:26:56.315 1 => Not registering server as public
<W>2014-04-04 19:26:56.315 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 19:27:21.309 Caught SIGTERM, exiting
<W>2014-04-04 19:27:21.309 Killing running servers
<W>2014-04-04 19:27:21.602 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 19:27:21.786 1 => Removed Ice Authenticator 
<W>2014-04-04 19:27:21.899 1 => Stopped announcing server via bonjour
<W>2014-04-04 19:27:22.011 1 => Stopped
<W>2014-04-04 19:27:22.011 Shutting down
<W>2014-04-04 19:27:22.012 MurmurIce: Shutdown complete
<W>2014-04-04 19:28:06.347 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 19:28:06.404 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<F>2014-04-04 19:28:07.634 ServerDB: Failed initialization: Can't connect to MySQL server on '127.0.0.1' (111) QMYSQL: Unable to connect
<W>2014-04-04 20:03:43.799 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 20:03:43.800 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 20:03:43.899 DBus registration succeeded
<W>2014-04-04 20:03:43.921 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 20:03:44.585 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 20:03:44.688 1 => Server listening on [::]:64738
<W>2014-04-04 20:03:44.780 1 => Announcing server via bonjour
<W>2014-04-04 20:03:44.872 1 => Not registering server as public
<W>2014-04-04 20:03:44.872 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 20:03:52.701 Caught SIGTERM, exiting
<W>2014-04-04 20:03:52.701 Killing running servers
<W>2014-04-04 20:03:52.797 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 20:03:52.880 1 => Removed Ice Authenticator 
<W>2014-04-04 20:03:52.964 1 => Stopped announcing server via bonjour
<W>2014-04-04 20:03:53.049 1 => Stopped
<W>2014-04-04 20:03:53.049 Shutting down
<W>2014-04-04 20:03:53.069 MurmurIce: Shutdown complete
<W>2014-04-04 20:03:53.103 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 20:03:53.104 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<W>2014-04-04 20:03:53.175 DBus registration succeeded
<W>2014-04-04 20:03:53.177 MurmurIce: Endpoint "tcp -h 127.0.0.1 -p 6502" running
<W>2014-04-04 20:03:53.205 Murmur 1.2.4 (1.2.3-349-g315b5f5-2.2+deb7u1) running on X11: Debian GNU/Linux 7.4 (wheezy): Booting servers
<W>2014-04-04 20:03:53.349 1 => Server listening on [::]:64738
<W>2014-04-04 20:03:53.491 1 => Announcing server via bonjour
<W>2014-04-04 20:03:53.633 1 => Not registering server as public
<W>2014-04-04 20:03:53.633 Object::connect: No such slot MurmurDBus::userTextMessage(const User *, const TextMessage &)
<C>2014-04-04 20:04:13.525 Caught SIGTERM, exiting
<W>2014-04-04 20:04:13.525 Killing running servers
<W>2014-04-04 20:04:13.837 1 => Removed all Ice ServerCallbacks
<W>2014-04-04 20:04:14.039 1 => Removed Ice Authenticator 
<F>2014-04-04 20:04:14.040 Lost connection to SQL Database: Reconnect: Can't connect to MySQL server on '127.0.0.1' (111) QMYSQL: Unable to connect
<W>2014-04-04 20:05:01.178 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-04 20:05:01.218 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<F>2014-04-04 20:05:03.347 ServerDB: Failed initialization: Can't connect to MySQL server on '127.0.0.1' (111) QMYSQL: Unable to connect
Не пойму куда растут ноги этой записи

Код: Выделить всё

ServerDB: Failed initialization: Can't connect to MySQL server on '127.0.0.1' (111) QMYSQL: Unable to connect
Вот настройки mumble-server.ini

Код: Выделить всё

# Path to database. If blank, will search for
# murmur.sqlite in default locations or create it if not found.
database=mumble

# If you wish to use something other than SQLite, you'll need to set the name
# of the database above, and also uncomment the below.
# Sticking with SQLite is strongly recommended, as it's the most well tested
# and by far the fastest solution.
#
dbDriver=QMYSQL
dbUsername=mumble
dbPassword=15623846
dbHost=127.0.0.1
dbPort=3306
dbPrefix=murmur_
dbOpts=

# Murmur defaults to not using D-Bus. If you wish to use dbus, which is one of the
# RPC methods available in murmur, please specify so here.
#
dbus=system

# Alternate service name. Only use if you are running distinct
# murmurd processes connected to the same D-Bus daemon.
#dbusservice=net.sourceforge.mumble.murmur

# If you want to use ZeroC Ice to communicate with Murmur, you need
# to specify the endpoint to use. Since there is no authentication
# with ICE, you should only use it if you trust all the users who have
# shell access to your machine.
# Please see the ICE documentation on how to specify endpoints.
ice="tcp -h 127.0.0.1 -p 6502"

# Ice primarily uses local sockets. This means anyone who has a
# user account on your machine can connect to the Ice services.
# You can set a plaintext "secret" on the Ice connection, and
# any script attempting to access must then have this secret
# (as context with name "secret").
# Access is split in read (look only) and write (modify) 
# operations. Write access always includes read access,
# unless read is explicitly denied (see note below).
#
# Note that if this is uncommented and with empty content,
# access will be denied.

#icesecretread=
icesecretwrite=

# How many login attempts do we tolerate from one IP
# inside a given timeframe before we ban the connection?
# Note that this is global (shared between all virtual servers), and that
# it counts both successfull and unsuccessfull connection attempts.
# Set either Attempts or Timeframe to 0 to disable.
#autobanAttempts = 10
#autobanTimeframe = 120
#autobanTime = 300

# Murmur default to logging to murmur.log. If you leave this blank,
# murmur will log to the console (linux) or through message boxes (win32).
logfile=/var/log/mumble-server/mumble-server.log

# If set, murmur will write its process ID to this file.
pidfile=/var/run/mumble-server/mumble-server.pid

# The below will be used as defaults for new configured servers.
# If you're just running one server (the default), it's easier to
# configure it here than through D-Bus or Ice.
#
# Welcome message sent to clients when they connect
welcometext="<br />Welcome to this server running <b>Murmur</b>.<br />Enjoy your stay!<br />"

# Port to bind TCP and UDP sockets to
port=64738

# Specific IP or hostname to bind to.
# If this is left blank (default), murmur will bind to all available addresses.
#host=

# Password to join server
serverpassword=

# Maximum bandwidth (in bits per second) clients are allowed
# to send speech at.
bandwidth=72000

# Maximum number of concurrent clients allowed.
users=100

# Amount of users with Opus support needed to force Opus usage, in percent.
# 0 = Always enable Opus, 100 = enable Opus if it's supported by all clients.
#opusthreshold=100

# Regular expression used to validate channel names
# (note that you have to escape backslashes with \ )
#channelname=[ \\-=\\w\\#\\[\\]\\{\\}\\(\\)\\@\\|]+

# Regular expression used to validate user names
# (note that you have to escape backslashes with \ )
#username=[-=\\w\\[\\]\\{\\}\\(\\)\\@\\|\\.]+

# Maximum length of text messages in characters. 0 for no limit.
#textmessagelength=5000

# Maximum length of text messages in characters, with image data. 0 for no limit.
#imagemessagelength=131072

# Allow clients to use HTML in messages, user comments and channel descriptions?
#allowhtml=true

# Murmur retains the per-server log entries in an internal database which
# allows it to be accessed over D-Bus/ICE.
# How many days should such entries be kept?
# Set to 0 to keep forever, or -1 to disable logging to the DB
#logdays=31

# To enable public server registration, the serverpassword must be blank, and
# this must all be filled out.
# The password here is used to create a registry for the server name; subsequent
# updates will need the same password. Don't lose your password.
# The URL is your own website, and only set the registerHostname for static IP
# addresses.
# Only uncomment the 'registerName' parameter if you wish to give your "Root" channel a custom name.
#
#registerName=Mumble Server
#registerPassword=secret
#registerUrl=https://wiki.mumble.info/wiki/
#registerHostname=

# To enable bonjour service discovery uncomment the following line.
# To change the name announced by bonjour adjust the registerName variable.
# See http://developer.apple.com/networking/bonjour/index.html for more information
# about bonjour.
#bonjour=True

# If you have a proper SSL certificate, you can provide the filenames here.
# Otherwise, Murmur will create it's own certificate automatically.
#sslCert=
#sslKey=

# If murmur is started as root, which user should it switch to?
# This option is ignored if murmur isn't started with root privileges.
uname=speak

# If this options is enabled, only clients which have a certificate are allowed
# to connect.
#certrequired=False

# If enabled, clients are sent information about the servers version and operating
# system.
#sendversion=True

# You can configure any of the configuration options for Ice here. We recommend
# leave the defaults as they are.
# Please note that this section has to be last in the configuration file.
#
[Ice]
Ice.Warn.UnknownProperties=1
Ice.MessageSizeMax=65536
Заранее благодарю..

B0nuse
Site Admin
Сообщения: 1588
Зарегистрирован: 27 июл 2009, 08:58
Благодарил (а): 40 раз
Поблагодарили: 363 раза
Контактная информация:

Re: mysqld.sock' (2) QMYSQL: Unable to connect

Сообщение B0nuse »

http://www.mysql.ru/docs/man/Can_not_co ... erver.html
Сокет где хранится?
В студию, пожалуйста

Код: Выделить всё

cat /etc/my.cnf
Скрытый текст. Вы не состоите в группах, которым доступен этот текст
Мы в Telegramm https://t.me/mumbleru
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news :rtfm:

Изображение <--- Хочешь себе такой? Читай тут

ApPosum
Сообщения: 2
Зарегистрирован: 04 дек 2012, 00:06

Re: mysqld.sock' (2) QMYSQL: Unable to connect

Сообщение ApPosum »

Вот my.cnf

Код: Выделить всё

#
# 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
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
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
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# 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/

После переноса под пользователя root при подключении к базе ругается вот так

Код: Выделить всё

Lost connection to SQL Database: Reconnect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect
<W>2014-04-05 00:42:20.335 Initializing settings from /etc/mumble-server.ini (basepath /etc)
<W>2014-04-05 00:42:20.368 OpenSSL: OpenSSL 1.0.1e 11 Feb 2013
<F>2014-04-05 00:42:22.139 ServerDB: Failed initialization: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QMYSQL: Unable to connect

B0nuse
Site Admin
Сообщения: 1588
Зарегистрирован: 27 июл 2009, 08:58
Благодарил (а): 40 раз
Поблагодарили: 363 раза
Контактная информация:

Re: mysqld.sock' (2) QMYSQL: Unable to connect

Сообщение B0nuse »

Какой вывод у команды

Код: Выделить всё

mysql -h 127.0.0.1 -u mumble -p15623846 mumble
и

Код: Выделить всё

telnet 127.0.0.1 3306
Мы в Telegramm https://t.me/mumbleru
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news :rtfm:

Изображение <--- Хочешь себе такой? Читай тут

Ответить