[Spce-user] 500 i'm terribly sorry , server error ocurred(6/SL)

[Pablo Muñoz-Cobo]

Hello Andrew:

Thanks for your reply  this is the output you requested:

mysql> select * from location;
+----+-----------+--------------+-----------------------------------------------+-----------------------+-----------------------------------------------------------------------------------+---------------------+-------+------------------+------------+---------------------+-------+--------+-----------------+--------------------+---------+----------------------+--------+----------+
| id | username  | domain       | 
contact                                       | received              | 
path | expires             | q     | callid           | cseq       | 
last_modified       | flags | cflags | user_agent      | 
socket             | methods | ruid                 | reg_id | instance |
+----+-----------+--------------+-----------------------------------------------+-----------------------+-----------------------------------------------------------------------------------+---------------------+-------+------------------+------------+---------------------+-------+--------+-----------------+--------------------+---------+----------------------+--------+----------+
|  7 | 911123124 | 192.168.3.56 | 
sip:911123124 at 192.168.3.56:5060;transport=udp | sip:192.168.3.24:5060 | 
<sip:lb at 127.0.0.1;lr;received=sip:192.168.3.24:5060;socket=sip:192.168.3.56:5060> 
| 2014-03-04 16:21:35 | -1.00 | bd7ced49050283a8 | 1804289648 | 
2014-03-04 15:21:35 |     0 |    192 | ZNID (S3.0.522) | 
udp:127.0.0.1:5062 |    7839 | uloc-530f583e-38df-1 |      0 | NULL     |
| 10 | 911123123 | 192.168.3.56 | 
sip:911123123 at 192.168.3.56:5060;transport=udp | sip:192.168.3.25:5060 | 
<sip:lb at 127.0.0.1;lr;received=sip:192.168.3.25:5060;socket=sip:192.168.3.56:5060> 
| 2014-03-04 16:17:58 | -1.00 | 573e7c573f1a50fb |  549349969 | 
2014-03-04 15:17:58 |     0 |    192 | ZNID (S3.0.533) | 
udp:127.0.0.1:5062 |    7839 | uloc-530f583e-38df-2 |      0 | NULL     |
+----+-----------+--------------+-----------------------------------------------+-----------------------+-----------------------------------------------------------------------------------+---------------------+-------+------------------+------------+---------------------+-------+--------+-----------------+--------------------+---------+----------------------+--------+----------+
2 rows in set (0.00 sec)

BR,
Pablo


El 04/03/14 14:41, Andrew Pogrebennyk escribió:
> E.g. select * from location where username='your_gpon_user_XX'\G