Thirdlane.com logo

No database socket found (and unable to detect a suitable path)

Posted by Ulsa on Fri, 01/24/2014
Forums
Thirdlane platform General Questions

Dear All,

We are experiencing issues with Asterisk 1.8.16.0 while users on calls asterisk database is getting the warning given below. Because of this ASTERISK is not working at all.

Can anyone please let me know what should we do to fix this issues.

Appreciate your valuable time.!!!

[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database user

found, using 'asterisk' as default.
[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database

password found, using 'asterisk' as default.
[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database host

found, using localhost via socket.
[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database name

found, using 'asterisk' as default.
[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database port

found, using 3306 as default.
[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database socket

found, using '/var/lib/mysql/mysql.sock' as default.
[2014-01-24 12:39:02] WARNING[2024] res_config_mysql.c: MySQL RealTime: No database socket

found (and unable to detect a suitable path).

Submitted by thirdlane on Wed, 01/29/2014 Permalink

Is this a new issue? Which Thirdlane product and what version are you running? How and when was it installed? Have you checked your res_config_mysql.conf in /etc/asterisk

It should look something like:

[pbxconf]
dbhost=localhost
dbname=pbxconf
dbuser=youruser
dbpass=yourpassword
dbport=3306
dbsock=/var/lib/mysql/mysql.sock
requirements=warn
[queuelog]
dbhost=localhost
dbname=pbxlogs
dbuser=youruser
dbpass=yourpassword
dbport=3306
dbsock=/var/lib/mysql/mysql.sock
requirements=warn

Were there any recent updates, reboots, etc? Is mysqld running? Did you change anything in the database configuration?

Submitted by Ulsa on Sat, 03/08/2014 Permalink

Dear Alex,

Here is the Asterisk version 1.8.16.0.
PBX Manager 7.0.1.120

We had issues with PBX portal last time we had given access to you to look into this,
Then that time you have updated our asterisk version and PBX manager,

While running asterisk in office hours suddenly we got previous mentioned errors,

I do not know why our asterisk servers are frequently all of sudden hangs up.

Our asterisk server got hanged completely to get rid out of it,

We had to reboot the servers,

Thanks
Ulsa
VOIPOFFICE LLC