Koozali.org: home of the SME Server

can't login to roundcube v 1.0

Offline davidS

  • ****
  • 80
  • +0/-0
can't login to roundcube v 1.0
« on: July 25, 2014, 02:46:30 PM »
hello
i followed the stephdl RoundCube for SME Server V1.0 installation for sme server 8
and i get en error Connection to  server failed
i tried to follow an older topic from the forum " http://forums.contribs.org/index.php?topic=50422.15 "
but with no luck .
roundcube error log message is " Login failed for admin from xxx.xxx.xxx.xxx. Could not connect to mydomain.com:143: Connection timed out in /opt/roundcube/program/lib/Roundcube/rcube_imap.php on line 184 "

also when using : mysql -u roundcube -p -e "show databases;"
+--------------------+
| Database               |
+--------------------+
| information_schema|
| roundcube             |
| test                       |
+--------------------+
IMAP is enable in the server i'm using sme server 8.1 up to date in server only mode and webmail (horde) is working perfectly

any suggestion ?

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #1 on: July 25, 2014, 04:24:27 PM »
Is it a fresh install of roundcube or you have had another installation before ?
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #2 on: July 25, 2014, 06:23:28 PM »
hi
it's a fresh installation but I uninstalled it and installed it again

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #3 on: July 25, 2014, 07:47:01 PM »
I cannot reproduce the issue it works for me, can you do the followed command and give back the return

Code: [Select]
rpm -qa *roundcube*
How i tried, full upgrade of a virtual sme8.1, then

Code: [Select]
# yum install smeserver-roundcube --enablerepo=epel,stephdl
Loaded plugins: fastestmirror, protect-packages, smeserver
Loading mirror speeds from cached hostfile
 * base: mirror.bbln.org
 * epel: mirrors.ircam.fr
 * smeaddons: mirror.absolutnet.de
 * smeextras: mirror.absolutnet.de
 * smeos: mirror.absolutnet.de
 * smeupdates: mirror.absolutnet.de
 * updates: mirrors.atosworldline.com
epel                                                     | 3.7 kB     00:00     
epel/primary_db                                          | 3.2 MB     00:05     
stephdl                                                  | 1.9 kB     00:00     
stephdl/primary_db                                       |  35 kB     00:00     
Excluding Packages from CentOS - os
Finished
Excluding Packages from CentOS - updates
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package smeserver-roundcube.noarch 0:1.1-2.el5.sme set to be updated
--> Processing Dependency: roundcube >= 1.0 for package: smeserver-roundcube
--> Processing Dependency: git for package: smeserver-roundcube
--> Running transaction check
---> Package git.i386 0:1.8.2.1-1.el5 set to be updated
--> Processing Dependency: perl-Git = 1.8.2.1-1.el5 for package: git
--> Processing Dependency: perl(Term::ReadKey) for package: git
--> Processing Dependency: perl(Git) for package: git
---> Package roundcube.noarch 0:1.0.1-2.el5.sme set to be updated
--> Processing Dependency: roundcube_plugins >= 1.0 for package: roundcube
--> Running transaction check
---> Package perl-Git.i386 0:1.8.2.1-1.el5 set to be updated
---> Package perl-TermReadKey.i386 0:2.30-4.el5 set to be updated
---> Package roundcube_plugins.noarch 0:1.0-3.el5.sme set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                  Arch        Version                Repository    Size
================================================================================
Installing:
 smeserver-roundcube      noarch      1.1-2.el5.sme          stephdl       26 k
Installing for dependencies:
 git                      i386        1.8.2.1-1.el5          epel         7.3 M
 perl-Git                 i386        1.8.2.1-1.el5          epel          49 k
 perl-TermReadKey         i386        2.30-4.el5             epel          32 k
 roundcube                noarch      1.0.1-2.el5.sme        stephdl      4.0 M
 roundcube_plugins        noarch      1.0-3.el5.sme          stephdl      945 k

Transaction Summary
================================================================================
Install       6 Package(s)
Upgrade       0 Package(s)

