Hi, we installed 4.0.6 a few weeks back & got the same issues I posted all these and others changes that need to be made on the far-dev group, Sorry to hear you had to figure this out when it was in the google group. Did you search for Oracle issues before installing?
FC 4 is still not compatible w/oracle & there are many issues that arise while installing. Ian Redding NTP Website System Administrator (http://ntp.niehs.nih.gov) Contractor - INDUS Corp (www.induscorp.com) E-mail: [EMAIL PROTECTED] 919-541-0642 -----Original Message----- From: Bill Bagent [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 04, 2007 3:13 PM To: [email protected] Subject: [farcry-dev] FarCry 4.0.3 and Oracle; anyone successfully installed? I am attempting to install FarCry 4.0.3 on Solaris/Oracle 10g environment. Initially the installer indicated an "Invalid DNS". The DNS validated on CF (7.0.2) but I found a query Oracle doesn't like in the checkDSN method of FlightCheck.cfc (around line 66). I believe Oracle requires the "from" clause so I changed SELECT 'patrick' AS theMAN to SELECT 'patrick' AS theMAN from dual. This got me past the Invalid DSN error and the installation began. I then got "[Macromedia][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges" when executing the following query: CREATE TABLE farcry.FQAUDIT( AUDITID VARCHAR2(50) NOT NULL , OBJECTID VARCHAR2(50) NULL, DATETIMESTAMP DATE NOT NULL, USERNAME VARCHAR2(255) NOT NULL , LOCATION VARCHAR2(255) NULL , AUDITTYPE VARCHAR2(50) NOT NULL , NOTE VARCHAR2(255) NULL , CONSTRAINT PK_FQAUDIT PRIMARY KEY (AUDITID) ) My farcry user has sufficient privileges because I can cut and paste this query into a sql editor and it successfully creates the table in the farcry schema while logged in as the farcry user. I even gave the farcry user DBA privileges to see if that helped but got the same error when running the installer. Thanks in advance... Here's the installer page with the error: http://www.nabble.com/file/p12484690/indexcfm.htm indexcfm.htm -- View this message in context: http://www.nabble.com/FarCry-4.0.3-and-Oracle--anyone-successfully-insta lled--tf4379737s621.html#a12484690 Sent from the FarCry - Dev mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
