[sr-dev] [tracker] Task opened: Registrar module don't save data to location mysql table. (Attachment added)

[sip-router]

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Mészáros Mihály (bakfitty) 

Attached to Project - sip-router
Summary - Registrar module don't save data to location mysql table.
Task Type - Bug Report
Category - registrar (k)
Status - Assigned
Assigned To - Daniel-Constantin Mierla
Operating System - Linux
Severity - High
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - OS Debian: lenny

The problem is occurs even if i Installed from deb packages from repository or from source

Repository i used:

  deb http://deb.kamailio.org/kamailio30 lenny main
  deb-src http://deb.kamailio.org/kamailio30 lenny main

or compiled from git repository source with dpkg-buildpackage pkg/kamailio/.

  modparam("usrloc", "db_mode",   3)

I probed both way with db_mode,1 and db_mode 3, but without success.
Currently i attached my kamailio.cfg

<code>
hal:/usr/src/kamailio-3.0.2+lenny2/modules_k/registrar# kamctl ul show
database engine 'MYSQL' loaded
Control engine 'FIFO' loaded
entering fifo_cmd ul_dump
Domain:: location table=512 records=1 max_slot=1
	AOR:: misi
		Contact:: sip:misi at 193.6.222.63:6522;rinstance=4b5da8841248277d Q=
			Expires:: 2276
			Callid:: NDA1NGM5MWY1NzhkNTI1NzM2Y2QyZTc4NzkxMWIzNzQ.
			Cseq:: 2
			User-agent:: PortGo v6.0, Build 06122010
			State:: CS_NEW
			Flags:: 0
			Cflag:: 0
			Socket:: udp:195.111.192.7:5060
			Methods:: 5119
FIFO command was:
:ul_dump:openser_receiver_16358
</code>
hal:/usr/src/kamailio-3.0.2+lenny2/modules_k/registrar# mysql openser 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3995
Server version: 5.0.51a-24+lenny4 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from location;
Empty set (0.00 sec)

Any help appreciated.

One or more files have been attached.

More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=79

You are receiving this message because you have requested it from the Flyspray bugtracking system.  If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.