I had the same problem, you need to change a couple of things in the ser.cfg file.

I guess you have already uncommented all the lines that ser.cfg tells you to in order to work with SQL database.

In the main routing logic, you have to add lookup("aliases");

route{

            lookup("aliases");

In the usrloc params, put 1 instead of 2 in the last field:

#modparam("usrloc", "db_mode", 2)
modparam("usrloc","db_mode",1)

This will make the date to be stored in the MySQL tables, though it's a bit slow, since you add an alias with serctl command, wait 15 or 20 seconds until you can see it in your database.

Good luck,

Llanos

 

 

 

>Hi list,

>I'm running ser-0.9.0.
>I've come across a strange behaviour of adding new aliases to user names.
>I add an alias with serctl command, but the alias wont store in the mysql
>table.   If I try it again I get error: <sip:joe@mydomain.com>;q=1;expires=-268
>Once I restart SER I can again add the alias, but with same result,
>it's not saved in the table 'aliases'.
>Have anybody come across this issue?
>
>Thank you,
>Lada
>
>_______________________________________________
>Serusers mailing list
>serusers@lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers