gbrowse problem user account login/registration

[apple23]

Hello,
I have this problem, I'll appreciate any help.
This is how my configuration file looks like to enable authentication for users

smtp_gateway = localhost

user_accounts = 1
user_accounts_registration = 1
user_accounts_openid = 0

user_account_db = DBI:mysql:gbrowse_login;user=gbrowse;password=gbrowse

I create users using :
gbrowse_create_account.pl -pass <password> -fullname <fullname> <username>

and then it asks for an e-mail address but it says it's optional so I skip it, and when i go to login in Gbrowse it said: Invalid username or password provided, please try again.
I looked into the database gbrowse_login and the user exists there....

I tried setting an e-mail address and I got the same problem and even I dont receive any e-mail.

What can I do to create user to login into GBrowse using the database gbrowse_login ???

Thanks in advanced,

ps: Im using GBrowse version 2.33 and mysql as database.

[pr0t3us]

Hi apple23,

I use Gbrowse 2,28 and the login works.
I see your data in the conf file and I note that in the row
"user_account_db = DBI:mysql:gbrowse_login;user=gbrowse;password=gbrowse" is not specified the host (for example "host=localhost").

For the mail I noted that the user receive a mail only if he registered using the GUI from Gbrowse.

Bye
Alessandro

[apple23]

Hello Alessandro, thank you for answer me. I did what you suggest me and still doesnt work.

My config file looks like this:
user_account_db = DBI:mysql:gbrowse_login;user=gbrowse;password=gbrowse;host=localhost

I follow this steps:
-I create an user account with:
gbrowse_create_account.pl -pass ana -fullname Ana ana

-I check it:

mysql> use gbrowse_login;
Database changed
mysql> select * from users;
+--------+-------+------------------+----------------------------------+----------+-------------+-----------+----------------------------------+---------------------+---------------------+
| userid | gecos | email | pass | remember | openid_only | confirmed | cnfrm_code | last_login | created |
+--------+-------+------------------+----------------------------------+----------+-------------+-----------+----------------------------------+---------------------+---------------------+
| 1 | Ana | [email protected] | P8mjc52f9d9202ca2baaa5cea3d138c3 | 0 | 0 | 1 | Aqx8oyC8SM7N3_DcoqmLVQKXd0zv8J9U | 2011-05-26 12:02:57 | 2011-05-26 12:01:56 |
+--------+-------+------------------+----------------------------------+----------+-------------+-----------+----------------------------------+---------------------+---------------------+

and when I go to login with ana to the GBrowse I get this:
Invalid username or password provided, please try again.

I dont know what's wrong :'(

[pr0t3us]

Hi,

this is very strange....I have the same rows.

+---------------------+----------------------------------------------+--------+----------+---------------------+---------------------------+-------------+-----------+--------------------+----------------------------------+
| last_login | pass | userid | remember | created | email | openid_only | confirmed | gecos | cnfrm_code |
+---------------------+----------------------------------------------+--------+----------+---------------------+---------------------------+-------------+-----------+--------------------+----------------------------------+
| 2011-05-19 16:40:40 | 5bnAca3ee27c04ff5b7a40d39882f3c52375b926e3d6 | 1 | 0 | 2011-05-19 16:39:32 | alex@######### | 0 | 1 | alessandro albiero | a111bd36d1ed2f775fe3e0539302f652 |
| 2011-05-23 16:52:21 | mKW3ab234b6ff0696234240c8975aa105e472d991c39 | 2 | 0 | 2011-05-23 16:51:39 | claudio.forcato@########## | 0 | 1 | claudio | 78c74286a6cd9bb6db27d541dca9a533 |
+---------------------+----------------------------------------------+--------+----------+---------------------+---------------------------+-------------+-----------+--------------------+----------------------------------+

but... the database is on the same server where run Gbrowse, is it true ?
Have you tried to register using the gbrowse page ?

[apple23]

Hi,
yes, the database in on the same server where I run GBrowse.

I've tried to register an user using gbrowse page but it's mandatory to put an e-mail address to validate the registration and I got this error:

Error: Cannot connect to mail server, an account has not been created.

and I've kept the default configuration:
smtp= localhost

I think it's important to mention that I downloaded login.sql (GBrowse 2.33) to create the database gbrowse_login, i was looking for it when I installed GBrowse and I did'nt find it so I created the database running login.sql.

[pr0t3us]

Hi,

I used this guide

http://gmod.org/wiki/GBrowse_Configuration/Authentication#GBrowse_Authentication_via_Apache.27s_Built-in_Authentication_Modules

Try to check it and let me know if after if works