Hi,
Is there any way how to get(create?) from SER
Call Data Records for billing?
According documentation I see that acc modul
does not provide enough info to do it.
Pali
Hi,
Is there a way i can install all modules during ser installation?
Or how can i install more than one at a go?(include_modules="mysql,acc"
and include_modules="mysql acc" both failed)
Thanks for you help,
Regards,
Wilson
---
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.282 / Virus Database: 150 - Release Date: 9/25/2001
Greetings,
I'm currently attempting to install ser 0.8.14 on FreeBSD 4.10 with
mysql 4.0.18 installed. The server has a single ethernet interface.
Previously, ser 0.8.12 from /usr/ports/net/ser was running flawlessly,
but was lacking several features and didn't do things I wanted.
SO i've tried upgrading (and failed) by installing:
ser-0.8.14_src.tar.gz
ser-0.8.14_freebsd_i386.tar.gz
and even cvs version via 'cvs co -r rel_0_8_14 sip_router'
Everything compiles without any error (not counting *.d warnings):
gmake all
gmake install
then it's required to
ln -s /usr/local/lib/mysql/libmysqlclient.so.12
/usr/local/lib/mysql/libmysqlclient.so.10,
as the ser's mysql.so module is looking for .so.10 version.
The problem is that the moment i enable mysql module by
adding/uncommenting this in the default ser.cfg:
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
modparam("usrloc","db_mode", 1)
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
optionally adding:
modparam("auth_db", "db_url","mysql://ser:heslo@localhost/ser")
SER fails to load:
---
sip# ser -E
Listening on
195.250.77.70 [195.250.77.70]:5060
Aliases: sip.arminco.com:5060 sip:5060 195.250.77.70:*
sip# stateless - initializing
Maxfwd module- initializing
0(71635) mod_init(): Database connection opened successfuly
0(0) INFO: udp_init: SO_RCVBUF is initially 41600
0(0) INFO: udp_init: SO_RCVBUF is finally 231936
5(71640) INFO: fifo process starting: 71640
2(71637) 3(71638) 4(71639) 1(71636) connect_db(): No enough memory
connect_db(): No enough memory
connect_db(): No enough memory
connect_db(): No enough memory
2(71637) 3(71638) 4(71639) 5(71640) 1(71636) db_init(): Error
while trying to connect database
db_init(): Error while trying to connect database
db_init(): Error while trying to connect database
connect_db(): No enough memory
db_init(): Error while trying to connect database
2(71637) 3(71638) 4(71639) 5(71640) 1(71636) auth_db:init_child():
Unable to connect database
auth_db:init_child(): Unable to connect database
auth_db:init_child(): Unable to connect database
db_init(): Error while trying to connect database
auth_db:init_child(): Unable to connect database
2(71637) 3(71638) 4(71639) 5(71640) 1(71636) init_mod_child():
Error while initializing module auth_db
init_mod_child(): Error while initializing module auth_db
init_mod_child(): Error while initializing module auth_db
auth_db:init_child(): Unable to connect database
init_mod_child(): Error while initializing module auth_db
2(71637) 3(71638) 4(71639) 5(71640) 1(71636) init_child failed
init_child failed
init_child failed
init_mod_child(): Error while initializing module auth_db
init_child failed
5(71640) 3(71638) 4(71639) 5(71640) 1(71636) 2(71637) INFO:
signal 15 received
INFO: signal 15 received
INFO: signal 15 received
INFO: signal 15 received
INFO: signal 15 received
INFO: signal 15 received
--
If I disable mysql by 'modparam("usrloc","db_mode", 0)', it runs without
it ok. I've tried compiling with gcc-3.2, tried compiling mysql
4.0.18/4.0.20 manually, tried binary distrib from www.mysql.com, same
error message.
So is this a known mysql/auth_db bug and is there a solution for it?
--
With best regards,
Vahan Yerkanian
ARMINCO Global Telecom
Does someone run ser-8.14 version with nathelper and rtpproxy successful?
Or does someone can run the latest cvs verion ser and rtpproxy successful?
In cvs version I have gotten the follow errors:
ug 28 16:32:00 sipod-sh /usr/local/sbin/ser[10654]: WARNING: no fifo_db_url given - fifo DB commands disabled!
Aug 28 16:32:05 sipod-sh /usr/local/sbin/ser[10659]: NOTICE:maxfwd:process_maxfwd_header: value 70 decreased to 16
Aug 28 16:32:16 sipod-sh /usr/local/sbin/ser[10660]: NOTICE:maxfwd:process_maxfwd_header: value 70 decreased to 16
Aug 28 16:32:19 sipod-sh /usr/local/sbin/ser[10662]: NOTICE:maxfwd:process_maxfwd_header: value 70 decreased to 16
Aug 28 16:32:19 sipod-sh /usr/local/sbin/ser[10662]: ERROR: alter_mediaip: you can't rewrite the same SDP twice, check your config!
Aug 28 16:32:19 sipod-sh /usr/local/sbin/ser[10662]: ERROR: fix_nated_sdp: can't alter media IP
Aug 28 16:32:19 sipod-sh /usr/local/sbin/ser[10662]: ERROR: alter_mediaip: you can't rewrite the same SDP twice, check your config!
Aug 28 16:32:20 sipod-sh /usr/local/sbin/ser[10660]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:32:20 sipod-sh /usr/local/sbin/ser[10659]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:32:20 sipod-sh /usr/local/sbin/ser[10662]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:32:25 sipod-sh /usr/local/sbin/ser[10659]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:32:25 sipod-sh /usr/local/sbin/ser[10660]: NOTICE:maxfwd:process_maxfwd_header: value 70 decreased to 16
Aug 28 16:32:26 sipod-sh /usr/local/sbin/ser[10661]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:34:39 sipod-sh /usr/local/sbin/ser[10660]: NOTICE:maxfwd:process_maxfwd_header: value 70 decreased to 16
In 8.14 version I have gotten follow errors:
ug 28 16:53:41 sipod-sh /usr/local/sbin/ser[10779]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:53:41 sipod-sh /usr/local/sbin/ser[10776]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:53:41 sipod-sh /usr/local/sbin/ser[10777]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:53:44 sipod-sh /usr/local/sbin/ser[10776]: WARNING: run_actions: null action list (rec_level=1)
Aug 28 16:53:46 sipod-sh /usr/local/sbin/ser[10777]: WARNING: run_actions: null action list (rec_level=1)
Can some give me a successful configure file and verion infromation?
Thank you.
U have incoming DID number 1111 that forking to to aliases 2222 and 3333
You have failure route configured on the ser and there u have forwarding
to voicemail
Now.. if somebody call 1111 SER will fork call to 2222 and 3333 and if
both of them did not pickup the phone it will be passed to failure route
BUT not as call to 2222/3333 but as call to 1111
That means that you should not care about configure voicemail on your
aliases.. only configure VM or not on incoming DID
I hope it is understandable :)
> -----Original Message-----
> From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org]
On
> Behalf Of Jev
> Sent: Friday, August 27, 2004 3:30 PM
> To: serusers(a)lists.iptel.org
> Subject: [Serusers] one to many aliases and voicemail
>
> Hi all,
>
> Having an alias map to a single uri is fine, and if the target uri has
> voicemail enabled that is fine.
>
> What happens if I have a alias that goes one to many, and some of the
> target uris have voicemail enabled? When someone calls a particular
> alias, I don't want ser to redirect to sems at all.
>
> How can I achieve this? Is it possible to detect if a invite has the
> result of an alias (probably by using hints in the sip msg?), and if
so
> can I detect how many targets a alias maps to? In basic terms, if
> alias_targets is > 1, then do not redirect to voicemail.
>
> Thanks!
> -Jev
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
Sorry for posting this message again but i changed my subscription.
Hi ..I have a problem with the ser accounting..I installed
ser-0.8.12_src.tar.gz with acc and mysql modules by editing the acc
makefile to enable SQL accounting and by editing the ser makefile to
include mysql module.I installed mysql server and client and I ran
ser_mysql.sh to create my ser database.I configured ser.cfg to connect to
the ser mysql database and I configured ser_mysql.sh ( I changed the
password ). Everything is fine ..Ser starts with no errors and realisezes
user authentication.I also added db_flag to my ser.cfg file.I can place
calls but the MAIN PROBLEM is that I can't see any accounting information
in MySQL ser database....Can anyone help me ?..Thanks
Hello John,
You will find attached my PostgreSQL database dump for Serweb; As I said
I'm not sure that all the fields are good enough, maybe you will have to
change some of them... Let me know if you make some modifications.
In order to run Serweb with PGSQL please do as follow:
1. load the SQL DDL file into your PGSQL
2. load at least one account with the same domain listed in
/serweb/html/set_domain.php
e.g. $config->domain = "your_domain.com";
2. modify:
/serweb/html/config_data_layer.php
$config->data_sql->type="pgsql";
$config->data_sql->host[$i]['host']="localhost"; //database host
$config->data_sql->host[$i]['port']=""; //database
port - leave empty for default
$config->data_sql->host[$i]['name']="database_name"; //database name
$config->data_sql->host[$i]['user']="your_login";
//database conection user
$config->data_sql->host[$i]['pass']="your_password";
I'm using the last SERWEB from the CVS. I think that's all you need to do.
If you succeed to connect please let me know.
Is there anybody using the last Serweb with Postgre ? Any chance to login ?
Thanks,
SB
John Draper <crunch(a)webcrunchers.com> wrote:
SB wrote:
>
> Hello,
>
> I'm using SERWEB but I have some trouble to login when the
> login/password is correct. If the password is wrong, I have an error
> message telling me "wrong password". But if the login/password is Ok,
> then the page start a long processing cycle without anything in return
> (after 5 minutes, blank page or server unreachable).
>
> In my configuration, I have:
>
>clear_text_pw=1
>
>
>
> My default domain match with the admin user's domain i'm using to
> login. The database I'm using is PostgreSQL (all serweb sql scripts
> have been ported to PGSQL, I will provide all the sql files as soon as
> everything is running smoothly).
>
You have this running under PostGreSQL? WOW! Cool... I'm just now
getting started setting up my SER
server, but have no clue on how to get it hooked into PostGres. Could
you point me to some documents you
found that tells me how to do it?
I'm using 0.8.10 by the way, should I install a newer version?
John
Hi,
I am using sems_2004-07-27 and ser-0.8.14.
I use windows messenger(4.7) to test the IM function of SER and it is fine. Now I want to know if SER support saving contact list in database just like msn messenger6.2(not windows messenger) does.And if it can,what should I do?
Thanks.
jerry
jerryws(a)sohu.com
2004-08-30
Hi everyone:
Because I couldn't find the RPM package SER-0.8.14
for linux, and the mysql supported package. I have
installed SER-0.8.12. But there is no "ping_nated_only"
and "nat_uac_test" in module nathelper . To judge whether
the client is behind NAT, How can I do?
Anyone help me please!
thank you!
Mean
gdut200104024532(a)163.com
2004-08-30