[Serusers] SER pre-release - PRESENCE ISSUES

SER LIST sergrp at hotmail.com
Sun Nov 12 21:32:59 CET 2006


I ran the command(s) and I get the following output (The only difference is 
that I do not see an explicit "NO" in the NULL Column; other than they are 
similar to what you wrote).  I am running mysql 4.1.12 on CentOS 4.3

mysql> select * from version where table_name like 'domain%';
+-----------------+---------------+
| table_name      | table_version |
+-----------------+---------------+
| domain_attrs    |             1 |
| domain          |             2 |
| domain_settings |             1 |
+-----------------+---------------+
3 rows in set (0.00 sec)

mysql> desc domain;
+--------+------------------+------+-----+---------+-------+
| Field  | Type             | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+-------+
| did    | varchar(64)      |      |     |         |       |
| domain | varchar(128)     |      | PRI |         |       |
| flags  | int(10) unsigned |      |     | 0       |       |
+--------+------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> desc domain_attrs;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| did   | varchar(64)      | YES  | MUL | NULL    |       |
| name  | varchar(32)      |      |     |         |       |
| type  | int(11)          |      |     | 0       |       |
| value | varchar(255)     | YES  |     | NULL    |       |
| flags | int(10) unsigned |      |     | 0       |       |
+-------+------------------+------+-----+---------+-------+
5 rows in set (0.00 sec)



>From: Michal Matyska <michal at iptel.org>
>To: SER LIST <sergrp at hotmail.com>, serusers at lists.iptel.org
>Subject: Re: [Serusers] SER pre-release - PRESENCE ISSUES
>Date: Sun, 12 Nov 2006 16:12:46 +0100
>
>Ok, there were no hint that you did it already. In that case please
>check what value is in the table "version".
>
>
>mysql -user -pheslo ser010
>
>mysql> select * from version where table_name like 'domain%';
>+-----------------+---------------+
>| table_name      | table_version |
>+-----------------+---------------+
>| domain_attrs    |             1 |
>| domain          |             2 |
>| domain_settings |             1 |
>+-----------------+---------------+
>3 rows in set (0.02 sec)
>
>You should see the output as above. Check the table structure (just to
>be sure).
>
>
>mysql> desc domain;
>+--------+------------------+------+-----+---------+-------+
>| Field  | Type             | Null | Key | Default | Extra |
>+--------+------------------+------+-----+---------+-------+
>| did    | varchar(64)      | NO   |     |         |       |
>| domain | varchar(128)     | NO   | PRI |         |       |
>| flags  | int(10) unsigned | NO   |     | 0       |       |
>+--------+------------------+------+-----+---------+-------+
>3 rows in set (0.09 sec)
>
>mysql> desc domain_attrs;
>+-------+------------------+------+-----+---------+-------+
>| Field | Type             | Null | Key | Default | Extra |
>+-------+------------------+------+-----+---------+-------+
>| did   | varchar(64)      | YES  | MUL | NULL    |       |
>| name  | varchar(32)      | NO   |     |         |       |
>| type  | int(11)          | NO   |     | 0       |       |
>| value | varchar(255)     | YES  |     | NULL    |       |
>| flags | int(10) unsigned | NO   |     | 0       |       |
>+-------+------------------+------+-----+---------+-------+
>5 rows in set (0.00 sec)
>
>
>
>Michal
>
>
>On Sun, 2006-11-12 at 09:34 -0500, SER LIST wrote:
> > 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 at iptel.org>
> > >To: SER LIST <sergrp at hotmail.com>, serusers at 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",
> > > > "@from.uri.host") OR
> > > > lookup_domain("$td", "@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 at iptel.org>
> > > > >To: serusers at 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", "@from.uri.host")
> > > > >lookup_domain("$td", "@ruri.host")
> > > > >
> > > > >To set attr called "uid" use:
> > > > >www_authenticate() - see new ser.cfg or
> > > > >lookup_user("From") or lookup_user("$fu", "@from.uri")
> > > > >
> > > > >lookup_user("To") or lookup_user("$tu", "@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 at gmail.com>
> > > > > > >To: "SER LIST" <sergrp at hotmail.com>
> > > > > > >CC: serusers at iptel.org, serdev at 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 at hotmail.com>:
> > > > > > >>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 at lists.iptel.org
> > > > > > http://lists.iptel.org/mailman/listinfo/serusers
> > > > >
> > > > >_______________________________________________
> > > > >Serusers mailing list
> > > > >Serusers at 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! www.mobilejamfest.com
>

_________________________________________________________________
Find a local pizza place, music store, museum and more…then map the best 
route! Check out Live Local today!  http://local.live.com/?mkt=en-ca/




More information about the sr-users mailing list