Bug #6526 MaxDB on MySQL 7.5.00.19 - Early problem after successful instalation
Submitted: 9 Nov 2004 18:20 Modified: 11 Nov 2004 21:51
Reporter: Costas Nikolaou Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MaxDB Severity:S2 (Serious)
Version:7.5.00.19 OS:Microsoft Windows (Windows XP)
Assigned to: Ulf Wendel CPU Architecture:Any

[9 Nov 2004 18:20] Costas Nikolaou
Description:
I downloaded MaxDB on MySQL 7.5.00.19 and installed it on a Windows XP PC. The installation terminated successfully.

I started reading the document about creating a new database instance and according to it...
I issued the following commands:

1) dbmcli db_create MAXDB1 DBM,DBM
2) dbmcli -d MAXDB1 -u DBM,DBM -i maxdb1_01.txt

    where maxdb1_01.txt is an ASCII file with the following content:
             param_startsession
             param_init
             param_put MAXUSERTASKS 5
             param_put MAXSERVERTASKS 15
             param_put CACHE_SIZE 3000
             param_put MAXDATAVOLUMES 5
             param_checkall
             param_commitsession
             param_addvolume 1 LOG LOG_001 F 2000
             param_addvolume 1 DATA DAT_001 F 10000
             db_admin
             db_activate DBA,DBA
             load_systab

    Statements completed successfully...
    ...but only the last statement (load_systab) terminated with error: -24904, ERR_DOMPWRONG: wrong DOMAIN password

As many times I tried connecting to this instance through
   dbmcli -d MAXDB1 -u DBA,DBA (success)
and getting the DB online
   db_online (success)
and asking next to load system table
   load_systab (fail)
the reply was always the above mentioned error.

Alas, this error number (and message) is not covered in the corresponding error messages section of the documentation. (In this category of errors the first mentioned error is the one with EC -24905). Should I consider myself such an unlucky person? I would appreciate your help and your suggestions.

Please consider that the enviromental parameters are as follows:
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Costas Nikolaou\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DOLPHIN
ComSpec=C:\WINDOWS\system32\cmd.exe
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Costas Nikolaou
LOGONSERVER=\\DOLPHIN
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=c:\program files\sdb\programs\bin;c:\program files\sdb\programs\pgm;C:\Inprise\vbroker\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1\Borland\Delphi6\Bin;C:\PROGRA~1\Borland\Delphi6\Projects\Bpl
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 6, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0806
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\COSTAS~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\COSTAS~1\LOCALS~1\Temp
USERDOMAIN=DOLPHIN
USERNAME=Costas Nikolaou
USERPROFILE=C:\Documents and Settings\Costas Nikolaou
windir=C:\WINDOWS

Thanks in advance

Costas Nikolaou
Data Ocean Inc.
28 Oktovriou 10-12
Nea Ionia - Athens 14231 - GREECE

How to repeat:
???
On my system following the procedure described above...
[11 Nov 2004 21:51] Ulf Wendel
Hello Costas,

this is a known documentation flaw. You can ask in a dbmcli session for help on a command with "help command". This is the help output for load_systab:

/opt/sdb/programs/bin/dbmcli>help load_systab
OK
load_systab              [-u <user>,<pwd>] [-ud <domainpwd>] (needs dbname)

Sadly, the documentation and the help do not mention, that you have to supply a arbitrary domain password. Try this:

/opt/sdb/programs/bin/dbmcli on DEMO>load_systab -ud DBA
OK
0,OK: everything works fine
0,/opt/sdb/7500/bin/x_python /opt/sdb/7500/env/lsystab.py -R /opt/sdb/7500 -d DEMO -u DBA,*
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC and JDBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle sytem tables
Installing tables for SQL Studio
Installing suppose list
Installing tables for WebAgent
Installing tables for WebDAV
Installing tables for WebDAV XML Indexing
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
==================================
Installation successfully finished
==================================

Best regards,
Ulf Wendel
[16 Nov 2004 16:18] Costas Nikolaou
Thanks for your reply.

Your suggestion worked fine.

Best Regards
Costas Nikolaou