Koozali.org formerly Contribs.org

Obsolete Releases => SME 7.x Contribs => Topic started by: cool34000 on January 07, 2007, 09:11:40 AM

Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 07, 2007, 09:11:40 AM
I take advantage of the release of a new version of eGroupWare (v1.2.106-2) to provide a howto to script its installation.

First of all, download necessary files here (http://mesh.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-1.2.106-2.zip) and here (http://mesh.dl.sourceforge.net/sourceforge/egroupware/eGroupWare-contrib-1.2.106-2.zip)

Create a folder in /root nammed 'egroupware'

Copy the 2 downloaded files into /root/egroupware

Create a file /root/egroupware/98egroupware with :
Code: [Select]

# eGroupWare
Alias /egroupware /opt/egroupware/html
<Directory /opt/egroupware/html>
SSLRequireSSL on
AddType application/x-httpd-php .php .php3 .phtml
Options Indexes +Includes FollowSymLinks
AllowOverride all
order deny,allow
deny from all
allow from all
php_flag magic_quotes_gpc on
php_flag track_vars on
php_flag register_globals off
php_admin_value phpa on
php_admin_value eaccelerator.enable 1
php_admin_value display_errors 0
php_admin_value mbstring.func_overload 7
</Directory>

This template allows access from anywhere (global). https mode is enabled.

Create a file /root/egroupware/60redir-egroupware with :
Code: [Select]

{

if ($port ne "443")

{

$OUT .= <<'HERE';


## Redirect Web Address to Secure Address


RewriteEngine on

RewriteRule ^/egroupware https://%{HTTP_HOST}/egroupware


## End Of Redirect


HERE


}

}
This template redirect automatically http to https for access to eGroupWare

Create a file /root/egroupware.sh with :
Code: [Select]
#!/bin/sh


echo "-------------------------------------------------------------------"
echo "Installation of eGroupWare (public access, automatic https mode)..."
echo "-------------------------------------------------------------------"


DOMAINE=$(db configuration get DomainName)


echo "Generating password..."
passok=0
while [ "$passok" != "1" ] ; do
openssl genrsa 32 > /root/pass.txt
pass=$(grep -v "PRIVATE KEY" < /root/pass.txt)
echo test > /root/pass.txt
sed -e "s/test/$pass/" /root/pass.txt >/root/pass.new
passok=$(grep -c $pass < /root/pass.new)
done
egwpass=$pass
echo "Password is : $egwpass"
rm -f /root/pass.txt
rm -f /root/pass.new


echo "Creating Data bases..."
mysqladmin -u root create egroupware
echo "Creating mysql user..."
mysql -e " grant select, insert, update, delete, create, drop, index, alter on egroupware.* \
to 'egroupware'@'localhost' \
identified by '$egwpass' "
mysqladmin flush-privileges


echo "Decompressing files..."
mkdir -p /opt/egroupware/backup
mkdir -p /opt/egroupware/files
mkdir -p /opt/egroupware/tmp
unzip -q /root/egroupware/eGroupWare-1.2.106-2.zip -d /opt/egroupware
unzip -qo /root/egroupware/eGroupWare-contrib-1.2.106-2.zip -d /opt/egroupware
mv -f /opt/egroupware/egroupware /opt/egroupware/html
mv -f /opt/egroupware/html/sitemgr/sitemgr-link /opt/egroupware/html/


echo "Cleaning installed modules..."
rm -rf /opt/egroupware/html/phpsysinfo
rm -rf /opt/egroupware/html/phpldapadmin


echo "Setting file access rules :"
cd /opt
echo "   - Changing owner recursivly..."
chown -R root:www /opt/egroupware
echo "   - Recursive CHMOD 550 on folders..."
find egroupware -type d -exec chmod 550 {} \;
echo "   - Recursive CHMOD 440 on files..."
find egroupware -type f -exec chmod 440 {} \;
echo "   - Customization of CHMOD for a few folders..."
chmod -R 770 /opt/egroupware/files
chmod -R 770 /opt/egroupware/backup
chmod -R 770 /opt/egroupware/tmp
chmod -R 770 /opt/egroupware/html/fudforum
chmod 770 /opt/egroupware/html/phpgwapi/images
touch /opt/egroupware/html/header.inc.php
chown www /opt/egroupware/html/header.inc.php
chmod 600 /opt/egroupware/html/header.inc.php


echo "Adding templates..."
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts
cp /root/egroupware/60redir-egroupware /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts/
cp /root/egroupware/98egroupware /etc/e-smith/templates/etc/httpd/conf/httpd.conf/
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart
echo


echo "-------------------------------------------------------------------------------"
echo "Installation completed, you must finish the installation of eGroupWare website."
echo "Please go to https://$DOMAINE/egroupware"
echo "-------------------------------------------------------------------------------"
echo
echo
echo "Reminder :"
echo "         - Website open globally"
echo "         - https mode enabled with automatic redirection"
echo
echo "         - eGroupware is installed in the folder : /opt/egroupware/html"
echo "         - tmp folder path is                    : /opt/egroupware/tmp"
echo "         - backup folder path is                 : /opt/egroupware/backup"
echo "         - files folder path is                  : /opt/egroupware/files"
echo
echo "         - MySQL database name is                : egroupware"
echo "         - MySQL username is                     : egroupware"
echo "         - MySQL user password is                : $egwpass"
echo "-------------------------------------------------------------------------------"

Now the only thing you have to do is
Code: [Select]
# sh egroupware.shand eGroupWare installs automatically.
A random password is generated for MySQL user, please note the informations given by the script and finish eGroupWare installation.


edit : added setup howto


you should be able to go to https://yourdomain.com/egroupware

Here what I do set at header admin stage :
Quote
Server root : /opt/egroupware/html
Include root : /opt/egroupware/html
Admin user for header manager : admin
Admin password to header manager : my_password
Limit access to setup to the following addresses, networks or hostnames (e.g. 127.0.0.1,10.1.1,myhost.dnydns.org) :
Persistent connections : yes
Sessions Type : php
Enable MCrypt : no
MCrypt version :
MCrypt initialization vector :
Domain select box on login : no
Database instance (eGW domain) : mydomain.com
DB Type : MySQL
DB Host : localhost
DB Port : 3306
DB Name : egroupware
DB User : egroupware
DB Password : my_db_password <-- the one given by the script !
Configuration User : admin
Configuration Password : my_password
Then write config and continue and login at Setup/Config Admin
Click on Install all applications
When done, click on Re-Check the installation
Then click on Edit current configuration
Quote
Enter the full path for temporary files : /opt/egroupware/tmp
Enter the full path for users and group files : /opt/egroupware/files
Enter the full path to the backup directory: /opt/egroupware/backup
Enter the location of eGroupWare's URL : /egroupware
Image type selection order : PNG->JPG->GIF
Enter the hostname of the machine on which this server is running : mydomain.com
Enter your default FTP server : localhost
Attempt to use correct mimetype for FTP instead of default 'application/octet-stream' : No
Enter your HTTP proxy server :
Enter your HTTP proxy server port :
Enter your HTTP proxy server username :
Enter your HTTP proxy server password :
POP/IMAP mail server hostname or IP address : localhost
Mail server protocol : IMAP
Mail server login type : standard
Mail domain (for Virtual mail manager) :
SMTP server hostname or IP address : localhost
SMTP server port : 25
User for SMTP-authentication (leave it empty if no auth required) :
Password for SMTP-authentication :
Select which type of authentication you are using : SQL/SSL
Select where you want to store/retrieve user accounts : SQL
SQL encryption type for passwords (default - md5) : MD5
Allow authentication via cookie : Yes
Auto login anonymous user : No
Allow password migration : No
Allowed migration types (comma-separated) :
Minimum account id (e.g. 500 or 100, etc.) :
Maximum account id (e.g. 65535 or 1000000) :
User account prefix :
Usernames are casesensitive : No
Auto create account records for authenticated users : No
Auto-created user accounts expire : never
Add auto-created users to this group ('Default' will be attempted if this is empty.) :
If no ACL records for user or any group the user is a member of : Deny Access
Do you want to manage homedirectory and loginshell attributes? : No
LDAP Default homedirectory prefix (e.g. /home for /home/username) :
LDAP Default shell (e.g. /bin/bash) :
LDAP host :
LDAP accounts context :
LDAP search filter for accounts, default: "(uid=%user)", %domain=eGW-domain :
LDAP groups context :
LDAP rootdn (searching accounts and changing passwords) :
LDAP root password :
LDAP encryption type : DES
Enable LDAP Version 3 : No
Host/IP Domain controler :
Domain name :
Enter some random text for app session encryption :
Mcrypt algorithm (default TRIPLEDES) : TRIPLEDES
Mcrypt mode (default CBC) : CBC
Select where you want to store/retrieve filesystem information : SQL version 2 (EXPERIMENTAL, required and works only with FilesCenter)  
Select where you want to store/retrieve file contents : Filesystem
And then click on save
Finally, create the admin account... Installation is finished !
Click on Back to user login and login with the admin account you've created !!!


I've tested many modules and I have to say that all worked for me !

Work well in collaboration !!!


The french version of this howto can be seen here (http://forums.ixus.fr/viewtopic.php?t=37221)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: fpausp on January 10, 2007, 03:52:39 PM
Thanks  :D

fpausp
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 10, 2007, 09:06:07 PM
I forgot to say to CHMOD header.inc.php to 400 (read only for root) AFTER the install is done for security reasons...
Code: [Select]
chmod 400 /opt/egroupware/html/header.inc.phpThis should be better !

I'm also digging the fact that mysql user should have LOCK permission for its database... Will tell here if needed.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Amir Inbar on January 14, 2007, 08:18:50 AM
what do i have to do AFTER the install and the setup completes ?
I get an empty page and beeing redirected to setup after i write the config at the setup page.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 14, 2007, 11:09:16 AM
Quote from: "amir"
what do i have to do AFTER the install and the setup completes ?
I get an empty page and beeing redirected to setup after i write the config at the setup page.
I've modified the howto and added howto for the 2 next setup stages. Just take a look at it.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Amir Inbar on January 14, 2007, 08:57:54 PM
@cool34000 :

Worked like charm ..

Thank you.

I have another problem though, related to Hebrew characters - i use UTF-8 as the basic encoding but some of the mail messages show scrambled and some messages are shown with whiped out text - mainly messags that were written in Hebrew.

Do you know how to solve that ?

Another question : is there a known solution for syncing eGroupWare with outlook without the need to accept security warnings ?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 14, 2007, 09:13:20 PM
Don't know, sorry... I'm discovering eGroupWare !
You should try http://www.egroupware.org/ for further support/questions
Title: Server-manager and other ibays missing after egroupware inst
Post by: straubd on January 14, 2007, 09:32:42 PM
Help - I followed the directions as outlined, ran the egroupware.sh installation script and now none of my previous ibays, http://server/server-manager and https://server/egroupware can be accessed. I've rebooted the server and have restarted the httpd services with no success.

The primary ibay is the only one that is accessible.

What am I doing wrong here?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Amir Inbar on January 14, 2007, 09:39:04 PM
@ straubd :

watch out for lines being copied-pasted incorrectly from browser to pico.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: straubd on January 14, 2007, 10:15:47 PM
Did that, same results. However, the following errors have occured in the template section of the script.

ERROR in /etc/e-smith/templates-custom//etc/httpd/conf/httpd.conf/VirtualHosts/60redir-egroupware: Program fragment delivered error <<Can't find string terminator "
HERE" anywhere before EOF at /etc/e-smith/templates-custom//etc/httpd/conf/httpd.conf/VirtualHosts/60redir-egroupware line 4.>> at template line 1
WARNING in /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts: ERROR: Template processing failed for //etc/httpd/conf/httpd.conf/VirtualHosts: 1 fragment generated errors
 at /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts line 38
WARNING in /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts: Use of uninitialized value in concatenation (.) or string at /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts line 38.
ERROR in /etc/e-smith/templates-custom//etc/httpd/conf/httpd.conf/VirtualHosts/60redir-egroupware: Program fragment delivered error <<Can't find string terminator "
HERE" anywhere before EOF at /etc/e-smith/templates-custom//etc/httpd/conf/httpd.conf/VirtualHosts/60redir-egroupware line 4.>> at template line 1
WARNING in /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts: ERROR: Template processing failed for //etc/httpd/conf/httpd.conf/VirtualHosts: 1 fragment generated errors
 at /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts line 38
WARNING in /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts: Use of uninitialized value in concatenation (.) or string at /etc/e-smith/templates//etc/httpd/conf/httpd.conf/80VirtualHosts line 38.
WARNING: Template processing succeeded for //etc/httpd/conf/httpd.conf: 4 fragments generated warnings
 at /sbin/e-smith/expand-template line 45
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 15, 2007, 12:31:00 AM
Please be careful on the beginning and on the ending of templates files :
They have blank lines !!!
Verify your templates and expand templates then restart service.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Amir Inbar on January 15, 2007, 07:07:47 AM
Quote from: "cool34000"

Don't know, sorry... I'm discovering eGroupWare !
You should try http://www.egroupware.org/ for further support/questions


Thank you anyway - greate script !
Title: Funambol sync
Post by: daniel on January 15, 2007, 01:28:59 PM
I've been working with egroupware since version 102 and have had the outlook sync working using the syncml or funambol clients.   I followed the script on a new test server but am unable to get the sync working.  I verified xmlrpc was turned on in egroupware admin setup.  My setup includes php5 and mysql5 all of which I had working on egroupware 105 for testing.

Has anyone else had an issue with it not working?

PS  thanks for the script
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Franco on January 15, 2007, 04:52:37 PM
Yes, I get XML-RPC Fault:9999 when visiting the Filescenter:
Code: [Select]
PHP Fatal error:  Call to a member function on a non-object in /opt/egroupware/html/xmlrpc/testsuite.php on line 58


I also get:

Code: [Select]
PHP Warning:  imap_open(): Couldn't open stream {localhost:143}INBOX in /opt/egroupware/html/email/inc/class.mail_dcom_imap.inc.php on line 214
When trying the email.

Using the default PHP and MySQL from SME.

Thanks,
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 16, 2007, 10:41:46 AM
Quote from: "stuntshell"
Yes, I get XML-RPC Fault:9999 when visiting the Filescenter:
Code: [Select]
PHP Fatal error:  Call to a member function on a non-object in /opt/egroupware/html/xmlrpc/testsuite.php on line 58


I also get:

Code: [Select]
PHP Warning:  imap_open(): Couldn't open stream {localhost:143}INBOX in /opt/egroupware/html/email/inc/class.mail_dcom_imap.inc.php on line 214
When trying the email.

The 1st error you see is because xmlrpc service is not enabled in eGroupWare. In the admin panel, configure your site to enable xmlrpc service and FileCenter will work !

For the 2nd error you see, you should use in eGroupWare same users and passwords as SME accounts. It works perfectly !

I know eGroupWare is able to work with LDAP authentification, still don't know how to make this works but hope I'll be able soon to give a simple howto here (unless someone already knows how to make this working)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Franco on January 16, 2007, 08:13:05 PM
:D
Very good!
I still get this error:
Code: [Select]
httpd: PHP Warning:  imap_open(): Couldn't open stream {localhost:143}INBOX in /opt/egroupware/html/email/inc/class.mail_dcom_imap.inc.php on line 214 Should I worry?

Thanks,
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 16, 2007, 09:59:31 PM
There is nothing to worry about, but obviously something is going wrong !
If you can not retrieve mails via IMAP, have you tried via POP ? (both protocols are supported)
If this work with POP, maybe you forgot to fill IMAP server name in the setup process ? Go to https://yourserver/egroupware/setup to check it. I don't ask you if IMAP is enabled on your server, I bet it is !!!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Franco on January 16, 2007, 10:12:41 PM
Oh no! Everything works!!!  :)
I just see this message coming through the logs everytime I log in.

Thanks,
Title: downloadable script?
Post by: rkscscc on January 16, 2007, 11:01:25 PM
hiya cool34000...

is it possible for you to create the complete script for easy downloading instead of people struggling with typing errors?

also, a general question about groupware, their homepage says you have access from various clients (outlook included), but would outlook have the full feature range of the webclient?


thanks for all your hard work!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 16, 2007, 11:54:36 PM
@stuntshell : I don't have any errors in my logs... Are you sure EGW users and passwords are the same that SME's ? I ask that because man can add mailboxes to a user but by default, EGW will open EGWuserlogin@localhost to retrieve mails... That's why EGWuserlogin must equal SMEuserlogin (and of course password). If not, I don't have anymore ideas :oops: Sorry... See EGW forums, maybe this will help you ?

@rkscscc : I do not have the necessary bandwidth to do that at home at the moment : I'm lost in the asshole of the world where xDSL means 512/128kbps :cry: I'm also an onlinegamer and ping is life !!! :twisted:
Anyway, this script and the templates are for everyone so I have no problem on putting these 3 little files on any FTP a generous soul would provide...
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 17, 2007, 03:05:52 AM
About what can do (or what cannot do) eGroupWare and Outlook, I invite you to test eGWOSync (http://www.egroupware.org/wiki?wikipage=synchronisation%20outlook#egwosync).
I've just discovered it while trying to answer your post...
Using this tool is really not hard but there is one thing you must know before starting...
To use eGWOSync with HTTPS, YOU MUST HAVE A VALID CERTIFICATE
If not there are howtos on contribs.org to do this...
I highly recommend to use HTTPS with eGroupWare !!!

Here is another solution, which does not use HTTPS and THAT IS NOT SECURED.
So I recommend to limit access to eGroupWare from LAN only...

I highly insist in the fact that http and xmlrpc shouldn't be used together, password are written in plain text !!! You are warned !


Here's the howto :
delete the file created by the script : 60redir-egroupware
Code: [Select]
rm /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts/60redir-egroupwareReplace the content of the file /etc/e-smith/templates/etc/httpd/conf/httpd.conf/98egroupware by this :
Code: [Select]

# eGroupWare
Alias /egroupware /opt/egroupware/html
<Directory /opt/egroupware/html>
AddType application/x-httpd-php .php .php3 .phtml
Options Indexes +Includes FollowSymLinks
AllowOverride all
order deny,allow
deny from all
allow from { "$localAccess"; }
php_flag magic_quotes_gpc on
php_flag track_vars on
php_flag register_globals off
php_admin_value phpa on
php_admin_value eaccelerator.enable 1
php_admin_value display_errors 0
php_admin_value mbstring.func_overload 7
</Directory>

Be careful on the blank line on top&end :wink:
Then expand the template and restart apache :
Code: [Select]
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart


At this stage, things should be the same if you use https or http :
If it's not already done, activate xmlrpc services in Admin panel / site configuration. Then click on xmlrpc item and click on introspection.
This should give you something like this :
Quote from: "xmlrpc introspection"
methods available at http://yourservername:80/egroupware/xmlrpc.php
system.listMethods
Documentation
This method lists all the methods that the XML-RPC server knows how to dispatch

Signature
array system.listMethods(string)
array system.listMethods()


system.methodHelp
Documentation
Returns help text if defined for the method passed, otherwise returns an empty string

Signature
string system.methodHelp(string)


system.methodSignature
Documentation
Returns an array of known signatures (an array of arrays) for the method name passed. If no signatures are known, returns a none-array (test for type != array to detect missing signature)

Signature
array system.methodSignature(string)


system.login
Documentation
eGroupWare client or server login via XML-RPC

Signature
struct system.login(struct)


system.logout
Documentation
eGroupWare client or server logout via XML-RPC

Signature
struct system.logout(struct)


system.phpgw_api_version
Documentation
Returns the eGroupWare API version

Signature
string system.phpgw_api_version()


system.time
Documentation
returns system-time and -timezone and if loged in user-time and timezone

Signature
struct system.time()

If you passed the test, install eGWOSync (you need .net framework 1.1). Launch the program and provide the needed information during the 'first time run' :
Put just your server name in field Http://
Port should be 80 if using http or select Use SSL/Secure to use https (if you must have a valid certificate)
URI should be left by default (/egroupware/xmlrpc.php)
On next page, insert username and password and enter yourdomain.com
Then test your login. If you get 2 success, you can now sync calendar, addressbook, notes, todo's :P

Enjoy !
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: rkscscc on January 17, 2007, 08:31:13 AM
cool34000,

send me an email with the files to admin @ rkscomputersolutions dot com

if you stick all the files in one zip then i'll get it hosted, no probs...

Will have it up within a short time....
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 17, 2007, 11:49:03 PM
Done, 3Kb! :D
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: rkscscc on January 19, 2007, 10:52:05 AM
http://www.rkscomputersolutions.com/egroupware.zip

done and dusted....  thanks man
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Franco on January 19, 2007, 01:23:58 PM
Quote from: "cool34000"
Are you sure EGW users and passwords are the same that SME's ? I ask that because man can add mailboxes to a user but by default, EGW will open EGWuserlogin@localhost to retrieve mails... That's why EGWuserlogin must equal SMEuserlogin (and of course password).

EGW and SME does not need to have the same passwords, the only piece that needs access to e-smith is the mail part, and you can have different passwords set, there's an option so you can customize the imap settings. Checkmark and enter the propper information.

About the error log I was receiving, it was due to the fact I had used a localhost name instead of the fully qualified domain in setup. After fixing that, all good to go.

Thanks,
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: fpausp on January 19, 2007, 09:36:04 PM
Hi,

I have installed egroupware on sme 7.1, when i send a mail anglemail hide my adress.

Where can i change this ?

fpausp
Title: Help Empty Blank Page
Post by: steveyb on January 29, 2007, 09:27:45 PM
Hello,

I have installed egroupware using the script above with no errors however I get an empty page after i write the config at the setup page. https://www.myserver.com/egroupware/setup/index.php any help will be greatly appreciated.

Thanks

Steve
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 30, 2007, 08:46:14 PM
Have you downloaded the .zip file ?
Have you followed the howto (setup process) ?
Title: egroupware setup fail
Post by: davdo on January 31, 2007, 10:43:29 PM
I have installed egroupware using the script above with no errors however I get an empty page after i write the config at the setup page.  :shock:
Title: egroupware setup fail
Post by: davdo on January 31, 2007, 10:44:14 PM
I have installed egroupware using the script above with no errors however I get an empty page after i write the config at the setup page. Help.. :shock:
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on January 31, 2007, 11:03:37 PM
Just follow the setup howto, you will pass the setup stage :wink:
Title: I follow the setup howto
Post by: davdo on February 01, 2007, 03:40:40 AM
I get an empty page after i write the config at the setup page. the log : httpd: PHP Warning:  main(/opt/egroupware/html /phpgwapi/setup/setup.inc.php): failed to open stream: No such file or directory in /opt/egroupware/html/header.inc.php on line 118
Feb  1 03:28:18 server1 httpd: PHP Warning:  main(): Failed opening '/opt/egroupware/html /phpgwapi/setup/setup.inc.php' for inclusion (include_path='.:/usr/share/pear-addons:/usr/share/pear') in /opt/egroupware/html/header.inc.php on line 118
Feb  1 03:28:18 server1 httpd: PHP Warning:  main(/opt/egroupware/html /phpgwapi/inc/common_functions.inc.php): failed to open stream: No such file or directory in /opt/egroupware/html/setup/inc/functions.inc.php on line 47
Feb  1 03:28:18 server1 httpd: PHP Fatal error:  main(): Failed opening required '/opt/egroupware/html /phpgwapi/inc/common_functions.inc.php' (include_path='.:/usr/share/pear-addons:/usr/share/pear') in /opt/egroupware/html/setup/inc/functions.inc.php on line 47
 
?? :shock:
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on February 02, 2007, 11:08:00 AM
Which version of SME are you running ?
I tested my script on 7.0 final and actual release 7.1... Both are working on a clean install !

Have you passed successfully the tests at the beginning of install stage ? (check install)
This warning about pear is very strange...
I've seen on another howto to enter the command :
Code: [Select]
pear install log
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: dbuechel on February 21, 2007, 09:08:24 AM
one question:

there are a new release eGroupWare-1.3-015 -

how can i install or upgrade your version ?!?

thx

db


-sorry for my bad english ;) -
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on February 21, 2007, 10:01:03 PM
I found this (but not tested it for now) :
Quote from: "eGroupWare documentation"
Before you start to update your installation, make a backup from your eGroupWare
files and he database.
1) Download the packages from our sourceforge3 page.
2) Install the packages on your server:
For RPM packages do the following:
[root@server tmp]# rpm –Uvh eGroupWare*
For tar.gz packages go to your web server’s root directory (above your eGroupWare installation):
[root@server tmp]# cd /var/www/html
[root@server html]# tar xzvf eGroupWare-x.xx.xxx-x.tar.gz

