It seems that you do not have "version" table. that table contains
version of each table in your database, this is used for sanity
checking.
You can take a look into ser_mysql.sh and copy the contents of version
table from corresponding sql table.
Jan.
On 20-01-2006 16:08, Yi Zheng wrote:
> Hi,
>
> I have the following authentication related stuff in my ser.cfg file. However ser server failed to start with the following messages logged. I have a directory /root/dbtext/ser to store tables (such as subscriber). What could be wrong? Thanks,
>
> log messages
> --------------------
> Jan 20 13:44:08 my ./ser[4424]: table_version(): Error in db_query
> Jan 20 13:44:08 my ./ser[4424]: authdb_fixup: Error while querying table
> version
> Jan 20 13:44:08 my ./ser[4424]: ERROR: fix_expr : fix_actions error
>
>
>
> My ser.cfg
> ---------------
> loadmodule "/home/ser/presence/ser-0.10.99-dev30-tm-timers-pa-3/lib/ser/modules/dbtext.so"
> loadmodule "/home/ser/presence/ser-0.10.99-dev30-tm-timers-pa-3/lib/ser/modules/auth.so"
> loadmodule "/home/ser/presence/ser-0.10.99-dev30-tm-timers-pa-3/lib/ser/modules/auth_db.so"
>
> # -- auth params --
> # Uncomment if you are using auth module
> #
> modparam("auth_db", "calculate_ha1", yes)
> #
> # If you set "calculate_ha1" parameter to yes (which true in this config),
> # uncomment also the following parameter)
> #
> modparam("auth_db", "password_column", "password")
> # -- rr params --
> # add value to ;lr param to make some broken UAs happy
> modparam("rr", "enable_full_lr", 1)
> modparam("usrloc", "db_mode", 0)
> modparam("pa", "use_db", 0)
> modparam("auth_db", "db_url", "dbtext:///root/dbtext/ser")
>
> /root/dbtext/ser/subscriber
> -------------------------------------
> username(str) password(str) ha1(str) domain(str) ha1b(str)
> suser:supasswd:xxx:iptel.org:xxx
> test:test123::my.cisco.com::
>
> Note: forwarded message attached.
> Date: Fri, 20 Jan 2006 11:36:18 -0800 (PST)
> From: Yi Zheng <yizheng(a)sbcglobal.net>
> Subject: [Serusers] using dbtext module for authentication
> To: serusers(a)lists.iptel.org
>
> Hi,
>
> I don't have enough space for MySql and hence want to try to use a plain text file (dbtext module) for authentication purpose. Just wondering whether it works properly with SER and what are the limitations besides limited space. Thanks,
>
> - ming
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
On 19-01-2006 17:43, Yeung OnTai-q16645 wrote:
> When I use "#serctl add <username> <password> <email>", it does not work
> anymore, because it complains that subscriber table is not found.
serctl (the shell script) will be deprecated.
> Whatever database table(subscriber or other) is being used now, there
> should be a place where I can provision a new client with password.
> Otherwise how can I authenticate it when the client register to SER?
The table is called credentials, there is a command called ser_cred in
sip_router/tools/serctl which can be used to provision the table.
Note that an interface similar to the original serctl is being worked
on, it will be available soon.
> It seems like in ser-0.10.99, clients can just register to ser without
> any provisioning....
No, but the newer SER version has much cleaner data model and the
meaning of tables changed. credentials table maps digest credentials
to users (identified by uid). uri table maps SIP URIs to users, and so
on.
Jan.
Hello,
Sorry for asking such a dumb question but I'm in a kind of a hurry.
How do I declare variables in which I wish to store data I get from
avp_load_radius() ?
How do I assign a value to a variable and then check it up to some other
value?
Basicly my problem comes to avp+radius basic usage.
Best regards, Zoran
Hi,
I am reading to understand the different solutions for NAT travesal. For nathelper+RTP proxy solution, what does the force_rport() function do? Is it rfc3581 compliant? Does it mean that the client needs to understand "received" and "rport" in the Via header? Thanks,
- ming
I would like to know what's the most stable version of SER to use RADIUS,
POSTGRES, LDAP, ENUM, LRC, NATHELPER and ACC modules? And what´s the name
that i should use to get it from the CVS server.
Regards,
Jose Simoes
Yes, On serweb acount tab message store.
I've seen the voicemail plugin code,
and this doesn't write on mysql silo table.
How I do put voicemail on serweb?
Regards
Alejandro.
El sáb, 23-07-2005 a las 11:46 +0200, harry gaillac escribió:
> Hello,
>
> You mean forward to voicemail on account tab ?
>
> harry
> --- Alejandro Mellado <amellado(a)uct.cl> a écrit :
>
> > Hi
> >
> >
> > I'm trying to activate the voicemail in serweb.
> > I've working msilo with IM successfully.
> >
> > Somebody Can help me?
> >
> >
> > Regards
> > Saluda Atte.
> > Alejandro Mellado <amellado(a)uct.cl>.
> > Escuela de Informática
> > Universidad Católica de Temuco
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers(a)lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> >
>
>
>
>
>
>
>
> ___________________________________________________________________________
> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
> Téléchargez cette version sur http://fr.messenger.yahoo.com
Saluda Atte.
Alejandro Mellado <amellado(a)uct.cl>.
Escuela de Informática
Universidad Católica de Temuco
On 20-01-2006 11:36, Yi Zheng wrote:
> Hi,
>
> I don't have enough space for MySql and hence want to try to use a plain text file (dbtext module) for authentication purpose. Just wondering whether it works properly with SER and what are the limitations besides limited space. Thanks,
Not all modules have been tested with dbtext, you will probably have
to try it for yourself.
dbtext is slow, thus it is not suitable for larger setups.
Updates of dbtext files are not realtime, thus you would not see
changes immediately.
Jan.
On 18-01-2006 09:07, Yeung OnTai-q16645 wrote:
> Hi all,
>
> I need to build SER with presence and XCAP. Does anyone know which
> version of SER contain a relatively "stable" version of "pa" and "rls".
> I've tried 0.9.6 and the cvs stable build, but I ran into different
> problems(error in loading modules, compling errors, etc) in making the
> source code.
>
> Can anyone point me to the right direction please?
Try the version from http://ftp.iptel.org/pub/ser/presence
That one should be relatively easy to build. Note that the XCAP server
is not included.
Jan.
>
> Thank you very much!
>
> Regards,
> Dennis
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
It looks like you are trying to call the functions of DB API but do not
have db_func_t defined anywhere in the module. Check, for example, the
sources of auth_db module, look for db_func_t
Jan.
On 17-01-2006 14:47, jvr_78(a)yahoo.com.ar wrote:
> Hi,
> I'm new in this group.
> I have work with ser 0.8.14 and now I need presence module, so actualice the
> ser version to 0.10.99, and now don't work my module.
>
> the error that show is:
>
> #ser
> 0(3981) ERROR: load_module: could not open module
> </usr/local/lib/ser/modules/control.so>: /usr/local/lib/ser/modules/control.so:
> undefined symbol: dbf
> 0(3981) parse error (47,13-14): failed to load module
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (62,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (63,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (66,21-22): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (67,19-20): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (68,19-20): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (69,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (70,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (71,21-22): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (72,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (73,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (74,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (75,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (76,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (77,20-21): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (78,19-20): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (79,19-20): Can't set module parameter
> 0(3981) set_mod_param_regex: No module matching control found
> | 0(3981) parse error (80,20-21): Can't set module parameter
> 0(3981) parse error (130,28-29): unknown command, missing loadmodule?
>
> 0(3981) parse error (134,20-21): unknown command, missing loadmodule?
>
> 0(3981) parse error (150,33-34): unknown command, missing loadmodule?
>
> 0(3981) parse error (159,35-36): unknown command, missing loadmodule?
>
> 0(3981) parse error (161,25-26): unknown command, missing loadmodule?
>
> 0(3981) parse error (169,24-25): unknown command, missing loadmodule?
>
> 0(3981) parse error (184,42-43): unknown command, missing loadmodule?
>
> 0(3981) parse error (215,26-27): unknown command, missing loadmodule?
>
> 0(3981) parse error (219,24-25): unknown command, missing loadmodule?
>
> 0(3981) parse error (230,24-25): unknown command, missing loadmodule?
>
> 0(3981) parse error (263,28-29): unknown command, missing loadmodule?
>
> 0(3981) parse error (267,20-21): unknown command, missing loadmodule?
>
> 0(3981) parse error (281,24-25): unknown command, missing loadmodule?
>
> ERROR: bad config file (31 errors)
>
>
>
>
>
> ___________________________________________________________
> 1GB gratis, Antivirus y Antispam
> Correo Yahoo!, el mejor correo web del mundo
> http://correo.yahoo.com.ar
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
Frank
Thanks for the reply
I thought that setting "modparam("usrloc", "db_mode", 2)" to 1 did the same
thing. ie it updates the table whenever anything changes. I had it set to 1
but the "location" sql database swelled to over 9000 and ser wouldn't
restart until I truncated the table. My concern is that ser can't delete
records in sql even though I checked the grants and privileges for user ser
and they seem to be ok. Also serctl alias rm doesn't remove the aliases
record from the table, again an issue with grants. But serctl alias add
works.
| Grants for ser@localhost
|
+---------------------------------------------------------------------------
--------+
| GRANT USAGE ON *.* TO 'ser'@'localhost' IDENTIFIED BY PASSWORD
'*******************************' |
| GRANT ALL PRIVILEGES ON `ser`.* TO 'ser'@'localhost'
|
+---------------------------------------------------------------------------
--------+
Got any ideas?
Rick
_____
From: Frank Fischer [mailto:frank.fischer@digitalnomads.ch]
Sent: Tuesday, January 24, 2006 3:25 AM
To: RThompson(a)vir2com.com
Subject: RE: [Serusers] ser live database and mysql
ser keeps the location table in memory for performance reasons and does
synchronisation with the backend database sometimes. As far as i understand,
this could lead to differences between in-memory data and in database-data.
To avoid this situation and force SER to write all data to the database, you
could use the experimental module "usrloc-cl". It works fine for me.
- Frank
_____
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of Richard C. Thompson
Sent: Monday, January 23, 2006 9:55 PM
To: serusers(a)lists.iptel.org
Subject: [Serusers] ser live database and mysql
Hi all
Hopefully someone can answer this.
I am running ser with mysql and I have noticed that serctl moni shows a
smaller number in "location" than the mysql "location" table.
Eg
serctl moni shows 404 in location
mysql shows 556 in location
I have
modparam("usrloc", "db_mode", 2)
even when I refresh the sql query many times over a long time, the tables
never match.
It seems that ser can't delete some of the entries
Any help or hints would be appreciated
Rick
