Author Topic: Login problems  (Read 4848 times)

Offline herbertbactong

  • Newbie
  • *
  • Posts: 2
Login problems
« on: September 05, 2006, 03:58:28 AM »
Hi,

This is my first time to install roundcube. Although I think I did everything correct, I can't login using roundcube.

I can see the login screen, enter the credentials, then roundcube brings be back to the login screen without any message.

I checked my IMAP logs and it does successfully log me in although right after the login successfull line, it puts in a logout line as well.

Imap is working since squirrel is OK and Oulook is OK as well.

Can somebody give me idea where to check what the problem is?

Thanks.

Offline bpat1434

  • Administrator
  • Hero Member
  • *****
  • Posts: 673
Re: Login problems
« Reply #1 on: September 05, 2006, 08:38:34 AM »
How about the Database that roundcube uses? Is that setup?

In your config files, is auto_create_user set to TRUE or FALSE? If it's false, there's the issue. You have to allow users to be entered into the database before they can check or read their email.
 
  

Offline herbertbactong

  • Newbie
  • *
  • Posts: 2
Re: Login problems
« Reply #2 on: September 05, 2006, 10:32:27 AM »
Hi,

Yes auto create is set to true. I did have problems with the DB at first so i was getting an error page. But when I fixed it (wrong db name) the login box showed up so i'm assuming the DB is working already. Besides, IMAP logs says I was able to login.

Any suggestions how to check if DB is the problem? or something else?

Thanks.

Offline Delta-9

  • Jr. Member
  • **
  • Posts: 35
Re: Login problems
« Reply #3 on: September 05, 2006, 01:05:18 PM »
If you are using MySQL you can download the "MySQL Query Browser" and connect to your database from your pc and see if roundcube is able to write (create) data to the database. You can also do this from the unix prompt with "mysql -u (user) -p" it'll then prompt you for your password. Once at the "mysql>" prompt you would enter:

use yourroundcubedatabasenamehere;
select * from users;

you should then be able to see your users in the database. In the unix shell mode, it is very hard to see that data b/c the lines wrap on your terminal prompt. If you see your user in the 'users' table, then you know that roundcube was able to create your user in the database.

Offline Paladin2187

  • Newbie
  • *
  • Posts: 2
Re: Login problems
« Reply #4 on: September 05, 2006, 03:29:26 PM »
I'm having this exact same problem. I hadn't used roundcube in a while so I did a fresh install today and now it is doing this login over and over thing. I know the DB is authenticating cause if I change the password for the database user in the db.inc.php file I get the failed to connect error. I also think the privileges are correct cause when I browse the users and identities tables in phpMyAdmin for the database for roundcube, my info shows up in there.

I tried deleting everything that was left over from the last time I used roundcube and recopied all the files but no luck. I also tried increasing the debug level to 4 but no errors appear. I can't find any errors in any of my logs either. It's like roundcube is working just fine and all it is designed to do is reload the user login screen over and over.

Offline Delta-9

  • Jr. Member
  • **
  • Posts: 35
Re: Login problems
« Reply #5 on: September 05, 2006, 08:17:13 PM »

When you did your fresh install did you follow the new instructions for the latest release? I believe there are some minor changes to the database from beta1 to beta2 that need to be followed. I also had issues trying to migrate from beta1 to beta2. I simply "dropped" the database table from MySQL and deleted the old roundcube folder and started from scratch. Doing that gave me a working version of roundcube.

Offline Paladin2187

  • Newbie
  • *
  • Posts: 2
Re: Login problems
« Reply #6 on: September 07, 2006, 01:03:07 PM »
Yeah that is what I did. I have a whole new database name, new username and password for mysql and the install is in a new folder. I followed the instructions and everything went smooth. The login actually appears to work. No logs indicate it is failing and if I do a bogus username or password I get the appropriate login failed error screen.

Grr. I'm planning on redoing this whole server this weekend anyway cause I have a bunch of new hardware for it and the OS is out of date (FreeBSD5.2 vs. 61). Maybe I'll tackle it again after that.

