Re: [SR-Users] Siremis error Call to a member function getQuoted()

2015-03-24 Thread canuck15
. "`"; In this way, you don't need to rename the table and change the name of it on php code. Cheers, Daniel On 23/03/15 16:20, canuck15 wrote: Ok, so the complete fix is: edit ...openbiz/bin/data/BizDataSql.php go to line 237 replace the line with. $xtable = $assoc["XTa

Re: [SR-Users] Siremis error Call to a member function getQuoted()

2015-03-23 Thread canuck15
Go through all the files in that directory and change Table="group" To Table="grouptable" Or whatever the new name given to the group table is. Now it all seems to work. On 3/23/2015 7:03 AM, canuck15 wrote: Hi, I figured that part out which is when I got the database

Re: [SR-Users] Siremis error Call to a member function getQuoted()

2015-03-23 Thread canuck15
heers, Daniel On 23/03/15 02:52, canuck15 wrote: I think I found the root cause. Siremis database has a table called "group". That is a reserved word in mysql that cannot be used as a table name. http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html Do the following to

Re: [SR-Users] Siremis error Call to a member function getQuoted()

2015-03-22 Thread canuck15
OM group; error > RENAME TABLE group TO group1; > SELECT * FROM group1; no error On 3/21/2015 4:39 PM, canuck15 wrote: When you add/update/view Administrator usernames To reproduce Administration > User Management > Click on any existing username. The browser goes blank. Error in apa

[SR-Users] Siremis error Call to a member function getQuoted()

2015-03-21 Thread canuck15
When you add/update/view Administrator usernames To reproduce Administration > User Management > Click on any existing username. The browser goes blank. Error in apache logs is: PHP Fatal error: Call to a member function getQuoted() on a non-object in /var/www/html/openbiz/bin/data/BizDataSql

Re: [SR-Users] What is the best SIP trunk authentication strategy

2015-03-19 Thread canuck15
Wednesday 18 March 2015 08:32:10 canuck15 wrote: I can run a cron job every hour to DNS lookup and update the ip_addr table as needed so I think this is a satisfactory solution for IP authentication. Is there a mechanism to identify all originating servers for a hostname/domain? If the answer is no (and

Re: [SR-Users] What is the best SIP trunk authentication strategy

2015-03-19 Thread canuck15
Please keep in mind that I have no control over SIP trunk providers. The vast majority do not allow me to do any of these things as far as I know. This is something that needs to be solved in Kamailio with standard user/pass/realm authentication. TLS is not an option for me. On 3/18/2015 11

[SR-Users] What is the best SIP trunk authentication strategy

2015-03-18 Thread canuck15
Been struggling with this for awhile now. So far I am finding it rather difficult to come up with way to authenticate SIP trunks taking into account all possible scenarios. My setup is Kamailio combined with Asterisk realtime. Everything is in a MySQL database. All authentication is done by

Re: [SR-Users] how can I use WITH_IPAUTH when the IP may be stored in the DB as a FQDN?

2015-03-14 Thread canuck15
# source IP allowed, leave the 'while' parent loop. $var(i) = $dbr(ka=>rows); return; } $var(i) = $var(i) + 1; } return; } sql_result_free("ka"); retur

[SR-Users] What does it mean when auth_check and auth_challenge flags are "0"?

2015-03-14 Thread canuck15
I am trying to decipher a kamailio.cfg file for a particular open source project. There are problems with authentication and I am trying to understand why. They use the following lines for authentication check if (!auth_check("$fd", "subscriber", "0")) { auth_challenge("$fd", "0");

Re: [SR-Users] Help with 407 Proxy Auth. Required

2015-03-14 Thread canuck15
Specifically, after auth_check line add: xlog("The return code is $rc\n"); Can add additional lines to view the values of other pseudovariables http://www.kamailio.org/wiki/cookbooks/4.0.x/pseudovariables On 3/9/2015 7:56 AM, Daniel-Constantin Mierla wrote: On 09/03/15 15:41, Agiftel wrote:

[SR-Users] does ipops module dns_int_match_ip(hostname, ipaddr) search all returned records?

2015-03-12 Thread canuck15
I am reading the documentation for the ipops module dns_int_match_ip() function and it states the following: "Returns TRUE if ipaddr is associated by DNS to hostname. FALSE otherwise. It uses internal DNS resolver. At this moment, the function might not check all the IP addresses as returned b

Re: [SR-Users] how can I use WITH_IPAUTH when the IP may be stored in the DB as a FQDN?

2015-03-11 Thread canuck15
/sec I suppose. Perhaps many thousands of SIP extensions using those trunks but not directly using DNS authentication themselves. On 3/9/2015 4:27 AM, Daniel-Constantin Mierla wrote: Hello, On 08/03/15 21:38, canuck15 wrote: Here is is the relevant section of kamailio.cfg $var(tempfU

[SR-Users] how can I use WITH_IPAUTH when the IP may be stored in the DB as a FQDN?

2015-03-08 Thread canuck15
Here is is the relevant section of kamailio.cfg $var(tempfU) = $fU; #!ifdef WITH_IPAUTH if((!is_method("REGISTER")) && allow_source_address() && $au == "") { # Loading $fU from database using IP sql_pvquery("elxpbx", "SELECT name FROM sip WHERE host = '$si' AND sippasswd