But that is exactly what I had done. I had used the ser_mysql.sh script that
came w/ the CVS version to create a database ser10 and set the appropriate
db_url. I get the error when using the new database schema.
From: Michal Matyska <michal(a)iptel.org>
To: SER LIST <sergrp(a)hotmail.com>om>, serusers(a)lists.iptel.org
Subject: Re: [Serusers] SER pre-release - PRESENCE ISSUES
Date: Sun, 12 Nov 2006 11:47:22 +0100
Yes, the db schema has changed a lot since 0.9.x. You'll need to create
the new one using the ser_mysql.sh reinstall.
Or if you have lot of data provisioned, wait a moment, upgrade script
might be under construction.
If you still want to try the new version, then run:
ser_mysql.sh -n ser010 reinstall
(it will create new database called ser010) and change db_url in your
new ser.cfg to "mysql://ser:heslo@127.0.0.1/ser010".
Michal
On Sat, 2006-11-11 at 19:35 -0500, SER LIST wrote:
Thank you. But now when I use the new syntax
lookup_domain("$fd",
"(a)from.uri.host") OR
lookup_domain("$td", "(a)ruri.host")
I get the following error:
----------------------------
/usr/local/sbin/ser[31115]: register_udomain(): Invalid table version
(use
ser_mysql.sh reinstall)
/usr/local/sbin/ser[31115]: domain_fixup(): Error while registering
domain
/usr/local/sbin/ser[31115]: ERROR: fix_expr :
fix_actions error
-----------------------------
And when I comment those lines, ser starts fine!!!
Any suggestions.
Thanks
>From: Michal Matyska <michal(a)iptel.org>
>To: serusers(a)lists.iptel.org
>Subject: Re: [Serusers] SER pre-release - PRESENCE ISSUES
>Date: Fri, 10 Nov 2006 20:40:13 +0100
>
>You can find some ideas in the new ser.cfg (on CVS).
>
>It seems to be little bit inconsistent to have lookup_user("from") but
>not lookup_domain("from"). I'd like to see either both or neither.
:-)
>
>To set attr called "did" and load domain attrs (if allowed by modparam)
>use:
>lookup_domain("$fd", "(a)from.uri.host")
>lookup_domain("$td", "(a)ruri.host")
>
>To set attr called "uid" use:
>www_authenticate() - see new ser.cfg or
>lookup_user("From") or lookup_user("$fu", "(a)from.uri")
>
>lookup_user("To") or lookup_user("$tu", "(a)to.uri")
>lookup_user("Request-URI") or lookup_user("$tu",
"@ruri")
>
>
>To load attr for that user
>load_attrs("$fu","$f.uid")
>load_attrs("$tu","$t.uid")
>
>Michal
>
>On Fri, 2006-11-10 at 13:42 -0500, SER LIST wrote:
> > Thank you. settig the xcap_root for the xcap module fixed the two
errors
> > relating to xcap_root.
> >
> > BUT I am still getting the two errors relating to the lookup_domain
>command,
> > namely:
> >
> > -------------------------------------
> > ser: parse error (192,24-25): unknown command, missing loadmodule?
> > ser: parse error (261,26-27): unknown command, missing loadmodule?
> > ser: ERROR: bad config file (2 errors)
> > ser startup failed
> > ----------------------------------
> >
> > I am using the presence example file. The excerpt from my ser.cfg
file
>is (I
> > have marked the LINES where the error occurs):
> >
> > ---- start ---
> >
> > loadmodule "/usr/local/lib/ser/modules/sl.so"
> > loadmodule "/usr/local/lib/ser/modules/avp.so"
> > loadmodule "/usr/local/lib/ser/modules/avpops.so"
> > loadmodule "/usr/local/lib/ser/modules/tm.so"
> > loadmodule "/usr/local/lib/ser/modules/rr.so"
> > loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
> > loadmodule "/usr/local/lib/ser/modules/usrloc.so"
> > loadmodule "/usr/local/lib/ser/modules/registrar.so"
> > loadmodule "/usr/local/lib/ser/modules/domain.so"
> > loadmodule "/usr/local/lib/ser/modules/textops.so"
> > loadmodule "/usr/local/lib/ser/modules/mysql.so"
> > loadmodule "/usr/local/lib/ser/modules/dialog.so"
> > loadmodule "/usr/local/lib/ser/modules/rls.so"
> > loadmodule "/usr/local/lib/ser/modules/pa.so"
> > loadmodule "/usr/local/lib/ser/modules/xcap.so"
> > loadmodule "/usr/local/lib/ser/modules/presence_b2b.so"
> > loadmodule "/usr/local/lib/ser/modules/uri.so"
> > loadmodule "/usr/local/lib/ser/modules/uri_db.so"
> > loadmodule "/usr/local/lib/ser/modules/fifo.so"
> > loadmodule "/usr/local/lib/ser/modules/xmlrpc.so"
> > loadmodule "/usr/local/lib/ser/modules/xlog.so"
> > loadmodule "/usr/local/lib/ser/modules/auth.so"
> > loadmodule "/usr/local/lib/ser/modules/auth_db.so"
> > loadmodule "/usr/local/lib/ser/modules/msilo.so"
> >
> >
> > { LINES TRUNCATED}
> >
> >
> > if (uri==myself) {
> >
> > if (!lookup_domain("To")) {
<--------------------------
> > LINE 192
> >
> > xlog("L_ERR", "Unknown domain to: %tu
from:
>%fu\n");
> > route(1);
> > break;
> > }
> >
> > if (method=="SUBSCRIBE") {
> > if (!t_newtran()) {
> > sl_reply_error();
> > break;
> > };
> >
> >
> > (lines truncated)
> >
> > if (lookup_domain("From")) { <---------------------- LINE 261
> >
> > if
(lookup_user("From"))
>{
> >
> > if
> > (is_simple_rls_target("$uid-list")) {
> > #
log(1,
>"it
> > is simple subscription!\n");
> > #
takes
>From
> > UID and makes XCAP query for user's
> > #
list
>named
> > "default"
> >
> > if
> > (!query_resource_list("default")) {
> >
> > t_reply("404", "No such user list");
> >
> > break;
> > }
> > }
> > }
> > }
> >
> > ----------- END ---------------------
> >
> > Any suggestions??
> >
> > THanks in advance
> >
> >
> >
> >
> >
> >
> >
> > >From: samuel <samu60(a)gmail.com>
> > >To: "SER LIST" <sergrp(a)hotmail.com>
> > >CC: serusers(a)iptel.org, serdev(a)iptel.org
> > >Subject: Re: [Serusers] SER pre-release - PRESENCE ISSUES
> > >Date: Fri, 10 Nov 2006 10:14:17 +0100
> > >
> > >XCAP parameters where removed from rls and pa and a new module,
called
> > >xcap contains the xcap root so you
have to delete pa and rls xcap
> > >parameter, load the new module xcap.so and set the xcap_root
parameter
> > >of xcap module to the directory
having the doc structure.
> > >
> > >About the lookup_domain, there can be a typo. Can you post the
config
> > >file syntax??
> > >
> > >Hope it helps!
> > >
> > >Samuel
> > >
> > >2006/11/10, SER LIST <sergrp(a)hotmail.com>om>:
> > >>I installed the SER pre-release along w/ all modules. The problem
is
>that
> > >>presence now does not run (it was working w/ the
>presence-release-10.99).
> > >>The errors I get are:
> >
>
>----------------------------------------------------------------------------------------------------------
> > >>set_mod_param_regex: parameter <xcap_root> not found in module
<rls>
> > >>ser: parse error (82,20-21):
Can't set module parameter
> > >>set_mod_param_regex: parameter <auth_xcap_root> not found in
module
><pa>
> > >>parse error (97,20-21): Can't set module parameter
> > >>ser: parse error (186,24-25): unknown command, missing loadmodule?
> > >>parse error (255,26-27): unknown command, missing loadmodule?
> > >>ERROR: bad config file (4 errors)
> >
>
>-------------------------------------------------------------------------------------------------------------
> > >>I checked the pa module code and also the rls code and the
parameters
> > >>auth_xcap_root and xcap_root
are NOT defined !!!!
> > >>
> > >>The error on line 185 and 255 refer to the "Lookup_domain"
function. I
> > >>verified that the domain module
has been compiled and included in
the
> > >>ser.cfrg file
> >
> > _________________________________________________________________
> > Ready for the world's first international mobile film festival
>celebrating
> > the creative potential of today's youth? Check out Mobile Jam Fest
for
your
a chance to WIN $10,000!
www.mobilejamfest.com
_______________________________________________
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
_________________________________________________________________
Say hello to the next generation of Search. Live Search try it now.
http://www.live.com/?mkt=en-ca
_________________________________________________________________
Ready for the world's first international mobile film festival celebrating
the creative potential of today's youth? Check out Mobile Jam Fest for your
a chance to WIN $10,000!