Topic: Egroupware fails to install

[mojo]

I have been attempting to install egroupware on sme8 from the contrib located at http://wiki.contribs.org/Egroupware

The yum install complains...

  Installing     : eGroupware                                                                                                                                     28/29
chcon: couldn't compute security context from unlabeled
setsebool:  SELinux is disabled.
/usr/bin/php -d memory_limit=256M /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=?|f0d#oZggLF2teF' 'db_root=root' 'db_root_pw=' 'db_grant_host=localhost'
Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.:
Access denied for user 'root'@'localhost' (using password: NO))

Installation failed --> exiting!

EGroupware install log saved to /root/eGroupware-install.log
Updating eGroupware... Please wait!
Backing up MySQL database...
Error in PREIN scriptlet in rpm package smeserver-egroupware-1.8.005-5.el5.sme.noarch
error: %pre(smeserver-egroupware-1.8.005-5.el5.sme.noarch) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping smeserver-egroupware-1.8.005-5.el5.sme
Migrating existing database hosts

The install log from /root ...
Mon Sep  8 13:23:24 CDT 2014
/usr/bin/php -d memory_limit=256M /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=?|f0d#oZggLF2teF' 'db_root=root' 'db_root_pw=' 'db_grant_host=localhost'
Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.:
Access denied for user 'root'@'localhost' (using password: NO))

Installation failed --> exiting!

What can I do to install this?

Thanks

[mojo]

I found this...

Followed the instructions to the letter, worked perfectly on my test bench machine, went belly up on my production one!
Did a total un-install as instructed on the Contribs page.
Re installed again and noticed this :-


> /usr/bin/php -d memory_limit=256M /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=l%mw5]0sq!WC&GcQ' 'db_root=root' 'db_root_pw=' 'db_grant_host=localhost'
> Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.:
> Access denied for user 'root'@'localhost' (using password: NO))
>
> Installation failed --> exiting!

Now I am out of my depth, any suggestions?

CANCEL that. I should really learn to google contribs more often, found the solution elsewhere on the site.

mysqladmin -u root create egroupware
mysql -e " grant all privileges on egroupware.* to 'egroupware'@'localhost' "
mysql -u root -e " SET PASSWORD FOR egroupware@localhost = PASSWORD( 'ATTENTION_put_here_password_for_egroupware_mysql_user' ) "
mysqladmin flush-privileges

Paul.

How do I find the random password generated while running the installer?

[stephdl]

I suppose in the DB

config show egroupware

are you interested to test smeserver-egroupware-epl-14.1, I'm currently working on it, testing only at the minute and just for SME9

[stephdl]

I don't think that your post found on internet is relevant. Indeed at the end of the egroupware installation, it is 'normal' that we have a fail in the DB creation, mainly because it is the job of smeserver-egroupware, But your problem comes of this package

please give me the return of these commands

Code: [Select]

ll /opt
cat /etc/group|grep apache
cat /etc/group-|grep apache
groups apache

[mojo]

The results...

ll /opt

Code: [Select]

total 20
drwxr-xr-x  6 root  root  4096 Aug 23  2013 egroupware
drwxr-xr-x  2 root  root  4096 Sep  8 12:33 eGW_RPM_BACKUP
drwxr-xr-x 11 www   www   4096 Sep  4  2013 fax
drwxrwxr-x 13   504   504 4096 Jun  5  2010 Funambol
drwxr-xr-x  3 admin admin 4096 Sep 21  2013 openoffice
cat /etc/group|grep apache

Code: [Select]

apache:x:102:cat /etc/group-|grep apache

Code: [Select]

apache:x:102:groups apache

Code: [Select]

apache : www
And yes I would be interested in 14.1, looks slick!

Thanks

[stephdl]

do  you have installed before egroupware or it is your first attempt

what about of : 'config show egroupware'

[mojo]

I may have tried previously. I have attempted several installs now having completely uninstalled egroupware with yum remove smeserver-egroupware and sh /root/eGW-Full-Uninstall.sh and also with   yum remove `rpm -qa|grep -i  eGroupware`

 'config show egroupware' returns nothing.

Thanks for all your help

[stephdl]

then

Code: [Select]

