Koozali.org: home of the SME Server

Roundcube login fails

Offline chrislaurie

  • *
  • 96
  • +0/-0
Re: Roundcube login fails
« Reply #15 on: December 05, 2013, 04:57:58 PM »
@janet I also saw that - not sure how that happened. Trying to work out the command line that turns them on because they do not appear in the server-manager front end.

@mmccarn - I think you are on to something. On the production server I roundcube cannot get verified by the password as specified, but admin can get a list of databases. On the other completely fresh SME8.1 neither can get access.

I veriffied this after a compete uninstall and re-install. Removed the databases and roundcube users. I say users, because when I went to remove the user there were 2 roundcube users! One with host % and onw with host: localhost. One last thing I tried, before the uninstall and re-install was to give the password in   /opt/roundcube/config/db.inc.php to the roundcube users with phpmyadmin in MySql. This had some effect: the screen looked as if the logon passed but there was an error about failure to connect as well.

Anyway I now have one user, a roundcube database, but still no luck past the Connection to storage failed.

Is it save to delete the dovecot indices?

Is the logon failure a permissions thing?

Should I try changing the password again?

Thank you all for helping me so far.

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: Roundcube login fails
« Reply #16 on: December 05, 2013, 06:27:52 PM »
just one question.
When you want to perform an authentication to roundcube do you do just with the name of your user

for example

Code: [Select]
userthen issue the password

or do you try

Code: [Select]
user@acron.biz
that is not good
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: Roundcube login fails
« Reply #17 on: December 05, 2013, 08:39:58 PM »
chrislaurie

Quote
@janet I also saw that - not sure how that happened.

Possibly a carry over from the late days of sme7 & repo changes/shutdowns if you upgraded to sme8.
You should have used the commands to reset all repos to standard.

Quote
Trying to work out the command line that turns them on because they do not appear in the server-manager front end.

You need to read the FAQ link a bit more thoroughly, see
http://wiki.contribs.org/SME_Server:Documentation:FAQ:Section01#Adding.2C_removing_or_disabling_repositories

I strongly advise you to stop troubleshooting roundcube for now, fix your repos, run yum update, post-upgrade & reboot, then once your system is up to date try again with roundcube.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline chrislaurie

  • *
  • 96
  • +0/-0
Re: Roundcube login fails
« Reply #18 on: December 05, 2013, 09:43:28 PM »
OK so I fixed the repos, ran update (it found 3 files one of them was grub). And now I am back to troubleshooting Roundcube.

The mysql login is my current suspect.

Offline chrislaurie

  • *
  • 96
  • +0/-0
Re: Roundcube login fails
« Reply #19 on: December 05, 2013, 09:57:46 PM »
I just tried to change the pasword of the roundcube user in MySql to the password in the db.inc.php.

I get past the login screen but the then there is a database connection error in the middle of the page. The mail, address book, calendar  and settings icons is visible but nothing works just the error message is shown.

Offline egareg

  • *
  • 35
  • +0/-0
Re: Roundcube login fails
« Reply #20 on: December 13, 2013, 11:29:15 AM »
Hi all !

