I'm trying to set-up a simple webdav service on my suse box, but am running into some problems. I wonder if anyone can shed some light on them. I have installed the latest binaries (7_5_0_5) and have created a data-source called webdavdb with the users dbm_user and dba_user. The database is online, and the dba_user can log into it via: http://dev4suse:9999/websql <http://dev4suse:9999/websql> (dev4suse is the name of the server). When I now browse over to: http://dev4suse:9999/webdav <http://dev4suse:9999/webdav> I get a server 500 error. http://dev4suse:999/webdav?gui <http://dev4suse:999/webdav?gui> shows the tabs but nothing else. Clicking on any tab other than the first one causes the wahttp service to crash. I enabled logging in the webdav service, and this is the output... PRODUCT : MaxDB C-PreComp Runtime VERSION : 7.5.0 BUILD : 005-121-054-885 DATASOURCE: SESSION : 2; SQLMODE : INTERN SERVERDB : webdavdb SERVERNODE: dev4suse CONNECT "dba_user " IDENTIFIED BY :A ISOLATION LEVEL 1 SQLCODE: -4008 Unknown user name/password combination SQLERRD(INDEX_5) : 1 SEC. FOR STATEMENT START : DATE : 2004-01-15 TIME : 0009:45:24 END : DATE : 2004-01-15 TIME : 0009:45:25 SQCFINISH
webdav32.log looks like this: [2004/01/15 09:42:07] WDVHandlerInit [2004/01/15 09:42:07] Use URL prefix /WebDAV [2004/01/15 09:45:18] GET: Could get no connection to database [2004/01/15 09:45:25] GET: Could get no connection to database [2004/01/15 09:47:00] GET: Could get no connection to database waconf32.log looks like this: [2004/01/15 09:36:10] Configuration: SessionPools: [WebDAV] SessionPoolType=ODBC Datasource= Driver=SAP DB Autocommit=SQL_ATTR_AUTOCOMMIT_OFF SqlTrace=/var/log/sapdb/wa/webdavsql.log ServerNode=dev4suse ServerDb=webdavdb User=dba_user Password=xxx SessionPoolSize=10 Services: [waecho] PathPrefix=waecho UserDll=/opt/sdb/programs/web/lib/waecho InitFunc=wd83Init ServiceFunc=wd83Service ExitFunc=wd83Exit LogFile=/var/log/sapdb/wa/waecho32.log UserDllType=C With SSL=FalseUse FastCGI prefix for cookie path SSL URL= Default Web Session Timeout=0 [websql] PathPrefix=websql UserDll=/opt/sdb/programs/web/lib/websql InitFunc=WebSQLInit ServiceFunc=WebSQLService ExitFunc=WebSQLExit LogFile=/var/log/sapdb/wa/websql32.log UserDllType=CPP With SSL=FalseDo not use FastCGI prefix for cookie path SSL URL=https://your-server/websql Default Web Session Timeout=3200 [webdbm] PathPrefix=webdbm UserDll=/opt/sdb/programs/web/lib/webdbm InitFunc=DBMWeb_Service_Init ServiceFunc=DBMWeb_Service_Service ExitFunc=DBMWeb_Service_Exit LogFile=/var/log/sapdb/wa/webdbm32.log UserDllType=CPP With SSL=FalseDo not use FastCGI prefix for cookie path SSL URL= Default Web Session Timeout=0 [webdav] PathPrefix=WebDAV SessionPool=WebDAV UserDll=/opt/sdb/programs/web/lib/libwdvhandler InitFunc=WDVHandlerInit ServiceFunc=WDVHandlerService ExitFunc=WDVHandlerExit LogFile=/var/log/sapdb/wa/webdav32.log UserDllType=C With SSL=FalseDo not use FastCGI prefix for cookie path SSL URL= Default Web Session Timeout=0 /usr/spool/sql/ini/WebAgent75.ini looks like this: [HTTP] Browsable=1 DefaultDocument=index.html DocumentRoot=/opt/sdb/programs/web/Documents enableWebDAV=1 LogDirectory=/var/log/sapdb/wa LogRequests=1 MaxThreads=10 MimeTypeFile=/opt/sdb/programs/web/config/mime.types Port=9999 [BIT32] [BIT32\COMServices] [BIT32\Global] LogFile=/var/log/sapdb/wa/wa32.log ConfLogFile=/var/log/sapdb/wa/waconf32.log logWithInfo=1 [BIT32\Resources] documentRoot=/opt/sdb/programs/web/Documents/WARoot MIMETypes=/opt/sdb/programs/web/config/mime.types [BIT32\GeneralSettings] developerMode=1 AdminUserName=admin AdminUserPassword=init [BIT32\Services] [BIT32\Services\waecho] ExitFunction=wd83Exit InitFunction=wd83Init Library=/opt/sdb/programs/web/lib/waecho.so LibraryType=C LogFile=/var/log/sapdb/wa/waecho32.log ServiceFunction=wd83Service ServiceName=waecho SessionPool= serviceStart=1 useFastCGIForCookiePath=1 withSSL=0 sslURL= webSessionTimeout=0 [BIT32\Services\websql] ExitFunction=WebSQLExit InitFunction=WebSQLInit Library=/opt/sdb/programs/web/lib/websql.so LibraryType=CPP LogFile=/var/log/sapdb/wa/websql32.log ServiceFunction=WebSQLService ServiceName=websql SessionPool= withSSL=0 sslURL=https://your-server/websql webSessionTimeout=3200 serviceStart=1 useFastCGIForCookiePath=0 connectionPoolTimeout=3200 [BIT32\Services\webdbm] ExitFunction=DBMWeb_Service_Exit InitFunction=DBMWeb_Service_Init Library=/opt/sdb/programs/web/lib/webdbm.so LibraryType=CPP LogFile=/var/log/sapdb/wa/webdbm32.log ServiceFunction=DBMWeb_Service_Service ServiceName=webdbm SessionPool= serviceStart=1 useFastCGIForCookiePath=0 withSSL=0 sslURL= webSessionTimeout=0 [BIT32\Services\webdav] ExitFunction=WDVHandlerExit InitFunction=WDVHandlerInit Library=/opt/sdb/programs/web/lib/libwdvhandler.so LibraryType=C LogFile=/var/log/sapdb/wa/webdav32.log ServiceFunction=WDVHandlerService ServiceName=WebDAV SessionPool=WebDAV serviceStart=1 useFastCGIForCookiePath=0 withSSL=0 sslURL= webSessionTimeout=0 IDXSearchLib=/opt/sdb/programs/web/lib/sapdbxis [BIT32\SessionPools] [BIT32\SessionPools\WebDAV] serverDB=webdavdb serverNode=dev4suse userId=dba_user password=letmein datasource= driver=SAP DB autocommit=Off poolType=ODBC poolSize=10 sqlTraceFilename=/var/log/sapdb/wa/webdavsql.log [BIT64] [BIT64\COMServices] [BIT64\Global] LogFile=/var/log/sapdb/wa/wa64.log ConfLogFile=/var/log/sapdb/wa/waconf64.log logWithInfo=0 [BIT64\Resources] documentRoot=/opt/sdb/programs/web/Documents/WARoot MIMETypes=/opt/sdb/programs/web/config/mime.types [BIT64\GeneralSettings] developerMode=1 AdminUserName=admin AdminUserPassword=init [BIT64\Services] [BIT64\Services\waecho] ExitFunction=wd83Exit InitFunction=wd83Init Library=/opt/sdb/programs/web/lib/lib64/waecho.so LibraryType=C LogFile=/var/log/sapdb/wa/waecho64.log ServiceFunction=wd83Service ServiceName=waecho SessionPool= serviceStart=1 useFastCGIForCookiePath=1 withSSL=0 sslURL= webSessionTimeout=0 [BIT64\Services\websql] ExitFunction=WebSQLExit InitFunction=WebSQLInit Library=/opt/sdb/programs/web/lib/lib64/websql.so LibraryType=CPP LogFile=/var/log/sapdb/wa/websql64.log ServiceFunction=WebSQLService ServiceName=websql SessionPool= withSSL=0 sslURL=https://your-server/websql webSessionTimeout=3200 serviceStart=1 useFastCGIForCookiePath=0 connectionPoolTimeout=3200 odbcDriver=SAP DB 7.3 [BIT64\Services\webdbm] ExitFunction=DBMWeb_Service_Exit InitFunction=DBMWeb_Service_Init Library=/opt/sdb/programs/web/lib/lib64/webdbm.so LibraryType=CPP LogFile=/var/log/sapdb/wa/webdbm64.log ServiceFunction=DBMWeb_Service_Service ServiceName=webdbm SessionPool= serviceStart=1 useFastCGIForCookiePath=0 withSSL=0 sslURL= webSessionTimeout=0 [BIT64\Services\webdav] ExitFunction=WDVHandlerExit InitFunction=WDVHandlerInit Library=/opt/sdb/programs/web/lib/lib64/libwdvhandler.so LibraryType=C LogFile=/var/log/sapdb/wa/webdav64.log ServiceFunction=WDVHandlerService ServiceName=webdav SessionPool= serviceStart=1 useFastCGIForCookiePath=0 withSSL=0 sslURL= webSessionTimeout=0 IDXSearchLib=/opt/sdb/programs/web/lib/lib64/sapdbxis [BIT64\SessionPools] [BIT64\SessionPools\WebDAV] serverDB=YourServerDB serverNode=YourServerNode userId=Your SYSDBA password=Your SYSDBA Password datasource= driver=SAP DB autocommit=Off poolType=ODBC poolSize=10 sqlTraceFilename= I've run out of things to try, so any ideas would be great. Ian
