Daniel, Well, we've made some significant progress here (and again, thank you for sticking with me while I fool with this). I created a whole new database and ran the script suggested on that page; my output was *almost* perfect:
>param_startsession OK --- >param_init OK --- >param_put MAXUSERTASKS 5 OK --- >param_put MAXSERVERTASKS 15 OK --- >param_put CACHE_SIZE 3000 OK --- >param_put MAXDATAVOLUMES 5 OK --- >param_checkall OK --- >param_commitsession OK --- >param_addvolume 1 LOG LOG_001 F 2000 OK --- >param_addvolume 1 DATA DAT_001 F 10000 OK --- >db_admin OK --- >db_activate DBA,DBA OK --- >load_systab ERR -24988,ERR_SQL: sql error When I tried to connect to that database, just to see if it worked, my webdav32.log gave me this message: [2005/04/28 05:47:10] GET: Internal server error: [MySQL MaxDB][LIBSQLOD SO][MaxDB] Base table not found;-4004 POS(95) Unknown table name:WEBDAV_PROPERTY[WDVCAPI_Resource.c: 625] Obviously, it can now authenticate, but we've got to figure out what this load_systab error is, because it's probably quite related to the Internal Server Error above. I'll be looking through the archives, but if you know it off the top of your head, I'd appreciate hearing the solution the easy way. :-) Alex Kirk > Hi Alex, > > Here you are! The problem is the creation of your database. > Unfortunately db_create is by not all you have to do to get a working db > instance. Please have a look in here: > http://dev.mysql.com/doc/maxdb/en/c3/c82a6ba99d11d4aa90006094b92fad/fram > eset.htm > There you will find an example for creating a db instance by using the > command line tool dbmcli. The user provided with the db_create command > is the DBM user. Please notice the db_activate command. The user > provided there will be the SYSDBA of your db. Please use that one for > the WebDAV session pool. > > Cheers, > Daniel > > -----Original Message----- > From: Alex Kirk [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 27. April 2005 18:12 > To: Kirmse, Daniel > Subject: RE: WebDAV Not Using Provided Password? > > Daniel, > > I just created a fresh database with dmbcli, called TESTDB, with a user > of TESTU > and a password of TESTP: > > ./dbmcli>db_create TESTDB TESTU,TESTP <system user>,<system pass> > OK > > I was able to log into it no problem with dbmcli. However, when I used > those > settings for WebDAV, the same old ugly "Could get no connection to > database" > problem reared its head: > > <html><head><meta http-equiv="Content-Type" content="text/html; > charset=utf-8"></head><body ><PRE><PLAINTEXT> > PRODUCT : MaxDB C-PreComp Runtime > VERSION : 7.5.0 > BUILD : 016-121-077-688 > > DATASOURCE: > SESSION : 0; > SQLMODE : INTERN > SERVERDB : TESTDB > SERVERNODE: localhost > CONNECT "TESTU " IDENTIFIED BY :A ISOLATION LEVEL 1 > SQLCODE: -709 CONNECT: (database not running: no request pipe) > START : DATE : 2005-04-27 TIME : 0007:42:06 > END : DATE : 2005-04-27 TIME : 0007:42:06 > > SQCFINISH > > It's almost as is the WebDAV installation is broken, and I need to > reinstall. > What do you think? > > Alex Kirk > > > Hi Alex, > > > > How did you create your database? Webdbm? You could try DBA/DBA or > > SYSDBA/secret as these are commonly known defaults for the SYSDBA > user. > > Usually this is one step in the create database wizard. > > > > Cheers, > > Daniel > > > > -----Original Message----- > > From: Alex Kirk [mailto:[EMAIL PROTECTED] > > Sent: Mittwoch, 27. April 2005 17:36 > > To: Kirmse, Daniel > > Cc: [email protected] > > Subject: RE: WebDAV Not Using Provided Password? > > > > > One more detail: The Password is Opensnort containing an uppercase O > > and > > > some lowercase characters. Is this significant? If yes you would > have > > to > > > enclose the password with double quotes. You could check this with > > > websql for websql and webdav session pool use the same mechanism. > What > > > is working with websql must work with webdav as well. > > > > It's just a standard password I use for things I don't need to worry > > about > > security-wise. I tried enclosing it in double quotes within the admin > > interface, > > and when I return to the page to make sure the change took, the > password > > has > > vanished. So that's not an option. > > > > Interestingly enough, when I chose WebDAV as the session pool for > websql > > (with > > an Update followed by a Reload Service, which I confirmed in > > websql32.log) and > > then tried to log into websql, it took me to a login page; when I > > entered my > > database login info there, I got a nice "Page Cannot Be Displayed" > > error. > > > > > But by the way: Come to think of it. After installation the WebDAV > > > tables are only accessible for the SYSDBA user, so you should use > this > > > user in your session pool anyway. So I suggest we try login on with > > that > > > one to ensure that WebDAV is in working order (in principle). > > > > Certainly a solid idea. The only issue there is that I have no > > recollection of > > ever setting the SYSDBA password, and I don't know the default > > (SYSDBA?). That, and: > > > > <html><head><meta http-equiv="Content-Type" content="text/html; > > charset=utf-8"></head><body ><PRE><PLAINTEXT> > > PRODUCT : MaxDB C-PreComp Runtime > > VERSION : 7.5.0 > > BUILD : 016-121-077-688 > > > > DATASOURCE: OWNME > > SESSION : 1; > > SQLMODE : INTERN > > SERVERDB : OWNME > > SERVERNODE: localhost > > CONNECT "SYSDBA " IDENTIFIED BY :A ISOLATION LEVEL 1 > > SQLCODE: -4008 Unknown user name/password combination > > SQLERRD(INDEX_5) : 1 SEC. FOR STATEMENT > > START : DATE : 2005-04-27 TIME : 0007:04:49 > > END : DATE : 2005-04-27 TIME : 0007:04:50 > > > > SQCFINISH > > > > Does that lead you anywhere? > > > > Alex Kirk > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
