Koozali.org: home of the SME Server
Contribs.org Forums => General Discussion => Topic started by: soprom on March 18, 2010, 12:09:38 AM
-
As I want to apply updates on EGW when needed, the rpm install is not my preferred one. Here is the method I use, and I would like to submit it for comments. For example, it would be cool to create an ibay with the script, etc..
With this method, I also want to...
* access EGW by calling a subdomain like "egroupware.mydomain.com",
* use either EGW 1.6 or 1.7,
* store files on a webdav drive
So here is how I do it...
1. Create folders:
Folders used for EGW, httpd.conf and php
mkdir -p /opt/egw/1.6/userdata{tmp,files,backup}
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts
mkdir -p /etc/e-smith/templates-custom/etc/php.ini
2. Create database
Watch out for your password here...
mypasswd='!very-$-strong-$-password!not-.-like-.-123456!'
mysql -e "CREATE DATABASE egroupware;"
mysql -e "GRANT ALL ON egroupware.* TO egroupware@localhost IDENTIFIED BY $mypasswd;"
mysql -e "FLUSH PRIVILEGES"
3. Copy files to folders and set permissions
Download attached files to your system and place them on the server. Then set rigths for them.
..edited..
mkdir /root/egroupware
cd /root/egroupware
wget http://logicielslibres.sophieromano.com/system/files/20IbayContent.txt
wget http://logicielslibres.sophieromano.com/system/files/98egroupware.txt
wget http://logicielslibres.sophieromano.com/system/files/egwupdate.txt
wget http://logicielslibres.sophieromano.com/system/files/svnupdateperms.txt
wget http://logicielslibres.sophieromano.com/system/files/81timez.txt
Review those files and edit the timezone, 98egroupware as needed. Beware! 20IbayContent is modified and does not handle basedir the same way as stated on the Wiki. Then, move files to folders:
...edited...
cp 20IbayContent.txt /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/VirtualHosts/20IbayContent
cp 98egroupware.txt /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/98egroupware
cp 81timez.txt /etc/e-smith/templates-custom/etc/php.ini/81timez
cp egwupdate.txt /opt/egw/1.6/egwupdate
cp svnupdateperms.txt /opt/egw/1.6/svnupdateperms
and edit permissions:
chmod u+x /opt/egw/1.6/egwupdate
chmod u+x /opt/egw/1.6/svnupdateperms
chown -R www:www /opt/egw/1.6/userdata
chmod -R 770 /opt/egw/1.6/userdata/files
chmod -R 770 /opt/egw/1.6/userdata/backup
chmod -R 770 /opt/egw/1.6/userdata/tmp
4. Create a domain and an iBay for a DAV file system for EGW from the server-manager
* Create ibay egwdav (and a group) without script handling, with Read/Write only for group.
* Create subdomain (like http://davegw.mydomain.com) using ibay egwdav.
* Create domain like egroupware.yourdomain.com (and edit DNS if requiered) using internet dns.
5. Add repositories
If not done already, add contribs to repositories
db yum_repositories \
setprop smecontribs \
MirrorList http://distro.ibiblio.org/pub/linux/distributions/smeserver/mirrorlist/s...
signal-event yum-modify
6. Install packages
Add packages and install EGW using subversion...
yum install subversion
yum install smeserver-mod_dav --enablerepo=smecontribs
pear install XML_Feed_Parser
/opt/egw/1.6/egwupdate
/opt/egw/1.6/svnupdateperms
7. Configuration
Map egroupware to subdomain
mydomain=egroupware.yourdomain.com
db domains setprop $mydomain Content egw/1.6/egroupware
db domains setprop $mydomain WebApp yes
Make ibay DAV
This will be used as a filesystem when installing EGW. So instead of the standard VFS "/opt/egw/1.6/userdata/files", we would be able to use something like "http://davegw.mydomain.com/"
myibay=egwdav
/sbin/e-smith/db accounts setprop $myibay ModDav enabled
/sbin/e-smith/signal-event ibay-modify $myibay
8. Apply changes
expand-template /etc/httpd/conf/httpd.conf
sv t httpd-e-smith
When done with egroupware's setup, protect config.
See http://wiki.contribs.org/Egroupware#Starting_with_eGroupWare for initial setup
mv /opt/egw/1.6/egroupware/header.inc.php /opt/egw/1.6
ln -s /opt/egw/1.6/header.inc.php /opt/egw/1.6/egroupware/header.inc.php
chmod 644 /opt/egw/1.6/header.inc.php
Notes and links
* http://wiki.contribs.org/DAV
* http://www.egroupware.org/index.php?page_name=wiki&wikipage=WebDav
When doing an update, backup database.
Som people say that updating Egroupware in the same folder is not safe since it can bring a broken or buggy version. This is mainly true for dev version like 1.7.
Subversion: how it is used here...
#!/bin/sh
# yum install subversion
echo "Egroupware 1.6 SVN update"
myegw="/opt/egw/1.6"
echo "in folder $myegw"
cd $myegw
echo "...checking"
# 1.7 = svn checkout http://svn.egroupware.org/egroupware/trunk/aliases/default .
# 1.6 = svn checkout http://svn.egroupware.org/egroupware/branches/1.6/aliases/default .
svn checkout http://svn.egroupware.org/egroupware/branches/1.6/aliases/default . | tee $myegw/svnupdate.txt
cat $myegw/svnupdate.txt|grep "^U" > $myegw/svnupdate_u.txt
echo "Remove htaccess to let httpd.conf handle parameters"
#rm -f $myegw/egroupware/.htaccess
if [[ -s $myegw/svnupdate_u.txt ]]
then
echo "...apply changes"
cat $myegw/svnupdate_u.txt
$myegw/svnupdateperms
else
echo "...No updates."
fi
echo "Done"
rm -f $myegw/svnupdate.txt
Thanks for comments and recommendations...
-
I love this, so straightforward, but I have just one question, and please be gentle, I do not understand code fully just yet. I googled SVn to see what that means and came up with the idea that it is a way to keep something up to date from the source's website. Whether that is true or not, I just want to install eGroupware stable version, 1.6, without the dev version 1.7 --> What should I not do in your instructions because it seems to me that every line of your code is relative to the 1.6 version. I would like the DAV option and don't mind putting that folder into it's own Ibay, or the default location. Thankyou for your understanding. :o
-
# 1.7 = svn checkout http://svn.egroupware.org/egroupware/trunk/aliases/default .
# 1.6 = svn checkout http://svn.egroupware.org/egroupware/branches/1.6/aliases/default .
svn checkout http://svn.egroupware.org/egroupware/branches/1.6/aliases/default . | tee $myegw/svnupdate.txt
soprom is using SVN to install patches and updates for v1.6. The command is given for either 1.7 or 1.6, but only the 1.6 version is "active" (the other two are commented out).
-
Thankyou. So, if I am not mistaken, the # is similiar to <!-- --> in HTML Coding. Thanks again
One Last problem, the wget links are not found. http error 404
-
i edited the script to correct download paths and copying.
-
i edited the script to correct download paths and copying.
Now its error 403 Forbidden. I put the link in with my Windows IE, and it says "Accès refusé
Vous n'êtes pas autorisé(e) à accéder à cette page."
--edited--
One more, EGWupdate and 98egroupware
-
please retry...
it should read http://logicielslibres.sophieromano.com/system/files/20IbayContent. (http://logicielslibres.sophieromano.com/system/files/20IbayContent.) with a dot at the end
-
Yea, I was able to get
mkdir /root/egroupware
cd /root/egroupware
wget http://logicielslibres.sophieromano.com/system/files/20IbayContent.
wget http://logicielslibres.sophieromano.com/system/files/svnupdateperms.
wget http://logicielslibres.sophieromano.com/system/files/81timez.
but not
wget http://logicielslibres.sophieromano.com/system/files/98egroupware.
wget http://logicielslibres.sophieromano.com/system/files/egwupdate.
-
Or, tell me where you got these files and I'll go right to the source. It's an awesome tutorial, however, I am not able to go through it without those two files.
Yea, I was able to get
mkdir /root/egroupware
cd /root/egroupware
wget http://logicielslibres.sophieromano.com/system/files/20IbayContent.
wget http://logicielslibres.sophieromano.com/system/files/svnupdateperms.
wget http://logicielslibres.sophieromano.com/system/files/81timez.
but not
wget http://logicielslibres.sophieromano.com/system/files/98egroupware.
wget http://logicielslibres.sophieromano.com/system/files/egwupdate.
-
I edited the script and the url are now ok
-
Alright, did some searching, but couldn't come up with the answers after a few hours so I figured I would just ask.
One, I made ibay 'egwdav' but I did not know if I needed another IBAY like this one Make ibay DAV
which is after step number 7.
Secondly, the subdomain and new domain. I went into server manager and added a Domain egroupware.rburnsplumbing.com using my new ibay 'egwdav' in which everyone is a member of the group associated with it, but I didn't know if I still needed another subdomain * Create subdomain (like http://davegw.mydomain.com) using ibay egwdav.
, since the one I created closely resembled * Create domain like egroupware.yourdomain.com (and edit DNS if requiered) using internet dns.
After that, I went to my sitelution account, and added a nameserver with the same IP address as my website, not really sure if that was correct.
Lastly, I came up with an error during the update # /opt/egw/1.6/svnupdateperms
in folder /opt/egw/1.6
...Setting file access rules :
- Changing owner recursivly...
- Recursive CHMOD 550 on folders...
- Recursive CHMOD 440 on files...
- Customization of CHMOD for a few folders...
chown: cannot access `/opt/egw/1.6/egroupware/header.inc.php': No such file or directory
chmod: cannot access `/opt/egw/1.6/egroupware/header.inc.php': No such file or directory
...Permissions OkAt what step were the files installed. Maybe I can repeat a step and get back on track
-
egroupware.rburnsplumbing.com using my new ibay 'egwdav'
egroupware.rburnsplumbing.com is a subdomain not associated to an ibay.
davegw.mydomain.com is a subdomain associated to an ibay named egwdav
/opt/egw/1.6/egroupware/header.inc.php
make sure that step 6 downloaded egroupware in /opt/egw/1.6/egroupware
you should be able to open http://egroupware.rburnsplumbing.com/setup
-
Sorry, still having problems. I reinstalled my beta 5, reinstalled all contribs and users, and did these steps right after.
Step two returned an error to me: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(seCret PassWoRd)' at line 1
...right after mysql -e "GRANT ALL ON egroupware.* TO egroupware@localhost IDENTIFIED BY $mypasswd;"
I would just go to phpmyadmin and create te user, but I did tat during my previous trial runs, and egroupware did not install. So what should I really be doing?
Secondly, I don't fully understand the two subdomains. When in server manager to create a "domain", it doesn't say anything about a subdomain. Also, egroupware.rburnsplumbing.com is a subdomain not associated to an ibay.
davegw.mydomain.com is a subdomain associated to an ibay named egwdav
...how is that, when all domains in server manager are default to Primary for an ibay?
In addition, should there be any users in the group associated to egwdav, guessing that attributes the 'no script handling'.
Lastly, should I just update from ver 1.4, or is this the useful way to do it? I want version 1.6 because of the WebDAV file sharing, but I'm not really interested in it being under a subdomain allocated to an ibay (if that's what this tutorial is all about).
-
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(seCret PassWoRd)' at line 1
there is a space in the password which is not allowed I think
I would just go to phpmyadmin and create te user, but I did tat during my previous trial runs, and egroupware did not install.
phpmyadmin is a good way to go
how is that, when all domains in server manager are default to Primary for an ibay?
You are correct, leave subdomain (ordomain if your like) set to primary.
egroupware.rburnsplumbing.com is a subdomain associated to ibay primary
davegw.rburnsplumbing.com is a subdomain associated to an ibay named egwdav
In addition, should there be any users in the group associated to egwdav, guessing that attributes the 'no script handling'.
You are correct, users must be associated to the group.
But it is not related to "no script".
WebDAV file sharing
To use the standard file system, simply define folder in egroupware setup:
/opt/egw/1.6/userdata/tmp
/opt/egw/1.6/userdata/files
/opt/egw/1.6/userdata/backup
-
ok, still trying.
I did the user and password through phpMyAdmin. Set the 'egroupware@localhost' priveleges specific to the egroupware database. I got that squared away, even though there wasn't a space in my password. I don't know what that error was for unless it was the ' '.
Also, I changed all the "1.7" in the "98egroupware.txt" file, as well as the domain name, and locations to /opt/egw/1.6/
Now my issue is the header.inc.php file. I have a header.inc.php.template, but not the first one.
make sure that step 6 downloaded egroupware in /opt/egw/1.6/egroupware
Now this confuses me a little. /opt/egw/1.6/egwupdate installs an egroupware folder after processing. But should I be installing it like /opt/egw/1.6/egroupware/egwupdate? Should there be two egroupware folders meaning, /opt/egw/1.6/egroupware/egroupware/...
I seen something like that in one of the text files. Still doesn't explain the 'no header.inc.php file'.
***edit***
It seems the installation location is correct because the egourpware.rburnsplumbing.com ibay location is /egw/1.6/egroupware, but http://egroupware.rburnsplumbing.com/setup does not ccome up.
1) Should the location be /opt/egww/1.6/egroupware?
2) Should there be some type of port or something that I need to open? Both domain and subdomain uses internet DNS
3) I should still be able to access the ibay based on the domain name, was I supposed to do something with my account that I have for my domain name. Such as setup a nameserver associated to my static ip.
-
I think you are mixing things up so much that I can't follow you. Sorry about that.
If you don't have the file header.inc.php, it is because egroupware.yourdomain.com/setup/ has not been done yet.
Installation folder should be /opt/egw/1.6/egroupware
-
okay, that makes sense. The error was returned under the svnupdaterms. So, I did everything right, I just can't get to the egroupware.rburnsplumbing.com/setup
I even tried egroupware.rburnsplumbing.com/setup/index, but its not coming up. Is there something extra that I need to do to setup a subdomain?
I tried to setup a test.rburnsplumbing.com using the same IBay I use for my regular website, but it didn't come up. I think I may be missing something to setup a subdomain, because all the files that should be in /opt/egw/1.6
***Update***
I registered the /opt/egw/1.6 to my primary domain, rburnsplumbing.com, and it worked. So the installation is fine. But I'm just not doing something right with the subdomain and registering it. But now, I have a new issue. I can't get my primary domain back to the ibay that host my website files.
What I did first wasmydomain=rburnsplumbing.com
db domains setprop $mydomain Content egw/1.6/egroupware
db domains setprop $mydomain WebApp yes
/sbin/e-smith/signal-event ibay-modify $myibay... That worked, but under http://www.rburnsplumbing.com
Now I went to domains in the server-manager and changed the ibay back to my web hosting ibay, and it is coming up restricted access Error 403
Then I ...
mydomain=rburnsplumbing.com
db domains setprop $mydomain Content /home/e-smith/files/ibays/(my hosting ibay)/html
db domains setprop $mydomain WebApp yes
/sbin/e-smith/signal-event ibay-modify $myibay
... but that didn't solve it either. What should I do. Again, the egroupware 1.6 works, but the subdomain is not being directed as such. And now, I can't get it back to normal for my primary domain and the web hosting ibay.
-
Okay, sorry for the constant post, but it's like real time. As it happens, if there are problems, I post. I assume that's ok.
Anyway, I managed to eliminate my primary domain issue with http://forums.contribs.org/index.php/topic,45744.0.html
Now, my last problem is my subdomain. I did all the steps, created the two virtual domains, ie egroupware.rburnsplumbing.com set to no ibay and internet dns; and davegw.rburnsplumbing.com set to egw i-bay whcih has no php,cgi execution and dns resolve locally.
But after that, and the steps, egroupware.rburnsplumbing.com doesn't come up. So, now the question is how do I make a subdomain for this instance. I read http://forums.contribs.org/index.php/topic,33527.msg143087.html#msg143087 and http://forums.contribs.org/index.php/topic,38397.msg174778.html#msg174778
I was also thinking, should I make a link on my main web page to the egw/16/egroupware folder? But that really doesn't solve the issue of the subdomain.
I read somewhere that I have to do something with my registrar, sitelutions.com, and set my subdomain in there. Any enlightenment would be appreciated.
And again, this is the last hurdle before I have a complete eGroupware setup successfully.
-
egroupware.rburnsplumbing.com doesn't come up.
What is the result of this:
db domains show | grep egroupware
should I make a link on my main web page to the egw/16/egroupware folder?
Not I understand what you mean, but I think it not relavant to the current subject.
-
What is the result of this:
db domains show | grep egroupware
egroupware.rburnsplumbing.com=domain
Content=egw/1.6/egroupware
But mary may have answered this for me. She said I needed to set it up with my registrar, sitelutions.com in order for it to be available externally. http://forums.contribs.org/index.php/topic,45744.msg222853.html#msg222853
Not really 100% what she means with the dns and zone record setup, but at least I know what to look into. Basically, currently I have an "A" record for my ip to rburnsplumbing.com and an "MX" record for what I believe to be my mail. And Ieve there's two more, www and mail, I tried to add egroupware, seeing how the other two were prefixes, but no avail. So I will research some more, thanx guys.
-
You' need this:
db domains setprop egroupware.rburnsplumbing.com WebApp yes
signal-event domain-modify egroupware.rburnsplumbing.com
sv t httpd-e-smith
-
Well, I temporarily copied everything to run from my website/html Ibay. which is sufficient for now, to get a hang of things. But quick question, on the setup.
I got a ton of options under setting up my "domain: default (mysql)"
1) FTP Site: Should I create an IBay specifically for an FTP site concerning eGroupware or is this irrelevant
2) The IMAP port I guessed to be 993
3) Biggest question I have is my authentication information. Is it possible to use the accounts already in the server through LDAP, and still be able to add new accounts?
-
to run from my website/html Ibay. which is sufficient for now
Well, you wanted me to explain my method using subversion and that is why I posted it here in the first place. You are now using a completly different method for which you'll probably find info on the forum.
As I said, you might want to see http://www.egroupware.org for documentation and the wiki.contribs.org/Egroupware also has very specific help to setup EGW.
-
I'm sorry. I was still using the subversion method, I just changed the location of egwupdate, and svnupdateperms to an ibay html location. Don't want u to think I had u help me with all that for nothing. Turns out it didn't work anyway, none of the apps work properly, and the pear xml-feeds is not found, even though it is installed. I'm still trying to get it with this subdomain thing. Wondering,if I gave you access to my SME, maybe you could give it a once over, and then you will know if you should add a little more to your walkthrough, or if I'm a complete idiot. Basically, my installation works, I just can't get to it via egroupware.rburnsplumbing.com
Im still missing something, just don't know what it is yet.
-
newburns
Please stop ignoring the obvious.
Your domain egroupware.rburnsplumbing.com does not resolve correctly,
Do you have nameservers setup for that domain ?
Here is a ping result, and the IP shown (216.239.122.34) is not the IP of your server (which is 173.161.83.65)
PING c18-ss-2-lb.cnet.com (216.239.122.34) 56(84) bytes of data.
64 bytes from c18-ss-2-lb.cnet.com (216.239.122.34): icmp_seq=1 ttl=245 time=1.88 ms
64 bytes from c18-ss-2-lb.cnet.com (216.239.122.34): icmp_seq=2 ttl=245 time=2.03 ms
64 bytes from c18-ss-2-lb.cnet.com (216.239.122.34): icmp_seq=3 ttl=245 time=1.83 ms
64 bytes from c18-ss-2-lb.cnet.com (216.239.122.34): icmp_seq=4 ttl=245 time=1.87 ms
64 bytes from c18-ss-2-lb.cnet.com (216.239.122.34): icmp_seq=5 ttl=245 time=1.91 ms
--- c18-ss-2-lb.cnet.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4014ms
rtt min/avg/max/mdev = 1.830/1.907/2.034/0.069 ms
Go here
http://www.dnsstuff.com/
and here
http://www.dnstools.com/
to run tests, then talk to whoever maintains your domain records to get it set up correctly
-
Thanx, the linksshed some light on my situation. I set up egroupware.rburnsplumbing.com as a nameserver, which is incorrect. I had to change my subdomain to groupware.rburnsplumbing.com and add it as a host to my registrar, not my nameserver. Thanx, everything is all up.
-
1. DNS is not an issue for now since you're working from your LAN. It may wait.
2. Using an ibay for EGW is not recommended since we set specific permissions and templates.
3. If you try this and that, it's impossible for me to follow and to help you.
4. Did you apply these:
db domains setprop egroupware.rburnsplumbing.com WebApp yes
signal-event domain-modify egroupware.rburnsplumbing.com
sv t httpd-e-smith
-
soprom
> 1. DNS is not an issue for now since you're working from your LAN. It may wait.
That is not necessarily correct. If sme resolution is set to external DNS servers (the default), then the domain will not resolve locally, which I believe was the case here.
I can see the egroupware login screen is now web accessible since the domain DNS was fixed.
-
I aggree...
@newburns: you should test this from your PC
ping egroupware.rburnsplumbing.comYou should have successfull pings...
-
soprom
He changed it to
groupware.rburnsplumbing.com
which works OK
-
I just want to thank all of you. eGroupware seems essential for construction companies. Very nice touch!
-
Anyone having issues where the emailer in eGroupware will only email to local user part of the current domain, but not to anyone @adifferentdomain.com
Standard mailserver settings (used for Mail authentication too):
POP/IMAP mail server hostname or IP address: mail.rburnsplumbing.com
Mail server protocol: IMAPS
Mail server login type: Standard
Mail domain (for Virtual mail manager): Blank
SMTP server hostname or IP address: mail.rburnsplumbing.com
SMTP server port: 465
User for SMTP-authentication (leave it empty if no auth required): empty
Password for SMTP-authentication: empty
-
See http://wiki.contribs.org/SME_Server:Documentation:Administration_Manual:Chapter13#E-mail_Delivery
about SMTP of the ISP
in EGW it can be localhost.
-
Thanks a Ton, that did it. I replaced mail.rburnsplumbing.com with localhost, and it fixed it
-
New deal, I was wondering about the LDAP. It's either not binding, or there is nothing in my LDAP directory. Reasons being; through subsonic with same settings, it says there's a binding error, however, through Windows Live Mail Contacts, it searches the directory without any results. What are the LDAP settings for SME. Only thing I need it for is when account users change their passwords via ctrl-alt-del on a windows client pc, it will not change egroupware or subsonic. Also, if it is stored by SQL, will it continue to stay the same even with it loading from LDAP but stored in a SQL database?
(http://rburnsplumbing.com/smeforums/subsonicldap.png)
-
what is the version of your server? sme7 or sme8b5 ?
ldap would need to be running on sme8b5 but this I am not sure.
From the Wiki - sme8b5:
LDAP authentication: third party applications can authenticate against
SME Users passwords. LDAP is still read only, built automatically
from SME databases.
Did you try localhost and ldaps://localhost
-
SME 8 Beta 5
I would show you the screen for eGroupware, but groupware.10.1.10.150 doesn't work, LOL
Are my pics displaying?
(http://rburnsplumbing.com/smeforums/smeinfo1.png)
(http://rburnsplumbing.com/smeforums/smeinfo2.png)
-
See http://wiki.contribs.org/LDAP
-
See http://wiki.contribs.org/LDAP
What settings are you using because I have the following without any luck.
(http://rburnsplumbing.com/smeforums/egroupwareldap.png)
-
hi
smeserver-egroupware-1.6.003-2.noarch.rpm
is available here
http://sites.google.com/site/studiosacchetti/ (http://sites.google.com/site/studiosacchetti/)
-
hi
smeserver-egroupware-1.6.003-2.noarch.rpm
is available here
http://sites.google.com/site/studiosacchetti/ (http://sites.google.com/site/studiosacchetti/)
Please:
1. make your src.rpm file available
2. upload the contrib to contribs.org CVS, and use contribs.org bug tracker to track changes.
Thanks