[OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
Alex Ionescu
alex at opensips.org
Sat Mar 13 17:21:30 CET 2010
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 /<alex at opensips.org>/* wrote:
>
>
> From: Alex Ionescu <alex at opensips.org>
> Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
> To: "OpenSIPS users mailling list" <users at 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 at 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 at lists.opensips.org </mc/compose?to=Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
--
Alex Ionescu
www.voice-system.ro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100313/8784f18b/attachment.htm
More information about the Users
mailing list