Hello Orlando, please check whether file $INSTROOT/env/TRIGGER.py exists or not and report your findings to the mailing list. If the file does not exist, your download/installation was not correct.
Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Orlando Andico [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:11 AM To: maxdb@lists.mysql.com Subject: database instance creation via CLI doesn't work following the SAP Library, i've tried creating a database instance following the script below. i installed all the relevant files via RPM install. # ./dbmcli -s db_create ig ig,ig (from UNIX prompt) # ./dbmcli -d ig -u ig,ig -i dbcreate.sh (from UNIX prompt) param_startsession param_init OLTP param_put MAXUSERTASKS 15 #param_put _UNICODE YES #param_put DEFAULT_CODE UNICODE param_put CACHE_SIZE 32768 param_put CAT_CACHE_SUPPLY 4096 param_put MAXDATAVOLUMES 16 param_put MAXLOGVOLUMES 8 param_checkall param_commitsession param_addvolume 1 LOG /opt/sdbdata/LOG01 F 16384 param_addvolume 1 DATA /opt/sdbdata/DATA01 F 131072 param_addvolume 2 DATA /opt/sdbdata/DATA02 F 131072 db_admin db_activate igdba,igdba load_systab -ud DBA db_online db_start sql_execute CREATE USER iguser PASSWORD igpass DBA NOT EXCLUSIVE the big problem is that the load_systab command fails. I thought it was a Unicode issue, so i tried re-creating without Unicode. same problem. The error message is: ... Installing support for UDE (User Defined Extensions) Installing tables for JDBC Database Metadata Installing tables for SQLDBC Database Metadata ---------Traceback--------------- File "/opt/sdb/7600/env/installib.py", line 410, in connectAndInstall installRoutine (session, options) File "/opt/sdb/7600/env/lsystab.py", line 198, in install "TRIGGER" File "/opt/sdb/7600/env/installib.py", line 162, in include module = __import__ (file) ---------Error------------------- exceptions.ImportError: No module named TRIGGER I don't know if this error is what causes succeeding errors, but the net effect is that even the sysdba cannot create users via sql_execute CREATE USER.. from dbmcli, error is no DBA privilege, strange since it IS the sysdba account (although create_user seems to work). but the users created with create_user cannot do anything, even setting SQLUSER YES with user_put doesn't work (user_put SQLUSER=YES returns and error, BTW). also, the sysdba user cannot connect using sqlcli and cannot perform any SQL queries. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
