sr-users July 2004

sr-users@lists.kamailio.org

178 participants
449 discussions

[Serusers] 0.8.14 headache....
by Dave Bath 28 Jul '04

28 Jul '04

Hey guys, I am having a small headache with serweb and the latest version of ser.. tried to upgrade, and things went moderately smoothly... the main problem was forgetting to use the "prefix=..." command when compiling the source! However, whenever I have upgraded, the database always seems to be a problem ... I don't know why this is, and the serweb database fields never seem to be present in the ser_mysql.sh script... perhaps I have done something very strange. However, I now seem to have a functioning database and ser install again, and it has decided to start loading my config again, so all is well. BUT! I seem to have lost admin permissions, particularly for administering ACL's through serweb... I can't figure out which combination of database entries to use. So far I have 'perms' field in 'subscriber' table set to 'admin' And I can see I need to put something in the admin_privileges table, but I'm not sure of the values.. Can anyone who has it working please have a look in their DB and let me know the values? Many thanks Dave

1 0

RE: [Serusers] how to upgrade mysql to ver4.0+
by Linda Xiao 28 Jul '04

28 Jul '04

Hi, I have mysql v4.0+ installed. But it seems that there is no proper php-mysql module for mysql v4.0. The php-mysql-4.2.x depends on libmysqlclient.so.10 which is for mysql v3.x. Is there any solution for this dependency issue? Is the new php-mysql package available? By the way, I am using Redhat Linux 9. Regards/Linda -----Original Message----- From: Jan Janak [mailto:jan@iptel.org] Sent: Tuesday, July 27, 2004 1:34 AM To: Linda Xiao Cc: serusers(a)lists.iptel.org Subject: Re: [Serusers] how to upgrade mysql to ver4.0+ As far as I know mysql can handle the upgrade automatically, so you just need to upgrade the rpm packages of mysql. If you have any important data in the database then I would also recommend you to do backup using mysqldump, see man mysqldump. Jan. On 26-07 16:52, Linda Xiao wrote: > Hi, > > > > Can someone illustrate the steps on how to upgrade mysql from ver3.23 to > ver4.0? Basically I just want to use serweb-missed-calls feature. > > I have installed ser using rpm and the version is 0.8.12. and recompiled acc > module for mysql support. I can see some records in the missed-call table by > using mysql command. > > > > Thanks and Best Regards > > -------------------------------------------------------------- > Linda Xiao > > > > > _______________________________________________ > Serusers mailing list > serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers

2 1

[Serusers] trouble in sending voice mail
by Koyama Zehi 28 Jul '04

28 Jul '04

Hi Seruser list, I am very sorry to trouble you again but sine last two days I am trying to send my recorded message from sems but i could not able to do. my procedures is as given below... I) I have added two user in in subscriber dadtabse with serctl command. (serctl add koyama, koyama, zehi_koyam(a)yahoo.com) (serctl add matsu, matsu, matsu(a)yahoo.com 2)I have granted permission for these user as (serctl acl grant koyama voicemail) (sertl acl grant matsu voicemail). I hasve also started my sendmail program and it is working fine.. Now i have logged in as matsu and try to reach at koyama but since she is not available then i got a greeting message and request to record my message. When the recording was over..then sems want to send the meassage using email as a sender voicemail(a)210.251.64.168 (210.251.64.168 mine sip proxy address).but it get the trouble as Domain of sender address voicemail(a)210.251.64.168 does not exist what is the problem I could not guess even i am able to send the message from using the command "serctl mail koyama"..... Could you give me some clue....I am also inserting the log........ thanks in advance.. (2828) DEBUG: read_line (AmSmtpClient.cpp:120): RECEIVED: 220 localhost.localdomain ESMTP Sendmail 8.12.8/8.12.8; Thu, 29 Jul 2004 00:20:24 +0900 (2828) INFO: connect (AmSmtpClient.cpp:96): 127.0.0.1 welcomes us (2828) DEBUG: send_line (AmSmtpClient.cpp:147): SENDED: HELO 127.0.0.1 (2828) DEBUG: read_line (AmSmtpClient.cpp:120): RECEIVED: 250 localhost.localdomain Hello vovida [127.0.0.1], pleased to meet you (2828) DEBUG: send_line (AmSmtpClient.cpp:147): SENDED: quit (2828) DEBUG: read_line (AmSmtpClient.cpp:120): RECEIVED: 221 2.0.0 localhost.localdomain closing connection (2828) DEBUG: run (AmMail.cpp:112): Mail deamon starting its work (2828) INFO: connect (AmSmtpClient.cpp:92): connected to: 127.0.0.1 (2828) DEBUG: read_line (AmSmtpClient.cpp:120): RECEIVED: 220 localhost.localdomain ESMTP Sendmail 8.12.8/8.12.8; Thu, 29 Jul 2004 00:20:24 +0900 (2828) INFO: connect (AmSmtpClient.cpp:96): 127.0.0.1 welcomes us (2828) DEBUG: send_line (AmSmtpClient.cpp:147): SENDED: HELO 127.0.0.1 (2828) DEBUG: read_line (AmSmtpClient.cpp:120): RECEIVED: 250 localhost.localdomain Hello vovida [127.0.0.1], pleased to meet you (2828) DEBUG: send_line (AmSmtpClient.cpp:147): SENDED: mail from: voicemail(a)210.251.64.168 (2828) DEBUG: read_line (AmSmtpClient.cpp:120): RECEIVED: 553 5.1.8 voicemail(a)210.251.64.168... Domain of sender address voicemail(a)210.251.64.168 does not exist (2828) ERROR: send_command (AmSmtpClient.cpp:173): smtp server answered: 553 5.1.8 voicemail(a)210.251.64.168... Domain of sender address voicemail(a)210.251.64.168 does not exist --------------------------------- Do you Yahoo!? Y! Messenger - Communicate in real time. Download now.

