Ok, simple core install, to other host, Debian x64 squeeze from this: http://cdimage.debian.org/debian-cd/6.0.5/amd64/iso-cd/debian-6.0.5-amd64-netinst.iso
#aptitude install mysql-server mc
Create file and change:
root@r59vsipgw:/etc/apt/sources.list.d# cat kamailio.list
deb http://deb.kamailio.org/kamailio squeeze main
deb-src http://deb.kamailio.org/kamailio squeeze main
root@r59vsipgw:/etc/apt/sources.list.d#
 
and install official kamailo packages: kamailio, kamailio-carrierroute-modules, kamailio-mysql-modules, kamailio-utils-modules, kamailio-xml-modules, kamailio-xmlrpc-modules 
Create mysql openser dadabase, with all tables, and using test2.sql to insert lcr data.
# kamdbctl create
# mysql openser < test2.sql
# mysqladmin flush-tables
 
Change default kamailio.cfg:
#!define WITH_MYSQL
...
loadmodule "avpops.so"
loadmodule "lcr.so"
...
modparam("lcr", "db_url",DBURL)
modparam("lcr", "gw_uri_avp", "$avp(i:709)")
modparam("lcr", "ruri_user_avp", "$avp(i:500)")
...
and if restart kamailio, again skipping from syslog:
skipping disabled <gw/rule> = <1/5>
skipping disabled <gw/rule> = <3/5>
and other :-(
 
Please help me!
PS Attached my testted config
 
2012/6/21 Alexey Mechanoshin <ales999@gmail.com>
I'm confused... I do not know what is wrong i my system.
Ok, full info and full config (change my external IP in bind only).
 
root@r59vredfs:~# echo $LANG
ru_RU.UTF-8
root@r59vredfs:~# LANG=C ; aptitude show kamailio
Package: kamailio                       
State: installed
Automatically installed: no
Version: 3.3.0+squeeze1
Priority: extra
Section: comm
Maintainer: Jon Bonilla <manwe@aholab.ehu.es>
...
root@r59vredfs:~# LANG=C ; aptitude show mysql-server
Package: mysql-server                   
State: installed
Automatically installed: no
Version: 5.1.63-0+squeeze1
Priority: optional
...
 
root@r59vredfs:~# cat /etc/init.d/kamailio | grep DAEMON
DAEMON=/usr/sbin/kamailio
...
root@r59vredfs:~# /usr/sbin/kamailio -V
version: kamailio 3.3.0 (x86_64/linux)
flags: STATS: Off, USE_IPV6, USE_TCP, USE_TLS, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 4MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: unknown
compiled on 22:18:19 Jun 18 2012 with gcc 4.4.5
root@r59vredfs:~# kamctl mi version
Server:: kamailio (3.3.0 (x86_64/linux))
Build:: mi_core.c compiled on 22:38:59 Jun 18 2012 with gcc 4.4.5
Flags:: STATS: Off, USE_IPV6, USE_TCP, USE_TLS, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES
GIT:: unknown
root@r59vredfs:~#
2012/6/21 Juha Heinanen <jh@tutpro.com>
Alexey Mechanoshin writes:

> #mqldump openser lcr_gw lcr_rule lcr_rule_target > test2.sql
> (change only external IP-s)

i tried with test2.sql records and still i do not get any skipping
messages to syslog.  check that you are using kamailio 3.3.

-- juha

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



--
"В связи с отсутствием интереса общественности, конец света отменяется" (с) ?
С Уважением, Механошин Алексей



--
"В связи с отсутствием интереса общественности, конец света отменяется" (с) ?
С Уважением, Механошин Алексей