Topic: Egroupware and yum

[janet]

damjan

the connection with mysql could not be established:

It sounds like the mysql database was not created correctly especially the password section.
I think this might be due to line wrapping in the forum and therefore entering the command incorrectly

This is the correct command sequence, did you enter each command on one line as follows:
(leaving out my comments, ie first line...second line...etc)

first line to enter
mysqladmin -u root create egroupware

second line to enter (all on one line)
mysql -e " grant all privileges on egroupware.* to 'egroupware'@'localhost' "

third line to enter (all on one line)
mysql -u root -e " SET PASSWORD FOR egroupware@localhost = PASSWORD( 'egroupware_db_password' ) "

fourth line to enter
mysqladmin flush-privileges

[damjan]

Hi all,

Here is a list of Peter's instructions and my minor modifications which worked in my case:

1.
## CREATE YUM REPOSITORY
/sbin/e-smith/db yum_repositories set server_eGroupWare repository Name 'server_eGroupWare' BaseURL 'http://download.opensuse.org/repositories/server:/eGroupWare/CentOS_5/'  EnableGroups no GPGCheck yes GPGKey http://download.opensuse.org/repositories/server:/eGroupWare/CentOS_5/repodata/repomd.xml.key Visible no status disabled

2.
signal-event yum-modify


3.
yum --enablerepo=smecontribs install php53-mcrypt

4.
yum install eGroupware --enablerepo=*


5.
## CREATE MySQL DB & USER
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



6.
## FIXING SECURITY
chmod 666 /usr/share/egroupware/header.inc.php
chmod 777 /var/lib/egroupware/default/backup/
chmod 777 /var/lib/egroupware/default/files/

7.
## APACHE CONFIG

rm /etc/httpd/conf.d/egroupware.conf

cat > /etc/e-smith/templates/etc/httpd/conf/httpd.conf/98eGroupWare << EOF
####################################
#  eGroupWare
####################################
Alias /egroupware /usr/share/egroupware
<Directory /usr/share/egroupware/>
  AddType application/x-httpd-php .php .php3 .phtml
  AddType text/xml .xml
  Options FollowSymLinks ExecCGI
  AllowOverride None
  Order allow,deny
  Allow from all
  DirectoryIndex index.html index.php
  AddHandler cgi-script .cgi
  AddDefaultCharset Off
  php_flag file_uploads on
  php_flag log_errors on
  php_flag magic_quotes_gpc off
  php_flag magic_quotes_runtime off
  php_flag register_globals off
  php_flag short_open_tag on
  php_flag track_vars on
  php_flag display_errors off
  php_value error_reporting 'E_ALL & ~E_NOTICE'
  php_value max_execution_time 90
  php_admin_value mbstring.func_overload 7
  php_value memory_limit 48M
  php_value session.gc_maxlifetime 14400
  php_value include_path .:/usr/share/pear
  php_value open_basedir /usr/share/egroupware:/var/lib/egroupware:/tmp:/usr/share/pear
  php_value upload_max_filesize 8M
  <Files ~ "\.inc\.php$">
    Order allow,deny
    Deny from all
  </Files>
</Directory>
<Directory /usr/share/egroupware/phpsysinfo/>
  php_value open_basedir /
</Directory>
<Location /egroupware/icalsrv/icalsrv.php>
    Script PUT /usr/share/egroupware/icalsrv/icalsrv.php
    AddHandler ical/ics .ics
    Action ical/ics /usr/share/egroupware/icalsrv/icalsrv.php
    Order allow,deny
    Allow from all
</Location>
<Location /egroupware/rpc.php>
    php_admin_value mbstring.func_overload 0
    Order allow,deny
    Allow from all
</Location>
EOF

8.
## APPLY CHANGES
expand-template /etc/httpd/conf/httpd.conf
/etc/rc7.d/S86httpd-e-smith sigusr1

9.
## SETUP EGROUPWARE
http://yourdomain.com/egroupware/setup


10.
## ONCE INSTALLED, PUT SECURITY BACK
chmod 644 /usr/share/egroupware/header.inc.php

11.
## TO UPGRADE
yum update eGroupware –enablerepo=*
before upgrade copy header.inc.php and put it back after upgrade

[Stefano]

6.
## FIXING SECURITY
chmod 777 /var/lib/egroupware/default/backup/
chmod 777 /var/lib/egroupware/default/files/

this is E V I L and should be never done..