mv /opt/egroupware /opt/old_egroupware_old
yum install smeserver-egroupware --enablerepo=egroupware,smecontribs
signal-event post-upgrade; signal-event reboot


[mojo]

Okay now...

Code: [Select]

drwxr-xr-x  2 root  root  4096 Sep  8 12:33 eGW_RPM_BACKUP
drwxr-xr-x 11 www   www   4096 Sep  4  2013 fax
drwxrwxr-x 13   504   504 4096 Jun  5  2010 Funambol
drwxr-xr-x  6 root  root  4096 Aug 23  2013 old_egroupware_old
drwxr-xr-x  3 admin admin 4096 Sep 21  2013 openoffice

Strange now i have dependency issues...  yum install smeserver-egroupware --enablerepo=egroupware,smecontribs

Code: [Select]

smeserver-egroupware-1.8.005-5.el5.sme.noarch from smecontribs has depsolving problems
  --> Missing Dependency: eGroupware-gallery >= 1.8 is needed by package smeserver-egroupware-1.8.005-5.el5.sme.noarch (smecontribs)
smeserver-egroupware-1.8.005-5.el5.sme.noarch from smecontribs has depsolving problems
  --> Missing Dependency: eGroupware >= 1.8 is needed by package smeserver-egroupware-1.8.005-5.el5.sme.noarch (smecontribs)
Error: Missing Dependency: eGroupware-gallery >= 1.8 is needed by package smeserver-egroupware-1.8.005-5.el5.sme.noarch (smecontribs)
Error: Missing Dependency: eGroupware >= 1.8 is needed by package smeserver-egroupware-1.8.005-5.el5.sme.noarch (smecontribs)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest


[mojo]

On reboot it tells me ...

Code: [Select]

loading egw_default into mysql  [Fail]

[stephdl]

For installation run the following commands:

db yum_repositories set egroupware repository \
Name "server_eGroupWare" \
BaseURL http://download.opensuse.org/repositories/server:/eGroupWare/CentOS_5/ \
EnableGroups no GPGCheck yes \ Name "eGroupware (CentOS_5)" \
GPGKey http://download.opensuse.org/repositories/server:/eGroupWare/CentOS_5/repodata/repomd.xml.key \
Visible yes status disabled

then

signal-event yum-modify

yum install smeserver-egroupware --enablerepo=egroupware,smecontribs
signal-event post-upgrade; signal-event reboot

[mojo]

Same results...


yum install smeserver-egroupware --enablerepo=egroupware,smecontribs

Code: [Select]

  Installing     : eGroupware                                             28/29
chcon: couldn't compute security context from unlabeled
setsebool:  SELinux is disabled.
/usr/bin/php -d memory_limit=256M /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=@ZrG[Uv8Kl!kOtP)' 'db_root=root' 'db_root_pw=' 'db_grant_host=localhost'
Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.:
Access denied for user 'root'@'localhost' (using password: NO))

Installation failed --> exiting!

EGroupware install log saved to /root/eGroupware-install.log
Updating eGroupware... Please wait!
Backing up MySQL database...
Error in PREIN scriptlet in rpm package smeserver-egroupware-1.8.005-5.el5.sme.noarch
error: %pre(smeserver-egroupware-1.8.005-5.el5.sme.noarch) scriptlet failed, exit status 1
error:   install: %pre scriptlet failed (2), skipping smeserver-egroupware-1.8.005-5.el5.sme
Migrating existing database hosts


[mojo]

Found

/etc/e-smith/sql/init/81egw_default

and deleted it

[stephdl]

manifestly you have still some pieces of an old installation.

you ought to find them first and remove them (but with yum or rpm command)

-the sme DB configuration (you said that 'config show egroupware' returns nothing but please verify)
-mysql DB (verify that you have not an old DB called egroupware)
mysql
show databases;

removing the old mysql.init by hand is not the good choice since we cannot understand of which package it comes from (rpm -qf /etc/e-smith/sql/init/81egw_default)

Normally it is possible that you have other files of mysql.init or eventually some httpd/templates (/etc/e-smith/templates/etc/httpd/conf/httpd.conf)

[guest22]

-mysql DB (verify that you have not an old DB called egroupware)
mysql
show databases;

tip: mysqlshow will do