Re: [OpenSIPS-Users] [opensips_cp]: Blank Page after Login
Hi Markus, Take a look at the logs from apache/httpd server - there should be some messages over there indicating the nature of your problem. Based on my experience, I pretty sure there is something wrong with the DB access (either the mysql MDB2, either credentials). Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 11.01.2015 21:32, Markus Klaus Schäffauer wrote: Hello, I managed to install Opensips 1.11 following the online video-tutorial of 03/2014 on debian wheezy - all OK. But I have problems with the actual opensips control panel: I installed everything and it seems to be ok, but when login with user/password, the login is showing a blank page and I find no way to avoid this - there seems to be an ERROR in the database access. I followed the instructions in the online video-tutorial, too. I had only problems to install pear/MDB2#mysql, but the mysql-driver for MDB2 seems to have passed to the php-mdb2-driver-mysql package; at least, I am not finding pear/MDB2#mysql anymore. I gave all privileges to the files in /var/www/opensips_cp/web/ and put chown -R www-data:www-data as owner of all files, so it does not seem to be a problem of privileges. I checked, too, the MYSQL-database - the admin-user is correctly inserted; at least I imagine that without having succeeded so far, I wouldn't be able to pass from the login to the blank page. What may be gone wrong? The missing MDB2#mysql? Wrong combination of db user / password ? Incompatibility of opensips-version and opensips_cp-version? I have no idea... Thank you for any suggestions! Markus ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] [opensips_cp]: Blank Page after Login ERROR-messages
Hello, thank you for your feedback Bogdan-Andrei! This is what I get in /var/log/apache2/error.log when trying to access the web-interface: [Mon Jan 12 10:26:08 2015] [error] [client xx.xx.xx.xx] PHP Warning: Creating default object from empty value in /var/www/opensips-cp/config/db.inc.php on line 25, referer: http://domain.de/opensips-cp/web/ [Mon Jan 12 10:26:08 2015] [error] [client xx.xx.xx.xx] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /var/www/opensips-cp/web/db_connect.php on line 31, referer: http://domain.de/opensips-cp/web/ In lin 25 of db.in.php you will find the declaration of the database-driver = mysql - the following error-message (undefined method) seems to depend on this, too. So may it be possible that the missing pear/MDB2#mysql driver is the problem? I managed to install this driver via pear (not the usual way: pear install pear/MDB2#mysql, but that way: pear install MDB2_Driver_mysql), although originally I thougt that it was already served by php-mdb2-driver-mysql. No way, there is only showing up the blank page. The password of the db.inc.php is without relevance (changing it, will not alter the appearance of the blank page, only when putting the mysql-root-password, then I get an message that login was wrong. Somebody can tell me how to get the correct pear/MDB2#mysql? Thanks a lot, Markus PD: Strange behaviour... and it is not very helpfull that in the db.inc.php the database user must be root (and not opensips) - then it should be called correctly the database root user as in opensipsctrl too! ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Concerns with 1.x series and new 2.1 Opensips
Hi John, Indeed, depending on the nature of the query, some answers can be cached, other not. If not, you need to be sure your DB server is as efficient as possible in answering. Accounting via flatstore file can be realtime (data is written in RT into file and you can rote them when you need). The next 2.1 is the first OpenSIPS version supporting Async I/O ops. There are many kinds of I/O ops and used in many places. It is hard to add async support for all of them from the day one. The current plan is to have support for exec module, for rest_client module and possible for some mysql queries. In the worst case, you can push your DB queries into external scripts and use the exec module with the async support. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 11.01.2015 15:48, John Nash wrote: Hello Bogdan, Thank you. Cache features are really good and I am using for Register and Invite auth but I need to run a query to find out allowed duration for a call (unfortunately caching cannot be used in that). Also Accounting I am afraid has to be real time in my case. I think i should look forward to version 2.X till the features I need are there. Any guess how long full featured development version will be out? John On Sat, Jan 10, 2015 at 1:16 AM, Bogdan-Andrei Iancu bog...@opensips.org mailto:bog...@opensips.org wrote: Hi Nash, It is somewhere in the middle :). Of course the DB ops will bring some penalties to the performance, so you need to take care and tune your DB for the best performance (not to drag down opensips). With db ops is very common in OpenSIPS scripts, so you do not do anything crazy or stupid there. Of course, you should look into optimizing the DB ops you use: - DB auth - use caching at script level (see http://www.opensips.org/Documentation/Tutorials-MemoryCaching) - ACC - consider using db_flatstore to avoid writing into a real DB - dialog - if not really a must use db modes 2 or 3 (http://www.opensips.org/html/docs/modules/1.11.x/dialog.html#id294001) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 09.01.2015 20:19, John Nash wrote: I have used opensips for load balancing and some border proxy+ NAT+rtpproxy in past and am quite happy with it. Recently I decided to add DB operations (Auth and accounting, routing and dialog into it so that heavy lifting of VOIP network can be given to opensips. I wanted to send call to PBX only when it is really needed (Like voicemail and conference etc) But in a long time I saw this article http://www.opensips.org/Documentation/TroubleShooting-FindPerfPb As per this tutorial I think if any DB operation is slow, it will hit overall performance (I mean the transactions which do not require DB can also be stuck). I know good engineers at openisps have already figured it out and working on 2.X version but looks like it will take a while so that I can give it a try (As dialog is not in current release). With 1.X series + DB auth/acc + dialog should I reconsider my approach or there are systems running successfully and I am just being paranoid? John ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] How to set up user accounts?
Hi Karl, In order to configure accounts/users (with auth), you need to use the auth_db module - it requires a DB backend. Use the opensipsdbctl tool to create the DB and opensipsctl to add users into it. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 12.01.2015 13:28, Karl Karpfen wrote: Hi, I'm new to OpenSIPS and this may be a stupid question but I did not find the related information somewhere... So I set up OpenSIPS on my Ubuntu 12.04 LTS successfully (without database backend) and configuration seems to be OK, but it tells me no aliases exist. I don't know if an alias is the same like an user account. What I want to do now is to set up user names and passwords to limit access to my OpenSIPS server to these users. How can this be done? Thanks! ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Call sequence in serial forking
Hi John, AFAIK, there is no need to increase the cseq during normal serial forking. The only known issue is if you do the serial forking for authentication purposes (you received a 401/7 and you do serial forking with credentials) - is this case you need to increase the cseq. But once again, the classic serial forking does not require any change in cseq. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 12.01.2015 12:09, John Nash wrote: I am testing one setup where opensips drouting module sends call to Freeswitch and I encountered one situation ... UA sends Invite to opensips, opensips uses drouting module and sends Invite to Freeswitch , callee rejects the call and opensips sends ACK to freeswitch and sends second invite (from failure route). This second invite (which has same call id but different branch in via) is not treated as another transaction by freeswitch and it sends back SIP 482 Request merged response. I had the same setup tested using SEMS as SBC some times back successfully. I am not sure which side this issue should be taken care of (opensips or freeswitch) I looked in some freeswitch mail archives and in one post I can see someone suggesting that from opensips side we should increase Cseq in case of second invite. I think this can be done using script but I am not sure if i should do or not. This is the post http://lists.freeswitch.org/pipermail/freeswitch-users/2013-February/092600.html ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Concerns with 1.x series and new 2.1 Opensips
Ok I will test flatstore and will see how it goes if I try to insert into real DB using some other process (May be some script which will check for new records in loop) On Mon, Jan 12, 2015 at 4:06 PM, Bogdan-Andrei Iancu bog...@opensips.org wrote: John, Using exec has its own penalties - the exec itself is CPU consuming as the Operating System has to create a new process each time. Os it is not I/O, but it is CPU (system time). For the accounting part, I still recommend the flatstore as the most efficient approach. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developerhttp://www.opensips-solutions.com On 12.01.2015 11:55, John Nash wrote: OK..I think doing accounting in exec makes perfect sense. On Mon, Jan 12, 2015 at 2:36 PM, Bogdan-Andrei Iancu bog...@opensips.org wrote: Hi John, Indeed, depending on the nature of the query, some answers can be cached, other not. If not, you need to be sure your DB server is as efficient as possible in answering. Accounting via flatstore file can be realtime (data is written in RT into file and you can rote them when you need). The next 2.1 is the first OpenSIPS version supporting Async I/O ops. There are many kinds of I/O ops and used in many places. It is hard to add async support for all of them from the day one. The current plan is to have support for exec module, for rest_client module and possible for some mysql queries. In the worst case, you can push your DB queries into external scripts and use the exec module with the async support. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developerhttp://www.opensips-solutions.com On 11.01.2015 15:48, John Nash wrote: Hello Bogdan, Thank you. Cache features are really good and I am using for Register and Invite auth but I need to run a query to find out allowed duration for a call (unfortunately caching cannot be used in that). Also Accounting I am afraid has to be real time in my case. I think i should look forward to version 2.X till the features I need are there. Any guess how long full featured development version will be out? John On Sat, Jan 10, 2015 at 1:16 AM, Bogdan-Andrei Iancu bog...@opensips.org wrote: Hi Nash, It is somewhere in the middle :). Of course the DB ops will bring some penalties to the performance, so you need to take care and tune your DB for the best performance (not to drag down opensips). With db ops is very common in OpenSIPS scripts, so you do not do anything crazy or stupid there. Of course, you should look into optimizing the DB ops you use: - DB auth - use caching at script level (see http://www.opensips.org/Documentation/Tutorials-MemoryCaching) - ACC - consider using db_flatstore to avoid writing into a real DB - dialog - if not really a must use db modes 2 or 3 ( http://www.opensips.org/html/docs/modules/1.11.x/dialog.html#id294001) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developerhttp://www.opensips-solutions.com On 09.01.2015 20:19, John Nash wrote: I have used opensips for load balancing and some border proxy+ NAT+rtpproxy in past and am quite happy with it. Recently I decided to add DB operations (Auth and accounting, routing and dialog into it so that heavy lifting of VOIP network can be given to opensips. I wanted to send call to PBX only when it is really needed (Like voicemail and conference etc) But in a long time I saw this article http://www.opensips.org/Documentation/TroubleShooting-FindPerfPb As per this tutorial I think if any DB operation is slow, it will hit overall performance (I mean the transactions which do not require DB can also be stuck). I know good engineers at openisps have already figured it out and working on 2.X version but looks like it will take a while so that I can give it a try (As dialog is not in current release). With 1.X series + DB auth/acc + dialog should I reconsider my approach or there are systems running successfully and I am just being paranoid? John ___ Users mailing listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Concerns with 1.x series and new 2.1 Opensips
OK..I think doing accounting in exec makes perfect sense. On Mon, Jan 12, 2015 at 2:36 PM, Bogdan-Andrei Iancu bog...@opensips.org wrote: Hi John, Indeed, depending on the nature of the query, some answers can be cached, other not. If not, you need to be sure your DB server is as efficient as possible in answering. Accounting via flatstore file can be realtime (data is written in RT into file and you can rote them when you need). The next 2.1 is the first OpenSIPS version supporting Async I/O ops. There are many kinds of I/O ops and used in many places. It is hard to add async support for all of them from the day one. The current plan is to have support for exec module, for rest_client module and possible for some mysql queries. In the worst case, you can push your DB queries into external scripts and use the exec module with the async support. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developerhttp://www.opensips-solutions.com On 11.01.2015 15:48, John Nash wrote: Hello Bogdan, Thank you. Cache features are really good and I am using for Register and Invite auth but I need to run a query to find out allowed duration for a call (unfortunately caching cannot be used in that). Also Accounting I am afraid has to be real time in my case. I think i should look forward to version 2.X till the features I need are there. Any guess how long full featured development version will be out? John On Sat, Jan 10, 2015 at 1:16 AM, Bogdan-Andrei Iancu bog...@opensips.org wrote: Hi Nash, It is somewhere in the middle :). Of course the DB ops will bring some penalties to the performance, so you need to take care and tune your DB for the best performance (not to drag down opensips). With db ops is very common in OpenSIPS scripts, so you do not do anything crazy or stupid there. Of course, you should look into optimizing the DB ops you use: - DB auth - use caching at script level (see http://www.opensips.org/Documentation/Tutorials-MemoryCaching) - ACC - consider using db_flatstore to avoid writing into a real DB - dialog - if not really a must use db modes 2 or 3 ( http://www.opensips.org/html/docs/modules/1.11.x/dialog.html#id294001) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developerhttp://www.opensips-solutions.com On 09.01.2015 20:19, John Nash wrote: I have used opensips for load balancing and some border proxy+ NAT+rtpproxy in past and am quite happy with it. Recently I decided to add DB operations (Auth and accounting, routing and dialog into it so that heavy lifting of VOIP network can be given to opensips. I wanted to send call to PBX only when it is really needed (Like voicemail and conference etc) But in a long time I saw this article http://www.opensips.org/Documentation/TroubleShooting-FindPerfPb As per this tutorial I think if any DB operation is slow, it will hit overall performance (I mean the transactions which do not require DB can also be stuck). I know good engineers at openisps have already figured it out and working on 2.X version but looks like it will take a while so that I can give it a try (As dialog is not in current release). With 1.X series + DB auth/acc + dialog should I reconsider my approach or there are systems running successfully and I am just being paranoid? John ___ Users mailing listUsers@lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Concerns with 1.x series and new 2.1 Opensips
John, Using exec has its own penalties - the exec itself is CPU consuming as the Operating System has to create a new process each time. Os it is not I/O, but it is CPU (system time). For the accounting part, I still recommend the flatstore as the most efficient approach. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 12.01.2015 11:55, John Nash wrote: OK..I think doing accounting in exec makes perfect sense. On Mon, Jan 12, 2015 at 2:36 PM, Bogdan-Andrei Iancu bog...@opensips.org mailto:bog...@opensips.org wrote: Hi John, Indeed, depending on the nature of the query, some answers can be cached, other not. If not, you need to be sure your DB server is as efficient as possible in answering. Accounting via flatstore file can be realtime (data is written in RT into file and you can rote them when you need). The next 2.1 is the first OpenSIPS version supporting Async I/O ops. There are many kinds of I/O ops and used in many places. It is hard to add async support for all of them from the day one. The current plan is to have support for exec module, for rest_client module and possible for some mysql queries. In the worst case, you can push your DB queries into external scripts and use the exec module with the async support. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 11.01.2015 15:48, John Nash wrote: Hello Bogdan, Thank you. Cache features are really good and I am using for Register and Invite auth but I need to run a query to find out allowed duration for a call (unfortunately caching cannot be used in that). Also Accounting I am afraid has to be real time in my case. I think i should look forward to version 2.X till the features I need are there. Any guess how long full featured development version will be out? John On Sat, Jan 10, 2015 at 1:16 AM, Bogdan-Andrei Iancu bog...@opensips.org mailto:bog...@opensips.org wrote: Hi Nash, It is somewhere in the middle :). Of course the DB ops will bring some penalties to the performance, so you need to take care and tune your DB for the best performance (not to drag down opensips). With db ops is very common in OpenSIPS scripts, so you do not do anything crazy or stupid there. Of course, you should look into optimizing the DB ops you use: - DB auth - use caching at script level (see http://www.opensips.org/Documentation/Tutorials-MemoryCaching) - ACC - consider using db_flatstore to avoid writing into a real DB - dialog - if not really a must use db modes 2 or 3 (http://www.opensips.org/html/docs/modules/1.11.x/dialog.html#id294001) Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 09.01.2015 20:19, John Nash wrote: I have used opensips for load balancing and some border proxy+ NAT+rtpproxy in past and am quite happy with it. Recently I decided to add DB operations (Auth and accounting, routing and dialog into it so that heavy lifting of VOIP network can be given to opensips. I wanted to send call to PBX only when it is really needed (Like voicemail and conference etc) But in a long time I saw this article http://www.opensips.org/Documentation/TroubleShooting-FindPerfPb As per this tutorial I think if any DB operation is slow, it will hit overall performance (I mean the transactions which do not require DB can also be stuck). I know good engineers at openisps have already figured it out and working on 2.X version but looks like it will take a while so that I can give it a try (As dialog is not in current release). With 1.X series + DB auth/acc + dialog should I reconsider my approach or there are systems running successfully and I am just being paranoid? John ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] How to set up user accounts?
Hi, I'm new to OpenSIPS and this may be a stupid question but I did not find the related information somewhere... So I set up OpenSIPS on my Ubuntu 12.04 LTS successfully (without database backend) and configuration seems to be OK, but it tells me no aliases exist. I don't know if an alias is the same like an user account. What I want to do now is to set up user names and passwords to limit access to my OpenSIPS server to these users. How can this be done? Thanks! ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] Call sequence in serial forking
I am testing one setup where opensips drouting module sends call to Freeswitch and I encountered one situation ... UA sends Invite to opensips, opensips uses drouting module and sends Invite to Freeswitch , callee rejects the call and opensips sends ACK to freeswitch and sends second invite (from failure route). This second invite (which has same call id but different branch in via) is not treated as another transaction by freeswitch and it sends back SIP 482 Request merged response. I had the same setup tested using SEMS as SBC some times back successfully. I am not sure which side this issue should be taken care of (opensips or freeswitch) I looked in some freeswitch mail archives and in one post I can see someone suggesting that from opensips side we should increase Cseq in case of second invite. I think this can be done using script but I am not sure if i should do or not. This is the post http://lists.freeswitch.org/pipermail/freeswitch-users/2013-February/092600.html ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] [opensips_cp]: Blank Page after Login ERROR-messages
Hi Markus, Please paste here the content of the file /var/www/opensips-cp/config/db.inc.php Also paste the output of the command pear list From my experience, 99% of the times that error is generated because of the wrong credentials. But it might be something different this time. Regards, Alex Ionescu On 01/12/2015 11:52 AM, Markus Klaus Schäffauer wrote: Hello, thank you for your feedback Bogdan-Andrei! This is what I get in /var/log/apache2/error.log when trying to access the web-interface: [Mon Jan 12 10:26:08 2015] [error] [client xx.xx.xx.xx] PHP Warning: Creating default object from empty value in /var/www/opensips-cp/config/db.inc.php on line 25, referer: http://domain.de/opensips-cp/web/ [Mon Jan 12 10:26:08 2015] [error] [client xx.xx.xx.xx] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /var/www/opensips-cp/web/db_connect.php on line 31, referer: http://domain.de/opensips-cp/web/ In lin 25 of db.in.php you will find the declaration of the database-driver = mysql - the following error-message (undefined method) seems to depend on this, too. So may it be possible that the missing pear/MDB2#mysql driver is the problem? I managed to install this driver via pear (not the usual way: pear install pear/MDB2#mysql, but that way: pear install MDB2_Driver_mysql), although originally I thougt that it was already served by php-mdb2-driver-mysql. No way, there is only showing up the blank page. The password of the db.inc.php is without relevance (changing it, will not alter the appearance of the blank page, only when putting the mysql-root-password, then I get an message that login was wrong. Somebody can tell me how to get the correct pear/MDB2#mysql? Thanks a lot, Markus PD: Strange behaviour... and it is not very helpfull that in the db.inc.php the database user must be root (and not opensips) - then it should be called correctly the database root user as in opensipsctrl too! ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] [opensips_cp]: Blank Page after Login
Hello, this is the relevant part of my /var/www/opensips-cp/config/db.inc.php : ### //database driver mysql or pgsql $config-db_driver = mysql; //database host $config-db_host = localhost; //database port - leave empty for default $config-db_port = ; //database connection user $config-db_user = root; //database connection password $config-db_pass = opensipsrw; //database name $config-db_name = opensips; if (!empty($config-db_port) ) $config-db_host = $config-db_host . : . $config-db_port; ? And this is what pear list is listing: Installed packages, channel pear.php.net: = Package Version State Archive_Tar 1.3.12 stable Auth 1.6.2 stable Auth_SASL 1.0.4 stable Console_Getopt1.3.1 stable HTTP_Request2 2.1.1 stable Log 1.12.8 stable MDB2 2.5.0b5 beta MDB2_Driver_mysql 1.5.0b4 beta Mail 1.2.0 stable Mail_Mime 1.8.4 stable Mail_mimeDecode 1.5.5 stable Net_LDAP2 2.0.9 stable Net_SMTP 1.6.1 stable Net_Socket1.0.9 stable Net_URL 1.0.15 stable Net_URL2 2.0.0 stable PEAR 1.9.5 stable Structures_Graph 1.0.4 stable XML_Util 1.2.3 stable Is that MDB2_Driver_mysql wrong here? As I told before, I am not able to get pear/MDB2#mysql: pear install MDB2#mysql Skipping package pear/MDB2, already installed as version 2.5.0b5 No valid packages found install failed I have no idea why pear does not find any valid packages of MDB2#mysql. With kind regards, Markus ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] [opensips_cp]: Blank Page after Login
Hi Markus,
You DB config and pear modules look just fine.
I've just made some tests. I try to make a mistake in my DB config and I
get this:
Warning: Creating default object from empty value in
/home/alex/_work/opensips_cp_full/opensips-cp-code/branches/6.0/config/db.inc.php
on line 25 Fatal error: Call to undefined method
MDB2_Error::setFetchMode() in
/home/alex/_work/opensips_cp_full/opensips-cp-code/branches/6.0/web/db_connect.php
on line 31
Try to editing the file : /var/www/opensips-cp/web/db_connect.php and
make it look like this :
?php
require_once(../config/db.inc.php);
require_once(MDB2.php);
global $config;
$dsn = $config-db_driver.'://' .
$config-db_user.':'.$config-db_pass . '@' . $config-db_host . '/'.
$config-db_name.'';
$link = MDB2::connect($dsn);
if(PEAR::isError($link)) {
die(Error while connecting : . $link-getMessage());
}
$link-setFetchMode(MDB2_FETCHMODE_ASSOC);
if(PEAR::isError($link)) {
die(Error while connecting : . $link-getMessage());
}
?
This will give you some extra information why the connection is not working.
If you do not get any relevant information, for example I have altered
the DB name on purpose and I get Error while connecting : MDB2 Error:
no such database, please try checking for selinux policy.
Just do a setenforce 0 as root and check again if you still experience
the issue. If you don't then it's selinux.
I hope this will solve your problem.
Regards,
Alex Ionescu
I just made some tests. If I do a
On 01/12/2015 02:11 PM, Markus Klaus Schäffauer wrote:
Hello,
this is the relevant part of my /var/www/opensips-cp/config/db.inc.php :
###
//database driver mysql or pgsql
$config-db_driver = mysql;
//database host
$config-db_host = localhost;
//database port - leave empty for default
$config-db_port = ;
//database connection user
$config-db_user = root;
//database connection password
$config-db_pass = opensipsrw;
//database name
$config-db_name = opensips;
if (!empty($config-db_port) ) $config-db_host = $config-db_host .
: . $config-db_port;
?
And this is what pear list is listing:
Installed packages, channel pear.php.net:
=
Package Version State
Archive_Tar 1.3.12 stable
Auth 1.6.2 stable
Auth_SASL 1.0.4 stable
Console_Getopt1.3.1 stable
HTTP_Request2 2.1.1 stable
Log 1.12.8 stable
MDB2 2.5.0b5 beta
MDB2_Driver_mysql 1.5.0b4 beta
Mail 1.2.0 stable
Mail_Mime 1.8.4 stable
Mail_mimeDecode 1.5.5 stable
Net_LDAP2 2.0.9 stable
Net_SMTP 1.6.1 stable
Net_Socket1.0.9 stable
Net_URL 1.0.15 stable
Net_URL2 2.0.0 stable
PEAR 1.9.5 stable
Structures_Graph 1.0.4 stable
XML_Util 1.2.3 stable
Is that MDB2_Driver_mysql wrong here?
As I told before, I am not able to get pear/MDB2#mysql:
pear install MDB2#mysql
Skipping package pear/MDB2, already installed as version 2.5.0b5
No valid packages found
install failed
I have no idea why pear does not find any valid packages of MDB2#mysql.
With kind regards,
Markus
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Call sequence in serial forking
Hi John Did you try changing the Call-ID of every INVITE? Merged Request should be generated with requests that have same From tag, Call-ID, and CSeq https://tools.ietf.org/html/rfc3261#section-8.2.2.2 Regards, On Mon, Jan 12, 2015 at 2:09 AM, John Nash john.nash...@gmail.com wrote: I am testing one setup where opensips drouting module sends call to Freeswitch and I encountered one situation ... UA sends Invite to opensips, opensips uses drouting module and sends Invite to Freeswitch , callee rejects the call and opensips sends ACK to freeswitch and sends second invite (from failure route). This second invite (which has same call id but different branch in via) is not treated as another transaction by freeswitch and it sends back SIP 482 Request merged response. I had the same setup tested using SEMS as SBC some times back successfully. I am not sure which side this issue should be taken care of (opensips or freeswitch) I looked in some freeswitch mail archives and in one post I can see someone suggesting that from opensips side we should increase Cseq in case of second invite. I think this can be done using script but I am not sure if i should do or not. This is the post http://lists.freeswitch.org/pipermail/freeswitch-users/2013-February/092600.html ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- NguyenVD ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] OpenSIPs load balancer question
Hi Bogdan, I have created three servers, and connected them in the following topology: SIPp (10.241.88.34/27) (10.241.88.36/27) OpenSIPs (10.241.88.68/27) --- (10.241.88.67/27) Asterisk On OpenSIPs Have added -- opensips_loadbalancer_2015-1-8_11\:43\:20.cfg file (see attached) And changed the UDP listen line to: listen=udp:10.241.88.36:5060 # CUSTOMIZE ME Also Added the following to MySQL mysql -uopensips -popensipsrw opensips -e INSERT INTO load_balancer VALUES(1,1,'sip:10.241.88.66:5060','pstn=500;sip=500',2,''); On Asterisk, added the following to the Asterisk configuration files: /etc/asterisk/extensions.conf [sipp] exten = 2005,1,Answer exten = 2005,2,SetMusicOnHold(default) exten = 2005,3,WaitMusicOnHold(20) exten = 2005,4,Hangup /etc/asterisk/sip.conf [sipp] type=friend context=sipp host=dynamic port=6000 user=sipp canreinvite=no disallow=all allow=ulaw On SIPp, issued: ./sipp -sn uac -d 2 -s 2005 10.241.88.36 -l 30 The SIP packets are coming out of (10.241.88.68/27) OpenSIPs interface with destination IP address of 10.241.88.36. How can I configure OpenSIPs such that OpenSIPs changes the destination IP address to 10.241.88.66? Thanks Mohammad This email and attachments may contain privileged or confidential information intended only for the addressee(s) indicated. The sender does not waive any of its rights, privileges or protections respecting this information. If you are not the named addressee, an employee, or agent responsible for sending this message to the named addressee (or this message was received by mistake), you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If received in error, please notify us immediately by e-mail, discard any paper copies and delete all electronic files of the email. Computer viruses can be transmitted via email. The recipient should check this email and any attachments for viruses. Email transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender accepts no liability for any damage caused by any transmitted viruses or errors or omissions in the contents of this message. Overture Networks, Inc. 637 Davis Drive, Morrisville, NC USA 27560 www.overturenetworks.com opensips_loadbalancer_2015-1-8_11%3A43%3A20.cfg Description: opensips_loadbalancer_2015-1-8_11%3A43%3A20.cfg ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