Total download size: 12 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): smeserver-roundcube-1.1-2.el5.sme.noarch.rpm                                                                                                                                         |  26 kB     00:00     
(2/6): perl-TermReadKey-2.30-4.el5.i386.rpm                                                                                                                                                 |  32 kB     00:00     
(3/6): perl-Git-1.8.2.1-1.el5.i386.rpm                                                                                                                                                      |  49 kB     00:00     
(4/6): roundcube_plugins-1.0-3.el5.sme.noarch.rpm                                                                                                                                           | 945 kB     00:01     
(5/6): roundcube-1.0.1-2.el5.sme.noarch.rpm                                                                                                                                                 | 4.0 MB     00:07     
(6/6): git-1.8.2.1-1.el5.i386.rpm                                                                                                                                                           | 7.3 MB     00:16     
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                              474 kB/s |  12 MB     00:26     
warning: rpmts_HdrFromFdno: Header V4 DSA signature: NOKEY, key ID f5194398
stephdl/gpgkey                                                                                                                                                                              | 1.3 kB     00:00     
Importing GPG key 0xF5194398 "stephdl-repo (Repository de Labrusse) <stephdl@de-labrusse.fr>" from http://mirror.de-labrusse.fr/RPM-GPG-KEY
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : perl-TermReadKey                                                                                                                                                                            1/6
  Installing     : roundcube                                                                                                                                                                                   2/6
  Installing     : roundcube_plugins                                                                                                                                                                           3/6
  Installing     : perl-Git                                                                                                                                                                                    4/6
  Installing     : git                                                                                                                                                                                         5/6
  Installing     : smeserver-roundcube                                                                                                                                                                         6/6
Migrating existing database yum_available
Migrating existing database yum_installed
Migrating existing database yum_repositories
Migrating existing database accounts
Migrating existing database yum_updates
Migrating existing database hosts
Migrating existing database spamassassin
Migrating existing database configuration
Migrating existing database mailpatterns
Migrating existing database backups
Migrating existing database networks
Migrating existing database domains

Installed:
  smeserver-roundcube.noarch 0:1.1-2.el5.sme                                                                                                                                                                       

Dependency Installed:
  git.i386 0:1.8.2.1-1.el5         perl-Git.i386 0:1.8.2.1-1.el5         perl-TermReadKey.i386 0:2.30-4.el5         roundcube.noarch 0:1.0.1-2.el5.sme         roundcube_plugins.noarch 0:1.0-3.el5.sme       

Complete!

==============================================================
WARNING: You now need to run BOTH of the following commands
to ensure consistent system state:

signal-event post-upgrade; signal-event reboot

You should run these commands unless you are certain that
yum made no changes to your system.
==============================================================
[root@sme8dev5 ~]# rcplugin_update.sh
Updating to version 6f80b26c3263da6fd7f64a3bde76ddfdde70f424.
    Downloading: 100%         
Use composer self-update --rollback to return to version 9896abeb380f65a146e988f51b46cdb8e1b88e01
Loading composer repositories with package information
Updating dependencies (including require-dev)
  - Installing roundcube/plugin-installer (dev-master 0.1.4)
    Cloning 0.1.4

  - Installing johndoh/markasjunk2 (dev-release-1.0 2b73dc9)
    Cloning 2b73dc9a1f128cd5a4eb041a91039e226c3855c1

  - Installing johndoh/contextmenu (dev-release-1.0 cc776d4)
    Cloning cc776d4ad88fd5d9aebfd9b0014b45669cbe1217

  - Installing johndoh/globaladdressbook (dev-release-1.0 06c23bc)
    Cloning 06c23bc5964bd37ece0d24ad70cd5a39637d3190

Writing lock file
Generating autoload files
[root@sme8dev5 ~]# signal-event conf-roundcube; signal-event console-save
[root@sme8dev5 ~]# rpm -qa *roundcube*
roundcube-1.0.1-2.el5.sme
smeserver-roundcube-1.1-2.el5.sme
roundcube_plugins-1.0-3.el5.sme

did you do that CL after the installation ?

Code: [Select]
rcplugin_update.sh

answer yes (y) for all plugins you want to activate

If you do not want to restart your server

signal-event conf-roundcube; signal-event console-save

or

signal-event post-upgrade; signal-event reboot

also it could be interesting that you return that CL

Code: [Select]
config show roundcube
« Last Edit: July 25, 2014, 07:55:16 PM by stephdl »
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #4 on: July 25, 2014, 09:31:19 PM »
thank you for your quick reply
yes i did run # rcplugin_update.sh

