sr-users February 2006

sr-users@lists.kamailio.org

189 participants
373 discussions

[Users] Permissions and UnixODBC incompatability

by Lenir

Hey guys, The permissions module doesn't work with unixodbc module, but it works fine with mysql or postgres. Here's the debut output: 0(0) DEBUG: init_mod: permissions 0(0) permissions - initializing 0(0) WARNING: File not found: /usr/local/etc/openser/permissions.allow 0(0) Default allow file (/usr/local/etc/openser/permissions.allow) not found => empty rule set 0(0) WARNING: File not found: /usr/local/etc/openser/permissions.deny 0(0) Default deny file (/usr/local/etc/openser/permissions.deny) not found => empty rule set 0(0) find_mod_export: found <db_use_table> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_init> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_close> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_query> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_raw_query> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_free_result> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_insert> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_delete> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_update> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) find_mod_export: found <db_replace> in module unixodbc [/usr/local/lib/openser/modules/unixodbc.so] 0(0) db_init: Connection 'unixodbc://username:password@xx.xx.xx.xx/sybasetds' not found in pool 0(0) DEBUG:unixodbc:build_conn_str: connection string is <DSN=sybasetds;UID=username;PWD=password;> 0(0) DEBUG:unixodbc:new_connection: connection succeeded with reply <DSN=sybasetds;UID=username;PWD=password;> 0(0) DEBUG: register_fifo_cmd: new command (trusted_reload) registered 0(0) DEBUG: register_fifo_cmd: new command (trusted_dump) registered 0(0) unixsock_register_cmd: New command (trusted_reload) registered 0(0) unixsock_register_cmd: New command (trusted_dump) registered 0(0) Number of rows in trusted table: 3 0(0) ERROR: permissions: trusted_reload(): Database problem 0(0) pool_remove: Removing connection from the pool 0(0) init_trusted(): Reload of trusted table failed 0(0) Error while initializing allow_trusted function Here's the trusted table, all columns are varchar src_ip proto from_pattern -------------------------------- 216.82.124.34 any NULL 216.82.124.35 any NULL 216.82.124.62 any NULL Regards, Lenir

18 years, 4 months

[Users] question about avp_subst

by unplug

If I have a avp variable s:contact= <sip:871966806561@10.0.0.46:5060> How can I use avp_subst to get 871966806561?

18 years, 4 months

[Serusers] Full Duplex Audio

by George Lambson

Does anyone know how to acheive full duplex audio using SER and Mediaproxy? Turns out my call center server does full duplex audio by sending RTP out one port and recieving it on another. The problem is that I want Mediaproxy to send the audio down the right stream, but it doesn't use the info in the SDP that it gets, instead it sends it back on the port it recieved it from Any help would be great. Thanks.

18 years, 4 months

[Serusers] Invalid table version AGAIN

by Yi Zheng

I was able to have SER working with MySql database. I can see the location table updated with the registered users. However if I add the following line to ser.cfg to use digest authentication and restart ser, then I saw the following errors in /var/log/messages and ser failed to start. ser.cfg ---------- # Uncomment this if you want to use digest authentication if (!www_authenticate("10.1.104.254", "subscriber")) { www_challenge("10.1.104.254", "0"); break; }; /var/log/messages: -------------------------- Feb 17 16:25:39 localhost ./ser[32533]: authdb_fixup: Invalid table version (use ser_mysql.sh reinstall) Feb 17 16:25:39 localhost ./ser[32533]: ERROR: fix_expr : fix_actions error I am using the presence server snapshot. There is no reinstall for this version of ser_mysql.sh. And I made no change to the database or version table. So what is it complaining? I found this strange. - ming

18 years, 4 months

Fwd: [Serusers] error querying table version

by Yi Zheng

