<_Lux> hi

<yann2> hey _Lux :)

<_Lux> hi yann2

<_Lux> yann2: Do you know otzenpunk from the German community.

<yann2> seen him some times on #ubuntuusers

<_Lux> I asked him, if he could imagine working for the admin team.

<yann2> root@asa:/var/log# du -sh .

<yann2> 2.0G .

<yann2> root@asa:/var/log# df -h | fgrep log

<yann2> /dev/sda5 3.7G 2.7G 827M 77% /var/log

<yann2> mrf, that pb again

<_Lux> ??

<yann2> just look :)

<yann2> there is 700MB difference between du -sh and df

<_Lux> that means there are some open file handlers

<yann2> yep, i'm trying to search in the lsof

<yann2> do you know the argument to lsof to get filesize displayed human readable?

<yann2> apache2 2432 www-data 11w REG 8,5 525220224 472384 /var/log/www/de/static.log

<yann2> that seems like >500MB

<_Lux> yes

<yann2> root@asa:/var/log/www/de# head static.log

<yann2> [Wed Jan 10 02:11:58 2007] [error] [client 84.62.58.1] File does not exist: /srv/www/de/static/wikimedia/common, referer: http://wiki.ubuntuusers.de/Dapper_Drake

<yann2> jan, 10

<yann2> static.log is not rotated

<yann2> forum.log is neither

<_Lux> put it into /etc/logrotate.d

<yann2> root@asa:/var/log/www/fr/planet.ubuntu-fr.org# head error.log

<yann2> [Tue Oct 24 23:05:42 2006] [error] [client 81.22.75.237] File does not exist: /srv/www/fr/planet.ubuntu-fr.org/htdocs2/images/breezy-instable, referer: http://planet.ubuntu-fr.org/index.php?q=mac%20mini

<yann2> neither is this one

<yann2> i'll do it

<_Lux> yann2: Logratotaion is invoked by several conditions

<_Lux> One is to rotate daily regardless of size

<yann2> daily is better

<_Lux> one is to rotate only if size is greater than x

<yann2> anyway static. is over 500MB

<_Lux> size os better ;-)

<_Lux> size is better ;-)

<_Lux> yes, that is too much

<_Lux> doo you need assistance?

<yann2> nothing in /var/log/www is rotated

<yann2> only the gemran wiki is

<_Lux> yes I put it into rotation

<yann2> /var/log/www/fr/*.log , and so on

<yann2> /var/log/www/*/*.log < that possible,

<yann2> ?

<yann2> /var/log/www/*/*/*/.log < that possible,

<yann2> /var/log/www/*/*/*.log < that way

<_Lux> yann2: Under unix: Yes! Under linux: Try

<yann2> ^^

<_Lux> take a look /etc/logrotate.d/apache2

<_Lux> ls

<yann2> yeah, there is nothing with /var/log/www

<_Lux> one file for each site?

<_Lux> ubuntuusers.de for all ubuntuusers.de logs?

<yann2> there

<yann2> tell me if it works that way?

<_Lux> ubuntu-fr.org for all of your logs?

<yann2> what?

<yann2> no, we have separate files

<_Lux> how do you want to manage rotation?

<_Lux> one conf-file for each log to rotate?

<yann2> /etc/logrotate.d/www

<yann2> ?

<_Lux> ok!

<yann2> can you have a look, i never touched at logrotate before

<_Lux> just copy apache2 to www and edit the filespec

<_Lux> yes shure. i take a look

<_Lux> try "ls /var/log/www/*/*/*.log" looks good!

<yann2> yann@asa:/etc/logrotate.d$ logrotate -d www

<yann2> reading config file www

<yann2> error: error accessing /var/log/www/ir: Permission denied

<_Lux> ??

<_Lux> which program?

<yann2> oh, zed tells me it's run as root, sorry

<_Lux> ok

<_Lux> "/var/log/www/*/*/*.log" and

<_Lux> "/var/log/www/*/*.log" and

<_Lux> to get all log files

<yann2> mrf

<_Lux> mrf?

<yann2> german logfiles don't meet the same scheme as the others

<yann2> could y ou please change that?

<_Lux> what is "mrf"

<yann2> it's disappointment :)

<_Lux> ;-)

<_Lux> which schema do you want

<yann2> the same as for the others

<_Lux> ls /var/log/www

<yann2> /var/log/www/de/forum.log -> /var/log/www/de/forum.ubuntuusers.de/access.log

<_Lux> which others

<_Lux> admin.ubuntu-eu.org

<_Lux> mawu.ubuntu-eu.org

<_Lux> test.ubuntu-eu.org

