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@iptel.org To: SER LIST sergrp@hotmail.com, serusers@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@iptel.org To: SER LIST sergrp@hotmail.com, serusers@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@iptel.org To: serusers@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: %tufrom:
%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@gmail.com >To: "SER LIST" sergrp@hotmail.com >CC: serusers@iptel.org, serdev@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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list Serusers@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/