I also tried to run RoundCube on my sme server (v8.0) but it failed when I want to access on roundcube.
I just follow the steps in the wiki (http://wiki.contribs.org/RoundCube), but I obtain an error : "DATABASE ERROR: CONNECTION FAILED!"

I tried also the database test mentionned by mmccarn. It failed (see below).
Code: [Select]
[root@sme ~]# mysql -u roundcube -p -e "show databases;"
Enter password:
ERROR 1045 (28000): Access denied for user 'roundcube'@'localhost' (using password: YES)

After all, I looked into mysql about this "odd" roundcube database. And I found... nothing !
The installation process might be incomplete because no database was created... But I didn't see any kind of error during installation process.
I don't know wich tables have to be created in this roundcube database. So I can't do it manually.

[EDIT]
I found the file mysql.initial.sql in the installation package on roundcube website.
My roundcube database is fully created, the tables also...
But the connection issue is still there...
[/EDIT]
« Last Edit: December 13, 2013, 12:01:40 PM by egareg »

Offline egareg

  • *
  • 35
  • +0/-0
Re: Roundcube login fails
« Reply #21 on: December 13, 2013, 12:33:45 PM »
Eureka !  :-P

Reading some stuff in the
Code: [Select]
/opt/roundcube/logs/errors file indicates that
Code: [Select]
Table 'roundcube.carddav_addressbooks' doesn't exist
To create it, just go to
Code: [Select]
/opt/roundcube/plugins/carddav/dbinit and execute the next command :
Code: [Select]
mysql -u roundcube -p roundcube < mysql.sql
That's it for me !  8-)

[EDIT]
The same action has to be achieved with calendar :
Code: [Select]
cd /opt/roundcube/plugins/calendar/drivers/database/sql
mysql -u roundcube -p roundcube < mysql.sql
[/EDIT]
« Last Edit: December 13, 2013, 12:48:19 PM by egareg »

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Roundcube login fails
« Reply #22 on: December 13, 2013, 12:38:49 PM »
Congratulations!

If you have the time to help, you could open a bug report about 'installation does not configure mysql database correctly' using this URL:
http://bugs.contribs.org/enter_bug.cgi?product=SME%20Contribs&component=smeserver-roundcube&short_desc=&comment=

(assuming you agree with me about what happened).

Offline egareg

  • *
  • 35
  • +0/-0
Re: Roundcube login fails
« Reply #23 on: December 13, 2013, 12:51:37 PM »
I don't have account on bugs.contribs.org and I can't create one :
Code: [Select]
You don't have permission to access /createaccount.cgi on this server.

Offline egareg

  • *
  • 35
  • +0/-0
Re: Roundcube login fails
« Reply #24 on: December 13, 2013, 12:56:22 PM »
Is it possible to update the wiki page on contribs.org ?

How could I register on the wiki ?

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Roundcube login fails
« Reply #25 on: December 13, 2013, 01:00:11 PM »
I had no trouble creating a new bugzilla account just now -

I browsed to this page and entered an email address:
http://bugs.contribs.org/createaccount.cgi

I received a bugzilla registration confirmation email within seconds, and was prompted to change my password when I clicked on the account confirmation link in the email.


Wiki accounts are created by request based on your forum account:
http://wiki.contribs.org/Help:Contents#How_to_get_a_wiki_account.3F

Offline egareg

  • *
  • 35
  • +0/-0
Re: Roundcube login fails
« Reply #26 on: December 13, 2013, 01:10:14 PM »
Ho !
Unable to register on bugzilla with my Opera browser... I tried with Firefox and it's OK !  :roll:
No matter.

I will open a bug report.

Offline egareg

  • *
  • 35
  • +0/-0
Re: Roundcube login fails
« Reply #27 on: December 19, 2013, 05:15:50 PM »
Oops !  :-?

I tried to install Tiny Tiny RSS on mys server and I noticed the same probleme : no database was created during installation...

I search around with 'database', 'MySQL' keywords and I found this page on the wiki : http://wiki.contribs.org/MySQL (not so far hidden :D ).
I noticed the MySQL root password chapter and try to reset it... just in case of... my mind said 'do it' (perhaps I did some stuff around that issue some time ago).

That's it !  8)

I think that the password for MySQL root wasn't correct. It's not a bug from the contribs, just a bug from the server manager (me!).

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: Roundcube login fails
« Reply #28 on: December 19, 2013, 06:17:48 PM »
Thanks for reporting :)
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline chrislaurie

  • *
  • 96
  • +0/-0
Re: Roundcube login fails
« Reply #29 on: January 17, 2014, 03:06:04 PM »
Still not working for me.
I reset the mysql root password.
I tested that I can connect with phpmyadmin and the show databases for the admin account.
I then un-installed roundcube, dropped the database and ensured that there is nothing that I can find left.
I then re-installed roundcube.
When I log as any of the known users I get the "Connection to storage server failed." message.
In /opt/roundcube/logs/errors I have the following entries:

[17-Jan-2014 15:46:49 +0200]: IMAP Error: Login failed for admin from 192.168.0.104. Could not connect to acron.biz:143: Connection refused in /opt/roundcube/program/lib/Round
cube/rcube_imap.php on line 184 (POST /roundcube/?_task=login&_action=login)
[17-Jan-2014 15:52:55 +0200]: IMAP Error: Login failed for chris from 192.168.0.104. Could not connect to acron.biz:143: Connection refused in /opt/roundcube/program/lib/Round
cube/rcube_imap.php on line 184 (POST /roundcube/?_task=login&_action=login)

The carddav_addressbooks table is there as is the database.

One thing using this command:

mysql -u roundcube -p -e "show databases;" fails as I do not know the roundcube user password.

Any suggestions welcomed!