<_Lux> ubuntu-dk.org

<yann2> ?

<_Lux> verein.ubuntu-de.org

<_Lux> just take a look

<yann2> yeah, these need to be deleted

<yann2> i'll do some cleanup

<_Lux> fuser admin.ubuntu-eu.org/*

<yann2> 'm just cleaning /var/log a little bit

<_Lux> attention!

<_Lux> some logs are in use.

<_Lux> take a test with fuser

<_Lux> ls fr

<yann2> i kill that ubuntu-dk.org too

<_Lux> ok

<yann2> and the apache conf files too

<yann2> plus, we need to make clear that the files in sites-enabled SHOULD BE soft links to the files in sites-available

<yann2> which is not the case for all of them, and can lead to a lot of confusion

<_Lux> yes, you are right

<_Lux> otzenpunk thinks he is not able to support us

<_Lux> I will change the German config and logfiles

<yann2> root@asa:/var/log/www/test.wiki.ubuntu-de.org#

<yann2> this one is the only one which seemed to be used

<yann2> i deleted all the other directories in /var/log/www

<yann2> he is not? ok ^^

<yann2> yep, thanks

<yann2> should i make the weblogs world readable, or just readable by the group?

<_Lux> world readable is fine

<yann2> ok

<yann2> root@asa:/var/log/www# find . -type d -exec chmod 755 {} \;

<yann2> root@asa:/var/log/www# find . -type f -exec chmod 644 {} \;

<yann2> love these two :)

*** jalrnc_ is now known as jalrnc

<_Lux> yip

<yann2> oh and we still need to find out which dead logfiles are still opened

<_Lux> yes

<_Lux> ubuntuusers.de -> /etc/apache2/sites-available/de/ubuntuusers.de

<yann2> tail 27187 root 3r REG 8,5 744650044 423492 /var/log/apache2/access.log.1 (deleted)

<yann2> here it is :)

<yann2> tail? ^ ^

<_Lux> which process?

<yann2> root 27187 1 0 2006 ? 00:00:04 tail -f access.log

<yann2> oh :)

<yann2> root@asa:/var/log# df -h | fgrep log

<yann2> /dev/sda5 3.7G 2.1G 1.5G 58% /var/log

<yann2> \o/

<_Lux> grep ErrorLog /etc/apache2/sites-available/de/ubuntuusers.de

<yann2> there is none?

<_Lux> ??

<_Lux> I just edited the main configuration

<yann2> ok :)

<yann2> should be better now anyway with that tail killed

<_Lux> ooops apache is down

<yann2> ?

<yann2> wtf

<_Lux> apache2ctl configtest is fine

<yann2> yeah

<yann2> i didn't restarted anything

<_Lux> I did!

<yann2> (2)No such file or directory: apache2: could not open error log file /var/log/www/admin.ubuntu-eu.org/error.log.

<yann2> that was one too many

<yann2> i'll kill that vhost

<_Lux> aapache is on again

<yann2> great :)

<yann2> that vhost had moved a long time ago to ajok

<yann2> but the vhost was still there

<dee> thanks _Lux :)

<yann2> _Lux > can you handle the apache conf file for verein.ubuntu-de.org? :)

<_Lux> mompls

<dee> so, bye

<_Lux> yann2: I do

<_Lux> could yo please take a look at the files in /etc/apache2/sites-enabled

<_Lux> there are some files, that are no links!

<yann2> i'm just changing that :)

<_Lux> please take the full path for the links

<yann2> why?

<_Lux> bad experiences with relative paths

<yann2> ^^

<yann2> will do it

<yann2> hope i won't break anything

<_Lux> yann2: we will test and fix :->

<_Lux> I take ubuntu.no

<_Lux> I take pt

<yann2> think we're done :)

<_Lux> yes, we are

<_Lux> looks very good

<yann2> far better now

<yann2> yep

<_Lux> just take a breath and "apache2 restart" ;-)

<yann2> i did graceful already :p

<yann2> btw, we need to set up a default page

<_Lux> for what?

<yann2> strange, asa is unaccessible via it's ip

<yann2> http://80.82.17.134/ or http://80.82.17.135

<yann2> anyway, seems to be working now

<_Lux> No virtual host?

<_Lux> No virtual host for IP?

<yann2> the default virtual host was an empty directory with a subdir phpmyadmin, where you got à authorisation denied :)

<yann2> http://planet2.ubuntu-fr.org/

<yann2> planet2 has no valid vhost

<yann2> neither has http://forum2.ubuntu-fr.org/ anymore :)

<yann2> :/srv/www/admin.ubuntu-eu.org#

<yann2> that's the root

<yann2> should i change it do something more.. understandable, like default?

<_Lux> that's better

<yann2> which may redirect to www.ubuntu-eu.org?

<_Lux> yip

<yann2> can we delete /srv/www/__attic_www.ubuntuusers.de ?

<yann2> drwxr-s---+ 5 ubuntu-test ubuntu-test 94 2005-11-28 10:42 test.ubuntu-eu.org

<yann2> drwxr-s---+ 5 ubuntu-test ubuntu-test 74 2005-11-27 21:57 test.ubuntu-eu.org.off

<yann2> and these?

<_Lux> yes

<_Lux> just a moment!

<yann2> ouh

<yann2> you're lucky i had a look again on xchat =)

<_Lux> I make a tar.gz out of /srv/www/__attic_www.ubuntuusers.de

<yann2> ah this one

<yann2> but the tests ?

<_Lux> trash

<yann2> i'll make a backup of ubuntu-dk and delete it too

<yann2> what was in test?

<_Lux> I don't know it

<yann2> they're huuuuuuge.

<yann2> looks like tests for the moin

<yann2> test.ubuntu-eu.org/htdocs/foobar/underlay/pages/Zawarto(c59bc487)Pomocy/current

<yann2> anyway

<yann2> they're from the past :)

<_Lux> yip

<_Lux> we should put the archives to /srv/www/backup

<yann2> NO!

<yann2> this must NOT be accessible from the web

<yann2> somewhere in a /home/backup

<_Lux> It is not accessible from the web!!!

<_Lux> there is no website linking to /srv/backup

<_Lux> there is no website linking to /srv/www/backup

<yann2> yeah, but in /srv/www.....

<yann2> let's us put it somewhere else =)

<yann2> somewhere only root has access

<yann2> why not /root/backup?

<yann2> ah

<_Lux> too small filesystem

<yann2> we've a special filesystem in /srv/www

<yann2> yeah, forgot that one

<yann2> let's make that /srv/www/backup :)

<_Lux> done

<yann2> just chmoded it 700

<_Lux> perfect

<_Lux> I make a tar -cjvf and delete the directory afterwards

<yann2> yead, i did that for /srv/www/ubuntu-dk

<_Lux> logrotate works without any error

<_Lux> rm /etc/logrotate.d/wiki.ubuntuusers.de

<yann2> \o/ :)

<yann2> yep

<yann2> think we're done :)

<_Lux> yes. good session. :-)

<yann2> we still need to document replication

<yann2> it's the main problem for me now

<_Lux> ok

<yann2> i'm even thinking of killing it, as i just don't understand how it works, and as it often cause the servers to just crash

<yann2> at least until it's documented... look, we're blocked for the migration because of that

<yann2> i think ubuntu-de needs a svn as much as we do :p

<_Lux> yes! you are perfectly right

<_Lux> take a look: sudo tail /var/log/mail.log

<yann2> is that because of our fourm?

<_Lux> don't know. I don't see any address

<yann2> oh yeah i wanted to redirect the default vhost to www.ubuntu-eu.or

<_Lux> done: rm -r /srv/www/__attic_www.ubuntuusers.de

<yann2> i deleted the phpmyadmin in /srv/www/phpmyadmin

<yann2> oh btw

<yann2> i think the phpmyadmin i installed on eshu has no rights to access lisa and mawu

<yann2> could you change that?

<yann2> and btw, do you have an idea how we could login as root on lisa and mawu without having to use smurf's account?

<_Lux> yann2: that depends on the account you are using

<yann2> _Lux > eshu should be allowed to login as any user on mawu and lisa

<_Lux> mompls

<yann2> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/

<yann2> (this doc should be good)

<_Lux> we are using mysql-replication at work

<_Lux> it works fine

<_Lux> yann2: The best way to connect to mawu and lisa is to generate a user account that is allowed to connect

<yann2> phpmyadmin doesn't work like that :p

<_Lux> sure it does

<yann2> btw, under which user should the default page run?

<yann2> _Lux > phpmyadmin will try to connect with the user and password you give him

<yann2> and that should not be some kind of root

<_Lux> i can login as lux on mawu with phpmyadmin on eshu

<yann2> and lux has root access? that's not good...

<_Lux> zed % Ja ALL PRIVILEGES Ja

<_Lux> zed 80.248.214.35 Ja ALL PRIVILEGES Ja

<yann2> I may want to add an htaccess on top of the phpmyadmin

<_Lux> lux % Ja ALL PRIVILEGES Ja

<_Lux> lux localhost Ja ALL PRIVILEGES Ja

<_Lux> ...

<yann2> should I add the same htpasswd for the phpmyadmin as for the trac?

<_Lux> your choice

<_Lux> i think username an password is enough

<yann2> i'll add the htpasswd :p

<_Lux> yann2: Be sure, I will not use it ...

<yann2> I kind of like phpmyadmin, makes my life easier :)

<_Lux> why using two passwords?

<yann2> why preventing connections from the world if anyone can connect with phpmyadmin? :)

<_Lux> one for htaccess and one for the database?

<yann2> i dunno, I feel that phpmyadmin kind of not secure enough ^^

<yann2> anyway =)

<yann2> under which account should run the default website?

<yann2> apache-default?

<_Lux> yip

<yann2> root@asa:/srv/www/admin.ubuntu-eu.org# sudo adduser --no-create-home --disabled-login apache-default

<yann2> http://planet2.ubuntu-fr.org/

<yann2> strange, i did not specify any user

<yann2> ok there is no php on that one.. good thing in fact

<yann2> redirection done

<yann2> _Lux > could you check if /srv/www/verein.ubuntuusers.de is still needed? i think it's not

<_Lux> what did you do?

<_Lux> asa is reacting very slow

<yann2> yeah just restarted apache :)

<yann2> needs some minutes :p

<yann2> should already be better

<yann2> just removed the user i created as i don't need it apparently

<yann2> there is also a user ubuntu-admin which we may want to delete

<yann2> just be sure there is nothing using it actually

<_Lux> "/etc/apache2/sites-available/de/verein.ubuntu-de.org"

<_Lux> DocumentRoot /srv/www/verein.ubuntu-de.org/static

<_Lux> so, we can not delete it

<yann2> it should be moved in de/

<yann2> why is there a separate config file for verein?

<yann2> ah, it's ubuntu-de.org

<yann2> well, just move it to the /de directory =)

<_Lux> it has nothing to do with ubuntuusers.de

<yann2> that again -_-

<_Lux> When I am at home, I will send a mail to the verein-mailinglist and ask if we can move it

<yann2> the verein and the locoteam should learn to work together -_-

<yann2> it's such a pain that these are separate entities imho

<_Lux> yip, I agree

<dee> hello. :)

<yann2> :)

<dee> yann2: could you restart our wiki?

<dee> I've posted a ticket half an hour ago...

<yann2> ok

<dee> thx

<dee> yann2: please take a look at the load. the wiki was down maybe 45 minutes ago, then went online again by itself, the load went up to 30 and then the wiki breaks down again.

<yann2> i'm saying for monthes now that your wiki is killing the server, nothing new here.

<yann2> and it's going to become worse if you don't do anything.

<yann2> what should I do, give you a deadline? :/

<dee> yann2: I thought you have already?

<dee> 23.4 is D-Day.

<yann2> ah? :)

<yann2> i did not :)

<dee> and you don't speak German do you, otherwise you could take a look into a new agenda. I hope our webteam will set up the wiki from the scratch.

<yann2> du ich war monaten lang auf #ubuntuusers :p

<yann2> bin halt nur seltener da wegen den passwort, muss immer das join selsbst schreiben :)

<dee> ach so. *g*

<dee> but anyway our new webteam-head will set up a dev-server with new forum and hopefully new wiki.

<dee> at least I try to force him in this direction.

<yann2> ok

<dee> and to cite you, you said one time: "If it's not going better till Feisty release the wiki will be shut down"... I'm searching for the correct phrase.

<yann2> ah :)

<yann2> yeah, you see how it's working today

<yann2> expect +30% users on release

<yann2> it just won't work

<yann2> I won't even have to shut it down

<yann2> but i won't stay the whole day online to start it again and again every 30 minutes

<dee> yes, I know that. and I have said (in thsi thread in our forum) if the webteam won't fix it till then I will go together with the wiki. :)

<yann2> you know, it's not easy

<dee> but, to "calm you down", it's not the amount of users that is our problem.

<yann2> we had some problems with our forum once, got rid of them thanks to a really, really experienced guy which helped us out

<dee> the wiki crashed yesterday between 23:45 and 23:55... there weren't many users online.

<yann2> his patches were that good that they were integrated in punbb in security releases ^^

<dee> yann2: I hope that we will get it right till Feisty.

<dee> wow.

<dee> the problem is in some part that the old webteam was not so concerned about the wiki. the half of them is working on pocoo and less in our forum or wiki.

<yann2> concerning the wiki we just got lucky, i wrote some patches, which got integrated but weren't that good... i yelled a lot on the mailing lists, and they finally made a really good releases fixes the bigggest problems

<yann2> you don't want to know what I think of pocoo.

<dee> yann2: I think the same as I. ;)

<dee> and my other uu-members

<yann2> I think you better test it PERFECTLY before.

<dee> yann2 therefor teh dev-server. :)

<yann2> yeah... but it won't have that much users.

<yann2> devserver should be ready soon.

<dee> btw: we "discovered" yesterday that the wiki has a persistend connection to the db of the forum. we think that this i spart of the problem.

<yann2> but that should be made clear, i don't want ubuntuusers to beta test software just BECAUSE it is from people who ONCE belonged to the team

<dee> ah, you mean, pocoo... I don't like pocoo and don't think it will be ready before 2008.

<yann2> pocoo and ubuntu are 2 complete different things

<dee> I don't even understand why everyone's talking about it. Only the webteam (or part of it) stand behind it. I don't even know if the admins have said "yes" to it.

<yann2> sorry, you have no admins :/

<dee> we haven't? we have 3...

<yann2> which ones?

<dee> I thought Sascha, Lux (part of), Blackbird and ... hm.. somebody else.

<yann2> sasha? who's that? :D

<dee> the founder of our site. ^^

<yann2> blackbird is mitsuhiko?

<dee> yes.

<yann2> he meant he doesn't want to be active neither in the admin team, neither in the webteam

<dee> ah, Boone is Admin too. additionally we have a "Projektleitung" ;) who should decide tricky decision like that.

<yann2> he's not active in the server team for monthes and may lose his sudo access soon if he doesn't stand up

<dee> yann2: unfortunately some guys won't let him go.

<dee> or better: won't kick him.

<yann2> Lux is pretty active. Smurf is doing some great job when he has time.

<yann2> well, anyway

<dee> yes. Lux was also part of the new settings for the webteam.

<dee> I think with netzmeister it will go a better way.

<dee> unfortunately we have waited too long with this decision.

<yann2> wenn irgendwas mit pocoo schief geht, habt ihr dann selber schuld, ich denke es ist ne schlechte entscheidung ein software fur so nen grossen forum zu installieren, wenn's nicht schon ein paar monate/jahre alt ist und seeehr viel ausgetestet worden ist.

<dee> wie ich sagte: wie kommt du darauf, daß wir das installieren, sobald es fertig ist?

<dee> afaik redet nur das webteam wirklich davon.

<dee> und die entscheiden das hoffentlich nicht.

<yann2> und die leute die an pocoo teilnehmen sind bestimmt in ubuntuusers nur noch da, da das fur sie das perfekte ist, um pocoo live auf ein grossen forum zu test.

<yann2> naja, werden wir sehen -_-

<yann2> aber fur den ist das schon klar, denke ich.

<dee> ja, aber wie will das einer oder auch drei Leute umsetzen?

<dee> server platt machen und schnell alles umstellen.

<dee> afaik hat Pocoo bisher 3 "gegner" und von denen sind bald drei die Entscheidungsträger des Forums.

<dee> die sind glücklicherweise Realisten.

<yann2> gut zu hören :)

<yann2> in 2 jahren, wenn pocoo mature ist, und gut ausgestestet ist, warum nicht.

<dee> seh ich auch so.

<yann2> aber man sieht schon was die patches von armin gebracht haben.

<yann2> und jetzt ist niemand mehr da um die zu verbessern.

<dee> will das thema aber im Team erst so klar anschneiden, wenn Forum dun Wiki wieder laufen.

<dee> jupp. der patch mit der offenen Verbindung vom Wiki zum Forum ist auch von ihm.

<yann2> auch wenn der gut ist, man kann nicht so einfach drauf programmieren, hat hier zu viele konsequencen, man sieht's doch

<yann2> ging vielleicht vor 2 jahren aber nicht mehr jetzt

<dee> jupp, seh ich auch so. das Projekt ist zu groß. und seltsamerweise weiß vor allem bzgl. Wiki kaum ein Webteammitglied wirklich was, was ich schade finde.

<dee> das Neuaufsetzen wird uns so nämlich erschwert.

<yann2> yup

<yann2> freut mich zu hören das wieder leute fur das ganze zustandig sind

<dee> jo, mich auch. :)

<dee> gn8

<netzmeister> hello guys

<netzmeister> can anyone plz restart the apache on ASA? Our Wiki is dead

<jalrnc> netzmeister: done

<netzmeister> jalrnc: Thx ;-)

*** jalrnc_ is now known as jalrnc

Generated by irclog2html.pl 2.1 by Jeff Waugh - find it at freshmeat.net!