OE website upgraded to drupal 5.2

OE website upgraded to drupal 5.2

[Koen Kooi]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

The oe website has been upgraded to drupal 5.2 (after a few failed attemps and restoring a
week old backup) and all things seems to be running again.

The only thing I couldn't fix is the sorting of posts on the frontpage, it needs to be
sticky posts, new posts, old posts. Any drupal gurus with hints?

regards,

Koen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFGz2kDMkyGM64RGpERAiAgAKCcOeGwBko2PH8bNxIuOjWPI8gVzgCgjeeU
kI9/R0AEbs7uPB5KoTf4jKk=
=Zymm
-----END PGP SIGNATURE-----

Re: OE website upgraded to drupal 5.2

[Roger Meier]

Hi Koen

Which drupal and module versions did you use before upgrade?

There are still some issues with the wiki headings.
e.g. on page http://www.openembedded.org/wiki/GettingStarted

Do you use the Liquid Wiki Engine?
Or the older 4.6 module http://drupal.org/project/wiki ?

Greetings

roger


Quoting Koen Kooi <koen@dominion.kabel.utwente.nl>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> The oe website has been upgraded to drupal 5.2 (after a few failed   
> attemps and restoring a
> week old backup) and all things seems to be running again.
>
> The only thing I couldn't fix is the sorting of posts on the   
> frontpage, it needs to be
> sticky posts, new posts, old posts. Any drupal gurus with hints?
>
> regards,
>
> Koen
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (Darwin)
>
> iD8DBQFGz2kDMkyGM64RGpERAiAgAKCcOeGwBko2PH8bNxIuOjWPI8gVzgCgjeeU
> kI9/R0AEbs7uPB5KoTf4jKk=
> =Zymm
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Openembedded-devel mailing list
> Openembedded-devel@lists.openembedded.org
> http://lists.linuxtogo.org/cgi-bin/mailman/listinfo/openembedded-devel
>
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Re: OE website upgraded to drupal 5.2

[Koen Kooi]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Roger Meier schreef:
> Hi Koen
> 
> Which drupal and module versions did you use before upgrade?
> 
> There are still some issues with the wiki headings.
> e.g. on page http://www.openembedded.org/wiki/GettingStarted

That is manually inserted html, so probably the content-type for wiki needs to get
cascaded or we have to patch the markup filter.

> Do you use the Liquid Wiki Engine?

Yes, the 5.2 version.

regards,

Koen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFG36RQMkyGM64RGpERAhAsAKCDqSQNUr7mPUNgH++RoYNUD9vt/wCdGmx2
u7SB37hL1+0QdiYhK9pOkNw=
=j+Pn
-----END PGP SIGNATURE-----

Re: OE website upgraded to drupal 5.2

[Koen Kooi]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Koen Kooi schreef:
> Roger Meier schreef:
>> Hi Koen
> 
>> Which drupal and module versions did you use before upgrade?
> 
>> There are still some issues with the wiki headings.
>> e.g. on page http://www.openembedded.org/wiki/GettingStarted
> 
> That is manually inserted html, so probably the content-type for wiki needs to get
> cascaded or we have to patch the markup filter.

The correct answer was: "we have to patch the markup sanitizer", which I did :) The wiki
works as expected now, the only issue left is the reversed news.

regards,

Koen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFG4k5RMkyGM64RGpERAtDcAJ0TXh0NS0RZOFejHjM0EsjmQErt+wCeILg6
xIXSySrcvajScJ/nsDMaHfw=
=gbbm
-----END PGP SIGNATURE-----

Re: OE website upgraded to drupal 5.2

[Koen Kooi]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Koen Kooi schreef:
> Koen Kooi schreef:
>> Roger Meier schreef:
>>> Hi Koen
>>> Which drupal and module versions did you use before upgrade?
>>> There are still some issues with the wiki headings.
>>> e.g. on page http://www.openembedded.org/wiki/GettingStarted
>> That is manually inserted html, so probably the content-type for wiki needs to get
>> cascaded or we have to patch the markup filter.
> 
> The correct answer was: "we have to patch the markup sanitizer", which I did :) The wiki
> works as expected now, the only issue left is the reversed news.

The reversed news issue turned out to be a case of one 'db_rewrite_sql()' too many, this
is fixed now.

The current TODO:

