Thursday, October 17, 2013

roundcubemail mysql

RoundCube mail Fedora 19

http://nullr0ute.com/2013/06/roundcube-mail-on-rhelfedora/

[root@nut ~]# yum install roundcubemail mysql-server mod_nss

Loaded plugins: langpacks, refresh-packagekit
adobe-linux-x86_64                                       
fedora-chromium-stable                                   
google-chrome                                            
updates/19/x86_64/metalink                          
google-chrome/primary                                 
google-chrome                                            
Package roundcubemail-0.9.4-1.fc19.noarch already installed and latest version
Package 1:mariadb-server-5.5.32-8.fc19.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package mod_nss.x86_64 0:1.0.8-22.fc19 will be installed
adobe-linux-x86_64/filelists                            
fedora/19/x86_64/filelists_db                           
fedora-chromium-stable/19/x86_64/filelists_db    
google-chrome/filelists                                    
updates/19/x86_64/filelists_db                         
--> Finished Dependency Resolution

Dependencies Resolved


===========================================================================

 Package                     Arch                       Version                             Repository                   Size
===========================================================================
Installing:
 mod_nss                     x86_64                     1.0.8-22.fc19                       updates                      90 k

Transaction Summary

===========================================================================
Install  1 Package

Total download size: 90 k

Installed size: 244 k
Is this ok [y/d/N]: y
Downloading packages:
mod_nss-1.0.8-22.fc19.x86_64.rpm                   
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mod_nss-1.0.8-22.fc19.x86_64        

mod_nss certificate database generated.


  Verifying  : mod_nss-1.0.8-22.fc19.x86_64       


Installed:

  mod_nss.x86_64 0:1.0.8-22.fc19

Complete!

[root@nut ~]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@nut ~]#
[root@nut ~]#
[root@nut ~]# service mysqld status
Redirecting to /bin/systemctl status  mysqld.service
mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
   Active: inactive (dead)

[root@nut ~]#

[root@nut ~]#
[root@nut ~]# service mysqld start
Redirecting to /bin/systemctl start  mysqld.service

[root@nut ~]#

[root@nut ~]#
[root@nut ~]# service mysqld status
Redirecting to /bin/systemctl status  mysqld.service
mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
   Active: active (running) since Thu 2013-10-17 21:05:55 EEST; 1s ago
  Process: 1473 ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 1395 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 1472 (mysqld_safe)
   CGroup: name=systemd:/system/mysqld.service
           ├─1472 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─1630 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-er...

Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: To start mysqld at boot time you have to copy

Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: support-files/mysql.server to the right place for your system
Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: To do so, start the server, then issue the following commands:
Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: '/usr/bin/mysqladmin' -u root password 'new-password'
Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: '/usr/bin/mysqladmin' -u root -h nut.mb.org pas...ord'
Oct 17 21:05:52 nut.montebanato.ro mysqld-prepare-db-dir[1395]: Alternatively you can run:
Oct 17 21:05:53 nut.montebanato.ro mysqld_safe[1472]: 131017 21:05:53 mysqld_safe Logging to '/var/log/mysqld.log'.
Oct 17 21:05:53 nut.montebanato.ro mysqld_safe[1472]: 131017 21:05:53 mysqld_safe Starting mysqld daemon with database...mysql
Oct 17 21:05:55 nut.montebanato.ro systemd[1]: Started MariaDB database server.
[root@nut ~]#


# mysql -u root -p
mysql> create database roundcubemail;
mysql> create user roundcube;
mysql> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost IDENTIFIED BY 'changeme';
mysql> FLUSH PRIVILEGES;
mysql> quit
# mysql -u root -p roundcubemail < /usr/share/doc/roundcubemail-0.9.4/SQL/mysql.initial.sql

edit /etc/roundcubemail/db.inc.php:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:changeme@localhost/roundcubemail';

edit /etc/roundcubemail/main.inc.php:

$rcmail_config['default_host'] = 'localhost';



# service mysqld status
Redirecting to /bin/systemctl status  mysqld.service
mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
   Active: active (running) since Thu 2013-10-17 21:05:55 EEST; 33min ago
  Process: 1473 ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 1395 ExecStartPre=/usr/libexec/mysqld-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 1472 (mysqld_safe)
   CGroup: name=systemd:/system/mysqld.service
           ├─1472 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─1630 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-e...


# service mysqld enable
Redirecting to /bin/systemctl enable  mysqld.service
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'


# service mysqld status
Redirecting to /bin/systemctl status  mysqld.service
mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
   Active: active (running) since Thu 2013-10-17 21:05:55 EEST; 35min ago
 Main PID: 1472 (mysqld_safe)
   CGroup: name=systemd:/system/mysqld.service
           ├─1472 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─1630 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-e...

No comments:

Post a Comment