Hi Everyone !
[b]last updated 06.01.2006[/b]

The aim of this howto ist to help people install MaxDB on gentoo systems from sources.
This is a very long running process (about 10h) and it can not be done totaly automatic.
The ebuilds that i provide need interaction at a given point where they will tell you what to do.

This is meant as an alternative to installing the binary version.
It is meant to be used by people who don't mind spending their time in endles compilation sessions

If you do not know why you should use MaxDB read John L. Singleton's "Musings on MaxDB, Five Reasons Why MaxDB Will Replace Your Current Database"
([url]http://www.johnsingleton.com/maxdb/2004/06/five-reasons-why-maxdb-will-replace.html[/url]).

The following points should help you to install maxdb.
[b]I.) Before you start:[/b]
[b]THESE EBUILDS DO NOT SUPPORT UPDATES.[/b]
If you have a running MaxDB instance on your system then:
[list]- BACKUP YOUR DATA
- move the directory /opt/sdb to something like /opt/sdb.off
- move the directory /usr/spool/sql to something like /usr/spool/sql.off
- move the file /etc/opt/sdb to something like /etc/opt/sdb.off[/list]
[b]II.) portage principle[/b]
1.) ebuilds that are not allready in the portage tree should be copied to a so called portage overlay directory.
if you do not allready have on, do the following:
[code]- create a overlay directory. (normaly /usr/local/portage)
- add the overlay directory to you /etc/make.conf by adding a line like PORTDIR_OVERLAY=/usr/local/portage
[/code]
2.) creating directories in the overlay directory
you should create directories for the ebuilds in the overlay directory:
[code]- create a directory /usr/local/portage/dev-db/maxdb-devtools-src for the devtools.
- create a directory /usr/local/portage/dev-db/maxdb-src for the db-system
[/code]
[b]III.) Get the ebuilds[/b]
the ebuild you will need can be found in the bug system (bugs.gentoo.org).
[list]-> bug 42286 for the devtools
-> bug 42465 for the db-system
[/list]
1. Download the ebuilds into the directories:
[code]- download maxdb-devtools-src-562049-r1.ebuild from bug 42286 and put it to /usr/local/portage/dev-db/maxdb-devtools-src
- create a /usr/local/portage/dev-db/maxdb-devtools-src/files directory for the patches 
- download maxdb-devtools-src-562049.patch from bug 42286 and put it to /usr/local/portage/dev-db/maxdb-devtools-src/files
- download maxdb-src-7.6.0.16-r1.ebuild from bug 42465 and put it to /usr/local/portage/dev-db/maxdb-src
- create a /usr/local/portage/dev-db/maxdb-src/files directory for the patches 
- download maxdb-source-7_6_0_16_ini.patch from bug 42465 and put it to /usr/local/portage/dev-db/maxdb-src/files
- download maxdb-source-7_6_0_16-r1_all.patch from bug 42465 and put it to /usr/local/portage/dev-db/maxdb-src/files
[/code]
[b]IV) Installation[/b]

1. Keywords
Both ebuils are masked with the keyword ~x86 (as they should be because they are not included in the official portage tree).
Add them to the /etc/portage/package.keywords by doing a:
[code]- execute "echo dev-db/maxdb-devtools-src ~x86 >> /etc/portage/package.keywords"
- execute "echo dev-db/maxdb-src ~x86 >> /etc/portage/package.keywords"
[/code]
2. install the devtools
[code]- go to the /usr/local/portage/dev-db/maxdb-devtools-src directory[/code]
create the digest:
[code]- execute "ebuild maxdb-devtools-src-562049-r1.ebuild digest"[/code]
emerge the devtools:
[code]- execute "emerge maxdb-devtools-src"[/code]

You can ignore the warning and error at the end off the make process about the global SapDB registry it will be created by the ebuild later.

If this worked you should have your devtools in /opt/sdb/devtools. 

3. Install the db system
[b]FIRST (AGAIN): if you allready have a maxdb installation (or SAPDb) SAVE YOUR DATA !!!![/b]
[code]- go to the /usr/local/portage/dev-db/maxdb-src directory[/code]
create the digest:
[code]- execute "ebuild maxdb-src-7.6.0.16-r1.ebuild digest"[/code]
emerge the db-system:
[code]- execute "emerge maxdb-src"[/code]

- go to bed or to the next bar (you have got about 5 to 10 hours time now)  :wink: 
- at the end of the installation the ebuild will give some informations - follow them[/code]
When everthing works fine you got it.
[b]V) Post Installation[/b]
1. Database Installation
If you dont know how to create a database instance 
either
- see http://dev.mysql.com/doc/maxdb/install.html#install for manual installation
or 
- start your MaxDB web-administartion server with something like the following script
[code]export LD_LIBRARY_PATH="/opt/sdb/programs/lib:${LD_LIBRARY_PATH}"
export PATH="${PATH}:/opt/sdb/programs/bin"
cd /opt/sdb/programs/pgm
# start the webserver
./wahttp &
# start the db-server
/opt/sdb/programs/bin/x_server -Y start[/code]
- access the dbm-admin page with your web-browser at http://localhost:9999/webdbm
- click on "New Database" and follow the pages.

2. Information
Another very good source of information is http://sapdb.2scale.net the MaxDb Wiki Page

3. (And by god not least) THANX
Thanks to everybody who helped and still helps me to create and test this ebuilds.
Special thanks to:
*) Daniel Dittmar from SAP Labs Berlin - he is the guy who knows.
*) All the helpfull guys at the MaxDb mailing list (http://lists.mysql.com/maxdb)
*) Urs Joss, Dros, oldie, domlogic, cchee and the other guys from the forum who must have spent days testing the ebuils (big thanx guys)

If you have any problems or need help in what ever way fell free to contact me directly (hmun@thinkthinkdo.com) or even better post a forum message.

Last remark:
English is not my native language. So if there are typos or grammar erros please provide feedback.

Have fun - looking forward to your feedback - Mundi