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