[OpenSER-Users] Unable to configure LCR in openser - problem with next_gw()?

[Miodrag Radulovic]

YES - it works! Thanks a million Sergio, you saved my day!
 
So, there is a problem with wildcard syntax in from_uri column.... but
running mysqld_safe did not revealed any bad sql query:
 
/usr/local/libexec/mysqld, Version: 5.0.41-log (FreeBSD port:
mysql-server-5.0.41). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
070722  0:14:40       1 Connect     openser at localhost on openser
                      1 Query       select @@version_comment limit 1
                      1 Query       delete from lcr where prefix='9' AND
from_uri='lvs[0-9]' AND grp_id=1 AND priority=1
                      1 Quit       
070722  0:14:54       2 Connect     openser at localhost on openser
                      2 Query       select @@version_comment limit 1
                      2 Query       insert into lcr (prefix, from_uri,
grp_id, priority) VALUES ('9', '', 1, 1)
                      2 Quit       
070722  0:15:00       3 Connect     openserro at localhost on openser
                      3 Query       select @@version_comment limit 1
                      3 Query       select * FROM lcr ORDER BY prefix
                      3 Quit       
                      4 Connect     openserro at localhost on openser
                      4 Query       select @@version_comment limit 1
                      4 Query       select * FROM gw_grp ORDER BY grp_id
                      4 Quit       
                      5 Connect     openserro at localhost on openser
                      5 Query       select @@version_comment limit 1
                      5 Query       select gw_name, ip_addr,port,
uri_scheme, transport,grp_id, strip, prefix FROM gw ORDER BY grp_id
                      5 Quit       
070722  0:15:20       6 Connect     openser at localhost on openser
                      6 Query       select table_version from version where
table_name='domain'
                      6 Query       select domain from domain
                      6 Quit       
                      7 Connect     openser at localhost on openser
                      7 Query       select table_version from version where
table_name='subscriber'
                      7 Quit       
                      8 Connect     openser at localhost on openser
                      8 Query       select table_version from version where
table_name='trusted'
                      8 Query       select src_ip,proto,from_pattern,tag
from trusted
                      8 Quit       
                      9 Connect     openser at localhost on openser
                      9 Query       select table_version from version where
table_name='address'
                      9 Query       select grp,ip_addr,mask,port from
address
                      9 Quit       
                     10 Connect     openser at localhost on openser
                     10 Query       select table_version from version where
table_name='gw'
                     10 Quit       
                     11 Connect     openser at localhost on openser
                     11 Query       select table_version from version where
table_name='lcr'
                     11 Quit       
                     12 Connect     openser at localhost on openser
                     12 Query       select
ip_addr,port,uri_scheme,transport,strip,prefix,grp_id from gw
                     12 Query       select prefix,from_uri,grp_id,priority
from lcr
                     12 Quit       

And then openser stops its startup with following errors in openser log:

Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: new_connection:
Opening MySQL connection: mysql://openser:openserrw@localhost/openser
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: new_connection:
Connection type is Localhost via UNIX socket
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: new_connection:
Protocol version is 10
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: new_connection:
Server version is 5.0.41-log
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: pool_remove: Removing
connection from the pool
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: ERROR:lcr:load_regex:
bad from_uri re 
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: ERROR:
lcr:mod_init(): failed to reload gateways and routes
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: init_mod(): Error
while initializing module lcr
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]:
INFO:mi_fifo:mi_destroy: process hasn't been created -> nothing to kill
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: XLOG: destroy module
...
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG: tm_shutdown :
start
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG:
unlink_timer_lists : emptying DELETE list
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG: tm_shutdown :
emptying hash table
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG: tm_shutdown :
releasing timers
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG: tm_shutdown :
removing semaphores
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG: tm_shutdown :
destroying tmcb lists
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: DEBUG: tm_shutdown :
done
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: shm_mem_destroy
Jul 22 00:15:20 santos /usr/local/sbin/openser[10983]: destroying the shared
memory lock

I'm running openser-1.2.1 with mysql-server-5.0.41 on freebsd 6.2P5.
 
Miodrag