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