I deleted all rows in the version table and manually created the table based on the ser_mysql.sh. But now I am seeing a different set of error messages. I searched ser code but can't find where it comes from. What could be wrong? Feb 17 12:07:46 localhost ./ser[24061]: submit_query: Unknown column 'uid' in 'field list' Feb 17 12:07:46 localhost ./ser[24061]: db_query: Error while submitting query Feb 17 12:07:46 localhost ./ser[24061]: preload_udomain(): Error while doing db_query Feb 17 12:07:46 localhost ./ser[24061]: register_udomain(): Error while preloading domain 'location' Feb 17 12:07:46 localhost ./ser[24061]: domain_fixup(): Error while registering domain - ming Yi Zheng <yizheng(a)sbcglobal.net> wrote: Date: Thu, 16 Feb 2006 21:20:17 -0800 (PST) From: Yi Zheng <yizheng(a)sbcglobal.net> To: ser sip <serusers(a)lists.iptel.org> Subject: [Serusers] error querying table version Hi, While trying to setup auth_db() with mysql, I got the following error messages in /var/log/messages. table_version(): Invalid number of rows received: 2, location Feb 16 17:55:17 localhost ./ser[13709]: register_udomain(): Error while querying table version Feb 16 17:55:17 localhost ./ser[13709]: domain_fixup(): Error while registering domain I used ser_mysql.sh create to generate the ser database. It looks like that ser has two location entries in its version table. I tried to use ser_mysql.sh to reinstall the ser database but it ended up the same. What should I do to correct this? - ming _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

18 years, 4 months

Re: AW: [Users] question about db_schemes and avp functionality

by Daniel-Constantin Mierla

Hello, On 02/17/06 17:03, Broch, Andreas wrote: > Hi > We installed todays latest openserdev-cvs version on the system and tested the avp_db_query() function again, but its still not working. > > Here an example of the current syntax > avp_db_query("select column_name1,column_name2 from mytable where username='$fu/username'","$avp(s:value1);$avp(s:value2)") > "/username" is a flag for parameter of avp_db_load() or other functions. The pseudo-variable referring to From username is $fU. Try: avp_db_query("select column_name1,column_name2 from mytable where username='$fU'","$avp(s:value1);$avp(s:value2)") Cheers, Daniel > => Problem: No debug Errors, but no Action > The only difference is that, openser now knows the Function( produces no Errors on startup). > > But if I load the values from my self defined scheme(s), the data is loaded correctly into the avps (memory). > > For example > avp_db_load("$fu/username","$avp(s:anyvalue)/$scheme1") > > => Problem new avp's cant be stored to database ! > > -----Ursprüngliche Nachricht----- > Von: Daniel-Constantin Mierla [mailto:daniel@voice-system.ro] > Gesendet: Donnerstag, 16. Februar 2006 10:50 > An: Broch, Andreas > Cc: users(a)openser.org > Betreff: Re: [Users] question about db_schemes and avp functionality > > Hello, > > > On 02/15/06 17:53, Broch, Andreas wrote: > >> Hi >> >> We have a running IMS test - system without HSS functionality at the >> moment. >> >> Next step to realize are the Initial Filter Criteria. >> >> -> >> >> I want to create my own db_scheme, where I can store the required >> values of the user profile. >> >> My questions are: >> >> - How can use the db_scheme beside the default avp_table ( >> usr_preferences ) ? >> >> > db_scheme definition allows to specify a custom table name. See: > http://www.voice-system.ro/docs/avpops/ar01s05.html#db_scheme > > If the table has the same structure as usr_preferences, then you can > give the name in the second parameter of avp_db_load(). > http://www.voice-system.ro/docs/avpops/ar01s06.html#avp_db_load > >> - Avp's only have 1 value column. How can I load different attributes >> , if the parameters are stored in different columns of the self >> defined table >> >> > If they are in the subscriber table, then you can load them upon > authentication: > http://openser.org/docs/modules/1.1.x/auth_db.html#AEN147 > > Otherwise, with the latest cvs version (it was committed yesterday), you > can use avp_db_query() > http://openser.org/docs/modules/1.1.x/avpops.html#AEN239 > > Cheers, > Daniel > > >> Mfg >> >> Andreas Broch >> >> FTW >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Users mailing list >> Users(a)openser.org >> http://openser.org/cgi-bin/mailman/listinfo/users >> >> > >

18 years, 4 months

Re: [Serusers] Re: SerWeb Displays blank page

by mkumar＠mantragroup.com

