9 Feb
2012
9 Feb
'12
1:35 p.m.
I am a new user and am trying to configure kamailio to use SQLITE
instead of MYSQL. I see that SQLITE option is rather new and maybe not
as documented as MYSQL.
I am running on fedora 14 and have installed MYSQL3 from rpms. Kamailio
I built from sources because I need the SQLITE support.
What kamailio.cfg and kamctlrc parameters do I need to change to do
this?
I have already set these in kamctlrc:
...
## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, DBTEXT, or SQLITE
# by default none is loaded
#
# If you want to setup a database with kamdbctl, you must at least
specify
# this parameter
DBENGINE=SQLITE
## database host
DBHOST=localhost
## database name (for ORACLE this is TNS name)
# DBNAME=openser
...
and ran:
kamdbctl create openser
and
kamctl add user1 password1
successfully.
Now, it appears that I need to change kamailio.cfg for SQLITE. Can I
simply edit this file substituting SQLITE for MYSQL and loading the
SQLITE module?
How about this part:
...
####### Defined Values #########
# *** Value defines - IDs used later in config
#!ifdef WITH_MYSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!define DBURL "mysql://openser:openserrw@localhost/openser"
#!endif
...
Will this URL work with SQLITE?
Thanks in advance,
Perazim
9 Feb
9 Feb
1:45 p.m.
Hi,
On Thu, 09 Feb 2012 13:35:00 +0200 Perazim <perazim(a)inbox.lt> wrote:
I am a new user and am trying to configure kamailio to
use SQLITE
instead of MYSQL. I see that SQLITE option is rather new and maybe not
as documented as MYSQL.
I am running on fedora 14 and have installed MYSQL3 from rpms.
Kamailio I built from sources because I need the SQLITE support.
What kamailio.cfg and kamctlrc parameters do I need to change to do
this?
I have already set these in kamctlrc:
...
## database host
DBHOST=localhost
## database name (for ORACLE this is TNS name)
# DBNAME=openser
These are ignored, as sqlite db is a local file.
To set the file, use:
DB_PATH="/path/to/db.sqlite"
Now, it appears that I need to change kamailio.cfg for
SQLITE. Can I
simply edit this file substituting SQLITE for MYSQL and loading the
SQLITE module?
How about this part:
...
####### Defined Values #########
# *** Value defines - IDs used later in config
#!ifdef WITH_MYSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!define DBURL "mysql://openser:openserrw@localhost/openser"
#!endif
...
Will this URL work with SQLITE?
The sqlite URL is like:
sqlite:////path/to/db.sqlite
Basically, it's your regular URL format, but the hostname needs to be
left empty, and you include absolute path for the database file.
Permissions managements purely by setting proper file access
rights.
- Timo
3:06 p.m.
I got a little further but still not working. Here are changes I have
made to default:
kamailio.cfg:
...
# *** To enable mysql:
#!define WITH_MYSQL
#
# *** To enable authentication execute:
# - enable mysql
#!define WITH_AUTH
# - add users using 'kamctl'
...
...
####### Defined Values #########
# *** Value defines - IDs used later in config
#!ifdef WITH_MYSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!define DBURL "sqlite:////usr/local/etc/kamailio/db.sqlite"
#!endif
...
...
####### Modules Section ########
# set paths to location of modules (to sources or installation folders)
#!ifdef WITH_SRCPATH
mpath="modules_k:modules"
#!else
mpath="/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/"
#!endif
#!ifdef WITH_MYSQL
loadmodule "db_sqlite.so"
#!endif
...
and kamctlrc:
...
## your SIP domain
SIP_DOMAIN=perazim.net
## chrooted directory
# $CHROOT_DIR="/path/to/chrooted/directory"
## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, DBTEXT, or SQLITE
# by default none is loaded
#
# If you want to setup a database with kamdbctl, you must at least
specify
# this parameter
DBENGINE=SQLITE
## database host
# DBHOST=localhost
...
Still looks like kamailio is looking for mysql:
[root@travelmate yossi]# kamctl db show user
psql: could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
[root@travelmate yossi]#
I checked db.sqlite permissions and this should not be a problem.
Tried it with firewall disabled just in case.
What did I miss?
Thanks,
Perazim
13 Feb
13 Feb
5:37 p.m.
Hello,
On 2/9/12 2:06 PM, Perazim wrote:
I got a little further but still not working. Here are
changes I have
made to default:
kamailio.cfg:
...
# *** To enable mysql:
#!define WITH_MYSQL
#
# *** To enable authentication execute:
# - enable mysql
#!define WITH_AUTH
# - add users using 'kamctl'
...
...
####### Defined Values #########
# *** Value defines - IDs used later in config
#!ifdef WITH_MYSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!define DBURL "sqlite:////usr/local/etc/kamailio/db.sqlite"
#!endif
...
...
####### Modules Section ########
# set paths to location of modules (to sources or installation folders)
#!ifdef WITH_SRCPATH
mpath="modules_k:modules"
#!else
mpath="/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/"
#!endif
#!ifdef WITH_MYSQL
loadmodule "db_sqlite.so"
#!endif
...
and kamctlrc:
...
## your SIP domain
SIP_DOMAIN=perazim.net
## chrooted directory
# $CHROOT_DIR="/path/to/chrooted/directory"
## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, DBTEXT, or SQLITE
# by default none is loaded
#
# If you want to setup a database with kamdbctl, you must at least
specify
# this parameter
DBENGINE=SQLITE
## database host
# DBHOST=localhost
...
Still looks like kamailio is looking for mysql:
[root@travelmate yossi]# kamctl db show user
psql: could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
[root@travelmate yossi]#
I checked db.sqlite permissions and this should not be a problem.
Tried it with firewall disabled just in case.
What did I miss?
psql is for postgres, are you sure you set sqlite as db driver for
kamctl (in kamctlrc)?
Cheers,
Daniel
--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda
4667
days inactive
4671
days old
3 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Perazim -
Timo Teras