1 0

[Serusers] (no subject)
by Doug Eubanks 28 Jul '04

28 Jul '04

Hi, We are implementing a Sip Express Router install along with SEMS and SerWeb. I have to say, SER is the best sip proxy I have seen from the ones I have demoed. I am having problems with the routing logic setup portion. SEMS is working, I tested it by changing the main route, but all calls were forwarded to the voicemail. Can someone provide a sample that routes only calls not answered after 20 secs or who are offline (but registed as a user in the mysql database) to the voicemail? Is there anyway to dial the voicemail from your SIP client? I also need a sample setup that shows NAT, we are going to have some clients connected behind NAT I am sure. Lastly, the first time I installed SER (I screwed it up major and had to reinstall) I was using MySQL 4.0, now I am using mysql-3.23, the default for WhiteBox Enterprise Linux. When I was using 4.0, it was giving database connection errors, something about the authentication method was not supported. Will I have this problem if I reupgrade to 4.0 to use the unions on the SerWeb "Missed Calls Page"? I am using SER version ser-0.8.14, SEMS sems-0.1.1 and the CVS build for 7/27/04 of SerWeb. My config is listed below.... SerWeb works great, I just seem to have trouble tracking this stuff down. I also have RPMS of the versions listed for WhiteBox that will work with the stock RedHat Enterprise Linux server if anyone wants them. Thanks, Doug Eubanks admin(a)dougware.net # # $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $ # # simple quick-start config script # # ----------- global configuration parameters ------------------------ debug=7 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes # (cmd line: -E) /* Uncomment these lines to enter debugging mode #debug=7 #fork=no #log_stderror=yes */ check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 #children=4 fifo="/tmp/ser_fifo" alias=sip.simflex.net # ------------------ module loading ---------------------------------- # Uncomment this if you want to use SQL database loadmodule "/usr/lib/ser/modules/sl.so" loadmodule "/usr/lib/ser/modules/tm.so" loadmodule "/usr/lib/ser/modules/rr.so" loadmodule "/usr/lib/ser/modules/maxfwd.so" loadmodule "/usr/lib/ser/modules/usrloc.so" loadmodule "/usr/lib/ser/modules/registrar.so" loadmodule "/usr/lib/ser/modules/mangler.so" # loadmodule "/usr/lib/ser/modules/mediaproxy.so" loadmodule "/usr/lib/ser/modules/nathelper.so" loadmodule "/usr/lib/ser/modules/vm.so" # Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/lib/ser/modules/mysql.so" loadmodule "/usr/lib/ser/modules/auth.so" loadmodule "/usr/lib/ser/modules/auth_db.so" # ----------------- setting module-specific parameters --------------- # -- usrloc params -- #modparam("usrloc", "db_mode", 0) # Uncomment this if you want to use SQL database # for persistent storage and comment the previous line modparam("usrloc", "db_mode", 2) # -- auth params -- # Uncomment if you are using auth module # modparam("auth_db", "calculate_ha1", yes) modparam("auth_db", "db_url", "sql://REMOVED@sip.simflex.net/ser") modparam("usrloc", "db_url", "sql://REMOVED@sip.simflex.net/ser") # # If you set "calculate_ha1" parameter to yes (which true in this config), # uncomment also the following parameter) # modparam("auth_db", "password_column", "password") # -- rr params -- # add value to ;lr param to make some broken UAs happy modparam("rr", "enable_full_lr", 1) # ------------------------- request routing logic ------------------- # main routing logic route{ ### ADDED BY DOUG if (!proxy_authorize("sip.simflex.net" /* realm */, "subscriber" /* table name */ )) { proxy_challenge("sip.simflex.net", "0"); break; }; ### END OF ADDED BY DOUG # initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if ( msg:len > max_len ) { sl_send_reply("513", "Message too big"); break; }; # we record-route all messages -- to make sure that # subsequent messages will go through our proxy; that's # particularly good if upstream and downstream entities # use different transport protocol record_route(); # loose-route processing if (loose_route()) { t_relay(); break; }; # if the request is for other domain use UsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri==myself) { if (method=="REGISTER") { # Uncomment this if you want to use digest authentication # if (!www_authorize("sip.simflex.net", "subscriber")) { # www_challenge("sip.simflex.net", "0"); # break; # }; save("location"); break; }; lookup("aliases"); # native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; # forward to current uri now; use stateful forwarding; that # works reliably even if we forward from TCP to UDP if (!t_relay()) { sl_reply_error(); }; } *** DISCLAIMER *** This e-mail and any attachments thereto may contain information, which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by persons other than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer. Thank you for your cooperation.