Finally my problem is solved, php code in page.php under html dir caused problems. After calls to virtual() nothing happens, php dies and displays blank page. Now I need to fix this php problem. > Quoting mkumar(a)mantragroup.com: > >> Hello Serusers, >> >> Now I fixed all my php,apache errors and again I have the same blank page >> problem. Previously we had serweb on a different machine and even >> there we had >> problems. So especially for serweb we took a new unix box and >> installed serweb >> there and even here we had another problem. In our previous machine >> page use to >> display after 5 to 10 attempts but here it always displays the title page as >> "SIP Express Router Web interface" but I could never find the login >> screen. My >> phpinfo page is http://serweb.mantragroup.com/ser/html/admin/phpinfo.php I >> eneabled display errors and log errors for php >> >> My admin login page is >> >> http://serweb.mantragroup.com/ser/html/admin/index.php >> >> Please check page source of admin index.php and I have learnt from >> my previous >> installation that it should have some java script etc for displaying >> username, >> password etc but this page do not have. I also checked paths for >> style.css and >> login_completion.js.php both are correct. What else should I do? I posted in >> some php forums also but could not fix. Please help me understand and fix my >> problem. I will send if any config files are needed. >> >> Thanks for your help and time, >> Manoj. >> >> >> Quoting Karel Kozlik <karel(a)iptel.org>: >> >>>> Sorry for that, now I changed some paths. I got this error >>>> >>>> Warning: main(): open_basedir restriction in effect. >>>> File(/usr/share/pear/DB.php) is not within the allowed path(s): >>>> >>>> So I used /tmp dir, anyway I changed to /usr/shae/pear/. I am >>>> searching for >>>> fixing this errors. I changed /etc/php.ini open_basedir global >>>> value but unable >>>> to change local value so I still have same problem? >>> >>> open_basedir should not be set. And as I see it is not. So it is correct. >>> >>> The error messages I see on your serweb now say you have not >>> installed xml_rpc package from PEAR. Strange - it should be >>> installed by default with PEAR. >>> >>> You may install it by type: >>> >>> pear install xml_rpc >>> >>> >>> Karel >>> >>> >>> >>> >>> >>>> >>>> Quoting Karel Kozlik <karel(a)iptel.org>: >>>> >>>>>> I enabled logging and also restarted Apache but even now I could >>>>>> not find any >>>>>> error message and still it displays blank page. Please check my >>>>>> phpinfo at >>>>> >>>>> To me it displays this errors: >>>>> >>>>> Warning: main(./PEAR.php): failed to open stream: No such file or >>>>> directory in /tmp/DB.php on line 26 >>>>> >>>>> Fatal error: main(): Failed opening required './PEAR.php' >>>>> (include_path='.:/usr/share/pear') in /tmp/DB.php on line 26 >>>>> >>>>> >>>>> It signify there is something wrong in your PEAR library. Do you >>>>> have installed it correctly? The path /tmp/... is strange for me. >>>>> >>>>> Karel >>>>> >>>>>> http://serweb.mantragroup.com/serweb/html/admin/test.php Is >>>>>> there anything >>>>>> wrong with this related to serweb. >>>>>> >>>>>> Quoting Karel Kozlik <karel(a)iptel.org>: >>>>>> >>>>>>> Hi, >>>>>>> if no error message is logged it means logging is disabled.. :-) >>>>>>> >>>>>>> Set this values in your php.ini: >>>>>>> >>>>>>> error_reporting = E_ALL >>>>>>> log_errors = On >>>>>>> (for write errors to log file) >>>>>>> >>>>>>> and/or >>>>>>> >>>>>>> display_errors = On >>>>>>> (for display error in browser) >>>>>>> >>>>>>> >>>>>>> Karel >>>>>>> >>>>>>> >>>>>>> mkumar(a)mantragroup.com napsal(a): >>>>>>>> Hi All, >>>>>>>> >>>>>>>> I am using serweb stable 0.9.2 version and I followed all the >>>>>>>> steps in INSTALL >>>>>>>> file that comes with the installation. After my configuration >>>>>>>> when I try to >>>>>>>> load the url >>>>>>>> >>>>>>>> http://serweb.mantragroup.com/serweb/html/admin/index.php >>>>>>>> >>>>>>>> strangly nothing is getting displayed and no error messages >>>>>>>> are logged in any >>>>>>>> log. I am using >>>>>>>> >>>>>>>> Apache/2.0.51 >>>>>>>> PHP 4.4.1 >>>>>>>> Mysql 4.0.25 >>>>>>>> >>>>>>>> Did anyone experience this problem before? Please tell me what >>>>>>>> should I do to >>>>>>>> configure serweb properly? >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Kumar. >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> >>>> >>> >> >> >> >> _______________________________________________ >> Serusers mailing list >> serusers(a)lists.iptel.org >> http://lists.iptel.org/mailman/listinfo/serusers >> > > > >

18 years, 4 months