* unify tinderbox, viewmtn, org.oe.documentation and main website css
* make everything conform to standards (xhtml?)
* get more servers and hosting to spread services

regards,

Koen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFG5AJ+MkyGM64RGpERApmmAJ0fUkzSK4e4pYvAiLkhV58Aa4O3vACdGrL5
b+gwB+2P+UuZtp9ywHUCDxI=
=BxJz
-----END PGP SIGNATURE-----

Re: OE website upgraded to drupal 5.2

[Roger Meier]

Quoting Koen Kooi <k.kooi@student.utwente.nl>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Koen Kooi schreef:
>> Koen Kooi schreef:
>>> Roger Meier schreef:
>>>> Hi Koen
>>>> Which drupal and module versions did you use before upgrade?
>>>> There are still some issues with the wiki headings.
>>>> e.g. on page http://www.openembedded.org/wiki/GettingStarted
>>> That is manually inserted html, so probably the content-type for   
>>> wiki needs to get
>>> cascaded or we have to patch the markup filter.
>>
>> The correct answer was: "we have to patch the markup sanitizer",   
>> which I did :) The wiki
>> works as expected now, the only issue left is the reversed news.
>
> The reversed news issue turned out to be a case of one   
> 'db_rewrite_sql()' too many, this
> is fixed now.
Great!

>
> The current TODO:
just drop a line if you need a hand on one of these topics!

>
> * unify tinderbox, viewmtn, org.oe.documentation and main website css
It would be great to have viewmtn integrated into apache webserver.

The URL http://www.openembedded.org:1081/ would not be accessible on  
every network(e.g. corporate networks)

The following manual describes the way to do this:  
http://viewmtn.angrygoats.net/revision/file/6971b1ddbf5c30977d1c306f3baa120d709d474e/INSTALL

> * make everything conform to standards (xhtml?)
Most drupal sites conform to xhtml.
There are just a few Error's left:  
http://validator.w3.org/check?verbose=1&uri=http%3A%2F%2Fwww.openembedded.org%2F

> * get more servers and hosting to spread services


regards,

roger


>
> regards,
>
> Koen
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (Darwin)
>
> iD8DBQFG5AJ+MkyGM64RGpERApmmAJ0fUkzSK4e4pYvAiLkhV58Aa4O3vACdGrL5
> b+gwB+2P+UuZtp9ywHUCDxI=
> =BxJz
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Openembedded-devel mailing list
> Openembedded-devel@lists.openembedded.org
> http://lists.linuxtogo.org/cgi-bin/mailman/listinfo/openembedded-devel
>
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Re: OE website upgraded to drupal 5.2

[Koen Kooi]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Roger Meier schreef:
> Quoting Koen Kooi <k.kooi@student.utwente.nl>:
> 
> Koen Kooi schreef:
>>>> Koen Kooi schreef:
>>>>> Roger Meier schreef:
>>>>>> Hi Koen
>>>>>> Which drupal and module versions did you use before upgrade?
>>>>>> There are still some issues with the wiki headings.
>>>>>> e.g. on page http://www.openembedded.org/wiki/GettingStarted
>>>>> That is manually inserted html, so probably the content-type for   
>>>>> wiki needs to get
>>>>> cascaded or we have to patch the markup filter.
>>>> The correct answer was: "we have to patch the markup sanitizer",   
>>>> which I did :) The wiki
>>>> works as expected now, the only issue left is the reversed news.
> The reversed news issue turned out to be a case of one   
> 'db_rewrite_sql()' too many, this
> is fixed now.
>> Great!
> 
> The current TODO:
>> just drop a line if you need a hand on one of these topics!

*drops line* :)

> 
> * unify tinderbox, viewmtn, org.oe.documentation and main website css
>> It would be great to have viewmtn integrated into apache webserver.
> 
>> The URL http://www.openembedded.org:1081/ would not be accessible on  
>> every network(e.g. corporate networks)
> 
>> The following manual describes the way to do this:  
>> http://viewmtn.angrygoats.net/revision/file/6971b1ddbf5c30977d1c306f3baa120d709d474e/INSTALL