thist is output :
[root@secureserver ~]# rpm -qa *roundcube*
roundcube-1.0.1-2.el5.sme
roundcube_plugins-1.0-3.el5.sme
smeserver-roundcube-1.1-2.el5.sme

[root@secureserver ~]# config show roundcube
roundcube=service
    DbName=roundcube
    DbPassword=894997875745506
    DbUser=roundcube
    Name=RoundCube IMAP Client
    PluginsList=globaladdressbook,carddav,calendar,libcalendaring,contextmenu,markasjunk2,vcard_attachments,newmail_notifier,emoticons,tasklist
    PublicAccess=global
    status=enabled
i also have an sme server 9 for testing and it's working fine
« Last Edit: July 25, 2014, 09:37:33 PM by sibony88 »

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #5 on: July 25, 2014, 09:51:10 PM »
well probably something odd during the creation of the db, in the link you mentioned, the author said that he played with his mysql configuration.

I suggest that you completely remove the installation, the DB mysql and the DB of configuration, Then you could install again. As many contribs, smeserver-roundcube doesn't erase mysql DB when you remove it.

http://forums.contribs.org/index.php/topic,50422.msg254530.html#msg254530


Code: [Select]
yum clean all
yum remove smeserver-roundcube roundcube roundcube_plugins
signal-event console-save
config delete roundcube


log to mysql

Code: [Select]
mysql

then issue this command line to erase all databases and users

Code: [Select]
drop database roundcube;
USE mysql;
DELETE FROM user WHERE user = 'roundcube';
FLUSH PRIVILEGES;

then install roundcube

Code: [Select]
yum install smeserver-roundcube --enablerepo=epel,stephdl
rcplugin_update.sh
signal-event conf-roundcube; signal-event console-save
« Last Edit: July 25, 2014, 09:54:01 PM by stephdl »
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #6 on: July 26, 2014, 12:34:33 AM »
hi
i did remove and install it back but with no luck.
same error on login
"IMAP Error: Login failed for admin from 192.168.10.114. Could not connect to mydomain.com:143: Connection timed out in /opt/roundcube/program/lib/Roundcube/rcube_imap.php on line 184 "
when i look into my firewall i can see the connection on port 143 to the server but it seems that the server is refusing it

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #7 on: July 26, 2014, 10:52:52 AM »
It is the admin user you are used with the sme credentials of course, what about if you use another defined user  in the server-manager ?
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #8 on: July 26, 2014, 11:22:46 AM »
the same error with all the users

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #9 on: July 26, 2014, 11:26:35 AM »
the same error with all the users

yes, I have tested myself and the error is different

what about of
Code: [Select]
config show imap
can you do and report in a terminal

Code: [Select]
telnet localhost 143
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #10 on: July 26, 2014, 02:06:07 PM »
the output is :

[root@secureserver ~]# config show imap
imap=service
    ConcurrencyLimit=400
    ConcurrencyLimitPerIP=12
    TCPPort=143
    access=private
    status=enabled
[root@secureserver ~]# telnet localhost 143
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
* OK imapfront ready. + stunnel

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #11 on: July 26, 2014, 03:54:58 PM »
well, nothing strange, I don't understand what is occuring since it works for the test you did for sme9 and my tests on sme8. Certainly a specific problem to your server. By the way, what is the architecture of your sme8.1

What is the history of this server
an upgrade of sme7
a fresh install directly from sme8.1
do you have many clients who are using imap currently
??

Are you sure that you have removed mysql DB and configuration db before to reinstall it, as I have asked in my older post.
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #12 on: July 26, 2014, 05:33:14 PM »
my server was first installed as 8.0 and updated until now.
i did remove mysql like you said and run the "config delete roundcube" to remove the configuration db i also manually delete the folder from /opt/roundcube.
maybe there is leftovers or something
i don't have as many client so i can continue using horde and i will consider upgrading to sme9 in the future.
thank you for you time and help
if you have any more suggestion to my problem i will be happy to try.

Offline stephdl

  • *
  • 1,523
  • +0/-0
    • Linux et Geekeries
Re: can't login to roundcube v 1.0
« Reply #13 on: July 26, 2014, 05:39:23 PM »
By the way, what is the architecture of your sme8.1
not sure if it is interesting but you forget to answer
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

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

Offline davidS

  • ****
  • 80
  • +0/-0
Re: can't login to roundcube v 1.0
« Reply #14 on: July 26, 2014, 06:43:35 PM »
server only