Installing Farcry V2 beta, I had to add to manually add CF mapping /farcry to to the root directory of the farcry installation thanks to advice from Geoff Bowers, otherwise it would not install at all.
Next: When installing the file apps.cfm is created at the top level If you install with http://localhost/farcary/install then apps.cfm looks like this (running windows Apache 2.0.47) <cfscript> stApps = structNew(); stApps['127.0.0.1'] = 'farcry'; // name of physical directory for your FarCry Application </cfscript> when in fact it will have to be like this as the name of 'aadc-maps.aad.gov.au' should be inserted by cgi.server_name <cfscript> stApps = structNew(); stApps['aadc-maps.aad.gov.au'] = 'farcry'; // name of physical directory for your FarCry Application </cfscript> if you make the change then you can then sucessfully call the login page Next: then enter username/password and get the following error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00907: missing right parenthesis 15:45:50.050 - Database Exception - in D:\Data\FarCry\farcry_core\admin\includes\cfFunctionWrappers.cfm : line 34 Error Executing Database Query. I cant trace it but the SQL went this far qUser (Datasource=farcry_db, Time=0ms, Records=1) in D:\Data\FarCry\farcry_core\packages\security\authentication.cfc @ 15:45:50.050 SELECT * FROM dmUser WHERE upper(UserLogin) = ? ORDER BY UserLogin ASC Query Parameter Value(s) - Parameter #1(CF_SQL_VARCHAR) = FARCRY q (Datasource=farcry_db, Time=0ms, Records=1) in D:\Data\FarCry\farcry_core\admin\includes\cfFunctionWrappers.cfm @ 15:45:50.050 SELECT * FROM dmGroup g , dmUserToGroup ug, dmUser u WHERE g.groupId = ug.groupid AND upper(u.userLogin) = 'FARCRY' AND u.userId = ug.userId ORDER BY g.groupName q (Datasource=farcry_db, Time=15ms, Records=1) in D:\Data\FarCry\farcry_core\admin\includes\cfFunctionWrappers.cfm @ 15:45:50.050 SELECT * FROM farcry.dmExternalGroupToPolicyGroup WHERE upper(ExternalGroupUserDirectory)='CLIENTUD' AND upper(ExternalGroupName)='SYSADMIN' insertLog (Datasource=farcry_db, Time=31ms, Records=0) in D:\Data\FarCry\farcry_core\packages\farcry\audit.cfc @ 15:45:50.050 INSERT INTO FARCRY.fqAudit (AuditID, objectID, datetimeStamp, username, location, auditType, note) VALUES ('FB54A323-802A-3625-FEDB324FBA84E0B5', '', {ts '2003-10-02 15:45:50'}, 'farcry', '147.66.8.157', 'dmSec.login', 'userDirectory: CLIENTUD') qProfile (Datasource=farcry_db, Time=0ms, Records=1) in D:\Data\FarCry\farcry_core\packages\types\_dmProfile\getProfile.cfm @ 15:45:50.050 SELECT objectID FROM farcry.dmProfile WHERE userName = 'farcry' qgetData (Datasource=farcry_db, Time=15ms, Records=1) in D:\Data\FarCry\fourq\_fourq\getData.cfm @ 15:45:50.050 select * from FARCRY.dmProfile where objectID = 'FB3ABC1E-802A-3625-FA871995C77E3FB2' I must be getting close Dave ------------------------------------------------------------------------ ----------------- Dr Dave Watts ph +61 3 62 323 586 Applications/DB Developer fax +61 3 62 323 351 Australian Antarctic Data Centre email [EMAIL PROTECTED] http://www.aad.gov.au/default.asp?casid=3786 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