1 0

[Serusers] sql authentication
by ser die 28 Jul '04

28 Jul '04

hello friends , iam trying to have put the sql authentication into the script. can any body guide me. does i need to use serctl add to give the users and there passwords please give me if any sample config files are there with regards ser die hard __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail

2 1

[Serusers] Asterisk for VM - offline users and aliases
by Dave Bath 28 Jul '04

28 Jul '04

Hey there List, People have been very helpful in helping to point me in the right direction for vm handling using asterisk.. and I'm making some progress. I manage to have some of the calls handed off to asterisk, using a failure route. This is the code snippet: failure_route[4] { # If we've got here, it means that a call timer has expired, and the user is in the # voicemail group. Therefore we're going to try and hand off the call to the Asterisk # voicemail system. revert_uri(); rewritehostport("161.30.94.69:5060"); log (1, "VOICEMAIL: Handing off to Asterisk\n"); append_branch(); t_relay; } However, I am seeing two problems which I've been bashing my head against a brick wall for a little bit .... The first is that it only works if you dial the numerical alias, not if you dial the user name... do you know how I can make sure it's the alias being passed to * and not the username? Secondly, even though I have put the logic block for checking if a user is a vm user before checking if a user is online, I can't seem to get to the mailbox for an offline user.. I just get a 404 not found.... <snip> # Make sure we check the aliases table lookup("aliases"); # Enable diverted voicemail functionlity DB 26-07-2004 # Does user have vm activated? (i.e., is in the voicemail (ser->grp) group?) if (!(method=="MESSAGE") && (is_user_in("Request-URI", "voicemail"))) { log(1, "VOICEMAIL: vm user detected, activating failure route"); t_on_failure("4"); setflag(3); }; # native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { # BEGIN if not in location database ........ </snip> If you have any ideas at all, I would be very very grateful. Many thanks again for all the help... Dave

1 0

Re: [Serusers] account + IP binding (fwd)
by zolia＠z1sys.com 28 Jul '04

28 Jul '04

