Dear Thomas, thanks again for your time. In the meantime I've tried a couple of things.
Following the advice I received from another helpful user on this list (see thread "RPM or .tgz?") on my SuSE 9.1 I did: erase all RPMs for MaxDB: rpm -e max... delete any files left from that installation, eg under /opt/sdb and /usr/spool/sql. delete all of the ODBC configuration for MaxDB, ie delete files /etc/unixODBC/odbcinst.ini, /etc/unixODBC/odbc.ini and /home/alex/.odbc.ini. SuSEconfig Install all MaxDB RPMs: rpm -ivh maxdb... Start the webserver: /etc/init.d/maxdbweb start #orion8: /etc/init.d/maxdbweb start Starting MaxDB WebServer on port :orion8:/etc/unixODBC # 12821 TASKING Thread 23967 starting So it seems the webserver is running. Open a web browser, call URL: http://localhost:9999/webdbm or http://localhost:9999/websql. This gives an error message: "The connection was refused when attempting to contact localhost:9999." Note that I didn't configure ODBC or start the DB server so far. Following Dirk's advice given as a reply to thread "RPM or .tgz?" it seems not to be necessary, I thought. In fact, the official documentation also says that there is an alternative way to ODBC to connect to MaxDB on Unix/Linux, which would well explain that ODBC isn't necessary for the initial steps of installation and configuration. But as it didn't work, I created a new ODBC configuration. Here it is: /etc/unixODBC/odbcinst.ini: [MaxDB] Description = Driver = /opt/sdb/interfaces/odbc/lib/libsqlod.so Setup = /usr/lib/unixODBC/libsapdbS.so FileUsage = 1 CPTimeout = CPReuse = /etc/unixODBC/odbc.ini: [maxdbtest] Description = MaxDB Driver = MaxDB ServerNode = localhost ServerDB = With or without a ServerDB entry I get the following error message when I try to connect to MaxDB with DataManager with username test and password test (for the TST database). The same happens when I specify TST as ServerDB name. "[unixODBC][MySQL MaxDB][LIBSQLOD SO]DataSource name not found and no default driver specified." I also tried again to get a web server connection after setting up ODBC (but wasn't very optimistic after not getting a connection with DataManager...). I enclose the /var/log/sdb/httperr.log at the end of the posting. As far as I can see it's exaclty the same it is without ODBC set up. Most probably I am overlooking something very obvious. I'd really be grateful for any hint helping me to see what it is... Thanks for your patience! Alex > Hi Alex, > > > [unixODBC][MySQL MaxDB][LIBSQLOD SO][MaxDB] Unable to connect to data > > source;-709 CONNECT: (unknown host localhost (see /etc/hosts)) > > > > Did you try to let serverdb empty? > Did you write the serverdb exactly as you wrote it during install? > > > Greetings Thomas > > > ---------------------------------------------- > Dr. Thomas K�tter > SAP AG, SAP Labs Berlin > > > Do you know SAP^H^H^H MaxDB ? www.sapdb.org > > > > /var/log/sdb/httperr.log after setting up ODBC for unixODBC: [10/Jun/2004:14:38:40]: Starting ErrLog (build 121-073-298)[WAHTTP_Log.c: 208] [10/Jun/2004:14:38:40]: Listening on IP on port 9999[WAHTTP_Server.c: 1286] [10/Jun/2004:14:38:40]: DocumentRoot is: /opt/sdb/web/Documents[WAHTTP_FileAgent.c: 145] [10/Jun/2004:14:38:40]: Init: Initialized[WAHTTP_Server.c: 1306] [10/Jun/2004:14:38:40]: EXECPTION OCCURED:[WAHTTP_Log.c: 536] ----> Emergency Stack Back Trace <---- (0):0x404735b9 [0xbfffdab8](0x1,0xe,0xbfffdb38,0x402ab14f) (1):0x4035e4c6 [0xbfffdab8](0x1,0xe,0xbfffdb38,0x402ab14f) (3):0x402ab14f [0xbfffdac8](0xbfffdb14,0x40d2a000,0xbfffdb38,0x402ab141) (5):0x402ab350 [0xbfffdb38](0x40000,0x0,0x8052788,0x0) (7):0x8054278 [0xbfffdb78](0x40000,0x8052788,0x0,0x1) (9):0x8052d5e [0xbfffdbe8](0xa,0x8052788,0xbfffdd68,0x8052d1d) (11):0x8054132 [0xbfffdd68](0xbfffec14,0x67fc,0x270f,0x80540fe) (13):0x8054dbb [0xbfffdd98](0xbfffec14,0x0,0xbfffddd4,0xbfffea14) (15):0x40426500 [0xbffff018](0x1,0xbffff0a4,0xbffff0ac,0x40410490) ----> Register Dump <---- ------------------------------- ds es 0x0000007b 0x0000007b fs gs 0x00000000 0x00000033 trap err 0x0000000d 0x00000000 efl ss 0x00210202 0x0000007b edi esi 0x00000001 0x00000001 eax ebx 0xfffffff9 ecx edx 0x40f2abf0 esp uesp 0xbfffdaa4 0xbfffdaa4 ebp eip 0xbfffdab8 0x404735b9 cs cr2 0x00000073 0x00000000 ------------------------------- Floating point register unused ------------------------------- ----> Module List <---- |.text Start |.text End | Module File Name | 0x08048000 | 0x08058000 | /opt/sdb/web/pgm/wahttp | 0x40000000 | 0x40016000 | /lib/ld-2.3.3.so | 0x40018000 | 0x40058000 | /opt/sdb/web/lib/libwapi.so | 0x40063000 | 0x4010a000 | /opt/sdb/web/lib/libsqlrte.so | 0x4015d000 | 0x402ce000 | /opt/sdb/interfaces/odbc/lib/libsqlod.so | 0x4033d000 | 0x40345000 | /opt/sdb/web/lib/waecho.so | 0x40355000 | 0x40357000 | /lib/libdl.so.2 | 0x40358000 | 0x40365000 | /lib/tls/libpthread.so.0 | 0x40368000 | 0x4036f000 | /lib/tls/librtkaio.so.1 | 0x40370000 | 0x40378000 | /lib/libcrypt.so.1 | 0x403a1000 | 0x403db000 | /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so | 0x403ee000 | 0x4040f000 | /lib/tls/libm.so.6 | 0x40411000 | 0x4051b000 | /lib/tls/libc.so.6 | 0x40527000 | 0x40665000 | /opt/sdb/web/lib/websql.so | 0x406a0000 | 0x40744000 | /opt/sdb/web/lib/libsqlrte-nouniqueid.so | 0x40796000 | 0x407aa000 | /opt/sdb/web/lib/libdbfsapi.so | 0x407ae000 | 0x407bd000 | /opt/sdb/interfaces/odbc/lib/libodcompr.so | 0x407c1000 | 0x40a9a000 | /opt/sdb/web/lib/webdbm.so | 0x40b02000 | 0x40c26000 | /opt/sdb/web/lib/libwdvhandler.so | 0x40c4e000 | 0x40cda000 | /opt/sdb/web/lib/libwdvcapi.so | 0x40f43000 | 0x40f4a000 | /lib/libgcc_s.so.1 ----> Symbolic Stack Back Trace <---- 0: 0x404735b9 __cfree +0x0049 /lib/tls/libc.so.6 Frameinfo [0xbfffdab8] (0x1,0xe,0xbfffdb38,0x402ab14f) 1: 0x4035e4c6 __pthread_attr_destroy +0x0026 /lib/tls/libpthread.so.0 Frameinfo [0xbfffdab8] (0x1,0xe,0xbfffdb38,0x402ab14f) 2: 0x402ab14f eo07_CreateThread +0x024f /opt/sdb/interfaces/odbc/lib/libsqlod.so Frameinfo [0xbfffdac8] (0xbfffdb14,0x40d2a000,0xbfffdb38,0x402ab141) 3: 0x402ab350 sqlbeginthread +0x002c /opt/sdb/interfaces/odbc/lib/libsqlod.so Frameinfo [0xbfffdb38] (0x40000,0x0,0x8052788,0x0) 4: 0x08054278 MakeWorkers +0x0108 /opt/sdb/web/pgm/wahttp Frameinfo [0xbfffdb78] (0x40000,0x8052788,0x0,0x1) 5: 0x08052d5e StartWebServer +0x0066 /opt/sdb/web/pgm/wahttp Frameinfo [0xbfffdbe8] (0xa,0x8052788,0xbfffdd68,0x8052d1d) 6: 0x08054132 Start +0x006a /opt/sdb/web/pgm/wahttp Frameinfo [0xbfffdd68] (0xbfffec14,0x67fc,0x270f,0x80540fe) 7: 0x08054dbb main +0x01db /opt/sdb/web/pgm/wahttp Frameinfo [0xbfffdd98] (0xbfffec14,0x0,0xbfffddd4,0xbfffea14) ----> End of Stack Back Trace <---- -- +++ Jetzt WLAN-Router f�r alle DSL-Einsteiger und Wechsler +++ GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl -- +++ Jetzt WLAN-Router f�r alle DSL-Einsteiger und Wechsler +++ GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
