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@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@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@localhost on openser 3 Query select @@version_comment limit 1 3 Query select * FROM lcr ORDER BY prefix 3 Quit 4 Connect openserro@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@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@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@localhost on openser 7 Query select table_version from version where table_name='subscriber' 7 Quit 8 Connect openser@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@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@localhost on openser 10 Query select table_version from version where table_name='gw' 10 Quit 11 Connect openser@localhost on openser 11 Query select table_version from version where table_name='lcr' 11 Quit 12 Connect openser@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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users