| 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: | |
| Category: | MaxDB | Severity: | S2 (Serious) |
| Version: | 7.5.00.19 | OS: | Windows (Windows XP) |
| Assigned to: | Ulf Wendel | CPU Architecture: | Any |
[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
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...