Topic: Password problem, even after reseting it at MYSQL table through PhpmyA

Password problem, even after reseting it at MYSQL table through PhpmyAdmin. Kindly  post me solution of this problem.

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Please make a search of 'password problem', before asking the same questions.

/Joe

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Watever solution provided in the forum, i tried all of them. Still Same problem continue. Kindly help me out

4 (edited by Attila 04/19/2012 07:54:08 am)

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

hiya Joe

I have the same problem .....  reset the MD5   admin password to  5f4dcc3b5aa765d61d8327deb882cf99  'password'

Still get : Incorrect Password

The user and password combination is not valid for the system.

If you are not an authorized user, please contact your system administrator to obtain an account to enable you to use the system.
Try again

Please help

5 (edited by Attila 04/20/2012 05:02:11 am)

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Ok I resolved my Issue by doing the following:

1) Deleted the the 2.3.10 php files and copied my 2.3.9 back in the direcorory.

2) I could then loging using "password" with the admin login ( because I already done as above )

3) then coppied the new 2.3.10 php file overwrighting whate ever was in that directory.

I could then login as above and immediatly changed the passwords as needed

Peace

Attila

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Did the problem appeared after switching from 2.3.9 to 2.3.10 version?
Janusz

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

itronics wrote:

Did the problem appeared after switching from 2.3.9 to 2.3.10 version?
Janusz


Janusz - in my case yes, 

On the side I was wondering if activating Auth_LDAP  might not have caused it ?

Attila

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Hi Attila/Janusz,

  Do not activate Auth_LDAP if you do not have LDAP Server. If you have experience installed and activate Auth_LDAP and facing the Login problem. You need to De-activate it. Please follow the step below to De-activate the LDAP module.

  1) Edit the file located at FrontAccounting ROOT folder and also company folder. The company folder will start with company/0 company/1

   1.1) Open the file at installed_extensions.php, set the  'active' => false
       
       $installed_extensions = array (
  1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),
);


   1.2) Open the file at company/0/installed_extensions.php, set the  'active' => false
       
       $installed_extensions = array (
  1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),
);

  These module was submitted by myself, but if you do not have Ldap Server. It doesn't work. Hope it help.

Cheers,

tclim

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

1.1) Open the file at installed_extensions.php, set the  'active' => false
       
       $installed_extensions = array (
  1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),
);


   1.2) Open the file at company/0/installed_extensions.php, set the  'active' => false
       
       $installed_extensions = array (
  1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),
);

  These module was submitted by myself, but if you do not have Ldap Server. It doesn't work. Hope it help.

Cheers,

tclim

I tried your method without success ... version 2.3.10

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

I did the same process and it did not work..

Delete below from the installed_extensions.php should fix the problem.

1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Keep in mind that changing base installed_extension.php is not enough to deactivate the extension. You have to remove the mentioned section also from company/X/installed_extensions.php files.
Janusz

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Hi, I had the same problem. In my case the installed_extensions.php 'active' value was 1, so I changed to 0 and the problem solved.

Thank you very much.

I strongly recommend this to be wikied up to because I've tried several times to change table values and was able to access until I found this post.

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

Hi

In : moduls/auth_ldap/config_ldap.php

- you will finde :

$_ldap_config = array (
    // default configuration for all companies
    'default' => array (
        // LDAP authentication enabled?
        'enabled' => true,
        // LDAP configuration
        'ldap' => array (
            'host' => 'ldap',
            'port' => 389,
            'domain' => 'mycompany.com.au',
            'suffix' => 'dc=mycompany,dc=com,dc=au',
            'security' => 0,  // 0 = none, 1 = TLS, 2 = SSL
        ),
        // Map LDAP groups to FA roles
        // (first matching group sets the user's role)
        'group_role_map' => array (
            'Accounts Payable' => 'AP Officer',
            'Accounts Receivable' => 'AR Officer',
            'Sales' => 'Salesman',
            'Stores' => 'Purchase Officer',
            'Managers' => 'System Administrator',
            'Wheel' => 'System Administrator',
        ),
    ),
    // per-company overrides
    // (you can override 'enabled', 'ldap', or 'group_role_map' keys)
    'company' => array (
/*
        // example: this company doesn't use any LDAP authentication
        1 => array (
            'enabled' => false,
        ),
        // example: this company has some separate groups just for this company
        4 => array (
            'group_role_map' => array (
                'OtherCompany Accounts Payable' => 'AP Officer',
                'OtherCompany Accounts Receivable' => 'AR Officer',
                'OtherCompany Sales' => 'Salesman',
                'OtherCompany Stores' => 'Purchase Officer',
                'Managers' => 'System Administrator',
                'Wheel' => 'System Administrator',
            ),
        ),
*/
    ),    

- AND this is what you have to set as "false"

// example: this company doesn't use any LDAP authentication
        1 => array (
            'enabled' => false,
Bst. Rgs.,

MicCo

Re: Password problem, even after reseting it at MYSQL table through PhpmyA

This has now been wikied.