22 Jul
2007
22 Jul
'07
10:44 a.m.
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