Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
*Hi * *i have the same problem.i download the newest version,but with no lucky,can u tell how to solve it?* * * *ha do* haloha201 at yahoo.com users%40lists.opensips.org?Subject=%5BOpenSIPS-Users%5D%20Problem%20with%20OpenSIPS%20Control%20Panel%204.0In-Reply-To=4BA21291.9000408%40opensips.org *Mon Mar 22 11:40:43 CET 2010* - Previous message: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 http://lists.opensips.org/pipermail/users/2010-March/011525.html - Next message: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0http://lists.opensips.org/pipermail/users/2010-March/011558.html - *Messages sorted by:* [ date ]http://lists.opensips.org/pipermail/users/2010-March/date.html#11557 [ thread ]http://lists.opensips.org/pipermail/users/2010-March/thread.html#11557 [ subject ]http://lists.opensips.org/pipermail/users/2010-March/subject.html#11557 [ author ]http://lists.opensips.org/pipermail/users/2010-March/author.html#11557 -- Hi Alex i try new opensips-cp and it work fine now but i have problem with add new admin in opensips-cp webpage step1: add new admin with name : cucku step2: add successfull step3: login with username cucku -- the issue is here, there is no available tools for new admin which is added via webpage the available tool for new admin is absent :(,where do i need to add available tool for admin with name : cucku the query from mysql : mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 55 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all *** 2. row *** id: 56 first_name: cucku last_name: cucku username: cucku password: ha1: 91730b420f600d8da7817d96c20a59b9 available_tools: permissions: NULL 2 rows in set (0.00 sec) ERROR: No query specified Thank you Ha` --- On Thu, 3/18/10, Alex Ionescu alex at opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users wrote: From: Alex Ionescu alex at opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users at lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users Date: Thursday, March 18, 2010, 5:46 AM Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex Wait For Your Reply Your James ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Based on this thread (http://www.pear-forum.org/topic1244.html) , I added the following to user_management.php $resultset = $link-prepare($sql); ##added this if (PEAR::isError($resultset)) { die($resultset-getMessage() . ', ' . $resultset-getDebugInfo()); } ## $resultset-execute(); The error I got after trying to add user was this: MDB2 Error: no such field, _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE MDB2_STATEMENT_mysql_81a2b39d1bc2abeacb0359a975958e93 FROM 'INSERT INTO subscriber (last_name, first_name, username,domain,password,email_address,ha1,ha1b,datetime_created) VALUES (\'\',\'\',\'1002\',\'10.32.0.97\',\'1002\',\'c...@nvidia.com\',\'\',\'\', NOW())'] [Native code: 1054] [Native message: Unknown column 'last_name' in 'field list'] mysql describe subscriber; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(10) unsigned | NO | PRI | NULL| auto_increment | | username | char(64) | NO | MUL | || | domain| char(64) | NO | | || | password | char(25) | NO | | || | email_address | char(64) | NO | | || | ha1 | char(64) | NO | | || | ha1b | char(64) | NO | | || | rpid | char(64) | YES | | NULL|| +---+--+--+-+-++ 8 rows in set (0.00 sec) Not sure where last_name first_name come in here...?? From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of TCB Sent: Sunday, March 21, 2010 9:03 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Tried running ocp and i'm getting this error on adding users. Failed to issue query, error message : MDB2 Error: no such field I'm not getting any useful error to start tracing. TC. On Sat, Mar 20, 2010 at 12:10 AM, Christian Vo c...@nvidia.commailto:c...@nvidia.com wrote: Thanks Anca, I think that's fixed the problem with smonitor, I still can't add users though, Fatal error: Call to undefined method MDB2_Error::execute() in /srv/www/htdocs/opensips-cp/web/tools/users/user_management/user_management.php on line 223,... -Original Message- From: Anca Vamanu [mailto:a...@opensips.orgmailto:a...@opensips.org] Sent: Friday, March 19, 2010 2:41 PM To: OpenSIPS users mailling list Cc: Christian Vo Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Forward from Alex: --- Hi Christian, Please check the following : In the OpenSIPS config : - if you have loaded the mi_fifo module; loadmodule mi_fifo.so - if you have declared the correct fifo parameters (if the fifo file name is the same as in Control Panel boxes config and if it has right permissions set); - if I'm not wrong it should be something like this : modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) modparam(mi_fifo, fifo_mode, 0666) Leave the db.inc.php commented as it was before and please check the stuff above and let me know. Regards, Alex --- Christian Vo wrote: Forgot to add: I had smonitor's db.inc.php settings uncommented, Now getting this error instead [Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php on line 39, referer: http://10.32.0.97/cp/menu.php I'm very sure I installed pear and the related parts as per the install guide.. *From:* Christian Vo *Sent:* Friday, March 19, 2010 9:57 AM *To:* OpenSIPS users mailling list *Subject:* RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx Alex, Confirming that these are my settings: // each server is a box $box_id=0; // mi host:port pair || fifo_file // $boxes[$box_id]['mi']['conn']=127.0.0.1:8080http://127.0.0.1:8080; $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; // monit host:port $boxes[$box_id]['monit']['conn']=127.0.0.1:2812http://127.0.0.1:2812; $boxes[$box_id]['monit']['user']=admin; $boxes[$box_id]['monit']['pass']=monit; $boxes[$box_id]['monit']['has_ssl']=0; // description (appears in mi , monit ) $boxes[$box_id]['desc']=SIP server; At this point, Monit seems to be working, but Statistics Monitor complains Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080http://127.0.0.1/8080) *From:* users-boun...@lists.opensips.orgmailto:users-boun...@lists.opensips.org [mailto:users-boun
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Hi Alex i try new opensips-cp and it work fine now but i have problem with add new admin in opensips-cp webpage step1: add new admin with name : cucku step2: add successfull step3: login with username cucku -- the issue is here, there is no available tools for new admin which is added via webpage the available tool for new admin is absent :(,where do i need to add available tool for admin with name : cucku the query from mysql : mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 55 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all *** 2. row *** id: 56 first_name: cucku last_name: cucku username: cucku password: ha1: 91730b420f600d8da7817d96c20a59b9 available_tools: permissions: NULL 2 rows in set (0.00 sec) ERROR: No query specified Thank you Ha` --- On Thu, 3/18/10, Alex Ionescu a...@opensips.org wrote: From: Alex Ionescu a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org Date: Thursday, March 18, 2010, 5:46 AM Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Hi, When you create a new admin you must set also the permissions for this new admin account. So login in as admin and edit cucku's permissions. Regards, Alex On 3/22/2010 12:40, ha do wrote: the available tool for new admin is absen -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Tried running ocp and i'm getting this error on adding users. Failed to issue query, error message : MDB2 Error: no such field I'm not getting any useful error to start tracing. TC. On Sat, Mar 20, 2010 at 12:10 AM, Christian Vo c...@nvidia.com wrote: Thanks Anca, I think that's fixed the problem with smonitor, I still can't add users though, Fatal error: Call to undefined method MDB2_Error::execute() in /srv/www/htdocs/opensips-cp/web/tools/users/user_management/user_management.php on line 223,... -Original Message- From: Anca Vamanu [mailto:a...@opensips.org] Sent: Friday, March 19, 2010 2:41 PM To: OpenSIPS users mailling list Cc: Christian Vo Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Forward from Alex: --- Hi Christian, Please check the following : In the OpenSIPS config : - if you have loaded the mi_fifo module; loadmodule mi_fifo.so - if you have declared the correct fifo parameters (if the fifo file name is the same as in Control Panel boxes config and if it has right permissions set); - if I'm not wrong it should be something like this : modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) modparam(mi_fifo, fifo_mode, 0666) Leave the db.inc.php commented as it was before and please check the stuff above and let me know. Regards, Alex --- Christian Vo wrote: Forgot to add: I had smonitor's db.inc.php settings uncommented, Now getting this error instead [Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php on line 39, referer: http://10.32.0.97/cp/menu.php I'm very sure I installed pear and the related parts as per the install guide.. *From:* Christian Vo *Sent:* Friday, March 19, 2010 9:57 AM *To:* OpenSIPS users mailling list *Subject:* RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx Alex, Confirming that these are my settings: // each server is a box $box_id=0; // mi host:port pair || fifo_file // $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; // monit host:port $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; $boxes[$box_id]['monit']['user']=admin; $boxes[$box_id]['monit']['pass']=monit; $boxes[$box_id]['monit']['has_ssl']=0; // description (appears in mi , monit ) $boxes[$box_id]['desc']=SIP server; At this point, Monit seems to be working, but Statistics Monitor complains Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) *From:* users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] *On Behalf Of *Alex Ionescu *Sent:* Friday, March 19, 2010 1:42 AM *To:* OpenSIPS users mailling list *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi Christian, Your boxes config must look like this : $box_id=0; // mi host:port pair || fifo_file //$boxes[$box_id]['mi']['conn']=127.0.0.1:8080; //i guess you are using fifo, not xmlrpc so : $boxes[$box_id]['mi']['conn']=/tmp/opensips_proxy_fifo; // monit host:port = this is for monit to work ok $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; //you must take the username and password from the monit config file (monitrc). $boxes[$box_id]['monit']['user']=username; $boxes[$box_id]['monit']['pass']=password; // if you want to enable ssl $boxes[$box_id]['monit']['has_ssl']=1; Please re-check your config and let me know if it works now. Regards, Alex On 3/19/2010 01:42, Christian Vo wrote: New problem: So under opensips-cp/config/boxes.global.inc.php I changed the following: $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; (previously was $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; This seemed to resolve my issue with Systemà Monit However, System à Statistics Monitor , Systemà SIP Trace , System à MI Commands, and System à Dispatcher all complain with the following on-screen message Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) So I changed it back to $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; But then I notice tools/monit/local.inc.php still doesn't contain any code..?? *From:* users-boun...@lists.opensips.org mailto:users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] *On Behalf Of *Christian Vo *Sent:* Thursday, March 18, 2010 10:21 AM *To:* OpenSIPS users mailling list *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball.. (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way.) Not sure if I missed something, but I'm getting this error on-screen
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Hi Christian, Your boxes config must look like this : $box_id=0; // mi host:port pair || fifo_file //$boxes[$box_id]['mi']['conn']=127.0.0.1:8080; //i guess you are using fifo, not xmlrpc so : $boxes[$box_id]['mi']['conn']=/tmp/opensips_proxy_fifo; // monit host:port = this is for monit to work ok $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; //you must take the username and password from the monit config file (monitrc). $boxes[$box_id]['monit']['user']=username; $boxes[$box_id]['monit']['pass']=password; // if you want to enable ssl $boxes[$box_id]['monit']['has_ssl']=1; Please re-check your config and let me know if it works now. Regards, Alex On 3/19/2010 01:42, Christian Vo wrote: New problem: So under opensips-cp/config/boxes.global.inc.php I changed the following: $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; (previously was $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; This seemed to resolve my issue with Systemà Monit However, System à Statistics Monitor , Systemà SIP Trace , System à MI Commands, and System à Dispatcher all complain with the following on-screen message Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) So I changed it back to $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; But then I notice tools/monit/local.inc.php still doesn't contain any code?? *From:* users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] *On Behalf Of *Christian Vo *Sent:* Thursday, March 18, 2010 10:21 AM *To:* OpenSIPS users mailling list *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way...) Not sure if I missed something, but I'm getting this error on-screen now: Under the Systemà Monit tab I see Primary Sip Server 192.168.0.1:2812 Followed by I can't Connect Something is wrong here, since I adjusted config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be using 127.0.0.1:2812 for monit And I don't know where else I'd find any entry for 192.168.0.1 related to this.. This part was working for me back when I had the previous 4.0 tarball... odd *From:* users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] *On Behalf Of *Alex Ionescu *Sent:* Thursday, March 18, 2010 4:46 AM *To:* OpenSIPS users mailling list *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex On 3/18/2010 13:35, ha do wrote: HI Alex did you find new issue on opensips cp Thank you Ha` --- On *Sat, 3/13/10, Alex Ionescu /a...@opensips.org mailto:a...@opensips.org/* wrote: From: Alex Ionescu a...@opensips.org mailto:a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org mailto:users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 58 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all so i am still getting the invalid username on opensips-cp version 4 the i remove the folder opensips-cp version 4 and replace with opensips-cp version 3 and now it works without problem with opensips-cp version 3 i dont change anything and step i do : step 1. cd /var/www step 2. delete folder opensips-cp step 3. download the opensips-cp_3.0.tar.gz step 4. untar the file opensips-cp_3.0 step 5. chown www-data:www-data opensips-cp -R Thank you for your help Ha --- On *Fri, 3/12/10, Alex Ionescu /a...@opensips.org /mc/compose?to=a...@opensips.org/* wrote: From: Alex Ionescu a...@opensips.org /mc/compose?to=a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org /mc/compose?to=us...@lists.opensips.org Date: Friday, March 12, 2010, 9:02 AM Sorry, My mistake ... the MD5 should be applied on the value not on the field name ... So, it is : INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin',md5('admin:admin'),'all','all'); On 3/12/2010 13:06, Alex Ionescu wrote: Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Forgot to add: I had smonitor's db.inc.php settings uncommented, Now getting this error instead [Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php on line 39, referer: http://10.32.0.97/cp/menu.php I'm very sure I installed pear and the related parts as per the install guide.. From: Christian Vo Sent: Friday, March 19, 2010 9:57 AM To: OpenSIPS users mailling list Subject: RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx Alex, Confirming that these are my settings: // each server is a box $box_id=0; // mi host:port pair || fifo_file // $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; // monit host:port $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; $boxes[$box_id]['monit']['user']=admin; $boxes[$box_id]['monit']['pass']=monit; $boxes[$box_id]['monit']['has_ssl']=0; // description (appears in mi , monit ) $boxes[$box_id]['desc']=SIP server; At this point, Monit seems to be working, but Statistics Monitor complains Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Friday, March 19, 2010 1:42 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi Christian, Your boxes config must look like this : $box_id=0; // mi host:port pair || fifo_file //$boxes[$box_id]['mi']['conn']=127.0.0.1:8080; //i guess you are using fifo, not xmlrpc so : $boxes[$box_id]['mi']['conn']=/tmp/opensips_proxy_fifo; // monit host:port = this is for monit to work ok $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; //you must take the username and password from the monit config file (monitrc). $boxes[$box_id]['monit']['user']=username; $boxes[$box_id]['monit']['pass']=password; // if you want to enable ssl $boxes[$box_id]['monit']['has_ssl']=1; Please re-check your config and let me know if it works now. Regards, Alex On 3/19/2010 01:42, Christian Vo wrote: New problem: So under opensips-cp/config/boxes.global.inc.php I changed the following: $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; (previously was $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; This seemed to resolve my issue with System-- Monit However, System -- Statistics Monitor , System-- SIP Trace , System -- MI Commands, and System -- Dispatcher all complain with the following on-screen message Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) So I changed it back to $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; But then I notice tools/monit/local.inc.php still doesn't contain any code?? From: users-boun...@lists.opensips.orgmailto:users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Christian Vo Sent: Thursday, March 18, 2010 10:21 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way...) Not sure if I missed something, but I'm getting this error on-screen now: Under the System-- Monit tab I see Primary Sip Server 192.168.0.1:2812 Followed by I can't Connect Something is wrong here, since I adjusted config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be using 127.0.0.1:2812 for monit And I don't know where else I'd find any entry for 192.168.0.1 related to this.. This part was working for me back when I had the previous 4.0 tarball... odd From: users-boun...@lists.opensips.orgmailto:users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Thursday, March 18, 2010 4:46 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex On 3/18/2010 13:35, ha do wrote: HI Alex did you find new issue on opensips cp Thank you Ha` --- On Sat, 3/13/10, Alex Ionescu a...@opensips.orgmailto:a...@opensips.org wrote: From: Alex Ionescu a...@opensips.orgmailto:a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.orgmailto:users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Thx Alex, Confirming that these are my settings: // each server is a box $box_id=0; // mi host:port pair || fifo_file // $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; // monit host:port $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; $boxes[$box_id]['monit']['user']=admin; $boxes[$box_id]['monit']['pass']=monit; $boxes[$box_id]['monit']['has_ssl']=0; // description (appears in mi , monit ) $boxes[$box_id]['desc']=SIP server; At this point, Monit seems to be working, but Statistics Monitor complains Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Friday, March 19, 2010 1:42 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi Christian, Your boxes config must look like this : $box_id=0; // mi host:port pair || fifo_file //$boxes[$box_id]['mi']['conn']=127.0.0.1:8080; //i guess you are using fifo, not xmlrpc so : $boxes[$box_id]['mi']['conn']=/tmp/opensips_proxy_fifo; // monit host:port = this is for monit to work ok $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; //you must take the username and password from the monit config file (monitrc). $boxes[$box_id]['monit']['user']=username; $boxes[$box_id]['monit']['pass']=password; // if you want to enable ssl $boxes[$box_id]['monit']['has_ssl']=1; Please re-check your config and let me know if it works now. Regards, Alex On 3/19/2010 01:42, Christian Vo wrote: New problem: So under opensips-cp/config/boxes.global.inc.php I changed the following: $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; (previously was $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; This seemed to resolve my issue with System-- Monit However, System -- Statistics Monitor , System-- SIP Trace , System -- MI Commands, and System -- Dispatcher all complain with the following on-screen message Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) So I changed it back to $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; But then I notice tools/monit/local.inc.php still doesn't contain any code?? From: users-boun...@lists.opensips.orgmailto:users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Christian Vo Sent: Thursday, March 18, 2010 10:21 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way...) Not sure if I missed something, but I'm getting this error on-screen now: Under the System-- Monit tab I see Primary Sip Server 192.168.0.1:2812 Followed by I can't Connect Something is wrong here, since I adjusted config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be using 127.0.0.1:2812 for monit And I don't know where else I'd find any entry for 192.168.0.1 related to this.. This part was working for me back when I had the previous 4.0 tarball... odd From: users-boun...@lists.opensips.orgmailto:users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Thursday, March 18, 2010 4:46 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex On 3/18/2010 13:35, ha do wrote: HI Alex did you find new issue on opensips cp Thank you Ha` --- On Sat, 3/13/10, Alex Ionescu a...@opensips.orgmailto:a...@opensips.org wrote: From: Alex Ionescu a...@opensips.orgmailto:a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.orgmailto:users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 58 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all so i am still getting the invalid username on opensips-cp version 4 the i remove the folder opensips-cp version 4 and replace with opensips-cp version 3 and now it works without problem with opensips-cp version 3 i dont change anything and step i do : step 1. cd /var/www step 2. delete folder opensips-cp step 3. download the opensips-cp_3.0
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Thanks Anca, I think that's fixed the problem with smonitor, I still can't add users though, Fatal error: Call to undefined method MDB2_Error::execute() in /srv/www/htdocs/opensips-cp/web/tools/users/user_management/user_management.php on line 223,... -Original Message- From: Anca Vamanu [mailto:a...@opensips.org] Sent: Friday, March 19, 2010 2:41 PM To: OpenSIPS users mailling list Cc: Christian Vo Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Forward from Alex: --- Hi Christian, Please check the following : In the OpenSIPS config : - if you have loaded the mi_fifo module; loadmodule mi_fifo.so - if you have declared the correct fifo parameters (if the fifo file name is the same as in Control Panel boxes config and if it has right permissions set); - if I'm not wrong it should be something like this : modparam(mi_fifo, fifo_name, /tmp/opensips_fifo) modparam(mi_fifo, fifo_mode, 0666) Leave the db.inc.php commented as it was before and please check the stuff above and let me know. Regards, Alex --- Christian Vo wrote: Forgot to add: I had smonitor's db.inc.php settings uncommented, Now getting this error instead [Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP Fatal error: Call to undefined method MDB2_Error::setFetchMode() in /srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php on line 39, referer: http://10.32.0.97/cp/menu.php I'm very sure I installed pear and the related parts as per the install guide.. *From:* Christian Vo *Sent:* Friday, March 19, 2010 9:57 AM *To:* OpenSIPS users mailling list *Subject:* RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx Alex, Confirming that these are my settings: // each server is a box $box_id=0; // mi host:port pair || fifo_file // $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; // monit host:port $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; $boxes[$box_id]['monit']['user']=admin; $boxes[$box_id]['monit']['pass']=monit; $boxes[$box_id]['monit']['has_ssl']=0; // description (appears in mi , monit ) $boxes[$box_id]['desc']=SIP server; At this point, Monit seems to be working, but Statistics Monitor complains Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) *From:* users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] *On Behalf Of *Alex Ionescu *Sent:* Friday, March 19, 2010 1:42 AM *To:* OpenSIPS users mailling list *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi Christian, Your boxes config must look like this : $box_id=0; // mi host:port pair || fifo_file //$boxes[$box_id]['mi']['conn']=127.0.0.1:8080; //i guess you are using fifo, not xmlrpc so : $boxes[$box_id]['mi']['conn']=/tmp/opensips_proxy_fifo; // monit host:port = this is for monit to work ok $boxes[$box_id]['monit']['conn']=127.0.0.1:2812; //you must take the username and password from the monit config file (monitrc). $boxes[$box_id]['monit']['user']=username; $boxes[$box_id]['monit']['pass']=password; // if you want to enable ssl $boxes[$box_id]['monit']['has_ssl']=1; Please re-check your config and let me know if it works now. Regards, Alex On 3/19/2010 01:42, Christian Vo wrote: New problem: So under opensips-cp/config/boxes.global.inc.php I changed the following: $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; (previously was $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; This seemed to resolve my issue with Systemà Monit However, System à Statistics Monitor , Systemà SIP Trace , System à MI Commands, and System à Dispatcher all complain with the following on-screen message Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) So I changed it back to $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; But then I notice tools/monit/local.inc.php still doesn't contain any code..?? *From:* users-boun...@lists.opensips.org mailto:users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] *On Behalf Of *Christian Vo *Sent:* Thursday, March 18, 2010 10:21 AM *To:* OpenSIPS users mailling list *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball.. (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way.) Not sure if I missed something, but I'm getting this error on-screen now: Under the Systemà Monit tab I see Primary Sip Server 192.168.0.1:2812 Followed by I can't Connect Something is wrong here, since I adjusted config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be using 127.0.0.1:2812 for monit And I don't know where else I'd find any entry for 192.168.0.1 related to this.. This part was working for me back when
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
HI Alex did you find new issue on opensips cp Thank youHa` --- On Sat, 3/13/10, Alex Ionescu a...@opensips.org wrote: From: Alex Ionescu a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 58 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all so i am still getting the invalid username on opensips-cp version 4 the i remove the folder opensips-cp version 4 and replace with opensips-cp version 3 and now it works without problem with opensips-cp version 3 i dont change anything and step i do : step 1. cd /var/www step 2. delete folder opensips-cp step 3. download the opensips-cp_3.0.tar.gz step 4. untar the file opensips-cp_3.0 step 5. chown www-data:www-data opensips-cp -R Thank you for your help Ha --- On Fri, 3/12/10, Alex Ionescu a...@opensips.org wrote: From: Alex Ionescu a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org Date: Friday, March 12, 2010, 9:02 AM Sorry, My mistake ... the MD5 should be applied on the value not on the field name ... So, it is : INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin',md5('admin:admin'),'all','all'); On 3/12/2010 13:06, Alex Ionescu wrote: Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); You must encode the ha1 field. So, I believe that the correct query would be : INSERT INTO ocp_admin_privileges (username,password,md5(ha1),available_tools,permissions) values ('admin','admin','admin:admin','all','all'); Anyway, you can always check the INSTALL file (I think the query is located on line 102 or 103). Regards, Alex On 3/12/2010 12:41, Do Nguyen Ha wrote: step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.ro -Inline Attachment Follows- ___ 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 -- Alex Ionescu www.voice-system.ro -Inline Attachment Follows- ___ 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] Problem with OpenSIPS Control Panel 4.0
Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex On 3/18/2010 13:35, ha do wrote: HI Alex did you find new issue on opensips cp Thank you Ha` --- On *Sat, 3/13/10, Alex Ionescu /a...@opensips.org/* wrote: From: Alex Ionescu a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 58 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all so i am still getting the invalid username on opensips-cp version 4 the i remove the folder opensips-cp version 4 and replace with opensips-cp version 3 and now it works without problem with opensips-cp version 3 i dont change anything and step i do : step 1. cd /var/www step 2. delete folder opensips-cp step 3. download the opensips-cp_3.0.tar.gz step 4. untar the file opensips-cp_3.0 step 5. chown www-data:www-data opensips-cp -R Thank you for your help Ha --- On *Fri, 3/12/10, Alex Ionescu /a...@opensips.org/* wrote: From: Alex Ionescu a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org Date: Friday, March 12, 2010, 9:02 AM Sorry, My mistake ... the MD5 should be applied on the value not on the field name ... So, it is : INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin',md5('admin:admin'),'all','all'); On 3/12/2010 13:06, Alex Ionescu wrote: Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); You must encode the *ha1* field. So, I believe that the correct query would be : INSERT INTO ocp_admin_privileges (username,password,md5(ha1),available_tools,permissions) values ('admin','admin','admin:admin','all','all'); Anyway, you can always check the INSTALL file (I think the query is located on line 102 or 103). Regards, Alex On 3/12/2010 12:41, Do Nguyen Ha wrote: step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.ro -Inline Attachment Follows- ___ 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 -- Alex Ionescu www.voice-system.ro -Inline Attachment Follows- ___ Users mailing list Users@lists.opensips.org /mc/compose?to=us...@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 -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way...) Not sure if I missed something, but I'm getting this error on-screen now: Under the System-- Monit tab I see Primary Sip Server 192.168.0.1:2812 Followed by I can't Connect Something is wrong here, since I adjusted config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be using 127.0.0.1:2812 for monit And I don't know where else I'd find any entry for 192.168.0.1 related to this.. This part was working for me back when I had the previous 4.0 tarball... odd From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Thursday, March 18, 2010 4:46 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex On 3/18/2010 13:35, ha do wrote: HI Alex did you find new issue on opensips cp Thank you Ha` --- On Sat, 3/13/10, Alex Ionescu a...@opensips.orgmailto:a...@opensips.org wrote: From: Alex Ionescu a...@opensips.orgmailto:a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.orgmailto:users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 58 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all so i am still getting the invalid username on opensips-cp version 4 the i remove the folder opensips-cp version 4 and replace with opensips-cp version 3 and now it works without problem with opensips-cp version 3 i dont change anything and step i do : step 1. cd /var/www step 2. delete folder opensips-cp step 3. download the opensips-cp_3.0.tar.gz step 4. untar the file opensips-cp_3.0 step 5. chown www-data:www-data opensips-cp -R Thank you for your help Ha --- On Fri, 3/12/10, Alex Ionescu a...@opensips.org/mc/compose?to=a...@opensips.org wrote: From: Alex Ionescu a...@opensips.org/mc/compose?to=a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org/mc/compose?to=us...@lists.opensips.org Date: Friday, March 12, 2010, 9:02 AM Sorry, My mistake ... the MD5 should be applied on the value not on the field name ... So, it is : INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin',md5('admin:admin'),'all','all'); On 3/12/2010 13:06, Alex Ionescu wrote: Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); You must encode the ha1 field. So, I believe that the correct query would be : INSERT INTO ocp_admin_privileges (username,password,md5(ha1),available_tools,permissions) values ('admin','admin','admin:admin','all','all'); Anyway, you can always check the INSTALL file (I think the query is located on line 102 or 103). Regards, Alex On 3/12/2010 12:41, Do Nguyen Ha wrote: step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); -- Alex Ionescu www.voice-system.rohttp://www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.rohttp://www.voice-system.ro -Inline Attachment Follows- ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org/mc/compose?to=us...@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.rohttp://www.voice-system.ro -Inline Attachment Follows- ___ Users mailing list Users@lists.opensips.org/mc/compose?to=us...@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.orgmailto:Users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
New problem: So under opensips-cp/config/boxes.global.inc.php I changed the following: $boxes[$box_id]['mi']['conn']=127.0.0.1:8080; (previously was $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; This seemed to resolve my issue with System-- Monit However, System -- Statistics Monitor , System-- SIP Trace , System -- MI Commands, and System -- Dispatcher all complain with the following on-screen message Cannot connect to OpenSIPS Server via Management Interface (127.0.0.1/8080) So I changed it back to $boxes[$box_id]['mi']['conn']=/tmp/opensips_fifo; But then I notice tools/monit/local.inc.php still doesn't contain any code?? From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Christian Vo Sent: Thursday, March 18, 2010 10:21 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Thx for the notice, I've just downloaded and re-installed the lastest 4.0 tarball (moved the old dir to backup, and replaced it with the new, re-adjusting config parameters along the way...) Not sure if I missed something, but I'm getting this error on-screen now: Under the System-- Monit tab I see Primary Sip Server 192.168.0.1:2812 Followed by I can't Connect Something is wrong here, since I adjusted config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be using 127.0.0.1:2812 for monit And I don't know where else I'd find any entry for 192.168.0.1 related to this.. This part was working for me back when I had the previous 4.0 tarball... odd From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Alex Ionescu Sent: Thursday, March 18, 2010 4:46 AM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 Hi, Actually there were a few issues that were found and solved the last few days. I hope you won't have anymore problems if you download the new 4.0 tarball. So, give it a try and let me know. Regards, Alex On 3/18/2010 13:35, ha do wrote: HI Alex did you find new issue on opensips cp Thank you Ha` --- On Sat, 3/13/10, Alex Ionescu a...@opensips.orgmailto:a...@opensips.org wrote: From: Alex Ionescu a...@opensips.orgmailto:a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.orgmailto:users@lists.opensips.org Date: Saturday, March 13, 2010, 9:21 AM Hi, I will investigate the problem and will let you know if I find any issue. Regards, Alex On 3/13/2010 06:39, Do Nguyen Ha wrote: Hi Alex here is mysql query: mysql select * from ocp_admin_privileges\G; *** 1. row *** id: 58 first_name: last_name: username: admin password: admin ha1: d2abaa37a7c3db1137d385e1d8c15fd2 available_tools: all permissions: all so i am still getting the invalid username on opensips-cp version 4 the i remove the folder opensips-cp version 4 and replace with opensips-cp version 3 and now it works without problem with opensips-cp version 3 i dont change anything and step i do : step 1. cd /var/www step 2. delete folder opensips-cp step 3. download the opensips-cp_3.0.tar.gz step 4. untar the file opensips-cp_3.0 step 5. chown www-data:www-data opensips-cp -R Thank you for your help Ha --- On Fri, 3/12/10, Alex Ionescu a...@opensips.org/mc/compose?to=a...@opensips.org wrote: From: Alex Ionescu a...@opensips.org/mc/compose?to=a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org/mc/compose?to=us...@lists.opensips.org Date: Friday, March 12, 2010, 9:02 AM Sorry, My mistake ... the MD5 should be applied on the value not on the field name ... So, it is : INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin',md5('admin:admin'),'all','all'); On 3/12/2010 13:06, Alex Ionescu wrote: Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); You must encode the ha1 field. So, I believe that the correct query would be : INSERT INTO ocp_admin_privileges (username,password,md5(ha1),available_tools,permissions) values ('admin','admin','admin:admin','all','all'); Anyway, you can always check the INSTALL file (I think the query is located on line 102 or 103). Regards, Alex On 3/12/2010 12:41, Do Nguyen Ha wrote: step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); -- Alex Ionescu www.voice-system.rohttp://www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
HI Alex i have the same issue : Invalid Username / Password do i miss something to do Please help Thank you Ha` and the step i did: step 1. apt-get install apache2 php5 step 2. apt-get install php5-mysql php5-xmlrpc php-pear step 3. pear install MDB2 step 4. pear install MDB2#mysql step 5. pear install log step 6. vi /etc/apache2/httpd.conf - add Alias /cp /var/www/opensips-cp/web step 7. vi /etc/apache2/apache2.conf - add Alias /cp /var/www/opensips-cp/web step 8. chown www-data:www-data opensips-cp -R step 9. vi /etc/php5/apache2/php.ini - insert extension=mysql.so + extension=xmlrpc.so step 10. mysql -Dopensips -p ocp_admin_privileges.mysql step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); --- On Thu, 3/11/10, Alex Ionescu a...@opensips.org wrote: From: Alex Ionescu a...@opensips.org Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 To: OpenSIPS users mailling list users@lists.opensips.org Date: Thursday, March 11, 2010, 5:15 AM Hi, Did you add the first admin account using the query provided in the INSTALL file ? Because if you did it should have worked without changing the value of $config-admin_passwd_mode from 1 to 0. Regards, Alex Ionescu On 3/11/2010 13:51, TCB wrote: Hi, Had the same problem, change $config-admin_passwd_mode=1; to $config-admin_passwd_mode=0; in opensips-cp/config/globals.php and it worked. I dont know is this is the right way. regards On Thu, Mar 11, 2010 at 2:29 AM, er...@netcrc.net wrote: I have the following problem With install OpenSIPS 1.6 and Control Panel 4.0. When try the access the Control Panel didn't accept the user o password (Invalid Username / Password) With the commands opensips-c, monit-t said that the configuration files are fine. I can register phone. The question is how do I know the password to the web interface, try to file db.inc.php, boxes.global.inc.php, or if I have to change something in the database The reference for the installation of the control panel are Book OpenSIPS 1.6 and the link http://opensips-cp.sourceforge.net/ , but both have differences This is my first time with OpenSIPS I appreciate the help Thanks Erick Ch. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- TC ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.ro -Inline Attachment Follows- ___ 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] Problem with OpenSIPS Control Panel 4.0
Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); You must encode the *ha1* field. So, I believe that the correct query would be : INSERT INTO ocp_admin_privileges (username,password,md5(ha1),available_tools,permissions) values ('admin','admin','admin:admin','all','all'); Anyway, you can always check the INSTALL file (I think the query is located on line 102 or 103). Regards, Alex On 3/12/2010 12:41, Do Nguyen Ha wrote: step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Sorry, My mistake ... the MD5 should be applied on the value not on the field name ... So, it is : INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin',md5('admin:admin'),'all','all'); On 3/12/2010 13:06, Alex Ionescu wrote: Hi, The problem seems to be your step 11 : step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); You must encode the *ha1* field. So, I believe that the correct query would be : INSERT INTO ocp_admin_privileges (username,password,md5(ha1),available_tools,permissions) values ('admin','admin','admin:admin','all','all'); Anyway, you can always check the INSTALL file (I think the query is located on line 102 or 103). Regards, Alex On 3/12/2010 12:41, Do Nguyen Ha wrote: step 11. INSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions) values ('admin','admin','admin:admin','all','all'); -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Hi, Had the same problem, change $config-admin_passwd_mode=1; to $config-admin_passwd_mode=0; in opensips-cp/config/globals.php and it worked. I dont know is this is the right way. regards On Thu, Mar 11, 2010 at 2:29 AM, er...@netcrc.net wrote: I have the following problem With install OpenSIPS 1.6 and Control Panel 4.0. When try the access the Control Panel didn't accept the user o password (Invalid Username / Password) With the commands opensips-c, monit-t said that the configuration files are fine. I can register phone. The question is how do I know the password to the web interface, try to file db.inc.php, boxes.global.inc.php, or if I have to change something in the database The reference for the installation of the control panel are Book OpenSIPS 1.6 and the link http://opensips-cp.sourceforge.net/ , but both have differences This is my first time with OpenSIPS I appreciate the help Thanks Erick Ch. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- TC ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Hi, From your post I understand that you are trying to access the Control Panel using a SIP user username + password. You can only log in into CP using administrator account + password. (You can add one or more admin accounts if you want). If you read the INSTALL file you will see how to add *the first admin* account into the DB (check lines 103 104). In config/globals.php : if you change *$config**-admin_passwd_mode* from 1 (which is default - and means that the password is encoded in MD5) to 0 it will allow you to use plain text passwords for the admin accounts that you will add from the interface. If you read in the INSTALL file you will see that the first admin account is added using both an encoded and plain text password. So, the first admin should be able to log in regardless the value of $config-admin_passwd_mode. I hope this helps you. Regards, Alex On 21:59, Erick Chinchilla Berrocal wrote: I have the following problem With install OpenSIPS 1.6 and Control Panel 4.0. When try the access the Control Panel didn't accept the user o password (Invalid Username / Password) With the commands opensips-c, monit-t said that the configuration files are fine. I can register phone. The question is how do I know the password to the web interface, try to file db.inc.php, boxes.global.inc.php, or if I have to change something in the database The reference for the installation of the control panel are Book OpenSIPS 1.6 and the link http://opensips-cp.sourceforge.net/ , but both have differences This is my first time with OpenSIPS I appreciate the help Thanks Erick Ch. __ Information from ESET NOD32 Antivirus, version of virus signature database 3997 (20090409) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ___ 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] Problem with OpenSIPS Control Panel 4.0
Hi, Did you add the first admin account using the query provided in the INSTALL file ? Because if you did it should have worked without changing the value of *$config-admin_passwd_mode* from 1 to 0. Regards, Alex Ionescu On 3/11/2010 13:51, TCB wrote: Hi, Had the same problem, change $config-admin_passwd_mode=1; to $config-admin_passwd_mode=0; in opensips-cp/config/globals.php and it worked. I dont know is this is the right way. regards On Thu, Mar 11, 2010 at 2:29 AM, er...@netcrc.net mailto:er...@netcrc.net wrote: I have the following problem With install OpenSIPS 1.6 and Control Panel 4.0. When try the access the Control Panel didn't accept the user o password (Invalid Username / Password) With the commands opensips-c, monit-t said that the configuration files are fine. I can register phone. The question is how do I know the password to the web interface, try to file db.inc.php, boxes.global.inc.php, or if I have to change something in the database The reference for the installation of the control panel are Book OpenSIPS 1.6 and the link http://opensips-cp.sourceforge.net/ , but both have differences This is my first time with OpenSIPS I appreciate the help Thanks Erick Ch. ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- TC ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Alex Ionescu www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Thanks for your help, It's working, I will continue testing. Regards Erick Ch. Hi, Had the same problem, change $config-admin_passwd_mode=1; to $config-admin_passwd_mode=0; in opensips-cp/config/globals.php and it worked. I dont know is this is the right way. regards On Thu, Mar 11, 2010 at 2:29 AM, er...@netcrc.net wrote: I have the following problem With install OpenSIPS 1.6 and Control Panel 4.0. When try the access the Control Panel didn't accept the user o password (Invalid Username / Password) With the commands opensips-c, monit-t said that the configuration files are fine. I can register phone. The question is how do I know the password to the web interface, try to file db.inc.php, boxes.global.inc.php, or if I have to change something in the database The reference for the installation of the control panel are Book OpenSIPS 1.6 and the link http://opensips-cp.sourceforge.net/ , but both have differences This is my first time with OpenSIPS I appreciate the help Thanks Erick Ch. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- TC ___ 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