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

[Jonathan Creasy]

Can you post your configuration and current table contents now that it 
is working? I had some trouble with this also!

Thanks!

-Jonathan

Miodrag Radulovic wrote:
> 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
>
>
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>