That sadly doesn't work since it does somewhere in the fastcgi process. I haven't been
able to figure out was is going wrong :( The interim solution was to use the web.py
approach which is running now.

> * make everything conform to standards (xhtml?)
>> Most drupal sites conform to xhtml.
>> There are just a few Error's left:  
>> http://validator.w3.org/check?verbose=1&uri=http%3A%2F%2Fwww.openembedded.org%2F

I don't know anything about html other than <center> and <br> ;)

regards,

Koen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFG5BycMkyGM64RGpERAgboAKCwsUpiHqxZ6cicGWjlQkfOsWu3TgCfWFS4
QHX3F2eluir845MJmcURYx8=
=0MkB
-----END PGP SIGNATURE-----

Re: OE website upgraded to drupal 5.2 => ViewMTN via apache2

[Roger Meier]

[-- Attachment #1: Type: text/plain, Size: 3595 bytes --]

Hi Koen

ViewMTN via apache2 is running on my Debian etch Installation(see   
http://www.bufferoverflow.ch/viewmtn/viewmtn.py/)!

Just do the following step's on the server:

apt-get install libapache2-mod-fastcgi python-flup python-cheetah  
gnome-icon-theme highlight shared-mime-info

# cheetahtemplate => debian sarge Versions are needed !!!
wget  
http://ftp.de.debian.org/debian/pool/main/c/cheetah/python2.4-cheetah_0.9.16-1_i386.deb
wget  
http://ftp.de.debian.org/debian/pool/main/c/cheetah/cheetah-common_0.9.16-1_all.deb

dpkg -i python2.4-cheetah_0.9.16-1_i386.deb cheetah-common_0.9.16-1_all.deb

Apache Config:

         <Directory "/var/www/viewmtn/">
         # ExecCGI privilege is required to run the
         # ViewMTN process
         Options +ExecCGI

         # Make sure you update config.py with this URL.
         <Files viewmtn.py>
                 SetHandler fastcgi-script
         </Files>
         </Directory>




greetings,

roger



Quoting Koen Kooi <k.kooi@student.utwente.nl>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Roger Meier schreef:
>> Quoting Koen Kooi <k.kooi@student.utwente.nl>:
>>
>> Koen Kooi schreef:
>>>>> Koen Kooi schreef:
>>>>>> Roger Meier schreef:
>>>>>>> Hi Koen
>>>>>>> Which drupal and module versions did you use before upgrade?
>>>>>>> There are still some issues with the wiki headings.
>>>>>>> e.g. on page http://www.openembedded.org/wiki/GettingStarted
>>>>>> That is manually inserted html, so probably the content-type for
>>>>>> wiki needs to get
>>>>>> cascaded or we have to patch the markup filter.
>>>>> The correct answer was: "we have to patch the markup sanitizer",
>>>>> which I did :) The wiki
>>>>> works as expected now, the only issue left is the reversed news.
>> The reversed news issue turned out to be a case of one
>> 'db_rewrite_sql()' too many, this
>> is fixed now.
>>> Great!
>>
>> The current TODO:
>>> just drop a line if you need a hand on one of these topics!
>
> *drops line* :)
>
>>
>> * unify tinderbox, viewmtn, org.oe.documentation and main website css
>>> It would be great to have viewmtn integrated into apache webserver.
>>
>>> The URL http://www.openembedded.org:1081/ would not be accessible on
>>> every network(e.g. corporate networks)
>>
>>> The following manual describes the way to do this:
>>> http://viewmtn.angrygoats.net/revision/file/6971b1ddbf5c30977d1c306f3baa120d709d474e/INSTALL
>
> That sadly doesn't work since it does somewhere in the fastcgi   
> process. I haven't been
> able to figure out was is going wrong :( The interim solution was to  
>  use the web.py
> approach which is running now.
>
>> * make everything conform to standards (xhtml?)
>>> Most drupal sites conform to xhtml.
>>> There are just a few Error's left:
>>> http://validator.w3.org/check?verbose=1&uri=http%3A%2F%2Fwww.openembedded.org%2F
>
> I don't know anything about html other than <center> and <br> ;)
>
> regards,
>
> Koen
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (Darwin)
>
> iD8DBQFG5BycMkyGM64RGpERAgboAKCwsUpiHqxZ6cicGWjlQkfOsWu3TgCfWFS4
> QHX3F2eluir845MJmcURYx8=
> =0MkB
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Openembedded-devel mailing list
> Openembedded-devel@lists.openembedded.org
> http://lists.linuxtogo.org/cgi-bin/mailman/listinfo/openembedded-devel
>
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


[-- Attachment #2: config.py --]
[-- Type: text/plain, Size: 2526 bytes --]

# Copyright (C) 2005 Grahame Bowland <grahame@angrygoats.net>
#
# This program is made available under the GNU GPL version 2.0 or
# greater. See the accompanying file COPYING for details.
#
# This program is distributed WITHOUT ANY WARRANTY; without even the
# implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
# PURPOSE.

#
# config.py
#
# This python script is imported by ViewMTN
# Note that changes to the script may not be 
# noticed immediately by ViewMTN, as mod_python 
# caches imported Python modules.
#
# If config changes are not picked up, reloading
# the web server should solve the issue.
#

import sys

# default addresses should work without modification
# if running viewmtn standalone. You must change these 
# if you run viewmtn with a web server, see INSTALL.
dynamic_uri_path = 'http://www.bufferoverflow.ch/viewmtn/viewmtn.py/'
static_uri_path = 'http://www.bufferoverflow.ch/viewmtn/static/'

# if you are running under Apache2, set this.
# don't set it otherwise, it breaks any other configuration 
# including running standalone.
running_under_apache2 = True

# the path to the 'mtn' binary
monotone = '/usr/bin/mtn'

# the monotone database to be shared out
# everything in this database should be considered subject 
# to disclosure. So don't store your private key in 
# it!
dbfile = '/var/www/viewmtn/OE.mtn'

# highlight from http://andre-simon.de/
# if you don't have this available, just comment 
# the "highlight_command" line out
highlight_command = '/usr/bin/highlight'

graphopts = {
    # a directory (must be writable by the web user)
    # in which viewmtn can output graph files
    # (you should set up a cronjob to delete old ones
    #  periodically)
    'directory' : '/tmp/viewmtn-graph/',

    # a URL, relative or absolute, at which the files 
    # in the 'graphdir' directory can be found. Should 
    # end in a '/' character
    'uri' : 'graph/',

    # the path to the 'dot' program
    'dot' : '/usr/bin/dot',

    # options to use for nodes in the dot input file
    # we generate.
    'nodeopts' : { 'fontname'  : 'Monaco', 
       'fontsize'  : '8',
       'shape'     : 'box',
       'height'    : '0.3',
       'spline'    : 'true',
       'style'     : 'filled',
       'fillcolor' : '#dddddd' }
}

# Icon Theme to use for icons; 'gnome' is a safe value, 
# as is 'hicolor'. Note that icon_size must be a string, 
# not an integer
icon_theme = 'gnome'
icon_size = '16'

Re: OE website upgraded to drupal 5.2

[Clément Hermann (nodens)]

> Hi,
>
> The oe website has been upgraded to drupal 5.2 (after a few failed attemps
> and restoring a
> week old backup) and all things seems to be running again.
>
> The only thing I couldn't fix is the sorting of posts on the frontpage, it
> needs to be
> sticky posts, new posts, old posts. Any drupal gurus with hints?
>
 
The wiki seems to have problems as well.
 
Displaying a page shows the following warnings :
 
 
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation
"wiki_access" does not exist in /var/www/oe/includes/database.pgsql.inc on
line 125.
    * user warning: query: SELECT COUNT(*) FROM wiki_access WHERE (nid = 0 OR
nid = 77) AND ((gid = 0 AND realm = 'all')) AND grant_wiki_manage >= 1 in
/var/www/oe/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation
"wiki_access" does not exist in /var/www/oe/includes/database.pgsql.inc on
line 125.
    * user warning: query: SELECT COUNT(*) FROM wiki_access WHERE (nid = 0 OR
nid = 77) AND ((gid = 0 AND realm = 'all')) AND grant_wiki_move >= 1 in
/var/www/oe/includes/database.pgsql.inc on line 144.
 
 
Also, editing is broken, and there is no "search" box in the top right : only
"array" is shown there.
 
Regarding the "wiki_access table" problem, if liquid if used as the wiki module,
the problem seems to lies in postgresql handling by liquid. I don't use
postgresql much so I don't know for sure, but according to comments on
http://drupal.org/node/117309 there is no postgresql install scripts. That could
explain the "no relation" error.
 
Cheers,
 
--
Clément Hermann (nodens)