Topic: Egroupware fails to install

[mojo]

Here are the results...

Using username "root".
Last login: Mon Sep  8 17:57:51 2014 from 10.182.188.16
[root@sme ~]# config show egroupware
[root@sme ~]# mysqlshow
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| avantfax           |
| egroupware         |
| horde              |
| my_wiki            |
| mysql              |
| sme8admin          |
| sogo               |
| test               |
| zurmo              |
+--------------------+
[root@sme ~]#

[stephdl]

THerefore you have to remove

-SME DB (ok)
-mysql egroupware DB
http://wiki.contribs.org/Useful_Commands#Remove_a_database
-all rpm smeserver-egroupware
yum remove smeserver-egroupware eGroupware-\*

[mojo]

Removed the egroupware DB, ran the commands...

yum remove smeserver-egroupware eGroupware-\* ,

yum remove `rpm -qa|grep -i  eGroupware`

signal-event post-upgrade; signal-event reboot

The problem remains

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=wkVjcqYd(B98[t=1' '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...
mysqldump: Got error: 1049: Unknown database 'egroupware' when selecting the 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

Thanks so much for taking the time to help me.

[stephdl]

ll /opt

you have still a directory called egroupware in /opt, if yes remove it

After that
verify you have not a a mysql DB  and SME DB, remove all eGroupware package

Maybe it is time to reinstall your server....you have played a bit with it
Go to SME9

[janet]

mojo

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))

Would this be indicating that you have changed the root mysql password at some point in time (which you should NOT have done).

You can reset the mysql root password by following these instructions:
http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password

[mojo]

Janet,

If I type mysql at the prompt and it doesn't ask for a password. That mean the password is blank?

[stephdl]

Sorry Janet but this time you are wrong. see http://forums.contribs.org/index.php/topic,51099.msg258805.html#msg258805

never mind of this warning of eGroupware

[janet]

mojo

If I type mysql at the prompt and it doesn't ask for a password. That mean the password is blank?

No.
There is a password (a very long one, 72 chars), but sme server does not require you to enter that to access mysql, it does it for you automatically.
I was really just asking if you had manually changed the mysql root password, Did you ?
See
http://wiki.contribs.org/MySQL#MySQL_root_password

[janet]

stephdl

see http://forums.contribs.org/index.php/topic,51099.msg258805.html#msg258805
never mind of this warning of eGroupware

Are you saying/suggesting that this issue is really to do with a new version of smeserver-egroupware not being fully correct for use with sme9.0 ?

[stephdl]

Sorry Janet but I do not understand fully your question, French attitude

smeserver-egroupware is available for sme8 in the smecontribs and in my repo for sme9 (it is really recent)
Someone asks me that he would have egroupware-epl_14.1 for smeserver, so I started to work on it, but only for sme9 (it needs a PHP accelerator/caching)

It is for testing only : http://mirror.de-labrusse.fr/Sme-Server/smeserver-egroupware-epl/ epel and egroupware needed

The only Known issue for now is that the email client needs to be created by hand for each users, I do not understand why it is like that (IMAP Authentication). I did a post in egroupware website, i'm waiting a response. The UI is completely news, nice to see.

[janet]

stephdl

Rephrasing my question.

Are there bug(s) in your sme9 version of smeserver-egroupware that are responsible for the problems that OP is having when installing ?

[stephdl]

Are there bug(s) in your sme9 version of smeserver-egroupware that are responsible for the problems that OP is having when installing ?

No I don't think so, until proven otherwise. There is no version for sme8 and I open a version for sme9 recently

[mojo]

Janet

mojo

No.
There is a password (a very long one, 72 chars), but sme server does not require you to enter that to access mysql, it does it for you automatically.
I was really just asking if you had manually changed the mysql root password, Did you ?
See
http://wiki.contribs.org/MySQL#MySQL_root_password

I don't think I had ever changed password. I did do as you suggested and reset the password. Then rebooted. The installation still fails.

[mojo]

stephdl

I'm not sure if this is the right place to post this. I have a fresh install of sme 9 64 bit. Installed the egroupware contrib and I get a similar error.

Code: [Select]

Tue Sep  9 22:19:25 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=T41NR6BvEh_wFZpR' '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))
I have however gotten into the configuration page.  Thank you for all you do!

[stephdl]

Hum...from my repo....i will attempt to reproduce but i have done it many time this week...maybe only on 32 bit....could you test yourself on 32 bit.

Do you have restored the backup from your sme8