The problem of centos7+php7.1.6+mysql5.7+apache2.4 install EGW

kensting 2018-04-24 13:42:57 UTC #1

i install the egw17.1 in centos7,php7.1 ,mysql5.7,apache2.4.
use the install method of online from opensuse.(yum install egroupware-epl)
but report the error:

Unit mariadb.service could not be found.
Failed to start mariadb.service: Unit not found.
Failed to execute operation: No such file or directory
/usr/bin/php -d memory_limit=-1 /usr/share/egroupware/setup/setup-cli.php --setup-cmd-database sub_command=create_db ‘domain=default’ ‘db_type=mysqli’ ‘db_host=localhost’ ‘db_port=3306’ ‘db_name=egroupware’ ‘db_user=egroupware’ ‘db_pass=<pzBdfTgs5jBUe2M’ ‘db_root=root’ ‘db_root_pw=’ 'db_grant_host=localhost’
No default timezone (php.ini date.timezone) set, we temporary set ‘UTC’. You should fix that permanent!
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!

i don’t know how to solve it,can help me?
thanks very much.

StefanU 2018-04-24 14:18:38 UTC #2

Hi Kensting,

you can install EGw on a fresh CentOS without installing a DB before. EGw installs the dependent packages with.

Have you set a password for the DB-root?

Greetings
Stefan

kensting 2018-04-28 01:04:15 UTC #3

first,thanks for your reply.

yes,had set password for the db-root,but i have attempt modify the DB-root password to void,then,still make the same error message.

I just tried installing EGW with a fresh CentOS without a DB, but the same error still occurred.

by the way,if i had a environment of LAMP, and had one other website on my server,then,i should how to install EGW?

i setup egw from http://localhost/egroupware/setup/. but had some problems.
e.g.:some icon can’t display,and files can’t upload…

thanks.

StefanU 2018-05-01 13:21:41 UTC #4

Hmmm…
I’ve never seen anything like this.
Then it would be time to take a look at the webserver-error-log.
And make a “Check installation” in setup.

The access data for the DB are stored in the /var/lib/egroupware/header.inc.php
There is the password for the user egroupware !
The root user is only required during installation to create the egroupware database.
So you should always check if the DB is created.

Stefan

kensting 2018-05-01 14:37:24 UTC #5

check installation no any problem and DB had created too,no problem,but login in backend,like that picture.
i install egw from web,so header.inc.php is in /home/wwwroot/host/egroupware/,not in /var/lib/egroupware/.only files and backup in /var/lib/egroupware,it’s mkdir by myself,and chown -R www:www /var/lib/egroupware.

my question of install egw by online like this issue Installation Centos 7 - Mysql Fail

StefanU 2018-05-01 18:42:38 UTC #6

Please note that there are 3 different types of installation:
Package installation,
archive installation,
Git installation (from GitHub)

If you have a server with root access, you should definitely choose the package installation!!!
Please read the Release Notes and the install instructions.
And if you can, take a Debian or Ubuntu. There you have less effort to install a current PHP.
And please do not install via yum and then change the installation paths. If you do something like this, no one can really help you. Then you need to know what you’re doing.

Please do the installation again step by step and document it here. Maybe then we can see what you do differently.

Stefan