Note: The db user DBUSER1 is belongs to the user group TESTGROUP. $ loadercli Loader protocol: '/home/dba/.sdb/loader/log/loader.prt' Loader packages: '/home/dba/sdb/loader/packages'
loadercli>set odbctrace on OK --- loadercli>use user DBUSER1 TEST1 serverdb DWDB ERR -25005 User (DBUSER1) logon to database DWDB failed: -25024 Error switching current schema to DBUSER1; --- Trace: $ cat loader9F0010.log <html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body ><PRE><PLAINTEXT> PRODUCT : MaxDB C-PreComp Runtime VERSION : 7.6.00 BUILD : 016-123-109-428 DATASOURCE: SESSION : 2; SQLMODE : INTERN SERVERDB : DWDB SERVERNODE: dw2.dw CONNECT "DBUSER1 " IDENTIFIED BY :A ISOLATION LEVEL 0 TIMEOUT 0 KERNEL FEATURES : OPTIMIZED STREAMS START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:SELECT 1 FROM TABLES WHERE TABLENAME = 'WA_MY_INODE' AND TABLETYPE = 'VIEW' PARSE : CMD : mfIndex init : 1 mfIndex init : 2 PARSEID: OUTPUT: 0000107F 00000301 3C002C00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:SELECT 1 FROM TABLES WHERE TABLENAME = 'WA_MY_INODE' AND TABLETYPE = 'VIEW' EXECUTE: CMD : PARSEID: INPUT : 0000107F 00000301 3C002C00 01000000 mfIndex init : 2 mfIndex init : 2 SQLCODE: 100 Row not found SQLRESULTNAME : SQL_CURSOR_0001 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:CLOSE "SQL_CURSOR_0001" PARSE : CMD : PARSEID: OUTPUT: 0000107F 00000501 06002800 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:CLOSE "SQL_CURSOR_0001" EXECUTE: CMD : PARSEID: INPUT : 0000107F 00000501 06002800 01000000 PARSEID: SELECT: 0000107F 00000301 3C002C00 01000000 mfIndex init : 2 mfIndex restore : 2 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 PARSEID: DROP : 0000107F 00000501 06002800 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00000501 06002800 01000000 mfIndex delete : 2 PARSEID: DROP : 0000107F 00000301 3C002C00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00000301 3C002C00 01000000 S2:SELECT COUNT(*) FROM DOMAIN.SCHEMAS WHERE OWNER = 'DBUSER1' AND SCHEMANAME = 'DBUSER1' PARSE : CMD : mfIndex init : 2 PARSEID: OUTPUT: 0000107F 00000801 3C002C00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:SELECT COUNT(*) FROM DOMAIN.SCHEMAS WHERE OWNER = 'DBUSER1' AND SCHEMANAME = 'DBUSER1' EXECUTE: CMD : PARSEID: INPUT : 0000107F 00000801 3C002C00 01000000 mfIndex init : 2 mfIndex init : 2 SQLRESULTNAME : SQL_CURSOR_0002 SQLERRD(INDEX_3) : 1 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:MASS STATEMENT : FETCH "SQL_CURSOR_0002" PARSE : CMD : WARNING: W--3------------ PARSEID: OUTPUT: 0000107F 00000A01 2A002B00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:MASS STATEMENT : FETCH "SQL_CURSOR_0002" EXECUTE: CMD : PARSEID: INPUT : 0000107F 00000A01 2A002B00 01000000 PARAMETER DESCRIPTION: 0xa3f3a0 Application Kernel Nr. Type Length Type Length Fraction --------------------------------------------- 1 7 13 0 10 0 OUTPUT : 1: EXPRESSION1 : 0 SQLERRD(INDEX_3) : 1 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:CLOSE "SQL_CURSOR_0002" PARSE : CMD : PARSEID: OUTPUT: 0000107F 00000B01 06002800 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:CLOSE "SQL_CURSOR_0002" EXECUTE: CMD : PARSEID: INPUT : 0000107F 00000B01 06002800 01000000 PARSEID: SELECT: 0000107F 00000801 3C002C00 01000000 mfIndex init : 2 mfIndex restore : 2 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 PARSEID: DROP : 0000107F 00000A01 2A002B00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00000A01 2A002B00 01000000 PARSEID: DROP : 0000107F 00000B01 06002800 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00000B01 06002800 01000000 mfIndex delete : 2 PARSEID: DROP : 0000107F 00000801 3C002C00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00000801 3C002C00 01000000 S2:SELECT VALUE FROM SYSINFO.ACTIVECONFIGURATION WHERE PARAMETERNAME = 'SESSION_TIMEOUT' PARSE : CMD : mfIndex init : 2 PARSEID: OUTPUT: 0000107F 00000F01 3C002C00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:SELECT VALUE FROM SYSINFO.ACTIVECONFIGURATION WHERE PARAMETERNAME = 'SESSION_TIMEOUT' EXECUTE: CMD : PARSEID: INPUT : 0000107F 00000F01 3C002C00 01000000 mfIndex init : 2 mfIndex init : 2 SQLRESULTNAME : SQL_CURSOR_0003 SQLERRD(INDEX_3) : 1 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:MASS STATEMENT : FETCH "SQL_CURSOR_0003" PARSE : CMD : WARNING: W--3------------ PARSEID: OUTPUT: 0000107F 00001101 2A002B00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:MASS STATEMENT : FETCH "SQL_CURSOR_0003" EXECUTE: CMD : PARSEID: INPUT : 0000107F 00001101 2A002B00 01000000 PARAMETER DESCRIPTION: 0xa3e6f0 Application Kernel Nr. Type Length Type Length Fraction --------------------------------------------- 1 7 257 2 256 0 OUTPUT : 1: VALUE : 0 SQLERRD(INDEX_3) : 1 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:CLOSE "SQL_CURSOR_0003" PARSE : CMD : PARSEID: OUTPUT: 0000107F 00001201 06002800 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 S2:CLOSE "SQL_CURSOR_0003" EXECUTE: CMD : PARSEID: INPUT : 0000107F 00001201 06002800 01000000 PARSEID: SELECT: 0000107F 00000F01 3C002C00 01000000 mfIndex init : 2 mfIndex restore : 2 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 PARSEID: DROP : 0000107F 00001101 2A002B00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00001101 2A002B00 01000000 PARSEID: DROP : 0000107F 00001201 06002800 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00001201 06002800 01000000 mfIndex delete : 2 PARSEID: DROP : 0000107F 00000F01 3C002C00 01000000 START : DATE : 2006-05-02 TIME : 0009:36:55 END : DATE : 2006-05-02 TIME : 0009:36:55 SQCDROPPARSID PARSEID: : 0000107F 00000F01 3C002C00 01000000 -----Original Message----- From: Bumes, Hans-Georg [mailto:[EMAIL PROTECTED]@lists.mysql.com Sent: Tuesday, May 02, 2006 4:14 AM To: maxdb@lists.mysql.com Subject: RE: loadercli - can't logon i can't reproduce the error using the full qualified connect parameters loadercli -d <databasename> -n <servernode> -u <databaseuser,userpassword> Please send me the odbctrace protocolfile /home/dba/.sdb/loader/log/loader<stamp>.log for establishing the connection. You get the odbctrace executing the following sequence of loader commands. >loadercli loadercli>set odbctrace on loadercli>use user dbuser1,<password> serverdb db1 -----Original Message----- From: Jey Razack [mailto:[EMAIL PROTECTED] Sent: Freitag, 28. April 2006 16:47 To: Bumes, Hans-Georg Cc: maxdb@lists.mysql.com Subject: RE: loadercli - can't logon Any progress on this ? -----Original Message----- From: Jey Razack [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:06 PM To: maxdb@lists.mysql.com Subject: RE: loadercli - can't logon > can you please send me the os and kernel version ? RHEL 2.6.9-34.ELsmp #1 SMP x86_64 x86_64 x86_64 GNU/Linux -----Original Message----- From: Jey Razack [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 20. April 2006 19:34 To: [EMAIL PROTECTED] Subject: loadercli - can't logon $ loadercli -v Version: 7.6.00.16 $ loadercli -d DB1 -u DBUSER1,***** Loader protocol: '/home/dba/.sdb/loader/log/loader.prt' Loader packages: '/home/dba/sdb/loader/packages' Error connecting user DBUSER1 to database DB1 on local host: -25005 User (DBUSER1) logon to database DB1 failed: -25024 Error switching current schema to DBUSER1; log: // M Loader 7.6.00 Build 016-123-109-428 // * // M Loader instance started at dw2.dw for database DB1 // * // M Starting protocol at 2006042000132857 // * // M START 20060420 00132857 // * SET // * // M START 20060420 00132857 // * USE USER "DBUSER1" * SCHEMA DBUSER1 SERVERDB "DB1" // * // E -25024: Error switching current schema to DBUSER1; // E -25005: User (DBUSER1) logon to database DB1 failed: -25024 Error switching current schema to DBUSER1; -I can able to login to loadercli using dba account. -I can able to login to SQL Studio using DBUSER1 account. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
