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[XTable];
mysql -p
USE siremis;
RENAME TABLE group TO grouptable
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 error about
the group table. So I
/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 prove it.
mysql
USE siremis;
SELECT * FROM
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 apache logs is:
PHP Fatal error: Call
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
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
:
On 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
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
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:
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);
(i) = $var(i) + 1;
}
return;
}
sql_result_free(ka);
return;
} |
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) = $fU;
#!ifdef
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
/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
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 IS NULL,
14 matches
Mail list logo