Attached is aggregated info on a little adventure of getting SAP DB built and running from the CVS sources on Debian 3.0 (woody).
Greets, Tobias toberste@stalker$ ./create_demo_db.sh ERR 11641 XSERVER XSERVER is already running! create database TST... set parameters for TST... start TST... initialize TST... load system tables... create database demo user... set backup parameters... toberste@stalker$ ls -la ~/TST/ total 14839 drwxr-xr-x 2 toberste toberste 160 Jan 18 19:43 . drwxr-xr-x 38 toberste toberste 6312 Jan 18 19:55 .. -rw-rw---- 1 toberste toberste 20979712 Jan 18 19:43 DISKD0001 -rw-rw---- 1 toberste toberste 8396800 Jan 18 19:43 DISKL001 -rw-rw---- 1 toberste toberste 3014656 Jan 18 19:43 autosave.001 -rw-rw---- 1 toberste toberste 1900544 Jan 18 19:43 datasave toberste@stalker$ dbmcli -d TST -u dbm,dbm dbmcli on TST>sql_execute select table_name from all_tables OK END 'AUDIT_ACTIONS' 'ROLE_PRIVS' 'STMT_AUDIT_OPTION_MAP' 'TABLE_PRIVILEGE_MAP' --- dbmcli on TST>quit --- toberste@stalker$
How to create SAP DB from scratch on Debian 3.0 (woody) / i386
Login to CVS:
1. Type in a single line:
cvs -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb login
2. Press ENTER when you are asked for a password.
Build the Tools:
3. Getting the sources of the Tools
cvs -z5 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb co TOOLSRC
Note: The cvs client may hang after it has finished checking
out the source tree. Simply cancel the cvs client.
4. Edit TOOLSRC/sys/src/tt/toolvars-tml.pl.tt and replace
if ($MACH eq "I386") {
@OPTIMIZE = ("-O3", "-march=pentium", "-mcpu=pentiumpro");
} elsif ($MACH eq "IA64") {
with
if ($MACH eq "I386") {
@OPTIMIZE = ("-O2");
} elsif ($MACH eq "IA64") {
5. Edit TOOLSRC/sys/desc/bison.mac and replace
rm $TOOL/gnu/bin/bison;
with
rm -f $TOOL/gnu/bin/bison;
6. Edit TOOLSRC/sys/desc/alltools.mac and move line 419:
::tt/cpan/SAPDB/Install/xs.mac
right before line 26:
# make first
::tt/cpan/SAPDB/Install/xs.mac
ToolLib.pm.tt
7. Now do ..
cd TOOLSRC
./configure
make base basescripts
cp sys/src/APODev/lcmake.pm lib/perl5
mkdir lib/perl5/Mail
cp sys/src/Perl/Mail/Sendmail.pm lib/perl5/Mail
make alltools
su
bin/prepare_inst.pl
exit
make checkRegistryDir
cd ..
Build the SAP DB:
9. Getting the sources of the database software
cvs -z5 -d :pserver:[EMAIL PROTECTED]:/cvsroots/sapdb co sapdb-74
Note: The cvs client may hang after it has finished checking
out the source tree. Simply cancel the cvs client.
10. Edit sabdb-74/sys/src/en/gen04.h and append the following 2 lines
#undef true
#undef false
right after the lines
/* defined in curses.h */
#undef OK
#undef TRUE
#undef FALSE
11. Creating the configuration script (one line)
python TOOLSRC/bin/newSapdbSrc.py
-pyinclude /usr/include/python2.1 sapdb-74
12. Executing the configuration script
. devsapdb
13. Building the database software
imf all
14. Make sure you source have
. $HOME/path-to-sapdb/sapdb-74/.iprofile
in your shell startup (e.g. ~/.bashrc).
15. Replace old bundled python
cp `which python` $HOME/path-to-sapdb/sapdb-74/usr/bin/x_python
create_demo_db.sh
Description: Bourne shell script
drop_demo_db.sh
Description: Bourne shell script