On Wed, 28 Jul 2004, Bogdan-Andrei IANCU wrote: > zolia(a)z1sys.com wrote: > > >hello, > > > >is it possible to do source ip authentication besides normal > >www_authorize() for every user account?. This, as i understand, should > >prevent from intercepting credentials and later faking sip message to > >bypass www_authorization ? > > > this doesn't work. for each authentication challenge, ser generates an > noun that is kept into memory for a short period of time. So, this kind > of exploit is very limited - only if somebody trys in real time to do it > and in very narrow time window. yes probably, is would work only in real time, ie. to write some small proxy, which rewrites authorization header putting in in parallel sniffed encrypted password. Its a bit harder.. > IP checking doesn't help you - they can be also spoof. Plus, against > what address you check when the user register for the first time? or if What do you mean by "first time"? If there are only one IP from which UA requests MUST originate, then it should be possible to check it. > the user use multiple client in the same time? This would not be possible in our scenario. Antanas > bogdan > > > Or maybe there are some other counter measures > >against such fraud? > > > >Does src_ip comes directly from ip layer? If so, i could probably use this > >to check with some external database (ie. ser subscriber)? > > > >Antanas > >NTT > > > >_______________________________________________ > >Serusers mailing list > >serusers(a)lists.iptel.org > >http://lists.iptel.org/mailman/listinfo/serusers > > > > > > >

1 0

[Serusers] SERweb
by Ruth Vazquez Cerro 28 Jul '04

28 Jul '04

Hello: I'm trying to test SER SIP server. Up to now I installed SER and MySQL. Now I'm trying to install SERweb and I found a couple of troubles. I installed serweb_2004-01-04 version. The first question was that in all the files in html directory the requires had "prepend.php" while in phplib directory it was "prepend.php3". That was easily solved by moving or linking prepend.php3 to prepend.php. Then I found the next trouble. Asking for the web user_interface/index.php or admin.index.php I got "Fatal error: Call to undefined function: put_headers() in /var/www/html/iptel/html/user_interface/index.php on line 9" I think that that function should be defined because before in index.php it has a require: require "../../../../phplib/prepend.php"; and prepend.php also has a require including session.inc where the function is defined. Blindly I tried to change index.php a bit: Instead of having: --------------------------------------------------- require "../../../../phplib/prepend.php"; require "../../../../phplib/oohforms.inc"; put_headers(); page_open (array("sess" => "phplib_Session")); --------------------------------------------------- I wrote: --------------------------------------------------- require "../../../../phplib/prepend.php"; require "../../../../phplib/oohforms.inc"; put_headers(); page_open (array("sess" => "phplib_Session")); --------------------------------------------------- But it also failed with the message: Database error: cannot use database MySQL Error: 1046 (No Database Selected) Session halted. Whan am I doing wrong? Should I send any other information to help discover the mistake? Thanks in advance, Ruth.

1 0

[Serusers] error when starting php??
by Adrian Georgescu 28 Jul '04

28 Jul '04

The reasons can be so diverse, try reinstall mysql from scratch on your machine, watch out for the questions like "what is your root password" and remember it", you need at least to have it up and running (and get familiar with it) before attempting to run SER on it Start reading here: http://dev.mysql.com/doc/ Adrian >>>> Adrian; I have rebooted the server and tried to recreate the DB with the script "ser_mysql.sh create". And suddenly I started getting this error, even though all was working fine. ERROR 1045: Access denied for user: 'root at localhost' (Using password: NO) Any guidance or feedback would be appreciated. Regards,

1 0

[Serusers] error when starting php??
by Adrian Georgescu 28 Jul '04

28 Jul '04

Michael Try use mysql client in the command line like this mysql -u ser -pXXX -h192.168.251.200 ser If it does not work it means you do not have the rights, add rights in MySQL with: login as root on mysql server grant ALL ON ser.* TO ser@"192.%" IDENTIFIED by "XXX"; grant ALL ON ser.* TO ser@"localhost" IDENTIFIED by "XXX"; Adrian >>>>>>>>>>> Dear all; I am receiving this error every time I start PHP Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user: 'ser at intranet' (Using password: YES) in /export/home/serweb/serweb_2004-01-04/phplib/db_mysql.inc on line 73 Database error: pconnect(192.168.251.200, ser, $Password) failed. MySQL Error: () Session halted. Have anyone experienced this this before. Your help is greatly appreciated. Regards

2 1

← Newer
1
...
5
6
7
8
9
10
11
...
45
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users July 2004