[Users] RE: TLS Cipher error?

by Tóth Péter

Helo! The connection failed between openser and avaya, as you can see in sshdump, because the first handshake does not succeed. The reason of the failure, i think in the cipher, sent by avaya: TLS_DHE_RSA_WITH_DES_CBC_SHA After this package send a FIN, and close the connection! This is just 1 cipher, but in openssl must be send a dozen of ciphers, or not? Openser can not choose from one... I tried with an another openssl connection to an other machine (with s_client),and the connection was successfully, and in the cipherlist there is the upon one! I don't know, how to delete or add ciphers to the cipherlist, may this would help me a lot! Thanks: Peter -----Original Message----- From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] Sent: 2006. február 17. 10:37 To: Tóth Péter Cc: users(a)openser.org Subject: Re: [Users] TLS Cipher error? Does openser connect to avaya or vice versa? Watch the syslog output of openser. The tls stack of opneser will log to syslog why the connection failed. regards klaus Tóth Péter wrote: > Helo! > > > > Thans a lot for last help, I started succesfully the openser 1.0.0.0 tls > version, but I can not connent to an avaya pbx. The ssldump's result is > the following: > > > > New TCP connection #1: avaya_IP(14463) <-> debianom(5061) > > 1 1 0.0060 (0.0060) C>S Handshake > > ClientHello > > Version 3.1 > > cipher suites > > TLS_DHE_RSA_WITH_DES_CBC_SHA > > compression methods > > NULL > > 1 2 0.0572 (0.0512) S>C Alert > > level fatal > > value handshake_failure > > 1 0.0603 (0.0030) C>S TCP FIN > > 1 0.0682 (0.0079) S>C TCP FIN > > > > I do not know what is the following step. Openssl and libssl (0.9.7) are > installed, what should I do? I have to Edit the config-file? > > I don't find these ciphers... Pls help! > > > > Thanx: > > > > Tóth Péter > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > Users(a)openser.org > http://openser.org/cgi-bin/mailman/listinfo/users

18 years, 4 months

[Serusers] Verify sip number in ser.cfg failed...

by jimmy

Hi All, I am using ser 0.9.6, and refer the doc (http://www.iptel.org/ser/doc/seruser/seruser.html#CONDITIONS) and I want to use number 11 to 19 for pstn number, but in the first step to verify the pstn number failed. my code in ser.cfg, ******************************************* case 1: test sip client register number is 11 Sip uri is 11(a)192.168.5.1 if(uri=~"^sip:1[1-9]@"){ log(1,"LOG: number is 11-19\n") }else{ log(1,"LOG: NOT 11-19\n") } Result is "NOT 11-19" ******************************************* case 2: test sip client register number is 11 Sip uri is 11(a)192.168.5.1 if(uri=~"^sip:1[1-9]"){ log(1,"LOG: number is 11-19\n") }else{ log(1,"LOG: NOT 11-19\n") } Result is "number is 11-19" case 3: test sip client register number is ab Sip uri is ab(a)192.168.5.1 if(uri=~"^sip:1[1-9]"){ log(1,"LOG: number is 11-19\n") }else{ log(1,"LOG: NOT 11-19\n") } Result is "number is 11-19" ******************************************* Seems the character @ cause the incorrect result .? Did anyone experience this problem before? Or there is something wrong in my ser.cfg ? Please tell me what should I do to configure it properly? Thanks, Jimmy

18 years, 4 months

[Users] TLS Cipher error?

by Tóth Péter

Helo! Thans a lot for last help, I started succesfully the openser 1.0.0.0 tls version, but I can not connent to an avaya pbx. The ssldump's result is the following: New TCP connection #1: avaya_IP(14463) <-> debianom(5061) 1 1 0.0060 (0.0060) C>S Handshake ClientHello Version 3.1 cipher suites TLS_DHE_RSA_WITH_DES_CBC_SHA compression methods NULL 1 2 0.0572 (0.0512) S>C Alert level fatal value handshake_failure 1 0.0603 (0.0030) C>S TCP FIN 1 0.0682 (0.0079) S>C TCP FIN I do not know what is the following step. Openssl and libssl (0.9.7) are installed, what should I do? I have to Edit the config-file? I don't find these ciphers... Pls help! Thanx: Tóth Péter

18 years, 4 months

← Newer
1
...
13
14
15
16
17
18
19
...
38
Older →

Jump to page:

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 February 2006