HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Plugins/Modules/Addons (http://www.howtoforge.com/forums/forumdisplay.php?f=34)
-   -   Roundcube installation help.. (http://www.howtoforge.com/forums/showthread.php?t=59992)

xciso 18th December 2012 20:33

Roundcube installation help..
 
Hello.
I have now installed ispConfig on my vps server.
Now i want to install roundcube and i try to follow this guide:
http://www.howtoforge.com/how-to-ins...debian-squeeze

But i dont understand this:
With MySQL you can set up the database by issuing the following commands:

Code:

CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO username@localhost IDENTIFIED BY 'password';

(of course you have to replace the database, username and password accordingly)

What is it i should change? Cant the database be called "roundcubemail".

Thanks!

rwins 19th December 2012 06:58

Re: Roundcube installation help..
 
Edit and set the file config/db.inc.php on your folder roundcube instalation

From :
[...]
$rcmail_config['db_dsnw'] = '';
[...]
To :
[...]
$rcmail_config['db_dsnw'] = 'mysql://username:your-password@localhost/roundcubemail';
[...]

Edit and set the file config/main.inc.php

From
[...]
$rcmail_config['enable_installer'] = false;
[...]
To
[...]
$rcmail_config['enable_installer'] = true;
[...]

After that Browse on
http://your-domain.com/installer/?_step=1

Follow the intruction ...

fbsoft 3rd January 2013 00:48

Quote:

Originally Posted by rwins (Post 289823)
Edit and set the file config/db.inc.php on your folder roundcube instalation

From :
[...]
$rcmail_config['db_dsnw'] = '';
[...]
To :
[...]
$rcmail_config['db_dsnw'] = 'mysql://username:your-password@localhost/roundcubemail';
[...]

Edit and set the file config/main.inc.php

From
[...]
$rcmail_config['enable_installer'] = false;
[...]
To
[...]
$rcmail_config['enable_installer'] = true;
[...]

After that Browse on
http://your-domain.com/installer/?_step=1

Follow the intruction ...

What he said, of course in the sql command you should personalize your user and password
so to do so, log into your sql command line ( mysql -u root -p if you've set a sql password or mysql -u root if you haven't )
and then type the commands from the tutorial but personalize them...

so...
Code:

CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcubeuser@localhost IDENTIFIED BY 'password';

where...
Rouncubeuser is the actual user like root or anyother one ( let's say we'll change it to roundcubetest )
Password : is the actual password used to log into that database, so you should not leave password of course... you can and must change it, (lets say it would be 123456 )

the final code for sql would be ,

Code:

CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcubetest@localhost IDENTIFIED BY '123456';


afterwards in the config files also go to the step where it asks for info about you SQL server, there at the username input "roundcubeuser" ( in my example is roundcubetest )
password as well ( in my ex is 123456 ) and the server is of course localhost aka 127.0.0.1

LE: you can change the DB's name as well


All times are GMT +2. The time now is 10:17.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.