Installation Centos 7 - Mysql Fail

[Janef]

Hi,

I am trying to install eGroupware on a fresh installation of Centos.

I allways receive the following error:

Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.) Installation failed --> exiting

Following steps I have performed following the instruction:

wget http://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/e/epel-release-7-11.noarch.rpm`

rpm -ivh epel-release-7-11.noarch.rpm
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
yum install -y mod_php71w php71w-cli php71w-common php71w-gd php71w-mbstring php71w-mcrypt php71w-    mysqlnd php71w-xml

 systemctl restart httpd

So far I did not receive any errors.

rpm -Uvh https://centos7.iuscommunity.org/ius-release.rpm
yum install ius-release
yum install epel-release
yum install yum-plugin-replace

php -v
PHP 7.1.11 (cli) (built: Oct 29 2017 17:26:51) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies

I changed the timezone in /etc/php.ini

finally I installed (or try to) egroupware:

cd /etc/yum.repos.d/
wget https://download.opensuse.org/repositories/server:eGroupWare/CentOS_7/server:eGroupWare.repo
yum install egroupware-epl

[Yann_Lehmann]

Hi,

Hi,

I am trying to install eGroupware on a fresh installation of Centos.

I allways receive the following error:

Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.) Installation failed --> exiting

Have you installed Mysql or MariaDB ?

MariaDB disables root access over TCP. One possible workaround is to create a new Mysql-user with full admin rights and to use it instead of root.

AFAIK, you don’t need to access the DB with root rights, you can create a specific user for EGroupware, with full rights on the EGroupware-database.

[Janef]

Hi,
thank you for your reply. Unfortunatly I don’t really understand where in the installation process I would be able to enter the username or password. I tried to follow the description given on:

EGroupware/egroupware

I did not install any database server since the documentation explicitely stated that

With the provision of the Community Edition repositories for various Linux distributions the installation process is simplyfied and reduced to following steps:
providing a Linux Server - now a minimal installation is sufficient, which most distributions provide with a so called minimal installation media
configuring the EGroupware Community Edition repository and adding additional repositories to the Linux system of your choice
an update / install with the shell command installer of your distribution
if possible and wanted a differing configuration from the standard installation defaults

But if I check after the installation

`yum install mariadb-server
Package 1:mariadb-server-5.5.56-2.el7.x86_64 already installed and latest version
Nothing to do

`

[Yann_Lehmann]

I think I got the point.

In my previous post, I mixed two different cases. I faced a problem with no db root access when installing phpmyadmin on a server, and the workaround then was to create a separate db user with all rights.

Your problem is probably that the MariaDB server was installed without db root password, as it seems to be the standard way on Centos too (it is on Ubuntu). To set a db root password, you can use ‘mysql_secure_installation’ as root (root account of the system, not of MariaDB) or with sudo.

To check if your db root account is set up correctly, start the mysql-client like this (you can ommit sudo if you are logged in as root on the system):

yann@xxxx:~$ sudo mysql -u root -p
[sudo] password for yann:                       your system user password here
Enter password:                                 password of your db root account

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 26797
Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Afterwards, the installation of EGroupware should succeed (don’t mix your system root password with the db root password).

Hope this helps.

[RalfBecker]

Your problem is probably that the MariaDB server was installed without db root password, as it seems to be the standard way on Centos too (it is on Ubuntu). To set a db root password, you can use ‘mysql_secure_installation’ as root (root account of the system, not of MariaDB) or with sudo.

Install with RPM packages requires an empty root password, as it is the default for MySQL/MariaDB on that systems. I think Jan confuses it with install under Debian/Ubuntu with an interactive installer.

I think you simply for got to install MySQL/MariaDB and that’s why the installation fails. Most easy is to clean up your already installed EGroupware packages:

yum remove egroupware-epl\*

And then install again:

yum install mariadb-server egroupware-epl

Ralf

[kensting]

this problem had solved?i have this problem now.but i don’t know how solve it.