Forums

Resolved
0 votes
Hi guys I have tried to fix this but have come up against dead end. I purchased Roundcube to avoid this kind of issue. there are no files in /var/log/roundcubemail/
Where else should I look?
Friday, August 07 2015, 04:02 AM
Share this post:
Responses (17)
  • Accepted Answer

    Wednesday, August 12 2015, 01:33 PM - #Permalink
    Resolved
    0 votes
    Hi Nick thanks again for all your support:
    I have completed the installation this time and it has finally worked - I think the issue was the repos I was using - I forgot to disable the epels repo after the first clear out of roundcube.
    Thanks for your patience and excellent support.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 12 2015, 12:43 PM - #Permalink
    Resolved
    0 votes
    You should not have to follow any instructions to install and they'd be wrong. I think the instructions you are following are for a fully manual installation and not an rpm based installation. Also the ClearOS package should integrate with system-mysql and the database login string should have a port number in it. The setting up of the configuration file should be automatic.

    Also from v1.0 the configuration files moved from 2 files in /etc/roundcubemail to config/config.inc.php which will be under wherever the main roundcubemail installation is (/usr/share/rounducbemail?).

    Which package of Roundcube do you have installed? The one in clearos-contribs is 1.0.5. Can I suggest clearing everything out again and installung with:
    yum install app-roundcubemail
    This should install the three packages and tell you which repos they are coming from. Please make a note of the repo for roundcubemail. It should be clearos-contribs and be version 1.0.5. If it does not set up a config/config.inc.php file in the right place, please post back. Also make a note of any errors.

    There is an installation script somewhere under /usr/clearos/roundcubemail which you may have to run manually if ClearOS detects that the app has already been installed once.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 12 2015, 12:22 PM - #Permalink
    Resolved
    0 votes
    More info -
    there is no config dir in the /usr/share/roundcubemail/ for the config.Inc.php file to be placed in - yes I could create it but it seems that the /etc/rouncubemail folder is the correct location for the file.

    [root@mail ~]# ls -l /usr/share/roundcubemail/
    total 52
    drwxr-xr-x 2 root root 4096 Aug 12 19:22 bin
    -rw-r--r-- 1 root root 381 Jun 5 23:15 composer.json-dist
    -rw-r--r-- 1 root root 12962 Jun 5 23:15 index.php
    drwxr-xr-x 3 root root 4096 Aug 12 19:22 installer
    drwxr-xr-x 33 root root 4096 Aug 12 19:22 plugins
    drwxr-xr-x 8 root root 4096 Aug 12 19:22 program
    -rw-r--r-- 1 root root 3833 Jun 5 23:15 README.md
    -rw-r--r-- 1 root root 26 Jun 5 23:15 robots.txt
    drwxr-xr-x 4 root root 4096 Aug 12 19:22 skins
    drwxr-xr-x 6 root root 4096 Aug 12 19:22 SQL
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 12 2015, 10:37 AM - #Permalink
    Resolved
    0 votes
    Hi Nick after removal and re-installation I have run the webmail/installer script and created the config.inc.php file in /etc/roundcubemail - using the password found in /var/clearos/system_database/roundcubemail
    [root@mail ~]# ls -l /var/clearos/system_database/
    total 16
    -rw-------. 1 root root 40 Jul 30 2014 reports
    -rw-------. 1 root root 52 Jul 30 2014 root
    -rw------- 1 root root 32 Aug 12 19:57 roundcubemail
    drwxr-xr-x. 2 root root 4096 Jul 30 2014 state


    According to the instructions
     Copy or download the following configuration and save it as config.inc.php within the /etc/roundcubemail/ directory of your Roundcube installation.
    Make sure that there are no characters outside the <?php ?> brackets when saving the file.

    /etc/roundcubemail is the location where that file belongs.
    I checked /usr/share/roundcubemail/config/config.Inc.php and there is no file there. should I move the file to that location?
    I am still getting a password error in the config script
    Check DB config

    DSN (write): NOT OK(SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES))
    Make sure that the configured database exists and that the user has write privileges
    DSN: mysql://roundcube:xxxxxxxxxxxxxxx@localhost/roundcubemail
    (password removed)
    Thanks for all your help so far can you point me in the direction to get this sorted, please?
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 12 2015, 07:23 AM - #Permalink
    Resolved
    0 votes
    OK you have an installation error. Never run with clearos-epel permanently enabled. The team try to block installation of many of the incompatible packages, but not this one. Also my instructions for the manual installation were from way before the app was packaged by ClearOS, and as I said earlier, when they packaged it they changed it to use system-mysql and also integrated sieve filtering.

    I'd suggest you remove all traces of roundcube and start again. You can probably do:
    yum remove app-roundcubemail-core roundcubemail app-roundcubemail
    updatedb && locate roundcube
    Stop the "yum remove" if it takes out more than these three packages and use "rpm -e --nodeps" instead. From the "locate", remove all traces of roundcube, backing them up if you want. If you note your "mysql" password you can go into mysql and drop the database.

    Then disable clearos-epel (permanently) and try reinstalling.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 12 2015, 03:24 AM - #Permalink
    Resolved
    0 votes
    At this stage I can blow away the install of roundcube if necessary as without the Out of Office functionality the client is not going to use the software. If Ican get this working at least I can recoup the outlay for the software and be paid for a small percentage of the work I have done!
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, August 12 2015, 03:20 AM - #Permalink
    Resolved
    0 votes
    Hi Nick thanks for getting back to me. I have only just got back to look at this system.

    The answers to your questions are:
    1. I initially installed directly from the marketplace - in itself a frustrating experience because of the inability to use paypal directly - having to purchase predetermined levels of credit etc then going back to the installation and having to restart the download etc. So yes I definitely started this horror of a journey by using the marketplace!
    2. Yes clearos-epel is enabled but I believe it is one of the steps in the instructions to install roundcube manually and I definitely followed the steps in there after I could not get the original install working.
    3. the output of rpm -qa | grep roundcube
    pp-roundcubemail-core-1.0.2-1.v6.noarch
    roundcubemail-1.0.6-1.el6.noarch
    app-roundcubemail-1.0.2-1.v6.noarch
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 08 2015, 04:10 PM - #Permalink
    Resolved
    0 votes
    I am home now so I can look at my system and type better. The ClearOS version of Roundcube does have out of office functionality but I think it is because the Clear team built in sieve filtering which does not come in the standard installation. I suspect you won't have it because of your manual configuration.

    When you installed, did you install directly from the marketplace or did you use yum? Also do you have any third-party repos enables (such as clearos-epel)? What is the output of "rpm -qa | grep roundcube"
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 08 2015, 09:22 AM - #Permalink
    Resolved
    0 votes
    Hi Nick I neede to complete the installation prior to Monday. Maybe you can answer the other question is it possible to enable Out of office functionality on a clear OS system?
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 08 2015, 07:06 AM - #Permalink
    Resolved
    0 votes
    Crumbs. You've done a lot of stuff you should not have had to and have ended up with a conventional rather than ClearOS installation. You probably just had to run a deployinstall programming which normally runs on initial installation. This would have created config.inc.php where I had indicated and set up the http configuration accordingly. To use system-mysql you needed to change the database login string to include a port number. It's a pity you could not have waited until I had good access to my system.

    I don't know how to get a refund.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 08 2015, 01:11 AM - #Permalink
    Resolved
    0 votes
    Oh and by the way... the reason I was asked to install round cube was to hopefully provide and Out of Office message functionality for the client. After searching the forums I could not find an answer for that question. The clearos server does not support and Out of Office functionality and therefore round cube will not do so.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 08 2015, 01:07 AM - #Permalink
    Resolved
    0 votes
    Whilst I now have a functional webmail client I am disappointed at having paid the $15. I have spent more than 8 hours of non-billable time on this installation and probably could have saved the $15. It did not work out of the box, and even now the webconfig shows the same error as originally reported. I probably could have just followed the instructions here How do I go about trying to get a refund of the $15? Where can I raise a complaint, other than here?
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 08 2015, 12:34 AM - #Permalink
    Resolved
    0 votes
    Yahoo - I fixed it... using the graphical mysql management tool I dropped the existing database and created a new database I then created the roundcubemail user and gave it the password found earlier using cat /var/clearos/system_database/roundcubemail and granted all privileges on the database to that user
    I then re-ran the https://x.x.x.x/webmail/installer and updated the config.inc.php file with the rouncubemail user and password it then tested as OK but showed that the database required initialising. I initialised the database and it showed all green. I tested it and now it is working.
    Finally I hid the installer folder buy renaming it to .installer

    I used the following resources to help me work this out
    http://trac.roundcube.net/wiki/Howto_Install
    https://www.clearos.com/support/documentation/clearos/content:en_us:6_roundcubemail
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 07 2015, 11:43 PM - #Permalink
    Resolved
    0 votes
    Hi Nick,
    I have found the password by running cat /var/clearos/system_database/root
    also the roundcubemail password by cat /var/clearos/system_database/roundcubemail
    I created the config.Inc.php by running the https://x.x.x.x/webmail/installer as per the instructions for the paid version of Roundcube - and have placed the file in the /etc/roundcube dir.
    I have tried, root and roundcube and roundcubemail as usernames, with and without passwords in the database string in that file and still am getting the same error.
    /usr/share/roundcubemail/config/config.Inc.php - does not exist do you think I should create it here and remove the /etc/roundcube version?

    I'm not sure where to go from here...
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 07 2015, 08:25 AM - #Permalink
    Resolved
    0 votes
    I can't really help right now as I am miles away from my system. The paid for version of Roundcube uses system-mysql but please don't change the password. If you search the forum you can see how to find the password and you can then check it against the one in /usr/share/roundcubemail/config/config.Inc.php in the database string.

    Does the paid for version come with any support?
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 07 2015, 08:02 AM - #Permalink
    Resolved
    0 votes
    Hi Nick no I purchased the software and when it didn't work I did try to fix it using the info in the forums. I followed the instructions to reset the MySQL password but it hasn't worked. If you tell me what info you need I can get it to you. And maybe we can work it out.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 07 2015, 07:23 AM - #Permalink
    Resolved
    0 votes
    Try the httpd error logs and /var/log/messages. Have you upgraded from an installation howto you found on this site?
    The reply is currently minimized Show
Your Reply