Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0

[Alex Ionescu]

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 </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