mysqld.sock' (2) QMYSQL: Unable to connect
Правила форума
СНАЧАЛА ПОЛЬЗУЙТЕСЬ ПОИСКОМ!!!
При обращении просим Вас сразу указывать:
Вашу ОСь? Видео? Звук? DirectX? Логи Мамбл, Мурмур?
Это поможет быстрей и более точно ответить на Ваши вопросы.
СНАЧАЛА ПОЛЬЗУЙТЕСЬ ПОИСКОМ!!!
При обращении просим Вас сразу указывать:
Вашу ОСь? Видео? Звук? DirectX? Логи Мамбл, Мурмур?
Это поможет быстрей и более точно ответить на Ваши вопросы.
mysqld.sock' (2) QMYSQL: Unable to connect
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
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
-
- Site Admin
- Сообщения: 1588
- Зарегистрирован: 27 июл 2009, 08:58
- Благодарил (а): 40 раз
- Поблагодарили: 363 раза
- Контактная информация:
Re: mysqld.sock' (2) QMYSQL: Unable to connect
Похоже, что у Вас падает MySQL база. С ней и разбирайтесь.
Или перейдите на использование SQLite.
Или перейдите на использование SQLite.
Мы в Telegramm https://t.me/mumbleru
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news
<--- Хочешь себе такой? Читай тут
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news
<--- Хочешь себе такой? Читай тут
Re: Упарвление MurMur
Огромная просьба помочь, с данной проблемой:
Вопрос.
У меня приложение ругается при попытке подцепиться к базе: 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)
Вопрос.
У меня приложение ругается при попытке подцепиться к базе: 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)
Re: Упарвление MurMur
Эта ошибка решается изменением конфига.
Вместо localhost нужно указать 127.0.0.1 в настройках расположения базы.
Вместо localhost нужно указать 127.0.0.1 в настройках расположения базы.
Re: murmur & MySQL
Всем привет!
Появилась новая проблема. Есть сервер 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
Я связываю это с тем что на момент попытки подключения голосового сервера к БД сервер БД еще не успевает запуститься. Что тогда нужно сделать чтобы правильно настроить запуск. Спасибо за ответы.
Появилась новая проблема. Есть сервер 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
Я связываю это с тем что на момент попытки подключения голосового сервера к БД сервер БД еще не успевает запуститься. Что тогда нужно сделать чтобы правильно настроить запуск. Спасибо за ответы.
Не подключается к БД
Помогите пожалуйста ребят.. Поднял сервер на debian... На нем поднял web сервер с ispmanager, она соответсвенно подняла под себя и mysql и php и так далее...Создал нового пользователя добавил его в группу sudo и под ним поставил пакет mumble-server...Решил значит привязать это всё не к родной БД а к mysql...Всё в бил всё в порядке,сервер murmur запустился, но после рестарта сервера murmur не запускается....Вот лог mumble-server.log
Не пойму куда растут ноги этой записи
Вот настройки mumble-server.ini
Заранее благодарю..
Код: Выделить всё
<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
Код: Выделить всё
# 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
-
- Site Admin
- Сообщения: 1588
- Зарегистрирован: 27 июл 2009, 08:58
- Благодарил (а): 40 раз
- Поблагодарили: 363 раза
- Контактная информация:
Re: mysqld.sock' (2) QMYSQL: Unable to connect
http://www.mysql.ru/docs/man/Can_not_co ... erver.html
Сокет где хранится?
В студию, пожалуйста
Сокет где хранится?
В студию, пожалуйста
Код: Выделить всё
cat /etc/my.cnf
Скрытый текст. Вы не состоите в группах, которым доступен этот текст
Мы в Telegramm https://t.me/mumbleru
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news
<--- Хочешь себе такой? Читай тут
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news
<--- Хочешь себе такой? Читай тут
Re: mysqld.sock' (2) QMYSQL: Unable to connect
Вот my.cnf
После переноса под пользователя root при подключении к базе ругается вот так
Код: Выделить всё
#
# 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
-
- Site Admin
- Сообщения: 1588
- Зарегистрирован: 27 июл 2009, 08:58
- Благодарил (а): 40 раз
- Поблагодарили: 363 раза
- Контактная информация:
Re: mysqld.sock' (2) QMYSQL: Unable to connect
Какой вывод у команды
и
Код: Выделить всё
mysql -h 127.0.0.1 -u mumble -p15623846 mumble
Код: Выделить всё
telnet 127.0.0.1 3306
Мы в Telegramm https://t.me/mumbleru
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news
<--- Хочешь себе такой? Читай тут
Пожалуйста, при персональном обращении сразу формулируйте его цель. Спасибо.
Подпишитесь на Новости форума feed/news
<--- Хочешь себе такой? Читай тут