Just remember that the installation is in /opt/egroupware/html ! and do a backup before (db and files) !!!
Please give feed back when done

If you do a fresh  install, this should work the same way (don't forget to change the name of the archive in the script).

I'll test it when I will have some time...
Title: problems during installation
Post by: ameier on February 22, 2007, 10:41:45 PM
hallo to all,

i have tryed to make all the steps inside your howto. I use the final 7.1 version of sme server. After the script is ready the install hangs inside the setup site.......the msql fiel could not be accessed. Who could help me out ?

thx

andreas

p.s.: hope that my pur english is not to bad for this forum........LOL
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: soprom on February 23, 2007, 01:44:11 AM
I would check permissions and re-run setup.php as header.inc.php contains path to the application. You could also check header.inc.php to make sure paths are well defined.

Skip verification if it hangs.


eGroupWare-1.3-015:

I'm testing this version in /opt/egrouphead.
I installed it following the same howto.
Note that this is a beta version and there are bugs. The version is not suitable for production... Cute but not ready yet.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: piedie on March 06, 2007, 04:23:27 PM
Hey!

I am new to SME Server, and I like it very much so far. But egroupware doesnt work.

It says something like this, when i try to sh the script (I followed the how-to, with other scripts in /egroupware/ folder.

The error is this:

: command not found 2:
: command not found 3:
--------------------------------------------------------------------------
Installation of eGroupWare (public access, automatic https redirection)...
--------------------------------------------------------------------------
: command not found 7:
: command not found 8:
: command not found 10:
: command not found 11:
Generating password...
egroupware.sh: line 98: syntax error: unexpected end of file
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on March 06, 2007, 09:46:48 PM
Hey !

Are you running this script with root account ?
If not, you must put the full path for all commands...
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: piedie on March 06, 2007, 11:46:27 PM
Yes, as root @ servername... I tried chmodding, and removing emtpy lines, but no success! Something with paths? Or missing software? Using SME 7.1.?, just downloaded it a week or two ago.

Thanks  you for helping me!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: wifinetguy on March 11, 2007, 03:52:17 AM
Hi, everyone. I've just tried this on a fresh install of SME Server 7.1. Everything gets loaded into /opt/egroupware and I've created the files as outlined in the beginning of this thread. (60-redir and 98egroupware). I've restarted the webserver.

However, when I enter the URL to go to eGW (https://domain/egroupware) I get an index of the /egroupware ibay (empty since everything is installed in /opt/egroupware). There's no redirection going on.

I followed the beginning steps very carefully. Even went back to recheck my work. I can't figure out what I did wrong. Any help would be very much appreciated. Thanks in advance.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: soprom on March 11, 2007, 03:54:30 AM
Would you happen to have an IBAY named egroupware?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: wifinetguy on March 11, 2007, 03:56:57 AM
Yes.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: soprom on March 11, 2007, 04:00:33 AM
If you installed in /opt/egroupware, then remove the egroupware ibay.
It's one method or the other. Not both!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: wifinetguy on March 11, 2007, 04:04:52 AM
OK. I tried that right after getting your last reply. I also found that the directories that the script was supposed to create, didn't. So I manually went through the script and created the directories, copied the files over, etc.

Now I get a message that it can't establish a secure connection to the server. Where can I set that?

Thanks for your help so far!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: wifinetguy on March 11, 2007, 04:06:39 AM
And now I can't get to my /server-manager. It says it doesn't exist.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: wifinetguy on March 11, 2007, 06:32:37 AM
I've done a new, fresh install of SME Server 7.1. Then did a reinstall of the script here. My problem ended up being the absense of the blank lines in the two files for redirection.

All is fine now.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: soprom on March 11, 2007, 07:38:46 AM
Did you tried https ?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: piedie on March 12, 2007, 12:07:00 AM
I still can't get it to work, but I seem to be the only one with this problem... Anybody any idea? Thanks!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: wifinetguy on March 12, 2007, 03:19:34 AM
No, you're not the only one. I can't get to my egroupware page via https:. I get the error that says that Firefox can't establish a connection to the server. Safari gives me the same error. However, I can get in via the local IP address (https://192.168.xx.xxx/egroupware). But I can't get it to work via the FQDN.

Any ideas?

Thanks in advance...

*** Edit *** - Never mind. Stupid mistake. I hadn't forwarded port 443 through my firewall. Sorry for the boneheaded post.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: piedie on March 12, 2007, 11:28:28 AM
No, I meant: I seem to be the only one who cannot install this program. But I'll keep trying... :)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: ---rv--- on March 12, 2007, 01:21:32 PM
Hi,
I did a fresh install of SME7.1 and then immediately an upgrade to SME7.1.2.
After the first screen of egroupware's initialisation (NEXT), I have an empty screen ...
(Yes, I did a correct copy and past of the template - with blank line).

I notice this :
- with this fresh SME7.1.2, I cannot acces to the internet with firefox without manually configuration of the SME proxy,
- it is only during the second stage of the egroupware's initialisation that I'll the name and port of the SME proxy ... and I cannot acces thos step.

Do you thing it could it be a proxy issue ?
Title: Problem logging in..
Post by: coolme on March 14, 2007, 07:17:16 AM
I think I succesfully installed egroupware application following the howto. My problem is that when I try to login to "Setup/Config Admin Login" using the username and password I have created I cannot able to login. It keeps coming back to login page. The strange thing that I noticed is that below "Setup/Config Admin Login" there was a message saying "Invalid IP address"

Can anyone please help me what was I did wrong or setting to configure? I am using SME 7.1.2

thanks so much..
Title: Re: Problem logging in..
Post by: raem on March 14, 2007, 08:53:38 AM
coolme

> The strange thing that I noticed is that below "Setup/Config Admin
> Login" there was a message saying "Invalid IP address"

You have probably specified (ie limited access to) the setup page to only your local network IP or domain or a wrong IP/domain under the setting for
Limit access to setup to the following addresses, networks or hostnames

You can remove that from the config database for egroupware using phpmyadmin or rerun the install.

It's best left blank initially, you can add an IP there later after initial config is completed.
Title: Re: Problem logging in..
Post by: coolme on March 14, 2007, 09:04:09 AM
tnx man :D  I think you solve my problem. I'll try this solution.

Quote from: "RayMitchell"
coolme

> The strange thing that I noticed is that below "Setup/Config Admin
> Login" there was a message saying "Invalid IP address"

You have probably specified (ie limited access to) the setup page to only your local network IP or domain or a wrong IP/domain under the setting for
Limit access to setup to the following addresses, networks or hostnames

You can remove that from the config database for egroupware using phpmyadmin or rerun the install.

It's best left blank initially, you can add an IP there later after initial config is completed.
Title: Can't login to phpmyadmin & webmail
Post by: cola29 on March 14, 2007, 04:37:02 PM
I've installed SME7.0 and smeserver-phpmyadmin-multiuser-2.0-3.noarch.rpm.  Also, I've installed eGRoupware with a seperated ibay
Code: [Select]
Name=egroupware    
Group: Everyone
User access: Write = group, Read = group
Public access : Entire Internet (no password required)
Execution of dynamic content (CGI, PHP, SSI)=enabled

I've inputted following commands to make the egroupware work.
Code: [Select]
mkdir /home/e-smith/files/ibays/egroupware/files/tmp
mkdir /home/e-smith/files/ibays/egroupware/files/backup
chown www:www /home/e-smith/files/ibays/egroupware/files/tmp
chown www:www /home/e-smith/files/ibays/egroupware/files/backup
chown -R www:www /home/e-smith/files/ibays/egroupware/html/fudforum
mkdir –p /etc/e-smith/templates-custom/etc/php.ini

A new file "/etc/e-smith/templates-custom/etc/php.ini/30mbstring" contain following parameter
Code: [Select]
mbstring.func_overload = 7
Also, .....following command,
Code: [Select]
pear install log
/sbin/e-smith/db accounts setprop egroupware PHPBaseDir /home/e-smith/files/ibays/egroupware/:/usr/share/pear-addons:/usr/share/pear/:/tmp
signal-event ibay-modify egroupware

/sbin/e-smith/expand-template /etc/php.ini
service httpd-e-smith restart

After the setup, my eGroupware work well.  However, after I installed eGroupware, it responed "#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
" when I login phpmyadmin and cannot find the webpage of webmail again.

I've tried many many time, and have some fresh re-installation.  Can you help, please.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on March 14, 2007, 08:59:59 PM
Hi !

Cola29, I did this howto because it's not secure to put web apps like eGroupWare in an ibay. Especially if you do this :
Quote from: "cola29"
Name=egroupware    
Group: Everyone
User access: Write = group, Read = group
Public access : Entire Internet (no password required)


Just download the files (http://www.rkscomputersolutions.com/egroupware.zip) and launch the script, follow the setup howto also... This has been tested and it's working fine. Read the entire post, it's full of problems/solutions. Take care of web-setup process, follow the howto... If you want to customize the config, please do it after finishing the 1st run.



About the custom template you created :
Quote from: "30mbstring"
mbstring.func_overload = 7

This is globally activated and there is no need to do so ! It just need to be set for egroupware's ibay (if you still want to use the ibay install). phpMyAdmin have problem with that. Look here for more infos (http://forums.contribs.org/index.php?topic=34362.0) (search for mbstring in the page)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cola29 on March 15, 2007, 05:37:57 PM
Hi! cool34000

Thanks for your reply.  However, when I type "sh egroupware.sh", somethign seems go wrong.  Can you help, please?
Code: [Select]
[root@server ~]# sh egroupware.sh
: command not found 2:
: command not found 3:
--------------------------------------------------------------------------
Installation of eGroupWare (public access, automatic https redirection)...
--------------------------------------------------------------------------
: command not found 7:
: command not found 8:
: command not found 10:
: command not found 11:
Generating password...
egroupware.sh: line 98: syntax error: unexpected end of file
Title: @cola29
Post by: coolme on March 19, 2007, 02:37:40 AM
Cola29, I have the same problem too using the zip that I downloaded. I don't know what was the problem with that script. What I did is that I copy paste from the howto but be aware of the space at each line, just remove the space and you will be fine.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on March 23, 2007, 10:12:46 AM
Hi !

Has anyone got more luck than me with the ability to sync SME's LDAP accounts with eGroupWare ?

Reading the doc and some posts on their forum point me to that direction :
Code: [Select]
cp -f /opt/egroupware/html/phpgwapi/doc/ldap/phpgwaccount.schema /etc/openldap/schema/
cp -f /opt/egroupware/html/phpgwapi/doc/ldap/phpgwcontact.schema /etc/openldap/schema/
mkdir -p /etc/e-smith/templates-custom/etc/openldap/slapd.conf
cp -f /etc/e-smith/templates/etc/openldap/slapd.conf/10schema /etc/e-smith/templates-custom/etc/openldap/slapd.conf/
echo "include         /etc/openldap/schema/phpgwaccount.schema" >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
echo "include         /etc/openldap/schema/phpgwcontact.schema" >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
echo >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
expand-template /etc/openldap/slapd.conf
service ldap restart


Now I'm locked and don't really know what to do next... Is this good enough to work -> so I'm just messing up the install stage
Or is there more things to be done before syncing LDAP on eGroupWare ?

Thanks for any help !
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on March 23, 2007, 10:31:18 AM
Hey !

The problem for some of you getting this error :
Quote
[root@server ~]# sh egroupware.sh
: command not found 2:
: command not found 3:
--------------------------------------------------------------------------
Installation of eGroupWare (public access, automatic https redirection)...
--------------------------------------------------------------------------
: command not found 7:
: command not found 8:
: command not found 10:
: command not found 11:
Generating password...
egroupware.sh: line 98: syntax error: unexpected end of file
is due to an abnormal character at the end of each line of the script

Remove the bad character (a square or a space) at the end of each line and relaunch... This should be better !
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cola29 on March 24, 2007, 05:56:48 AM
Thanks coolme and cool34000.  I've successfully installed the eGroupware.  However, i can;t sync with my Outlook with eGWOSync.

When I did a server test, it responed "Fault Code: 9999 Reason "xmlrpc service is not enabled in the eGroupWare system configuration: "
"..... And I'm searching for solution. :lol:
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on March 24, 2007, 09:29:41 PM
Hi !

Quote from: "cola29"
xmlrpc service is not enabled in the eGroupWare system configuration
Then just enable it !!!

Remember that sync with Outlook will not work if you're using https without a valid certificate, in this case you have to use http instead...
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cola29 on March 25, 2007, 11:18:52 AM
Quote from: "cool34000"
Hi !

Quote from: "cola29"
xmlrpc service is not enabled in the eGroupWare system configuration
Then just enable it !!!

Remember that sync with Outlook will not work if you're using https without a valid certificate, in this case you have to use http instead...


hi! cool34000,

Success after I installed the cert in my browser, Thanks.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on March 25, 2007, 12:41:00 PM
Quote from: "cool34000"
Hi !

Has anyone got more luck than me with the ability to sync SME's LDAP accounts with eGroupWare ?

Reading the doc and some posts on their forum point me to that direction :
Code: [Select]
cp -f /opt/egroupware/html/phpgwapi/doc/ldap/phpgwaccount.schema /etc/openldap/schema/
cp -f /opt/egroupware/html/phpgwapi/doc/ldap/phpgwcontact.schema /etc/openldap/schema/
mkdir -p /etc/e-smith/templates-custom/etc/openldap/slapd.conf
cp -f /etc/e-smith/templates/etc/openldap/slapd.conf/10schema /etc/e-smith/templates-custom/etc/openldap/slapd.conf/
echo "include         /etc/openldap/schema/phpgwaccount.schema" >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
echo "include         /etc/openldap/schema/phpgwcontact.schema" >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
echo >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
expand-template /etc/openldap/slapd.conf
service ldap restart


Now I'm locked and don't really know what to do next... Is this good enough to work -> so I'm just messing up the install stage
Or is there more things to be done before syncing LDAP on eGroupWare ?

Thanks for any help !

Up !!! :)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: piedie on March 25, 2007, 03:04:28 PM
Yep, it works like a charm. I thought I did remove the line, but it turns out i didn't. Sorry for that! (BTW: What a great contrib!)
Title: solved- getting blank screen after initial setup
Post by: cfmunster on March 31, 2007, 08:13:45 PM
Hey, great contrib! I just did a clean install of SME Server 7.1 and got all the software updates.  I did the install of eGroupware and, like several other people, got to a point where I did the initial config and got a blank screen on the next page in my browser.

To solve the problem, I accessed the server command-line and used vi to edit /opt/egroupware/html/header.inc.php. I had to change these lines:

        define('EGW_SERVER_ROOT','/path/to/egroupware');
        define('EGW_INCLUDE_ROOT','/path/to/egroupware');
        define('PHPGW_SERVER_ROOT','/path/to/egroupware');
        define('PHPGW_INCLUDE_ROOT','/path/to/egroupware');

to these values:

        define('EGW_SERVER_ROOT','/opt/egroupware/html');
        define('EGW_INCLUDE_ROOT','/opt/egroupware/html');
        define('PHPGW_SERVER_ROOT','/opt/egroupware/html');
        define('PHPGW_INCLUDE_ROOT','/opt/egroupware/html');

Not sure why the initial setup didn't write those lines correctly, but they didn't. Now everything works great!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: lupo on April 01, 2007, 11:50:36 PM
Hi cool34000,

thanks for that great HowTo.
I've just one (or two) question(s). You wrote some pages before to sync eGW and Outlook with eGWOSync there must be a valid certificate on the server. Is that a certificate like from cacert.org? Is there an easier way to obtain a valid certificate?
Thanks!

Lupo
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 03, 2007, 04:28:13 PM
Hi !

@ lupo : well, I don't know as I don't have a valid certificate myself... CACERT should be OK as many others...
I didn't try to accept SME's default autogenerated certificate to see if all goes without the problem...
If I understand well Cola's last post, it seems that when he accepted his certificate XMLRPC over https worked... I don't know if he is using a valid one or just the autogenerated one... Maybe he could tell more on that subject...
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: lupo on April 04, 2007, 10:54:04 PM
Quote from: "cool34000"
Hi !

@ lupo : well, I don't know as I don't have a valid certificate myself... CACERT should be OK as many others...
I didn't try to accept SME's default autogenerated certificate to see if all goes without the problem...
If I understand well Cola's last post, it seems that when he accepted his certificate XMLRPC over https worked... I don't know if he is using a valid one or just the autogenerated one... Maybe he could tell more on that subject...


Thank you so far cool34000!

@cola29: could you please provide some information how and which certificate you have installed? Thanks!

Lupo
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cola29 on April 05, 2007, 06:47:46 PM
Quote from: "lupo"
@cola29: could you please provide some information how and which certificate you have installed? Thanks!

Lupo
When I log on to https://domain/server-manager/ I can view and install the cert to my browser.  it is what the cert I said. :D
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: lupo on April 08, 2007, 06:06:06 PM
Quote from: "cola29"
When I log on to https://domain/server-manager/ I can view and install the cert to my browser.  it is what the cert I said. :D


Thanks for that information. Did you use Internet Explorer to install the certificate? Have you changed any of the standard settings in the dialogue? I tried to install the certificate but everytime I open the Servermanager I am asked again if I want to accept the certificate.

As cool34000 described earlier, I tried to do the "Introspection" for xmlrpc. And it says this:
Code: [Select]

Fault: Code: 5 Reason 'Didn't receive 200 OK from remote server. (HTTP/1.1 302 Found)'
methods available at http://192.168.10.250:80/egroupware/xmlrpc.php

instead of that what cool34000 posted. I use egroupware via https and xmlrpc is activated?

The Logintest with eGWOsync fails.

Any Ideas what goes wrong?
Thanks!

Lupo
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 16, 2007, 04:30:42 AM
Quote
Quote:
[root@server ~]# sh egroupware.sh
: command not found 2:
: command not found 3:
--------------------------------------------------------------------------
Installation of eGroupWare (public access, automatic https redirection)...
--------------------------------------------------------------------------
: command not found 7:
: command not found 8:
: command not found 10:
: command not found 11:
Generating password...
egroupware.sh: line 98: syntax error: unexpected end of file
is due to an abnormal character at the end of each line of the script

Remove the bad character (a square) at the end of each line and relaunch... This should be better !
 
 


I am getting this error. However, if I pico egroupware.sh, I do not see any "squares" and the end of each line. I have also tried opening the fle with notepad and wordpad and not square. Any help would be appreciated.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 16, 2007, 11:31:29 AM
Try to do :
Code: [Select]
sh -x egroupware.shWell that's the verbose way, but you should see what's going on... And what's wrong...
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 16, 2007, 07:08:29 PM
Thx for quick reply. I found an extra character at the end of the egroupware.sh file. I deleted it and things ran smoothly until I did the installation check and found 3 warnings. I see that the mysql database is enabled, but I don't know if I will use the others it mentions. Is this a concern?
Quote
Checking the eGroupWare Installation
 Checking required PHP version 4.3+ (recommended 5.0): 4.3.9 ==> True
 Checking php.ini: safe_mode = Off: ini_get('safe_mode')='' = Off
 Checking php.ini: magic_quotes_runtime = Off: ini_get('magic_quotes_runtime')='0' = Off
 Checking php.ini: register_globals = Off: ini_get('register_globals')='0' = Off
 Checking php.ini: memory_limit >= 16M: ini_get('memory_limit')='32M'
 Checking php.ini: max_execution_time >= 30: ini_get('max_execution_time')='60'
 Checking php.ini: file_uploads = On: ini_get('file_uploads')='1' = On
 Checking php.ini: include_path contain .: ini_get('include_path')='.:/usr/share/pear-addons:/usr/share/pear'
 Checking extension mysql is loaded or loadable: True
 Checking extension pgsql is loaded or loadable: False
The pgsql extension is needed, if you plan to use a pgSQL database.
 Checking extension odbc is loaded or loadable: False
The odbc extension is needed, if you plan to use a MaxDB, MsSQL or Oracle database.
 Checking extension oci8 is loaded or loadable: False
The oci extension is needed, if you plan to use a Oracle database.
 Checking extension mbstring is loaded or loadable: True
 Checking php.ini: mbstring.func_overload = 7: ini_get('mbstring.func_overload')='7'
 Checking extension imap is loaded or loadable: True
 Checking extension session is loaded or loadable: True
 Checking PEAR is installed: True
 Checking PEAR::Log is installed: True
 Checking for GD support...: True
 Checking file-permissions of . for not world writable: root/www dr-xr-x---

This might take a while, please wait ...
 Checking file-permissions of header.inc.php for not world readable: www/www -rw-------
 Checking file-permissions of fudforum for writable by the webserver: root/www drwxrwx---
 Checking if php.ini setting session.save_path='/tmp' is writable by the webserver: root/root drwxrwxrwt

Please fix the above errors () and warnings()
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 16, 2007, 08:39:58 PM
Hi!

You have no pb here!
Quote
Checking extension mysql is loaded or loadable: True
Checking extension pgsql is loaded or loadable: False
The pgsql extension is needed, if you plan to use a pgSQL database.
Checking extension odbc is loaded or loadable: False
The odbc extension is needed, if you plan to use a MaxDB, MsSQL or Oracle database.
Checking extension oci8 is loaded or loadable: False
The oci extension is needed, if you plan to use a Oracle database.

Your server must use one of the 4 db engine supported by eGroupWare!
mysql support is enough! :D
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 16, 2007, 09:33:30 PM
Thx;

I am struggling with the blank screen problem that others mentioned earlier in the postings. I will have a look and see how far I get.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 17, 2007, 04:39:27 PM
I have done a bit more work re the blank screen episode;
1) I followed cfmunsters posts
Quote
To solve the problem, I accessed the server command-line and used vi to edit /opt/egroupware/html/header.inc.php. I had to change these lines:


but I found that this file was completely empty.

I decided to start over again so I deleted the folder /opt/egroupware. I ran the egroupware.sh again. I do not get any errors but now I don't even get to the set up page.

So probably something is wrong with the sh file or the other two. I downloaded everything from the zip file that was posted about halfway through by rkscscc. Do these files still have the errors in them? Is there a checksum for it?

Thanks for any help you can lend.

Ian
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 17, 2007, 05:34:10 PM
Hi !

I've done a lot of tests and I was never able to reproduce the extra character pb or the blank screen pb... This is really strange!

There are no errors in this file, I don't know why, maybe while dezipping or at download stage (binary vs ASCII) some of you get this error!

I would be curious to know how you download/unzip the file...
Here's my way: download the .zip file under windows, extract the downloaded files on my desktop, upload them using winscp and finaly launch the script with putty.


Infotip: If you want to reinstall eGroupWare, you also have to drop egroupware database!
I suggest you phpmyadmin to do that. Search for this contrib on this forum if you don't already have it.
The user shouldn't have to be deleted as the password is changed (this means the password also change for eGroupWare setup...)
The template is overwritten so no need to delete it.
Finaly, in some case you could need to delete cookies cache in your browser:
that happened to me once while I was testing and it was messing up the authentification just after install. It was trying to connect with the old cookie (not using the same password) and finaly it blacklisted me for 30 minutes because the cookie tryed more than 3 times to reconnect automatically :lol: I search a long time before understanding why it wasn't working anymore!
I hate cookies!!! :evil: lol


Also by the way, you cleaned the extra character in the script but did you checked the template ?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 17, 2007, 06:12:48 PM
Hi, thx for quick response.

I used winzip to extract into C: and then pscp to move over onto server.

I could not see an extra character at the end  of egroupware.sh, but when I "arrowed" thru, I was able to go past the end of the line. I backspaced, tried again and it ran without errors.

I will follow the rest of your advice at home tonight.

One more pertinent item is that I tried this on an extra pc, not the one acting as my gateway/server. This machine is in server mode only. I was reluctant to screw up my main machine.  I used the same domain name for it but a different server name. Is there some reason that I cannot use the local address i.e.192.168.***.***.

Thx in advance

Ian
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 17, 2007, 06:35:59 PM
Hi.

You can even use IP or your server name, this should be the same.

Try to delete database, I'm pretty sure this is it.
If it isn't enough, clean cookie cache... Else... Well... Send me a plane ticket :lol:
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 17, 2007, 07:53:31 PM
I'll give it a try and let you know.

Re the plane ticket, you obviously haven't been watching the weather. Global warming my a$$!
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 18, 2007, 11:41:28 PM
I was up until about 01:30 trying to get this going on test server but it would not happen,

Tried today on "production" and worked perfectly. I think the problem was around the local addressing and website names for my "server mode" only test machine.

Thx for help.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 19, 2007, 12:08:52 AM
Hi !


Quote from: "imcintyre"
Tried today on "production" and worked perfectly
Very good :D

Quote from: "imcintyre"
I think the problem was around the local addressing and website names
If you look at my howto for the setup stage in the first page of this post, the only fields refering to your domain name are:
Quote
Database instance (eGW domain) : mydomain.com
Quote
Enter the hostname of the machine on which this server is running : mydomain.com
Have you changed those fields according to your specific config? (the server's name instead)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 19, 2007, 12:38:03 AM
Yes, well at least I tried. I used the local address in both cases because my production server has the domain name but there is nothing that I saw to specify server1 or server2 in the https://mydomain.com/egroupware.

So I ended up putting the 192.168.***.*** into both places. I think then there may have been a conflict with the variables where localhost was the correct answer. I think I posted the error I received last night but either I messed it up or it was removed(?). Anyways I can post again tonight when I get home.

I had tried 4 or 5 times and I got worn down by the experience. I figured that this could be the problem and the only solution was to try on production server. Besides, I was becoming rather adept at removing it.

I also made up a small how to for noobs like me to install phpmyadmin contrib which I will post later, it is probably child's play for others but I couldn't find any directions anywhere. Besides deleting databases, what else is it for? Couldn't I have just as easily gone into the directories and deleted the database?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 19, 2007, 01:02:48 AM
Re !

Well then I guess you should try proxypass, maybe that's the solution to run it in that specific config...
I don't use it myself but you should find some help over google or even here.

About phpmyadmin, before posting your howto, see this (http://wiki.contribs.org/PHPMyAdmin)
Don't know if you're using this dmay's version anyway...


phpmyadmin is just an easy web interface to mysql.
You can create, modify or delete users
You can create, modify or delete databases
You can import or export your databases (i.e. for backup purpose !)
...and more...
Please keep this rpm up to date as security issues are found from time to time (and/or close its access from the outside, especially if you don't need it)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 19, 2007, 01:32:35 AM
Yes I am using dmays contrib and I searched everywhere for a how to but could not find. I ended up using rpm to install but wasn't exactly sure how to go about...

I do not have it on my production server and I don't have access without vpn to my network to get at test. The whole database thing is is beyond me at the moment so I will keep it that way.


Thx
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Holmgreen on April 19, 2007, 01:14:10 PM
Quote from: "cola29"

Code: [Select]
[root@server ~]# sh egroupware.sh
: command not found 2:
: command not found 3:
--------------------------------------------------------------------------
Installation of eGroupWare (public access, automatic https redirection)...
--------------------------------------------------------------------------
: command not found 7:
: command not found 8:
: command not found 10:
: command not found 11:
Generating password...
egroupware.sh: line 98: syntax error: unexpected end of file


I was fighting the exact same problem, but found the solution late last night:

I was using the vi-editor in putty to edit the files as instructed in this guide, and i swear by my family grave, that i removed all unattended spaces in all files. So i was rather puzzled that it didn't work - right up 'till the point where i installed winscp and opened the files in notepad. There it was... the space character in the very end of the file: egroupware.sh.

So... for those of you who are struggling with the same error and can't get it to work: Try another editor. Try Notepad. I had such high thoughts of the vi-editor and practically no good to say about Notepad - now i have to rethink my priorities... darn it  :wink:

And one last thing:
I can't thank you enough Cool34000, for the guide and for all the help you have done in this threat. I know it takes a lot of time, and hopefully you know that many of us would never have been able to get this to work, without you helping us. Thank you pal :D
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 19, 2007, 04:06:29 PM
Somebody made the comment that it might have something to do with the unzipping.

I never did see the squares at the end of each line. I opened with vi, pico and notepade. My original error was that the *.sh would not run, error at line 97. I used pico to open it and did not see any characters. I went to last line which was one line below the last row of code (started with echo as I recall), backspaced once, saved and away I went.

I used winzip to unzip the *.sh file. I did get the error you mentioned here but it was set up related.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 20, 2007, 06:26:11 PM
I am trying to figure this out at the Egroupware site but I was curious if anybody else has the problems of the alarms not working for calendar events. I have set them properly as there is an icon in the meeting that looks like a bell but no sound or flashing lights.

any comments?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 20, 2007, 06:40:34 PM
Hi!

I think alerts are send via email... Have you filled user's email address in its account when you created it ?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on April 20, 2007, 09:57:40 PM
I did and I also turned on email notices in the calendars section. I was hoping for the kind of outlook functionality that when you are beavering away you get a pop up alerting you that you are going to be late for the next meeting.

I went to their website and there was a bunch of noise about turning on the asynchronous function and importing the cron, but no "how to"

Do you have this function working?

Sometimes I get frustrated with this site but in going to other sites I realize how good this one is for help/responses and easy to follow format.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 20, 2007, 11:39:06 PM
Hi.

I'm not using this function...
One lead may be sync eGroupWare with Outlook and let Outlook do what you are expecting.


Have you tryed to post on their forum?

The website isn't rich in howtos or docs about the contribs, but the core product is not badly documented...
If it's not in there, it's just waiting for someone to do it  :P
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: crazybob on April 22, 2007, 08:25:04 AM
I am having the same problem as lupo trying to sync

Quote
As cool34000 described earlier, I tried to do the "Introspection" for xmlrpc. And it says this:
Code:

Fault: Code: 5 Reason 'Didn't receive 200 OK from remote server. (HTTP/1.1 302 Found)'
methods available at http://192.168.10.250:80/egroupware/xmlrpc.php

instead of that what cool34000 posted. I use egroupware via https and xmlrpc is activated?

The Logintest with eGWOsync fails.


[edit]

I just tried removing the redirect template, and reconfiguring, and now I can pass the logon/logoff test with eGWOSync.

Bob
I am using a valid cert.

Bob
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: crazybob on April 22, 2007, 02:14:20 PM
A thought on the blank page during setup. It may be Firefox causing the problem. I have run into other cases where PHP programs will work only with IE for some functions.

I have tried installing this with both browsers. And it appears the blank page does not occure with IE.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on May 19, 2007, 04:28:10 AM
Hello everyone,

I found this eGroupware contrib on this site http://www.smesmith.de/download/sme7/contribs/test/.

I downloaded it and installed it with "yum localinstall *"

I have just begun trying it but so far everything looks like its working fine.

It was so simple to install I wanted to let everyone know!


Kevin[/code]
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: dbuechel on May 25, 2007, 11:18:12 AM
have someone the file:

smeserver-egroupware-1.2.106-1.noarch.rpm

???

great

db
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: fpausp on May 25, 2007, 12:53:53 PM
http://sudemo.info/sme/index.php?dir=sme7%2Fwebapp%2Fegroupware%2F
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on May 25, 2007, 03:03:28 PM
Has anyone had any success getting egroupware to authenticate users against the SME LDAP service?

Or just get egroupware to be able to read and/or write from/to the SME LDAP service for the address book?


If so would you please post some instructions?


Thanks,

Kevin
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: dbuechel on May 25, 2007, 03:48:22 PM
when i want to install:

Quote

[root@willrouter ~]# yum localinstall smeserver-egroupware-1.2.106-1.noarch.rpm
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Loading "fastestmirror" plugin
Loading "smeserver" plugin
Setting up Local Package Process
Cannot open file: smeserver-egroupware-1.2.106-1.noarch.rpm. Skipping.
Nothing to do
================================================================
No new rpms were installed. No additional commands are required.
================================================================



hmmm... what´s wrong ?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: crazybob on May 25, 2007, 04:45:15 PM
Did you download the rpm?
Did you try to run the yum command from the location you downloaded the rrpm to?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on May 27, 2007, 08:18:43 PM
I am getting nowhere with the LDAP authentification.

I tried the scripts from cool3400 and they seem to work after I corrected a permissions issue with the /etc/openldap/schema/phpgw* files.

When I try to execute one of the LDAP scripts in egroupware i always get this message: "Error: Can't bind to LDAP server: cn=root,dc=<xxx>,dc=org! /setup/ldapimport.php"

I am guessing that my egroupware configuration is wrong

Code: [Select]
Do you want to manage homedirectory and loginshell attributes?:  No  
LDAP Default homedirectory prefix (e.g. /home for /home/username):  /home
LDAP Default shell (e.g. /bin/bash):  /bin/bash
LDAP host:  localhost
LDAP accounts context:  ou=person,dc=<xxx>,dc=org
LDAP search filter for accounts, default: "(uid=%user)", %domain=eGW-domain:  
LDAP groups context:  ou=posixGroup,dc=<xxx>,dc=org
LDAP rootdn (searching accounts and changing passwords):  cn=root,dc=<xxx>,dc=org
LDAP root password:  
LDAP encryption type:  DES  
Enable LDAP Version 3:  No  


Does anyone have any suggestions as to what these values should be?


Thanks in advance for your help!


Kevin
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on May 29, 2007, 07:07:42 AM
Hi!

I had an error trying to delete a user. It looks like the MySQL user needs LOCK TABLES on egroupware database.

You can easyly update this setting using phpmyadmin...

------

I saw the RPM version at sudemo but it's very old. I recommend not using it.
Dietmar Berteld has made an rpm based on this howto, it's better to use his rpm. See this page (http://wiki.contribs.org/Egroupware) in the wiki for more details. The bug I'm talking about is also in the rpm!

------

About LDAP, it would be very nice to make it work...
I can't believe that we are only 2 interested in this feature!
Quote from: "kevinb"
I tried the scripts from cool3400 and they seem to work after I corrected a permissions issue with the /etc/openldap/schema/phpgw* files.
What did you do exactly?
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: jester on May 29, 2007, 09:00:12 AM
SME does not store authentication information in LDAP, so you won't be able to authenticate SME users through LDAP.

There is work being done on this by Charlie (see bug: http://bugs.contribs.org/show_bug.cgi?id=1543) but it is still in SME-Future as a NFR so it might take some time... i don't know of voting for bugs is being taken into account by the devs, but you could vote for it.

regards,
jester.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on May 29, 2007, 05:24:03 PM
Thanks jester,

We'll continue to use IMAP for authentification. That is acceptable. Would be nice to have the user info (name etc) pulled over when a new account is logged into.

Also we would like to have the LDAP address book available in egroupware. Does anyone have any intructions they could share? I would be greatly appreciated.


Thanks again,

Kevin
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on May 30, 2007, 04:52:04 AM
cool3400,

I ran this:
Code: [Select]
cp -f /opt/egroupware/html/phpgwapi/doc/ldap/phpgwaccount.schema /etc/openldap/schema/
cp -f /opt/egroupware/html/phpgwapi/doc/ldap/phpgwcontact.schema /etc/openldap/schema/
mkdir -p /etc/e-smith/templates-custom/etc/openldap/slapd.conf
cp -f /etc/e-smith/templates/etc/openldap/slapd.conf/10schema /etc/e-smith/templates-custom/etc/openldap/slapd.conf/
echo "include         /etc/openldap/schema/phpgwaccount.schema" >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
echo "include         /etc/openldap/schema/phpgwcontact.schema" >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
echo >> /etc/e-smith/templates-custom/etc/openldap/slapd.conf/10schema
expand-template /etc/openldap/slapd.conf
service ldap restart


And then change the permissions of "/etc/openldap/schema/phpgw*" to allow read from everyone.


I wish I have some idea of what to enter for the LDAP information in the eGruopware setup. I have been searching but do not understand this .... yet.


Kevin
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on June 01, 2007, 04:19:14 PM
Has anybody upgraded to v 1.4?

 I had some issues with some of the missing functions in V1.2. When I checked with the egroupware web site forum, they told me my problems would be solved ( :roll: ) with an upgrade to V 1.4.

Thx in advance.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: jester on June 01, 2007, 04:45:41 PM
eGroupWare 1.4 is still a RC, one of these days it should become final cause they planned to release it during LinuxTag that is running until tomorrow, so....
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: imcintyre on June 01, 2007, 06:39:43 PM
Thx for the heads up, I have enough problems just muddling through regular issues...
Title: eGroupWare ver. 1.4.x final release is out
Post by: tadej.cepin on June 06, 2007, 09:39:06 AM
It would be nice if someone provide script and rpm for instalation of new v1.4.x eGW on SME 7.x ;)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on June 18, 2007, 08:49:44 PM
Hi all


Anyone using eGroupWare v1.2.106 should update ASAP as security issues were found. See http://www.egroupware.org/news for more details.
You have 2 choices:
1) update to v1.4
2) update to v1.2.107

Berdie made this rpm (http://forums.contribs.org/index.php?topic=37313.0) based on the new release of v1.4 but there are not many contribs available right now as it's a new version.

So, as an alternative, I've made an rpm based on v1.2.107 to benefit from all features. All security issues are fixed in this release, as in v1.4.
This rpm can be found here (http://mirror.contribs.org/smeserver/contribs/sgomez/contribs/egroupware/smeserver-egroupware-1.2.107_2-1.noarch.rpm)
Installation process is the same, you just have to create eGroupWare's admin account and change both Header admin and Config admin passwords.
SME users can login (email auth) with their login/password


Please note that both rpms cannot update an existing installation of eGroupWare
For more details on how to upgrade an existing installation, RTFM!


Best regards,
Sylvain
Title: Adress Book
Post by: heyyo on June 23, 2007, 07:27:01 PM
I have installed the new RPM egroupware 1.4 on SME 7.1.3 + php5 + mysql 5. I would like to set up LDAP settings in Egroupware's administration panel to see my SME users and group in the Egroupware's adressbook.
my domain is of the type mydomain.dyndns.org.
Any help would be appreciated.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on June 23, 2007, 09:51:59 PM
I would love to get this answered. I have been beating my head against this wall for weeks.

It appears that the 1.4 version of EGW does not require the installation of new schemas.

But I have yet to get EGW to read the LDAP store, write to the LDAP store or authenticate against the LDAP store.

There is some activity on this in the bug tracker.

Kevin
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: Peasant on June 29, 2007, 05:18:00 PM
Just tried installing from the contib for the first time. I notice that if I go into 'Edit Configuration' in the config-admin it lists the hostname of the machine on which the installation is running as musterfirma.com This is also listed under mail domain. I've a feeling these shouldn't be there, but can someone confirm this for me?

Thanks.
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on June 29, 2007, 05:34:21 PM
Hi...


You don't tell which RPM you installed. Is it v1.2.x or v1.4.x ?
And witch release did you used?
Did you follow install instructions after RPM is installed?
We need details to help :wink:


To everyone:
This thread is about v1.2.x and there is an otherone about v1.4.x
Post in the appropriate thread please.
Thanks in advance.



Best regards,
Sylvain
Title: egroupware installation http 403 forbidden problem
Post by: allforone on August 01, 2007, 12:28:15 AM
1. New 7.2 install  without the updates that appear after the installation.
2. when trying to access the configuration screen I get a HTTP 403 forbidden at this address http://hserver/egroupware/setup
3. I looked in the primary Ibay and saw nothing.
4. Boot Log errors ( these were the only ones)
Jul 31 11:02:27 hserver 10fix_privilege_tables: ERROR
Jul 31 11:02:27 hserver 10fix_privilege_tables:  1060 (42S21) at line 22: Duplicate column name 'File_priv'
Jul 31 11:02:27 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
Jul 31 11:02:27 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
Jul 31 11:02:27 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
Jul 31 11:02:27 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
Jul 31 11:02:32 hserver 10fix_privilege_tables: ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
Jul 31 11:02:32 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
Jul 31 11:02:32 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
Jul 31 11:02:32 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
Jul 31 11:02:32 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
Jul 31 11:02:32 hserver 10fix_privilege_tables: ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
Jul 31 11:02:33 hserver 10fix_privilege_tables: ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
Jul 31 11:02:36 hserver 10fix_privilege_tables: @hadGrantPriv:=1
Jul 31 11:02:36 hserver 10fix_privilege_tables: 1
Jul 31 11:02:36 hserver 10fix_privilege_tables: 1
Jul 31 11:02:36 hserver 10fix_privilege_tables: @hadShowDbPriv:=1
Jul 31 11:02:36 hserver 10fix_privilege_tables: 1
Jul 31 11:02:36 hserver 10fix_privilege_tables: 1
Jul 31 11:02:36 hserver 10fix_privilege_tables: waiting for mysqld to restart
Jul 31 11:02:37 hserver mysql.init: Loading 10fix_privilege_tables into mysql succeeded
Jul 31 11:02:37 hserver mysql.init: Loading 20mysql_migrate_horde into mysql succeeded
Jul 31 11:02:37 hserver mysql.init: Loading 21horde.mysql_set_password into mysql succeeded
Jul 31 11:02:37 hserver mysql.init: Loading 30horde_mysql_create_tables into mysql succeeded
Jul 31 11:02:38 hserver mysql.init: Loading 40horde_mysql_create_indexes into mysql succeeded


Also, sorry for posting in the wrong area, It will not happen again, community, I am new to posting.
Title: Re: egroupware installation http 403 forbidden problem
Post by: wr19026 on August 03, 2007, 09:19:51 PM
Quote from: "allforone"
1. New 7.2 install  without the updates that appear after the installation.
2. when trying to access the configuration screen I get a HTTP 403 forbidden at this address http://hserver/egroupware/setup

[snip]


I ran into exactly the same problem, anyone have any ideas?

EDIT: Beats me, but now it works :)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on August 03, 2007, 11:10:00 PM
Hi,

What version are you using? 1.2.x or 1.4.x?
I've tested v1.2.107 on my new SME 7.2 (with updates) and it still works very well...
The error you've seen is not egroupware related: it's talking about horde.
Please rise a bug or search if there are no bugs about this problem.

Don't expect to see anything in Primary ibays, RPM install goes in /opt (both versions)

There are a lot of chance that you messed up your apache configuration and that after a reconfiguration all came back (thanks to the template system!)
Title: [HOW TO] Install eGroupWare on SME 7.x
Post by: supersonico on August 10, 2007, 10:07:03 PM
Hi there.

Cool34000 is such a great howto and RPMS. thanks

I want to make a suggestion to any body that use EGW1.2 and want to use the funambol plug-in.

don't use the funambol plug-in 6.0.14 it doesn't work. so I finally make it work with the funambol-outlook-plugin-3.0.15.exe

available at

http://forge.objectweb.org/project/showfiles.php?group_id=96

In other hand I cant not make work the site-mgr in the root of the webserver.

Yes to use the site-mgr as the default web page in the server.
Title: Install eGroupWare 1.4 on SME 7.x (7.2)
Post by: nefkho on August 17, 2007, 09:28:17 AM
hi,

i tried installing the eGroupWare 1.4 on sme 7.2, one of the problem i encounter is the "Tracking System", i can view but when i add i just get blank or empty page. any one can help me?

thanks,
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: edgetek on October 29, 2007, 02:46:03 AM
I am trying to install and configure eGroupware on a new 7.2 SME with all updates. 
I am using the following contrib http://wiki.contribs.org/Egroupware
It installs fine and I can access the setup with the config-admin with the admin password.
However on the setup.php page, Step 3 - Admin Account if I activate the button it takes me back to the setup login screen.  it does this for any of the buttons.  Every step 1-6 are have green check marks, excluding step 3 and all of them have the same out come, that is to take me back to the setup login screen
Does anyone have any ideas on why this is not working?
Thank you for you help in advance.
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: SoftDux on February 20, 2008, 11:27:01 AM
hi all

I hope someone can help me. I installed eGroupware as per the wiki: http://wiki.contribs.org/Egroupware and setup an admin account (username = admin / password = admin), yet I cannot login, not even with the demo accounts.

I'm running SME 7.3, and use smeserver-egroupware-1.4.002-3.el4.sme.noarch.rpm

From phpMyAdmin I can see the admin account, and resetting the password as an MD5 type password doesn't help either. A reboot didn't work either. Any suggestions?
Title: Re: hellp Install eGroupWare on SME 7.x
Post by: mgb on April 13, 2008, 02:41:07 PM
is not work
You appear to have MySQLi (php5) support.*
No PostgreSQL support found. Disabling*
No MS SQL Server support found. Disabling*
No ODBC support found. Disabling*
No Oracle support found. Disabling*
You appear to have PHP session support. Enabling PHP sessions.*
is no work hellp
  http://217.194.194.156/egroupware
SME 7.3
Title: Re: hellp Install eGroupWare on SME 7.x
Post by: janet on April 14, 2008, 12:46:40 AM
mgb

Quote
  http://217.194.194.156/egroupware

When browsing to that site, the error I get is:

Fatal Error: It appears that you have not created the database tables for eGroupWare. Click here to run setup.

Seems self explanatory to me.
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: mgb on April 14, 2008, 08:05:50 AM
mysql -u root -p
Enter password:*******
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Your Database is not working!: Access denied for user 'egroupware'@'localhost' (using password: NO)
Make sure that your database is created and the account permissions are set.

Instructions for creating the database in MySql:
Login to mysql -
[user@server user]# mysql -u root -p
Create the empty database and grant user permissions -
mysql> CREATE DATABASE egroupware;
mysql> GRANT ALL ON egroupware.* TO egroupware@localhost IDENTIFIED BY '';

Or we can attempt to create the database for you:

password is not work for mysql ???
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: mgb on April 14, 2008, 08:08:12 AM
mysql -u root -p
Enter password:*******
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Your Database is not working!: Access denied for user 'egroupware'@'localhost' (using password: NO)
Make sure that your database is created and the account permissions are set.

Instructions for creating the database in MySql:
Login to mysql -
[user@server user]# mysql -u root -p
Create the empty database and grant user permissions -
mysql> CREATE DATABASE egroupware;
mysql> GRANT ALL ON egroupware.* TO egroupware@localhost IDENTIFIED BY '';

Or we can attempt to create the database for you:

password is not work for mysql ???


https://217.194.194.156/egroupware/setup/index.php
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: mgb on April 14, 2008, 12:27:52 PM

https://217.194.194.156/egroupware/setup/index.php
I FIX MYSQL

is new erro
login
 Blocked, too many attempts*
 

Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: mgb on April 14, 2008, 01:10:18 PM
I FIX MYSQL

is new erro
login
 Blocked, too many attempts*
and is not work good in hebrew

  ?????? ????? ??-?????? 
eGroupWare ?????? ?? ????? ?????? ?? ????? ???? ????? ???? 
??? ????? ???? ?????? ??????  Basque Brazil Bulgarian Catalán Croatian Czech Danish Deutsch Dutch English Español Français Greek Hebrew Hungarian Italiano Japanese Korean Latvian Lithuanian Norwegian Persian Polski Portuguese Russian Slovenian Slovensky Suomi Swedish Thai Turkish Ukrainian Vietnamese simplified Chinese traditional Chinese (Taiwan)  ??? ???? ????? ?? ????? ?????? ????

  ??? ?? ?? ????? ?????? ????? ?????
  ???? ???? ????? ??? ????? ??????? ????
  ???? ?????? ?????? ???? 
 ?????? debug ????? ????? ?????? 

 


Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on April 23, 2008, 06:56:07 AM
Is the author of this contrib planning on an upgrade soon? Version 1.4.003 and 1.4.004 now support groupdav so we can sync the address book of Thunderbird with eGroupware.
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: SoftDux on April 23, 2008, 04:20:58 PM
hi all

I hope someone can help me. I installed eGroupware as per the wiki: http://wiki.contribs.org/Egroupware and setup an admin account (username = admin / password = admin), yet I cannot login, not even with the demo accounts.

I'm running SME 7.3, and use smeserver-egroupware-1.4.002-3.el4.sme.noarch.rpm

From phpMyAdmin I can see the admin account, and resetting the password as an MD5 type password doesn't help either. A reboot didn't work either. Any suggestions?

Does someone perhaps know why Affa isn't working?
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: janet on April 23, 2008, 05:12:40 PM
SoftDux

Quote
Does someone perhaps know why Affa isn't working?

Please start a new thread and be a lot more specific and informative about the Affa problem you are having.
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 23, 2008, 06:53:50 PM
Hi,

Is the author of this contrib planning on an upgrade soon?
No, I don't... Simply because this contrib is in "smecontribs" and I don't know how to update it and don't have the time to learn how.
Follow eGroupWare's upgrade procedure on their website.


Regards,
Sylvain
Title: Re: [HOW TO] Install eGroupware on SME 7.x
Post by: kevinb on April 23, 2008, 07:33:21 PM
Hi Sylvan,

I understand your time constraints.

I have performed several installs and upgrades of eGroupware (even your contrib) with good success. This time however I get an error when creating a new email. The FCKeditor apparently has a hard coded path that does not work with the contrib (I do not understand why ... yet).

If you have done this upgrade please let me know if it worked. If it did work I will start the process of beating the wall with my head until I understand it.

Thanks,

Kevin
Title: Re: [HOW TO] Install eGroupware on SME 7.x
Post by: kb-ohnemus on April 23, 2008, 07:52:26 PM
This time however I get an error when creating a new email. The FCKeditor apparently has a hard coded path that does not work with the contrib (I do not understand why ... yet).

Well, something has changed about fckeditor, so after the upgrade to 004  fckeditor couldn't load fckstyles.xml and every app using fckeditor (mail, knowledbase) has complained about this. After searching for hours I cleared my browsers cache and the problem was mirically gone.
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: cool34000 on April 23, 2008, 08:02:17 PM
Hi,

I cleared my browsers cache and the problem was mirically gone.

That's because:
Quote from: egroupeware.org latest news .004 update
Please note: as FCK contains many static javascript and css files, you and your users might have to delete the browser cache after the update!

 :-D
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: kb-ohnemus on April 23, 2008, 08:42:50 PM
So always read the manual  :-P
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on April 24, 2008, 01:35:57 AM
No happiness here. I have cleared everything from Firefox and IE 6 and IE 7 (on more than one machine).

I confirmed I updated with "1.4.004-2".

The "Check Installation" in setup does have a new warning "Checking PEAR::Auth_SASL is installed: False
PEAR::Auth_SASL is needed by: EMailAdmin, felamimail. You can install it by running: pear install Auth_SASL". "pear install Auth_SASL" does not work. do I need this? I can log into EGW.

When I compose a new email in Firefox or IE 6, 7, I get "Error loading '/egroupware/phpgwapi/js/fckeditor/fckstyles.xml' (http Status: 200)".

I do not have any errors in EGW.

In the messages log I have "httpd: PHP Warning:  imap_open(): Couldn't open stream {localhost:143/notls}INBOX in /opt/egroupware/html/phpgwapi/inc/class.auth_mail.inc.php on line 76"

No errors in the httpd logs.

Any help would be appreciated. Thanks.

Kevin
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: atariblau on April 24, 2008, 11:57:00 AM
@kevinb:

I had this particular error with FCKEditor when testing different CMS (websitebaker, phpwcms, ...) with SME as they're also using this inline editor. This error drove me mad and searching the web only resulted in very little hints to solve this problem.

But finally the solution was to add the following line to httpd.conf:

AddType text/xml .xml

So you have to integrate this line to the scripts of this contrib and the error should be gone.
For me it worked like a charm and with all scripts using the FCkeditor.

HTH
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: gerteb on May 14, 2008, 01:20:24 AM
Have today installed eGW 1.4.004 because i badly need groupdav to sync with Thundebird/Lightning.

The first attempts to open https://my.domail/egroupware/icalsrv/groupdav.php/addressbook/ returned http error 403

From the howto: http://wiki.contribs.org/index.php?title=Egroupware i expanded the file /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90egw-syncml to look like this:
<Location /egroupware/rpc.php>
      AddHandler php5-cgi .php
      Action php5-cgi /php5-cgi/php
</Location>
<Location /egroupware/icalsrv.php>
      AddHandler php5-cgi .php
      Action php5-cgi /php5-cgi/php
</Location>
<Location /egroupware/icalsrv/groupdav.php>
      AddHandler php5-cgi .php
      Action php5-cgi /php5-cgi/php
</Location>


When i now open https://my.domail/egroupware/icalsrv/groupdav.php/addressbook/ i am prompted to login, but no action is taken upon login with eGW user/password

The access_log shows: "GET /egroupware/icalsrv/groupdav.php/addressbook/ HTTP/1.1" 401

And the error_log shows: PHP Warning:  imap_open() [<a href='function.imap-open'>function.imap-open</a>]: Couldn't open stream {localhost:143/notls}INBOX in /opt/egroupware/html/phpgwapi/inc/class.auth_mail.inc.php on line 76

It seems that something is going wrong on icalsrv/groupdav auth and eGW auth?? Can anybody help me on this problem?
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: kevinb on May 14, 2008, 01:48:43 AM
I too am dying for TB / Outlook contact syncing.

I had to back burner trying atariblau's suggestion (I'll need more instruction on this too atariblau ... thanks) to fix the FCKEditor problem and we are currently using a Funabol server (on Windows)to sync.

Please let me know if you get this working.

Kevin
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: gerteb on May 16, 2008, 06:40:17 AM
Have been digging into the auth problem with groupdav.php. PHP run as cgi does NOT support basic http auth!! As rpc.php, icalsrv.php and groupdav.php has to be run under PHP5, and sme does not work under PHP5, they have to be run under PHP5 as cgi  :-x

But there seems to be som solution by use of apache rewrite :P Have found these 2 rewrite solutions:
http://www.sslcatacombnetworking.com/articles/http-authentication-php-cgi.html
http://drupal.org/node/97663#comment-468295

There is just a problem :? SME does not support .htaccess as far as i know, so the rewrite condition and rule has to be set in http.conf :?

Haven't figured out how and where to set the rewrite, but my experience with apache says it has to be in the virtualhost part. Can anybody help me with, how to set that in the httpd.conf template system?

Any help will be highly appreciated
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: gerteb on May 16, 2008, 07:02:52 AM
Forgot to say i'we tried to set this rewrite that as a test redirect to google

<IfModule mod_rewrite.c>
      RewriteEngine on
     RewriteCond %{HTTP:Authorization} .*
RewriteRule ^.*$     http://www.google.com/ [R]
#      RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]
</IfModule>


In both /etc/e-smith/templates/etc/httpd/conf/httpd.conf/98egroupware and /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90egw-syncml, and as global. Neither worked.

Believe it will work if placed i <VirtualHost 0.0.0.0:80> and <VirtualHost 0.0.0.0:443>, but don't know how to do it in the template system.
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: gerteb on May 16, 2008, 02:36:42 PM
Got the rewrite hack to work under PHP5 as cgi. Inserted RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L] in the virtualhost part of httpd.conf.

But that just brought me back to square one :sad:

Access not permitted

You've tried to open the eGroupWare application: icalsrv, but you
have no permission to access this application.

Sorry to have bothered you, but does anyone know why egroupware is blocking access to icalsrv??
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: janet on May 17, 2008, 08:44:35 AM
gerteb

Quote
You've tried to open the eGroupWare application: icalsrv, but you
have no permission to access this application.
.....does anyone know why egroupware is blocking access to icalsrv??


Have you configured users within egroupware to have access rights to icalsrv ?
Title: Re: [HOW TO] Install eGroupWare on SME 7.x
Post by: gerteb on May 17, 2008, 11:53:30 PM
No i hadn't :shock: Spent several hours figuring that out :-? I am a newbie in that program, but now i rocks :lol: It could be a real competitor to w2k3sbs if the problem with national chars is solved. As i can see one of the next versions of icalsrv will include full suport of webDAV, so i presume that versions newer than 6.2 of SOGo connector eventualy will work with icalsrv.

To sumarize:

The file /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90egw-syncml shall look like this:
<Location /egroupware/rpc.php>
      AddHandler php5-cgi .php
      Action php5-cgi /php5-cgi/php
</Location>
<Location /egroupware/icalsrv.php>
      Script PUT /opt/egroupware/html/icalsrv.php
      AcceptPathInfo On
      AddHandler php5-cgi .php
      Action php5-cgi /php5-cgi/php
      AddHandler ical/ics .ics
      Action ical/ics /var/www/egroupware/icalsrv.php
      Order allow,deny
      Allow from all
</Location>
<Location /egroupware/icalsrv/groupdav.php>
      Script PUT /opt/egroupware/html/icalsrv/groupdav.php
      AcceptPathInfo On
      AddHandler php5-cgi .php
      Action php5-cgi /php5-cgi/php
      Order allow,deny
      Allow from all
</Location>

And execute expand-template /etc/httpd/conf/httpd.conf before editing /etc/httpd/conf/httpd.conf.

And as a temporary hack, in the file /etc/httpd/conf/httpd.conf insert in the section <VirtualHost 0.0.0.0:443> insert the line:
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]

In the two files icalsrv.php and groupdav.php insert in the top this line:
list($_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW']) = explode(':', base64_decode(substr($_SERVER['HTTP_AUTHORIZATION'], 6)));

The explanation can be found at http://www.sslcatacombnetworking.com/articles/http-authentication-php-cgi.html

The rewriterule ought to be expanded with two rewritecond's so it only affects the two files icalsrv.php and groupdav.php. If somebody can tell me how to insert these lines in the httpd.conf template system, i will post the final solution here. Until then. Don't do expand-template /etc/httpd/conf/httpd.conf :shock: