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?
Where else should I look?
Share this post:
Accepted AnswerHi 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.
Accepted AnswerYou 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:
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.
yum install app-roundcubemail
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.
Accepted AnswerMore 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/
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
Accepted AnswerHi 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/
-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  Access denied for user 'roundcube'@'localhost' (using password: YES))
Make sure that the configured database exists and that the user has write privileges
Thanks for all your help so far can you point me in the direction to get this sorted, please?
Accepted AnswerOK 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:
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.
yum remove app-roundcubemail-core roundcubemail app-roundcubemail
updatedb && locate roundcube
Then disable clearos-epel (permanently) and try reinstalling.
Accepted AnswerAt 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!
Accepted AnswerHi 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
Accepted AnswerI 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"
Accepted AnswerCrumbs. 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.
Accepted AnswerOh 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.
Accepted AnswerWhilst 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?
Accepted AnswerYahoo - 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
Accepted AnswerHi 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...
Accepted AnswerI 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?