A user will change from New state to Active only once he has logged in once.

If your user cannot log in, you might want to search in database if your user has a password and is active.

For that do the following request in your database:

SELECT * FROM res_users WHERE login = '<login>';

If column password is empty this means you didn't properly set the password.

You can go in OpenERP in User's form click on Options -> Set password on top of the form.

You can also change the password in db:

UPDATE res_users SET password = '<new_password>' WHERE login = '<login>';

Otherwise, it might be the active field which is set to False.

If you don't see the created user in users list, you have to add an advanced filter, active = False in the search bar. Then open the user, check the active box and save.

You also can change it in db:

UPDATE res_users SET active = TRUE WHERE login = '<login>';