Hi,
I got the webinterface working! After going over the php info I solved it.
But im still getting this errors :
Warning: Unable to include 'prolog.html' - request execution failed in
/var/www/html/ser/page.php on line 77
68.153.153.227 User Management
Warning: Unable to include 'blah.html' - request execution failed in
/var/www/html/ser/page.php on line 79
Oliver
I'm trying to run SER with a MySQL setup. I want to put the SER on one server, and the MySQL on another server. I am using the following parameters in my ser.cfg. Why can't I get this working right? I've tried connecting using MySQL's client commands directly and it works. It seems to be only doing this on the authdb section, because I tried commenting the usrloc database commands out, and it still only produces one error message. So apparently usrloc's MYSQL connection IS working, just not authdb's.
Thanks
# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url", "mysql://ser:password@192.168.1.194/ser")
# -- 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")
modparam("auth_db", "db_url", "mysql://ser:password@192.168.1.194/ser")
# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
I get the following messages in my log file:
Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: db_init(): Could not create a connection
Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: group:mod_init(): Unable to connect database
Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: init_mod(): Error while initializing module group
Hi!
I tried \n in log and xlog messages to enforce line breaks (to write
some debug info over multiple lines), but this does not work. I even
tried \r and \r\n, but none of them works, the logging in
/var/log/messages is always in the same line (tested on suse&redhat).
But in the sample scripts there are always \n in the log statements,
even at the end of the string.
Should \n work?
thanks,
klaus
Terrific, thanks. that was the final piece of the puzzle.
now SER authenticates REGISTERS and INVITES correctly, and clients with
bogus usernames/passwds are denied. thank you very much.
scott t
DSi
> -----Original Message-----
> From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at]
> Sent: Friday, March 19, 2004 2:47 pm
> To: Ticknor, Scott: DGSE
> Cc: serusers(a)lists.iptel.org
> Subject: Re: [Serusers] authentication recommnedations
>
>
> is_local uses the domain module from ser. This module checks domains
> against the domain table fo the ser database. Therefore, you have to
> insert the domains ser is responsible for (e.g.
> my.sip.domain) into the
> "domain" table in the mysql database from ser.
>
> Klaus
>
> Ticknor.Scott(a)ic.gc.ca wrote:
> >>>-----Original Message-----
> >>>From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at]
> >>>Sent: Thursday, March 18, 2004 12:48 pm
> >>>To: Ticknor, Scott: DGSE
> >>>Cc: serusers(a)lists.iptel.org
> >>>Subject: Re: [Serusers] authentication recommnedations
> >>>
> >>>
> >>>Hi!
> >>>
> >>>I use this setup:
> >>>
> >>>if (is_from_local() ) {
> >>> if (!proxy_authorize("", "subscriber"))
> >
> >
> > sorry to keep beating this up...
> > i am trying this logic out, but the debug messages show:
> >
> > is_local(): Realm 'my.sip.domain' is not local
> > is_local(): Realm 'X.X.X.X' is not local
> >
> > is this an error in the database configuration, or is there
> somewhere else
> > to configure local?? i found this via google:
> >
> > if (RES_ROW_N(res) == 0) {
> > DBG("is_local(): Realm '%.*s' is not local\n",
> > _host->len, ZSW(_host->s));
> > db_free_query(db_handle, res);
> > return -1;
> >
> > thanks,
> >
> > scott t
> > DSi
> >
> >
>
Hi!
Is it possible to stop the routing completly from a sub-route?
"break" only leaves the current route block, but I want to stop the
whole processing. For example, I want to put the sanity checks into a
separate route block like shown below.
route[0] {
#sanity checks
route(1);
...
}
route[1]{
if (!mf_process_maxfwd_header("10")) {
sl_send_reply("483","Too Many Hops");
log(1, "too many hops, ->break\n");
break;
};
}
How can I stop the route processing from within route[1]?
btw: I would be nice to return values from route blocks
if (route(1)) ...
regards,
klaus
a typical reason is that php settings are not as required. a typical
reason why it is that way is users configured other php.ini file than
used by the php interpreter.
-jiri
At 05:21 AM 3/19/2004, oliver vermeulen wrote:
>Hi all,
>
>Is anybody working with current iptel webinterface ?
>I made it running on my server , but it dose not login!
>http://65.38.211.66/iptel/html/admin/
>
>It hase the standard login, but it rejects it.
>I installed everything by the book.
>
>Any recommends?
>
>Thanks,
>Oliver
>
>_______________________________________________
>Serusers mailing list
>serusers(a)lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
--
Jiri Kuthan http://iptel.org/~jiri/
> > -----Original Message-----
> > From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at]
> > Sent: Thursday, March 18, 2004 12:48 pm
> > To: Ticknor, Scott: DGSE
> > Cc: serusers(a)lists.iptel.org
> > Subject: Re: [Serusers] authentication recommnedations
> >
> >
> > Hi!
> >
> > I use this setup:
> >
> > if (is_from_local() ) {
> > if (!proxy_authorize("", "subscriber"))
sorry to keep beating this up...
i am trying this logic out, but the debug messages show:
is_local(): Realm 'my.sip.domain' is not local
is_local(): Realm 'X.X.X.X' is not local
is this an error in the database configuration, or is there somewhere else
to configure local?? i found this via google:
if (RES_ROW_N(res) == 0) {
DBG("is_local(): Realm '%.*s' is not local\n",
_host->len, ZSW(_host->s));
db_free_query(db_handle, res);
return -1;
thanks,
scott t
DSi
At 05:38 PM 3/19/2004, Ticknor.Scott(a)ic.gc.ca wrote:
>> -----Original Message-----
>> From: Jiri Kuthan [mailto:jiri@iptel.org]
>> Sent: Friday, March 19, 2004 11:36 am
>> To: Ticknor, Scott: DGSE; klaus.mailinglists(a)pernau.at
>> Cc: serusers(a)lists.iptel.org
>> Subject: RE: [Serusers] authentication recommnedations
>>
>>
>> At 05:31 PM 3/19/2004, Ticknor.Scott(a)ic.gc.ca wrote:
>> >connect_db(): too many connections
>> >
>> >
>> >is this a result of the forking?
>>
>> yes, each process opens up many mysql connections. Allow mysql server
>> to accept many (see 'INSTALL', I think it gives more details on how to
>> do it)
>>
>> -jiri
>
>very good, thank you. and also i see from the CookBook that i can specify
>listen=x.x.x.x
indeed -- number of processes (and consequently mysql connections) can be
lowered if you bind SER to a specific interface.
-jiri
> -----Original Message-----
> From: Jiri Kuthan [mailto:jiri@iptel.org]
> Sent: Friday, March 19, 2004 11:36 am
> To: Ticknor, Scott: DGSE; klaus.mailinglists(a)pernau.at
> Cc: serusers(a)lists.iptel.org
> Subject: RE: [Serusers] authentication recommnedations
>
>
> At 05:31 PM 3/19/2004, Ticknor.Scott(a)ic.gc.ca wrote:
> >connect_db(): too many connections
> >
> >
> >is this a result of the forking?
>
> yes, each process opens up many mysql connections. Allow mysql server
> to accept many (see 'INSTALL', I think it gives more details on how to
> do it)
>
> -jiri
very good, thank you. and also i see from the CookBook that i can specify
listen=x.x.x.x
st
At 05:31 PM 3/19/2004, Ticknor.Scott(a)ic.gc.ca wrote:
>connect_db(): too many connections
>
>
>is this a result of the forking?
yes, each process opens up many mysql connections. Allow mysql server
to accept many (see 'INSTALL', I think it gives more details on how to
do it)
-jiri