Apache OpenOffice Wiki - User contributions [en]

User:Skoorb

2005-11-24T13:24:30Z

Skoorb: it is I

And its me, Alex Brooks, skoorb@openoffice.org. I'm a rather inactive member of the qa team.

User:Skoorb

2005-11-22T14:08:36Z

Skoorb: it is I...

And its me, skoorb@openoffice.org. I'm a rather inactive member of the qa team.

Talk:Windows

2005-11-22T14:07:13Z

Skoorb: VS 2005

Does anyone know how the new MS Visual studio 2005 releases affect the build process?
It could be good to document.

Thanks, --[[User:Skoorb|Skoorb]] 15:07, 22 November 2005 (CET)

Windows

2005-11-22T14:02:32Z

Skoorb: /* Welcome to OOo development for Windows */ to link to another wiki page it must be in double

== Welcome to OOo development for Windows ==

This is an initial attempt to fill out information for building on Windows.
If it ends up being complete, this notice can be removed!
At the moment you'll have to piece together information from the [[Main Page]] with the changes here for doing it on Windows.

Most of this wiki assumes that you'll be using a reasonably current
Linux system, as a time saving feature. While real hackers use
[http://www.gnu.org Free software] and don't have time to read
about non-Free stuff, if you're forced to build stuff for Windows, this is the place to be.

To get started from scratch you most likely need to follow these steps (from the Linux version):
[[Getting It]], [[Building]], [[Installing]], [[Running]]. There are also specific notes on [[Windows Debugging]]

== Development Tools ==

There have been several different ways of building with more or less success...

The reference page to look at is [http://tools.openoffice.org/dev_docs/build_windows_tcsh.html Building under Windows with tcsh]

Other ways to build are documented below, the official way requires Visual C++ .NET 2003

=== Visual C++ .NET 2003 ===

This is the full version of Visual C++. It is the official way to build OpenOffice.org.
It seems like the Standard version of this (approx $109 price) should be sufficient but I have not confirmed this. (The alternative is the full Visual Studio).

=== Visual C++ Toolkit 2003 ===

[http://msdn.microsoft.com/visualc/vctoolkit2003/ Visual C++ Toolkit 2003] is not currently usable because it doesn't contain all the libraries required for building OpenOffice.org. See [http://www.openoffice.org/issues/show_bug.cgi?id=51145 Issue 51145] for progress on this issue.

TODO: fill in all the required libraries, and possible alternatives - in the issue.

=== MinGW ===

[http://www.mingw.org/ MinGW] is basically gcc for Windows, without requiring the POSIX compatibility layer that CygWin provides. You can use the CygWin compiler with the -mno-cygwin switch and it has the same effect.

MinGW is not officially supported at the moment, so it will probably take some work to get it

Work to build OpenOffice.org with MinGW is at [http://qa.openoffice.org/issues/show_bug.cgi?id=24588 issue 24588] ; however this mostly deals with OpenOffice.org 1.1 branch at the moment.

== Using vanilla source ==

While ooo-build has been developed to make building OOo less painful, you might also try to start out with the standard source code. After you download and unpack a vanilla ooo source tarball, running "configure" in the directory "config_office" will gladly complain about missing build-dependencies. The remaining build process is described in the document [http://tools.openoffice.org/dev_docs/build_windows_tcsh.html Building under Windows with tcsh]

== Using ooo-build ==

These are addenda to using ooo-build with the following command line:
./configure --with-win32

ooo-build should pick up all the other requirements for you automatically (reading them out of the registry)

=== Extra requirements ===

* Cygwin requires the cabextract package.

== Miscellaneous info ==

* csc.exe comes from the c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322 directory, you might need <tt>--with-csc-path</tt>.
* Beware of using <tt>/c/</tt> instead of <tt>/cygdrive/c/</tt>.
* Avoid trailing slashes in configure parameters. They sure cause problems for <tt>--with-psdk-home</tt>.
* Using the latest cygwin release (1.5.18) can lead to tcsh freezing in places - the build will appear to hang. you can fix this by using the latest snapshot (e.g. 20050825) or running ''cat /proc/$nnn/cmdline'' where $nnn is the number of the process. See [http://www.openoffice.org/issues/show_bug.cgi?id=51560 issue 51560] for more info...
* With cygwin 1.5.18, makecab.exe hangs when run from the build process (but it works fine when run standalone). So you definitely want to use a snapshot and '''avoid cygwin 1.5.18''', unless you enjoy wasting half a week of your life debugging like I did ...

OOoHelpOutline

2005-11-22T14:01:16Z

Skoorb: Main OOoHelpOutline moved to OOoHelpOutline

'''Welcome to the outline of existing OpenOffice.org user resources!'''

The OOo Help Outline has recently moved to OpenOffice.org's Wiki to help open its accessibility as much as possible to the OpenOffice.org community, so that all may help to keep it current and reliable.

==Product==

===Overview===

* [http://www.openoffice.org/product/ OpenOffice.org Product Description]
* [http://www.openoffice.org/ OpenOffice.org's Home Page]
* [http://www.openoffice.org/sitemap.html OpenOffice.org's Site Map]
* [http://support.openoffice.org/index.html OpenOffice.org Support]
* [http://openoffice.start4all.com/ openoffice.org.start4all.com]
* [http://documentation.openoffice.org/manuals/index.html OpenOffice.org User Guide]
* [http://wwws.sun.com/software/star/staroffice/index.html StarOffice 7.0 Office Suite]
* [http://marketing.openoffice.org/2.0/featureguide.html OpenOffice.org 2.0 Office Suite - Guide to New Features]

===FAQs===

* [http://user-faq.openoffice.org/ OpenOffice.org User FAQ Project]
* [http://documentation.openoffice.org/faqs/index.html OpenOffice.org Documentation Project FAQs]
* [http://www.openoffice.org/faq.html OpenOffice.org's General FAQs]
* [http://www.bytebot.net/openoffice/faq.html The OpenOffice.org UnOfficial FAQs by Colin Charles]
* [http://oooauthors.org/en/FAQs/ OOoAuthors.org FAQ Compilation]
* [http://www.openoffice.org/FAQs/fontguide.html Font Troubleshooting Guide]

===Installation===

* [http://www.openoffice.org/dev_docs/instructions.html OOo's Instructions for Installing and Setting Up OpenOffice.org]
* [http://documentation.openoffice.org/setup_guide2/index.html OpenOffice.org's SetUp Guides]
* [http://download.openoffice.org/index.html OpenOffice.org's Download Central]
* [http://java.sun.com/j2se/1.4.1/download.html java.sun.com]
* [http://www.hypermax.net.au/~settantta/ooo/default.html Alex Fisher's OpenOffice.org Introduction]
* [http://www.openoffice.org/FAQs/build_faq.html Build FAQs for OpenOffice.org]
* [http://www.oooforum.org/forum/viewforum.php%3ff=1 OpenOffice.org Forum]
* [http://lingucomponent.openoffice.org/download_dictionary.html Spelling, Hyphenation, and Thesaurus Dictionaries: Download / Installation]
* [http://ooodocs.sourceforge.net/dictinstall/index.html OpenOffice.org Dictionary Installer]
* [http://www.bluethingy.com/linux/rh8menu.html Editing GNOME2 Menus]

===Calc===

* [http://sc.openoffice.org/ OpenOffice.org's Spreadsheet Project]
* [http://graphics.openoffice.org/chart/chart.html OpenOffice.org Graphics Applications – Charts]
* [http://documentation.openoffice.org/HOW_TO/index.html OpenOffice.org's How-To Documents]
* [http://documentation.openoffice.org/faqs/spreadsheet/index.html Spreadsheet FAQ Index Page]
* [http://sc.openoffice.org/addin_howto.html How to add-in in OpenOffice.org Calc]
* [http://www.oooforum.org/forum/viewforum.php%3ff=3 OpenOffice.org Forum]
* [http://www.richhillsoftware.com/ OpenOffice Calc Tips]
* [http://www.nostabo.net/openoffice.php OpenOffice.org Calc Tutorials and Resources]
* [http://spreadsheets.about.com/od/openofficecalc/ OpenOffice Calc Tutorials and Tips]
* [http://www.erack.de/bookmarks/D.html#SpreadSheet Links: Develop (targets SpreadSheet section)]

===Writer===

* [http://sw.openoffice.org/ OpenOffice.org's Word Processing Project]
* [http://graphics.openoffice.org/chart/chart.html OpenOffice.org Graphics applications – Charts]
* [http://documentation.openoffice.org/HOW_TO/index.html OpenOffice.org's How-To Documents]
* [http://documentation.openoffice.org/faqs/word_processing/index.html Word Processor FAQ Index Page]
* [http://www.oooforum.org/forum/viewforum.php%3ff=2 OpenOffice.org Forum]
* [http://prdownloads.sourceforge.net/ooodocs/writer_guide_en_1.0.1.zip%3fdownload OpenOffice.org Writer Guide]
* [http://www.taming-openoffice-org.com/writer/index.htm Taming OpenOffice.org on Writer]
* [http://www.onlineconnections.com.au/public/openoffice/brochureprinting.html Producing a Brochure or Booklet by Kelvin]
* [http://lingucomponent.openoffice.org/download_dictionary.html Spelling, Hyphenation, and Thesaurus Dictionaries: Download / Installation]
* [http://ooodocs.sourceforge.net/dictinstall/index.html OpenOffice.org Dictionary Installer]
* [http://ooodi.sourceforge.net/ OOodi - OpenOffice.org Dictionary Installer for Unix]
* [http://www.ooodocs.org/dictinstall/index.html Installing dictionaries in OpenOffice.org by Garry Knight]
* [http://ooovidtutors.sf.net/ Ooovidtutors - OpenOffice.org video tutorials by mimooh]

===Draw===

* [http://graphics.openoffice.org/ OpenOffice.org Graphics Applications Project]
* [http://documentation.openoffice.org/HOW_TO/index.html OpenOffice.org's How-To Documents]
* [http://www.cluesheets.com/CSDrawF.pdf StarOffice Draw 6.0 ClueSheet]
* [http://documentation.openoffice.org/faqs/drawing_graphics/index.html Drawing FAQ Index Page]
* [http://www.oooforum.org/forum/viewforum.php%3ff=5 OpenOffice.org Forum]

===Impress===

* [http://graphics.openoffice.org/ OpenOffice.org Graphics Applications Project]
* [http://documentation.openoffice.org/faqs/presentation/index.html Presentation FAQ Index Page]
* [http://www.oooforum.org/forum/viewforum.php%3ff=4 OpenOffice.org Forum]

===Formula Editor===

* [http://sw.openoffice.org/ OpenOffice.org's Word Processing Project]
* [http://documentation.openoffice.org/faqs/formula/index.html Math FAQ Index Page]
* [http://www.oooforum.org/forum/viewforum.php%3ff=6 OpenOffice.org Forum]

===HTML===

* [http://sw.openoffice.org/ OpenOffice.org's Word Processing Project]

===Data Source===

* [http://dba.openoffice.org/ OpenOffice.org's Database Access Project]
* [http://documentation.openoffice.org/HOW_TO/index.html OpenOffice.org's How-To Documents]
* [http://www.oooforum.org/forum/viewforum.php%3ff=9 OpenOffice.org Forum]
* [http://www.unixodbc.org/doc/OOoMySQL.pdf OpenOffice.org 1.0, ODBC, and MySQL 'How-tos' by John McCreesh]
* [http://dba.openoffice.org/howto/index.html OpenOffice.org Database How-Tos]
* [http://dba.openoffice.org/FAQ/index.html OpenOffice.org Database Tips 'n' Tricks]
* [http://homepage.ntlworld.com/garryknight/linux/oodbase.html Creating Flatfile Databases with OOo and SO 6 by Garry Knight]
* [http://ericzander.com/Publications/OO_MySQL_Tutorial/index.htm OO_MySQL_Tutorial by Eric Zander]
* [http://kienlein.com/pages/oo.html EDV - Systeme Kienlein]
* [http://openoffice.homelinux.org/index.php%3fmodule=pagemaster&PAGE_user_op=view_page&PAGE_id=4&MMN_position=5:3 Documentation - Database; JRE]

===Macros===

* [http://documentation.openoffice.org/HOW_TO/index.html OpenOffice.org's How-To Documents]
* [http://scripting.openoffice.org/ OpenOffice.org's Scripting Home Page]
* [http://ext.openoffice.org.nz/ OpenOffice.org Extensions Wiki]
* [http://www.ooomacros.org/ OOoMacros]
* [http://www.oooforum.org/forum/viewforum.php%3ff=9 OpenOffice.org Forum]
* [http://www.pitonyak.org/oo.php Andrew Pitonyak's Macro Information]
* [http://www.darwinwars.com/lunatic/bugs/oo_macros.html Andrew Brown's OpenOffice.org Macro Page]
* [http://homepages.paradise.net.nz/hillview/OOo/ Iannz OpenOffice.org Page]
* [http://www.oooforum.org/forum/viewtopic.phtml%3ft=4818&highlight=python How to use OOo with Python on Windows]
* [http://ooodocs.sourceforge.net/modules.php%3fop=modload&name=Downloads&d_op=viewdownload&cid=23 Templates and Macros from OOoDocs.org]
* [http://disemia.com/software/openoffice/ dis-Emi-A Software: OpenOffice]
* [http://home.nikocity.de/sysentw/FAQ/SO-FAQ_English_Version/so-faq_english_version.html SO-FAQ]

===Styles===

* [http://documentation.openoffice.org/manuals/index.html Look for "Introduction to Styles" under the Writer Guides]
* [http://www.openoffice.org/servlets/ReadMsg%3fmsgId=685429&listName=users Setting Up to Write Text Vertically]

===Templates===

* [http://documentation.openoffice.org/Samples_Templates/User/template/index.html User/Templates]
* [http://ooextras.sourceforge.net/ OOExtras]
* [http://ooodocs.sourceforge.net/modules.php%3fop=modload&name=Downloads&d_op=viewdownload&cid=23 Templates and Macros from OOoDocs.org]

===XML===

* [http://xml.openoffice.org/ OpenOffice.org XML File Format]
* [http://www.w3.org/XML/ Extensible Markup Language (XML)]
* [http://blogs.sun.com/roller/page/shudson310 Scotty's Engineering Log]
* [http://www.oasis-open.org/committees/office/press.php OASIS Open Office XML Format TC]
* [http://andreas.web-graphics.com/quickguide-sxw-xhtml/ Converting OpenOffice.org documents to XHTML strict with Writer2LaTeX, by Andreas Bovens]
* [http://books.evc-cit.info/ OpenOffice.org XML Essentials]
* [http://www.zvon.org/ ZVON.org - The Guide to the XML Galaxy]
* [http://www.logilab.org/projects/xmldiff/ Logilab.org - XmlDiff]

===Clip Art===

* [http://documentation.openoffice.org/Samples_Templates/User/gallery/index.html Gallery]
* [http://ooextras.sourceforge.net/ OOExtras]
* [http://www.openclipart.org/ Open Clip Art Library]
* [http://srufaculty.sru.edu/david.dailey/public/public_domain.htm Images in the Public Domain]
* [http://www.amazon.com/exec/obidos/tg/detail/-/B00005Q5IV/qid=1076780472/sr=5-2/ref=cm_lm_asin/002-6501732-7002411%3fv=glance The Big Box of Art 350,000] Not free, but works.
* [http://earth.prohosting.com/anvils/aboutMe/intro.html OOo Xfig Clipart and Network Icons for OOoDraw by Edward Chan]
* [http://marketing.openoffice.org/art/ OpenOffice.org Art Project]
* [http://www.kfacts.com/oooart/ OOoArt]
* [http://ooo.nicubunu.ro/ Nicu's OpenOffice.org pages]
* [http://hooboo.free.fr/index.php La Mouette et OpenOffice.org]
* [http://ooodocs.sourceforge.net/graphics/ OpenOffice.org Marketing Materials]

===General===

* [http://documentation.openoffice.org/ OpenOffice.org's Documentation Project]
* [http://documentation.openoffice.org/manuals/index.html OpenOffice.org User Guide]
* [http://ooodocs.sourceforge.net/ OOoDocs]
* [http://sourceforge.net/project/showfiles.php%3fgroup_id=43716 SourceForge.net: Project: OOoDocs: File List]
* [http://documentation.openoffice.org/thirdparty.html OpenOffice.org's Page of Third Party Documentation]
* [http://www.oooforum.org/ OpenOffice.org Forum]
* [http://www.kaaredyret.dk/openoffice_links_uk.html OpenOffice.org Links by Kaaredyret.dk]
* [http://www.kargs.net/openoffice.html OpenOffice.org Resource Page by Steve Karg]
* [http://www.tutorialsforopenoffice.org/ Tutorials for OpenOffice]
* [http://www.edafe.org/openoffice/index.html edafe.org: openoffice.org (esp. pointed toward win users)]
* [http://www.erack.de/bookmarks/O.html Links: OpenSource - OpenOffice.org]
* [http://www.openoffice-support.net/ Tutorials, Manuals, HowTo's and more]
* [http://ooo.chbs.dk/links/ OpenOffice.org Links]
* [http://www.ooo-portal.de/ Das deutsche OpenOffice.org Portal]
* [http://ooo.ximian.com/hackers-guide.html Unofficial OpenOffice Hacker's Guide]
* [http://ooolib.sourceforge.net/ OpenOffice.org Utility Library]
* [http://ooqstart.sourceforge.net/ Open Office QuickStarter applet]
* [http://del.icio.us/tag/openoffice del.icio.us/tag/openoffice]
* [http://www.spreadopenoffice.org/ Spread OpenOffice.org]

===Books===

* [http://www.cluesheets.com/ ClueSheets]
* [http://www.amazon.com/exec/obidos/ASIN/1886411867/qid=1059760834/sr=11-1/ref=sr_11_1/002-1171824-8604022 Linux in the Workplace]
* [http://www.amazon.com/exec/obidos/ASIN/0131407457/qid=1056818790/sr=2-1/ref=sr_2_1/002-9167496-2702401 OpenOffice.org 1.0 Resource Kit]
* [http://www.hod-ami.co.il/product.asp?catalog%5Fname=hodami&category%5Fname=Home+and+Office&product%5Fid=59407 עיבוד תמלילים עם OpenOffice 1.x]
** [http://www.hod-ami.co.il/images/bookdemo/59407.pdf Sample Chapter]
* [http://www.cafepress.com/getopenoffice OpenOffice.org and StarOffice Workbooks]
* [http://www.amazon.com/exec/obidos/ASIN/0764542222 OpenOffice.org For Dummies]
* [http://www.hentzenwerke.com/catalog/oome.htm OpenOffice.org Macros Explained]
* [http://www.oreilly.com/catalog/openoffice/ OpenOffice.org Writer: The Free Alternative to Microsoft Word]
* [http://books.evc-cit.info/ OpenOffice.org XML Essentials]
* [http://www.hentzenwerke.com/catalog/ooo501.htm OOoSwitch: 501 Things You Wanted to Know About Switching to OpenOffice.org]
* [http://www.samspublishing.com/title/0672326183 Sams Teach Yourself OpenOffice.org All in One]
* [http://www.amazon.com/exec/obidos/tg/detail/-/0789728338/ref=pd_sim_books_5/104-9698914-9518356%3fv=glance&s=books Special Edition Using StarOffice 6.0]
* [http://www.amazon.com/exec/obidos/tg/detail/-/0130384739/qid=1038357106/sr=8-4/ref=sr_8_4/103-6157785-3887854%3fv=glance&s=books&n=507846 StarOffice 6.0 Office Suite Companion]
* [http://www.hentzenwerke.com/catalog/tinyooo.htm The Tiny Guide to OpenOffice.org]

===E learning===

* [http://training.bytebot.net/ ByteBot.net Training Materials]
* [http://www.desktoplinux.com/news/NS2978835938.html Free online OpenOffice.org support program]
* [http://www.itrainonline.org/itrainonline/mmtk/opensource.shtml ItrainOnline: Resources for Trainers: MMTK: Open Source Software]

===Compatible Applications===

* [http://www.zope.org/Products/CMF/ Content Management Framework (CMF)]
* [http://www.dmaths.com/modules.php%3fname=Content&pa=showpage&pid=9 Dmaths]
* [http://peccatte.karefil.com/software/Catalogue/CatalogueENG.htm Files Metadata Miner Software]
* [http://gramps.sourceforge.net/ Gramps]
* [http://www.icoya.com/ icoya]
* [http://www.mozilla.org/ Mozilla]
* [http://www.planamesa.com/neojava/en/index.php NeoOffice/J]
* [http://www.opengroupware.org/ OpenGroupware.org]
* [http://plone.org/ Plone]
* [http://www.bezirksreiter.de/PyOpenOffice.htm PyOpenOffice]
* [http://www.scholarsaid.com/ Scholar's Aid]
* [http://www.hj-gym.dk/~hj/writer2latex/ Writer2LaTeX]
* [http://www.logilab.org/projects/xmldiff/ XmlDiff]
* [http://zope.org/ Zope]

==Web Site==

===Search===

* [http://www.openoffice.org/ Search Bar in Upper Right Corner]
* [http://support.openoffice.org/search.html OOo Site Search using Google]
* [http://www.openoffice.org/project/www/issues/query.cgi Issue Tracker Query Page]
* [http://darwinwars.com/lunatic/bugs/quickbugs.html Simplified Bug Finder by Andrew Brown]
* [http://www.openoffice.org/mail_list.html Mail List Archives]
* [http://www.openoffice.org/servlets/SearchList%3flistName=users&by=thread Search the Users List Archive]
* [http://search.gmane.org/ Gmane Newsgroup Search Page]

===Documentation===

* [http://www.openoffice.org/nonav/servlets/HelpTOC OpenOffice.org's Web Site Help TOC]
* [http://documentation.openoffice.org/ OpenOffice.org's Documentation Project]
* [http://lingucomponent.openoffice.org/download_dictionary.html Spelling, Hyphenation, and Thesaurus Dictionaries: Download / Installation]
* [http://www.openoffice.org/documentation.html OpenOffice.org Documentation Overview - Links, Information, Resources]
* [http://www.openoffice.org/mail_list.html OpenOffice.org's Mail Lists]
* [http://www.openoffice.org/servlets/SummarizeList%3flistName=users Browse the Users List]
* [http://www.openoffice.org/servlets/SearchList%3flistName=users&by=thread Search the Users List Archives]
* [http://development.openoffice.org/index.html OpenOffice.org for Developers]
* [http://api.openoffice.org/docs/DevelopersGuide/DevelopersGuide.htm Developer's Guide]
* [http://udk.openoffice.org/python/python-bridge.html Python-UNO bridge]

===Issue Tracker===

* [http://qa.openoffice.org/issue_handling/project_issues.html OpenOffice.org's Bugs and Issues Info]
* [http://qa.openoffice.org/index.html OpenOffice.org's QA Project]
* [http://www.kegel.com/openoffice/triage.html OpenOffice.org Issues by Dan Kegel]
* [http://www.openoffice.org/project/www/issues/query.cgi Query Page for Existing Issue Reports]
* [http://darwinwars.com/lunatic/bugs/quickbugs.html Simplified Bug Finder by Andrew Brown]
* [http://www.openoffice.org/servlets/SearchList%3flistName=users&by=thread Search the Users List Archives]

===Community===

* [http://www.openoffice.org/ OpenOffice.org's Home Page]
* [http://marketing.openoffice.org/index.html OpenOffice.org Marketing Project]
* [http://www.openoffice.org/copyright/copyrightapproved.html A list of folks who have filed OOo copyright assignments]
* [http://www.openoffice.org/welcome/credits.html A list fo folks who have contributed to OOo]
* [http://www.openoffice.org/mail_list.html OpenOffice.org's Mail Lists: Browse, Search or Subscribe]
* [http://www.openoffice.org/project/www/issues/query.cgi Issue Tracker Query Page]
* IRC chat channel at irc.freenode.net#openoffice.org

===Projects===

* [http://projects.openoffice.org/index.html Project Descriptions, Leaders, and Links to Project Pages]

===Native Languages===

* [http://lingucomponent.openoffice.org/download_dictionary.html Spelling, Hyphenation, and Thesaurus Dictionaries: Download / Installation]
* [http://www.ooodocs.org/dictinstall/index.html OpenOffice.org Dictionary Installer]
* [http://www.openoffice.org/dev_docs/source/1.0.3/index.html Localized Releases of OpenOffice.org 1.0.3.1]
* [http://l10n.openoffice.org/all_supported_languages.html l10n - All Supported Languages]
* [http://l10n.openoffice.org/languages.html Localization Contact Table]
* [http://native-lang.openoffice.org/ Native Language Confederation]

ES/Desarrollo/Syndication

2005-11-22T13:59:35Z

Skoorb: Main Syndication moved to Syndication

<h1>Syndicating OOo website</h1>

This script will parse and syndicate [[OOoES|OOoES]] Announcement section and then register it to a Database Backend. This is still a simple script and has no other functionality than parse the annoucment page you can change the project subdomain and you will be able to parse your announcments.

TODO:
<ul>
<li>Loop over multiple urls</li>
<li>Parse other documents such as Documentation</li>
</ul>

<pre>
#!/usr/bin/env python
# -*- coding: utf-8 -*-

###########################################################################
# Copyright (C) 2005 by Alexandro Colorado && Luis Cabrera
#
# Author:
# Alexandro Colorado <jza@openoffice.org>
# Luis Cabrera <lcabrera@sauco.org>
#
# Copyright: See COPYING file that comes with this distribution
#
###########################################################################

__shell_usage__ = '''Este programa esta pensado para recoger automaticamente
los enlaces localizados en una determinada pagina, compararlos con los ya
existentes en una bbdd, y, si hay nuevos enlaces, insertarlos en la bbdd y
posteriormente, mandar un correo a las listas de usuarios predeterminadas
con los enlaces a las nuevas noticias.
Si no hubieran noticias nuevas, el programa no debera hacer absolutamente
nada.
'''
__version__ = '20051024'
__author__='Luis Cabrera Sauco && Alexandro Colorado'

import HTMLParser
import urllib2
import [[Main_MySQLdb|MySQLdb]]
import smtplib

############ CONFIGURATION VARIABLES ###############

'''Pagina de la que recoger los enlaces iniciales'''
headlines_url = ''

'''Datos para la configuracia de la bbdd'''
myhost= ""
myuser=""
mypassword=""
mydb=""
mytb=""

'''Datos para el envio de correos de avisos'''
enviar_correo=1
remitente=""
destinatario=""
subject=""
##
###################################

class [[Main_HeadlinesParser|HeadlinesParser]](HTMLParser.HTMLParser):
def __init__(self):
HTMLParser.HTMLParser.__init__(self)
self.headlines = {}
self.while_anchor = False
self.last_href = None

def handle_starttag(self, name, attrs):
attrs = dict(attrs)
if name == "a":
if "href" in attrs:
current_href = attrs["href"]
if "news[[Main_ItemID|ItemID]]" in current_href:
self.while_anchor = True
self.last_href = current_href

def handle_data(self, content):
content = content.strip()
if self.while_anchor:
self.headlines[content] = self.last_href

def handle_endtag(self, name):
if name == "a":
self.while_anchor = False

def sendMessage(de, para=[], cc=[], asunto='Asunto',texto='Cuerpo.', archivos=[],
host='', charsettexto='iso-8859-1', loginUsername='', loginPassword=''):
""" Mandar mensaje por correo electronico. """

from email.MIMEBase import MIMEBase
from email.MIMEText import MIMEText
from email import Encoders
import mimetypes
from smtplib import SMTP
import os

msg=MIMEText(texto, _charset=charsettexto)
if archivos:
msg2=MIMEBase("multipart","mixed") # crear contenedor
msg2.preamble="Este es un mensaje MIME con varias partes.

"
#
es muy importante!!! (de lo contrario no reconoce primer anexo.)
msg2.epilogue=''
msg2.add_payload(msg)
msg=msg2

# Cabeceras primero
msg['From']=de
if isinstance(para,(str,unicode)): para=[para]
msg['To']=", ".join(para)
if cc:
if isinstance(cc,(str,unicode)): cc=[cc]
msg['Cc']=", ".join(cc)
para.extend(cc)
msg['Subject']=asunto

for archivo in archivos:
ctype, encoding = mimetypes.guess_type(archivo)
if ctype is None or encoding is not None:
ctype = 'application/octet-stream'
maintype, subtype = ctype.split('/', 1)
if maintype == 'text':
msgparte = MIMEText(file(archivo).read(), _subtype=subtype)
else:
msgparte = MIMEBase(maintype, subtype)
msgparte.add_payload(file(archivo,"rb").read())
# Encode the payload using Base64
Encoders.encode_base64(msgparte)
msgparte.add_header('Content-Disposition', 'attachment',
filename=os.path.basename(archivo))
msg.attach(msgparte)

if not host:
return msg.as_string(0)
s=SMTP(host)
if loginUsername and loginPassword:
s.login(login[[Main_UserName|UserName]],loginPassword)
x=s.sendmail(de,para, msg.as_string(0))
s.quit()
return x

def conectarBD():
"""Rutina de conexion a la BBDD"""

try:
db = [[Main_MySQLdb|MySQLdb]].Connect(host=myhost,user=myuser,passwd=mypassword,db=mydb)
return db
except:
print u"Error en la conexion a la Base de Datos"
return -1

def insertar[[Main_HeadLines|HeadLines]](datos):
"""Funcion para insertar los enlaces en mysql"""

conn = conectarBD()
c = conn.cursor()

if (conn != -1):
try:
"""Insertamos los links"""
for headline in datos:
try:
titulo_noticia = headline[0].decode('utf8').encode('latin1')
enlace_noticia = headline[1]
c.execute('''INSERT INTO mytb (headline, url) VALUES ('s')
''' % ( titulo_noticia, enlace_noticia ))
referencia_noticia = 'Acaba de ser a adida la siguiente noticia:

'+titulo_noticia+'

Pueden leer la noticia completa en el siguiente enlace:

'+enlace_noticia
referencia_noticia = referencia_noticia.decode('utf8').
encode('latin1')
if enviar_correo == 1:
sendMessage(de=remitente,para=destinatario,asunto=subject,
texto=referencia_noticia,host="localhost")
except:
pass
## print u'Enlace repetido'
except:
print u'Problemas al realizar los �INSERT�'
return -1

def main():
"""LLamada a las distintas funciones para conseguir los objetivos del programa"""

source = urllib2.urlopen(headlines_url).read()
parser = [[Main_HeadlinesParser|HeadlinesParser]]()
parser.feed(source)

lineas = parser.headlines.items()

try:
insertar[[Main_HeadLines|HeadLines]](lineas)
except:
print u'Problemas al insertar los enlaces.'

if __name__ == "__main__":
main()
</pre>
<hr />
Second script: Parse Documentation Page
<pre>
#!/usr/bin/env python
# -*- coding: latin1 -*-

###########################################################################
# Copyright (C) 2005 by Alexandro Colorado && Luis Cabrera
#
# Author:
# Alexandro Colorado <jza@openoffice.org>
# Luis Cabrera <lcabrera@sauco.org>
#
# Copyright: See COPYING file that comes with this distribution
#
###########################################################################

__shell_usage__ = '''
'''
__version__ = '20051030'
__author__='Luis Cabrera Sauco'

import HTMLParser
import urllib2

headlines_url = 'http://es.openoffice.org/servlets/[[Main_ProjectDocumentList|ProjectDocumentList]]?folderID=276&expandFolder=276&folderID=0'

class [[Main_HeadlinesParser|HeadlinesParser]](HTMLParser.HTMLParser):
def __init__(self):
HTMLParser.HTMLParser.__init__(self)
self.headlines = {}
self.while_anchor = False
self.last_href = None
self.mysearch = '[[Main_ProjectDocumentList|ProjectDocumentList]]'

def handle_starttag(self, name, attrs):
attrs = dict(attrs)
if name == "a":
if "href" in attrs:
current_href = attrs["href"]
if self.mysearch in current_href:
self.while_anchor = True
self.last_href = current_href

def handle_data(self, content):
content = content.strip()
if self.while_anchor:
self.headlines[content] = self.last_href

def handle_endtag(self, name):
if name == "a":
self.while_anchor = False

def main():
source = urllib2.urlopen(headlines_url).read()
parser = [[Main_HeadlinesParser|HeadlinesParser]]()
parser.feed(source)

for headline in parser.headlines.items():
# print '''insert into "Headlines" values ('s');''' % headline
urldoc = headline[1].decode('utf8').encode('latin1')
docsource = urllib2.urlopen(urldoc).read()
docparser = [[Main_HeadlinesParser|HeadlinesParser]]()
docparser.mysearch = 'documents'
docparser.feed(docsource)

for datos in docparser.headlines.items():
print '''insert into "Headlines" values ('s',' (headline[0],datos[0].decode('utf8').encode('latin1'),datos[1].decode('utf8').encode('latin1'))

if __name__ == "__main__":
main()

</pre>

-- Main.[[Main_AlexandroColorado|AlexandroColorado]] - 23 Oct 2005 
-- Main.[[Main_LuisCabreraSauco|LuisCabreraSauco]] - 02 Nov 2005

Java and OpenOffice.org

2005-11-22T13:56:06Z

Skoorb: Main OOoJava moved to OOoJava

=== [[Main_OpenOffice|OpenOffice]].org 2.0 Functionality depending on Java===

for use Java in [[Main_OpenOffice|OpenOffice]].org, please see

* Policies : http://tools.openoffice.org/policies/java_usage.html

==== [[Main_OpenOffice|OpenOffice]].org Base====

* Create Form Wizard

==== [[Main_OpenOffice|OpenOffice]].org Writer====

* Letter Wizard
* Fax Wizard
* Agenda Wizard
* HTML Wizard

* [[Main_SaveAs|SaveAs]] -> [[Main_AportisDoc|AportisDoc]] (Palm)
* [[Main_SaveAs|SaveAs]] -> [[Main_DocBook|DocBook]]
* [[Main_SaveAs|SaveAs]] -> Pocket Word (*.psw)

==== [[Main_OpenOffice|OpenOffice]].org Calc====

* [[Main_SaveAs|SaveAs]] -> Pocket Excel

==== All====

* [[Main_OfficeBean|OfficeBean]]
* Java Script Macros
* Beanshell Macros
* Python ???

Question: What is exactly not working ? Tools->Organzie Macros->[[[Main_JavaScript|JavaScript]]|Beanshell|Python] pops up a message boxes that no JRE is installed but then the Dialog is displayed (please also see http://www.openoffice.org/issues/show_bug.cgi?id=46680)

=== Java detection in [[Main_StarOffice|StarOffice]] 8 and [[Main_OpenOffice|OpenOffice]].org 2===

==== Which Java will be used ?====

[[Main_StarOffice|StarOffice]] tries to detect the newest Java version installed.
[[Main_StarOffice|StarOffice]] only detects Sun Java versions, while [[Main_OpenOffice|OpenOffice]].org also
detects Java versions from other vendors.
When using versions from different vendors, the numbering system might
be different so maybe not the newest version is used.
You can change the Java version in [[Main_StarOffice|StarOffice]] via tools/options/Java.
On GNOME, if AT tool support is enabled, [[Main_StarOffice|StarOffice]] will use that latest
version where the Java Access Bridge is enabled.

==== When is Java detection done ?====

On Windows, detection is done the first time Java is used.
On Linux/Solaris, detection is done the first time a user starts [[Main_StarOffice|StarOffice]].

==== How can I reset the Java configuration ?====

The configuration is stored in

< staroffice-config > /user/config/javasettings_ < platform > .xml.

Just delete this file if you want [[Main_StarOffice|StarOffice]] to detect again.
The Java configuration file cannot be modified manually. The data format
is not specified an may change anytime without further notice.
Don't try to modify that file to change the Java version. The < location >
and < version > entries are only for 'documentation', the Java version is
accessed via the < vendorData > , which is binary.

ES/Desarrollo/Syndication

2005-11-22T13:54:51Z

Skoorb: remove link to a main OOoES

ReleaseCodeline

2005-11-22T13:34:33Z

Skoorb: Main ReleaseCodeline moved to ReleaseCodeline

A [[Main_ReleaseCodeline|ReleaseCodeline]] represents a branch on which a [[Main_ProductRelease|ProductRelease]] has been developed. A cvs checkout of this branch will update the source to the latest version of the [[Main_ProductRelease|ProductRelease]].

Examples for a [[Main_ReleaseCodeline|ReleaseCodeline]] are :

* =mws_srx680= for [[Main_OpenOffice|OpenOffice]].org 1.1.x

* =HEAD= for [[Main_OpenOffice|OpenOffice]].org 2.0

-- Main.[[Main_MartinHollmichel|MartinHollmichel]] - 14 Aug 2005

ReleaseMilestone

2005-11-22T13:34:07Z

Skoorb: Main ReleaseMilestone moved to ReleaseMilestone

The [[Main_ReleaseMilestone|ReleaseMilestone]] number will be increased whenever child workspaces will be integrated during regular development or stabilising phases. When once has been decide to make a milestone ready for release, builds with cws integration will be made on the same milestone with just the build number increased.

-- Main.[[Main_MartinHollmichel|MartinHollmichel]] - 14 Aug 2005

Target Milestone

2005-11-22T13:33:50Z

Skoorb: Main TargetMilestone moved to TargetMilestone

== List of Target Milestones==

http://development.openoffice.org/releases/Target_Milestone.html

=== Setting a [[Main_TargetMilestone|TargetMilestone]]===

* A target milestone should only be set, if you are sure you have the resources availabe to fix an issue for the targeted release. For individuals this means that you also have to reassign the issue to yourself to indicate which person gave the committment for fixing (this may be slighty different for larger teams, such as child workspace teams or Sun's development team, where person reassign issue to other team members)

* If somebody is not sure about how to get patches reviewed or integrated this should be raised on the dev@openoffice.org list. There everybody should get assistance to get the correct target milestone and owner set.

-- Main.[[Main_MartinHollmichel|MartinHollmichel]] - 18 Aug 2005

MediaWiki Configuration

2005-11-21T09:27:20Z

Skoorb: delete me

This pages have been automatically generated by twiki2mediawiki. Please
review all of them, as there will be broken markup and broken links.

Please review your page and move the link from the "Converted Pages" to "Reviewed Pages". To move your page to a new name you have to login. If you would like to see a page removed add a link to the [[Twiki2mediawiki_TODO_list#remove.28d.29|remove(d)]] section.

== Reviewed Pages ==

=== ok ===

* [[OOo Ergonomics]] (from [[Main_OOoAnnoyances]])
* [[OpenDocument]]
* [[OpenOffice]]
* [[IRC Communication]]
* [[Main_OOoJava]]
* [[OOoRelease201]]
* [[ProductRelease]]
* [[OOoRelease200]]
* [[Writing warning-free code]] (from [[Main_WarningFree]])

SVG* got re-worked by Haui
* [[SVG Group Opacity]]
* [[SVG Elliptic Arcs]]
* [[SVG Import Filter]]
* [[Supported SVG Features]]
* [[Unsupported SVG Features]]
* [[SVG Import Source Code]]
* [[SVG User Experiences]]
* [[SVG Path Semantics]]
* [[Main SVGHEAD]] (remove this? [[User:MartinK]])
* [[SVG Import ToDo]]
* [[SVG Coordinate Systems]]

=== remove(d) ===

Please add a link to pages you would like to see removed here.

* [[_default_WebLeftBar]]
* [[_default_WebRss]]
* [[Main_CaioTiago]]
* [[Main_OOo]]
* [[Main_EikeRathke]]
* [[Main_IanNz]]
* [[Main_JacquelineMcNally]]
* [[Main_LondonOffice]]
* [[Main_OfficeLocations]]
* [[Main_SanJoseOffice]]
* [[Main_StefanTaxhet]]
* [[Main_TokyoOffice]]
* [[Main_MichaelMeeks]]
* [[Sandbox_MyPlayGround]]
* [[Sandbox_StefanTaxhetSandbox]]
* [[Sandbox_WebLeftBar]]
* [[Sandbox_WebRss]]
* [[Main_WebRss]]
* [[Main_TestTest]]
* [[Main_StefanTaxhetAdmin]]
* [[Sandbox_SurveyServicesOpenOfficeOrg]]
* [[Main_TOCStyleInclude]]
* [[Main_CodeStyleInclude]]
* [[Main_DianeMackay]]
* [[Main_StephanBergmann]]
* [[Main_PeterThoeny]]
* [[Main_FriedrichStrohmaier]]
* [[Main_AlexBrooks]] - Anyone with admin rights, feel free to delete whenever you can. --[[User:Skoorb|Skoorb]] 10:27, 21 November 2005 (CET)

These pages are of dubious usefulness, completeness & relevance and should prolly be removed:
* [[WebOOoBanners]]
* [[OOoES]]

== Converted Pages - pending re-work ==

It's good if you rename these pages as they are re-worked to remove the 'Main_' suffix - use the 'move' tab to do that.

* [[DomainDeveloper]]
* [[Main_SurveyServicesOpenOfficeOrg]]
* [[Main_MacOSXBuildInstructions]]
* [[Main_ReleaseMilestone]]
* [[Main_ReleaseCodeline]]
* [[Main_TargetMilestone]]

== Personal Pages ==

It's probable that we don't want / require personal pages in the wiki. Hence this lot can be axed in a week or two if no-one screams, many of them contain broken Twiki junk.
To help us with this process, it'd be great if you could remove the content from your page & move your name into the relevant 'remove(d)' section above to join the other alumnii there.

* [[Main_AlanKatzman]]
* [[Main_AlexandroColorado]]
* [[Main_AndreSchnabel]]
* [[Main_AndrewBrown]]
* [[Main_BadBoy]]
* [[Main_BerndSeidler]]
* [[Main_BernhardHaumacher]]
* [[Main_CharlesSchulz]]
* [[Main_ChrisReid]]
* [[Main_ChristophNeumann]]
* [[Main_CorNouws]]
* [[Main_CraigAdams]]
* [[Main_CristianDriga]]
* [[Main_CyrilJacquenot]]
* [[Main_CyrilRIP]]
* [[Main_DavidFraser]]
* [[Main_DeepankarDatta]]
* [[Main_DonaldGillies]]
* [[Main_DrewCrosland]]
* [[Main_EricBachard]]
* [[Main_EricHoch]]
* [[Main_ErnestoWalker]]
* [[Main_FlorianHeckl]]
* [[Main_FrankSchoenheit]]
* [[Main_GorkemCetin]]
* [[Main_GrSingleton]]
* [[Main_HelenePetit]]
* [[Main_JacquesRoux]]
* [[Main_JimWatson]]
* [[Main_JiriReznicek]]
* [[Main_JohannesSwoboda]]
* [[Main_JoostAndrae]]
* [[Main_JuergenSchmidt]]
* [[Main_KazunariHirano]]
* [[Main_KoheiYoshida]]
* [[Main_LaptopPerKidLetter]]
* [[Main_LouisSuarez]]
* [[Main_LuisCabreraSauco]]
* [[Main_MaartenBrouwers]]
* [[Main_MarcMaki]]
* [[Main_MarkoMoeller]]
* [[Main_MarkusHibbetts]]
* [[Main_MartinTaylor]]
* [[Main_MikeStockman]]
* [[Main_OpenTiss]]
* [[Main_PaoloMantovani]]
* [[Main_PatrickBall]]
* [[Main_PaulWujek]]
* [[Main_PavelJanik]]
* [[Main_PeteBedingfield]]
* [[Main_PeterEberlein]]
* [[Main_RalfSchellenberger]]
* [[Main_ReneAuberger]]
* [[Main_RobertRees]]
* [[Main_RolfMeyer]]
* [[Main_ScottCarr]]
* [[Main_SeoCoolhuoquoz]]
* [[Main_SettanttaOo]]
* [[Main_SuperBiskit]]
* [[Main_SvanteSchubert]]
* [[Main_Syndication]]
* [[Main_TheTschaena]]
* [[Main_VincentPatrick]]
* [[Sandbox_AndrewBrownSandbox]]
* [[Sandbox_BernhardHaumacherSandbox]]
* [[Sandbox_CristianDrigaSandbox]]
* [[Sandbox_ScottCarrSandbox]]

== Managing Rights ==

* sysop via db 
http://meta.wikimedia.org/wiki/Setting_user_rights_in_MediaWiki#Granting_rights_to_users

* [http://meta.wikimedia.org/wiki/User_rights User Rights]

It seems neccessary to require users to login to edit. 
This avoids defacement and makes authors feel more responsible for
the content.

Special Pages to take care of:
* Special:Userrights
* OOoWiki:Administrators

== Help Content (done) ==

Help:Contents with links to 
http://meta.wikimedia.org/wiki/MediaWiki_FAQ 
http://meta.wikimedia.org/wiki/MediaWiki_User%27s_Guide

Help:Editing with links to 
http://meta.wikimedia.org/wiki/Help:Editing 
http://meta.wikimedia.org/wiki/Help:Contents#For_editors

== Copyrights (done) ==

[[Project:Copyrights]]

== Navigation Box (done) ==

See http://meta.wikimedia.org/wiki/MediaWiki_FAQ#In_version_1.5
 
[[MediaWiki:Sidebar]]

== InterWiki Links ==

http://meta.wikimedia.org/wiki/Help:Guide_for_system_administrators_for_setting_up_interwiki_linking#add_your_own_custom

[[User:Haui]] configured issue InterWiki links for TWiki. That would be handy here too.

== Custom Namespaces ==

http://meta.wikimedia.org/wiki/Help:Namespace#Custom_namespaces
http://meta.wikimedia.org/wiki/Help:Custom_namespaces

== Cleanup Test Installations ==

mediawiki2, mediawiki, backups of httpd.conf, ... can be purged.

We might want to keep one playground though.

== CodeSyntaxHighlight MediaWiki Extension ==
Code Syntax highlighting using GeShi
http://qbnz.com/highlighter/
Has been added as per
http://mercury.it.swin.edu.au/swinbrain/index.php/CodeSyntaxHighlight_MediaWiki_Extension
 

Haven't updated help page yet.

The default color codes for Geishi could be improved.

I have changed the colors for oobas, but am not sure what colors to assign for C. I haven't managed to mimick the BASIC IDE as I don't understand why keywords like "for" are blue but "msgbox" is green.

For those that have access to the server the files are in:
ooodata/www/mwiki/extensions/CodeSyntaxHighlight/geshi
and look like (initial comments removed):
<code>[php]
$language_data = array (
'LANG_NAME' => 'C',
'COMMENT_SINGLE' => array(1 => '//', 2 => '#'),
'COMMENT_MULTI' => array('/*' => '*/'),
'CASE_KEYWORDS' => GESHI_CAPS_NO_CHANGE,
'QUOTEMARKS' => array("'", '"'),
'ESCAPE_CHAR' => '\\',
'KEYWORDS' => array(
1 => array(
'if', 'return', 'while', 'case', 'continue', 'default',
'do', 'else', 'for', 'switch', 'goto'
),
2 => array(
'null', 'false', 'break', 'true', 'function', 'enum', 'extern', 'inline'
),
3 => array(
'printf', 'cout'
),
4 => array(
'auto', 'char', 'const', 'double', 'float', 'int', 'long',
'register', 'short', 'signed', 'sizeof', 'static', 'string', 'struct',
'typedef', 'union', 'unsigned', 'void', 'volatile', 'wchar_t'
),
),
'SYMBOLS' => array(
'(', ')', '{', '}', '[', ']', '=', '+', '-', '*', '/', '!', '%', '^', '&', ':'
),
'CASE_SENSITIVE' => array(
GESHI_COMMENTS => true,
1 => false,
2 => false,
3 => false,
4 => false,
),
'STYLES' => array(
'KEYWORDS' => array(
1 => 'color: #b1b100;',
2 => 'color: #000000; font-weight: bold;',
3 => 'color: #000066;',
4 => 'color: #993333;'
),
'COMMENTS' => array(
1 => 'color: #808080; font-style: italic;',
2 => 'color: #339933;',
'MULTI' => 'color: #808080; font-style: italic;'
),
'ESCAPE_CHAR' => array(
0 => 'color: #000099; font-weight: bold;'
),
'BRACKETS' => array(
0 => 'color: #66cc66;'
),
'STRINGS' => array(
0 => 'color: #ff0000;'
),
'NUMBERS' => array(
0 => 'color: #cc66cc;'
),
'METHODS' => array(
1 => 'color: #202020;',
2 => 'color: #202020;'
),
'SYMBOLS' => array(
0 => 'color: #66cc66;'
),
'REGEXPS' => array(
),
'SCRIPT' => array(
)
),
'URLS' => array(
1 => '',
2 => '',
3 => 'http://www.opengroup.org/onlinepubs/009695399/functions/{FNAME}.html',
4 => ''
),
'OOLANG' => true,
'OBJECT_SPLITTERS' => array(
1 => '.',
2 => '::'
),
'REGEXPS' => array(
),
'STRICT_MODE_APPLIES' => GESHI_NEVER,
'SCRIPT_DELIMITERS' => array(
),
'HIGHLIGHT_STRICT_BLOCK' => array(
)
);
</code>

I found this link useful for working out color codes:
http://www.htmlgoodies.com/tutorials/colors/article.php/3478961

[[User:Iannz]]

SurveyServicesOpenOfficeOrg

2005-11-21T09:21:05Z

Skoorb: Main SurveyServicesOpenOfficeOrg moved to SurveyServicesOpenOfficeOrg

[[[Main_SurveyServicesOpenOfficeOrg|SurveyServicesOpenOfficeOrg]] http://survey.services.openopffice.org] is a new server for
replacing the old one.

-- Main.[[Main_StefanTaxhet|StefanTaxhet]] - 13 Sep 2005

In this topic goes everything related to configuring the server for surveying.

*Basic server setup:*
* Apache
* PHP 4.4 or higher
* Database: mysql

*First setup steps:*
* Establish the location of the htdocs directory for surveys. Also create a non_public folder.
* Configure mysql for usage: setup mysql root access and password. Create mysql user for applications. Restrict access to _localhost_.
* Identify and setup a CMS for the website
* Setup survey program

*Things to discuss further:*
* Shall we use CVS for placing everything under the _htdocs_ folder ?

-- Main.[[Main_CristianDriga|CristianDriga]] - 13 Sep 2005

*Today's journal - server config (Sep 14th)*
* Apache - enabled PHP scripting
* httpd.conf - added index.php to Directory Index directive
* created new Apache htdocs directory: /ooodata/surveys/public_html
* httpd.conf - changed Document Root to point to the new folder
* mysql - re-initialized the mysql server after yesterday's initial tests.

*To-Do:*
* make mysql start at boot time; set mysql root password; create mysql users for applications.

-- Main.[[Main_CristianDriga|CristianDriga]] - 14 Sep 2005

*Updating log with other settings since last comments here*

*12-10-2005 Made [[Main_MySQL|MySQL]] start/stop on boot*

1. Edited startup file: S50mysql.server
* Changed basedir and default variables to point to the current mysql files and data
* basedir=[/folder/here/] -> folder where mysql /bin and /sbin subfoders are located
* datadir= -> to point to the current data directory
* bindir= -> actually pointed it to mysql's /sbin directory as there is the startup program located
* bindir="$basedir/sbin"

2. created my.cnf file in /etc containing:

[server]
basedir=[/folder/here/] -> folder where mysql /bin and /sbin subfoders are located

3. copied S50mysql.server file to /etc/init.d

4. copy my_print_defaults to /bin
* cp /usr/sfw/bin/my_print_defaults /bin

5. 5. Symlink S50mysql.server file to startup and shutdown services folders:
* ln /etc/init.d/S50mysql.server /etc/rc3.d/S99mysql
* ln /etc/init.d/S50mysql.server /etc/rc0.d/K01mysql

-- Main.[[Main_CristianDriga|CristianDriga]] - 18 Oct 2005