Offline bpat1434

  • Administrator
  • Hero Member
  • *****
  • Posts: 673
Re: Login problems
« Reply #7 on: September 07, 2006, 02:05:36 PM »
Perhaps a better idea is to turn up error logging to say "8" instead of leaving it to the logs. Then, when ANYTHING fails, you'll know, and can post the output for use to see ;)
 
  

Offline skippy

  • Newbie
  • *
  • Posts: 4
Re: Login problems
« Reply #8 on: January 05, 2007, 10:50:19 PM »
Anyone still having this problem ??

I know this topic is old but I'm having the EXACT problem.

Hmail server 4.3 b248 With external DB
Mysql 5.0
roundcubemail-0.1beta2
Windows server 2003
PHP Version 5.2.0

ran the mysql5.initial.sql script for my roundcube db

Cant login.. but in my mail server log the imap login is successfull but roundcube disconnects right away.


This is my third fresh install :-[

Offline skippy

  • Newbie
  • *
  • Posts: 4
Re: Login problems
« Reply #9 on: January 05, 2007, 10:53:37 PM »
HMAIL SERVER LOG FILE when i try to log in roundcube as user@myemail.com
"TCPIP"  3716  "2007-01-04 22:49:29.453"  "Created accept socket 1124 on listening socket 1076"
"DEBUG"  3716  "2007-01-04 22:49:29.453"  "Socket::Socket(ID: 159)"
"IMAPD"  3716  159  "2007-01-04 22:49:29.453"  "192.168.1.1"  "SENT: * OK!"
"IMAPD"  3716  159  "2007-01-04 22:49:29.468"  "192.168.1.1"  "RECEIVED: cp01 CAPABILITY"
"IMAPD"  3716  159  "2007-01-04 22:49:29.468"  "192.168.1.1"  "SENT: * CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT[nl]cp01 OK CAPABILITY completed"
"IMAPD"  3716  159  "2007-01-04 22:49:29.468"  "192.168.1.1"  "RECEIVED: a001 LOGIN user@myemail.com "mypass""
"IMAPD"  3716  159  "2007-01-04 22:49:29.468"  "192.168.1.1"  "SENT: a001 OK LOGIN completed"
"IMAPD"  3716  159  "2007-01-04 22:49:29.484"  "192.168.1.1"  "RECEIVED: I LOGOUT"
"IMAPD"  3716  159  "2007-01-04 22:49:29.484"  "192.168.1.1"  "SENT: * BYE Have a nice day[nl]I OK Logout completed"
"TCPIP"  3716  "2007-01-04 22:49:29.484"  "Disconnecting socket 1312 for session 159"
"DEBUG"  3716  "2007-01-04 22:49:29.484"  "Socket::~Socket(ID: 159)"
"DEBUG"  3668  "2007-01-04 22:49:32.562"  "TimedoutConnectionRemoverTask::DoWork()"



In my browser if i set the the roundcube debug level to 8 i see the following
Code:

* CAPABILITY IMAP4 IMAP4rev1 CHILDREN IDLE QUOTA SORT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #29


Offline skippy

  • Newbie
  • *
  • Posts: 4
Re: Login problems
« Reply #10 on: January 05, 2007, 11:05:22 PM »
ok....
Here's my latest error :
DB Error in C:\Inetpub\wwwroot\Webmail\program\include\rcube_db.inc (479): DB Error: unknown error Query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), 'user@myemail.com', 'mail.fixmicro.com', '', 'en_US') [nativecode=1364 ** Field 'preferences' doesn't have a default value]
PHP Error in C:\Inetpub\wwwroot\Webmail\program\include\main.inc (604): Failed to create new user


What should be the default value for Field 'preferences'
And why is it not there ????

i'm pretty new to php/mysql.

Offline skippy

  • Newbie
  • *
  • Posts: 4
Re: Login problems
« Reply #11 on: January 05, 2007, 11:13:55 PM »
The forums rock!!!!

all i had to do was modify the user table set the preferences field to allow NULL .