[Spce-user] "Internal error, please try again later."

[Mario Contreras]

El 20/02/2012 19:44, Daniel Tiefnig escribió:
> On 02/20/2012 07:01 PM, Mario Contreras wrote:
>> It happened again, and when I restarted sems the problem has been
>> solved. Here it's the sems' log.
> Hmm, wondering why DBRegAgent says "ERROR: MySQL++ error: Can't connect
> to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" at
> 18:40:15. Is it able to connect in general? Is there any data in the
> kamailio.sems_registrations table? Is MySQL running? I guess it is, or
> you would have much more problems. ;o) Does /var/run/mysqld/mysqld.sock
> exist, and is it a UNIX socket?
>
> Is MySQL showing any unusual behaviour? Are there e.g. a lot of active
> connections in "show processlist;"? Was it restarted recently? Any crashes?
>
> br,
> daniel
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
Yes, mysql has always worked. I can't tell you if 
/var/run/mysqld/mysqld.sock existed since it's working correctly now. 
This is the content of kamailio.sems_registration:

+---------------+---------------------+---------------------+---------------------+-----------+-------------+-------------------------------------------------+
| subscriber_id | registration_status | last_registration   | 
expiry              | last_code | last_reason | 
contacts                                        |
+---------------+---------------------+---------------------+---------------------+-----------+-------------+-------------------------------------------------+
|             3 |                   5 | 2012-02-15 16:35:41 | 2012-02-15 
22:35:41 |       200 | OK          | 
<sip:1111111 at ........:5060>;expires=21600    |
|             6 |                   5 | 2012-02-20 16:47:56 | 2012-02-20 
22:47:56 |       100 | Trying      
|                                                 |
|             7 |                   2 | 2012-02-20 18:58:11 | 2012-02-21 
00:58:11 |       200 | OK          | 
<sip:1111111 at ........:5060>;expires=21600      |
+---------------+---------------------+---------------------+---------------------+-----------+-------------+-------------------------------------------------+

I presume it's incorrect since I have only one subscriber. I guess the 
ids 3 and 6 are subscribers I created when I got the errors but I 
already deleted. It's ok than the column 'contacts' show the ip of my 
domain instead of my domain?