Oracle?

[Jim Priest]

I need to look at setting up some kind of centralized error handler and am looking at Hoth and BugLogHQ.

Before I reinvent the wheel - is anyone working on an Oracle script for BugLogHQ?

Thanks!
Jim

[Oscar Arevalo]

I don't have access to an Oracle DB Server, but if you or someone else create the sql script let me know so we can add it to the BugLog package.

Oscar

--
Oscar Arevalo

http://about.me/oarevalo
http://www.coldbricks.com - Content Management System
http://www.oscararevalo.com - My Blog

[Jim Priest]

Any tips on what I need to change within the application?

I used Oracle SQL Developer to migrate the tables from MySQL to
Oracle... but when I crank up the app it's complaining about

D:/public/data/common/frameworks/BugLogHQ/components/lib/dao/dbDataProvider.cfc:
line 35

I'm guessing there are some settings throughout the app that tweak
things depending on the database.

Jim

[Jim Priest]

Well - I converted the MySQL script to Oracle with Oracle's SQL Developer.

The app files up and I get the login screen but when I login it
complains about not finding a file:

Could not find the included template /bugLog/hq/views/vwUpdatePassword.cfm.

Looking in that directory 'updatePassword.cfm' exists but not
'vwupdatepassword.cfm'.

If I rename that file the app continues to the change password form.

Changing the password fails trying to write to the database. Need to
dig into the code and see what else I need to change for Oracle.

Jim

[Oscar Arevalo]

Hey Jim,

When the password on the users table is in clear text (from older buglog versions) or is not hashed, then it forces you to change your password. "vwUpdatePassword.cfm" was the old name for that particular view. The file naming convention was changed in Buglog v1.6, so it looks like I missed to update the reference. Changing /hq/handlers/general.cfc line 352 to be:

<cfset setView("updatePassword")>

Should fix that particular error. (or you can also wait until I update the source in github and pull the latest version).

Now, the database part.

- Buglog uses a library called "DAOFactory" to abstract all interaction with the database. This is contained largely in the /components/lib/dao package. So most of the work to add a new DB should be done there. In particular in dbDataProvider.

- Also you need to set the "db.dbtype" setting in the config to "oracle" (or something like that). Anything that needs to do something db specific will look at that setting.

- There are a few other places where there are some SQL statements that might need to be updated too.

You can also take a look at this pull request, which was provided to add PosgreSQL support to BugLog. I imagine Oracle will need more changes, but will be at least a starting point:

https://github.com/oarevalo/BugLogHQ/pull/9

Let me know if you need any more help.

Oscar

[Jim Priest]

Thanks Oscar! 

I guess the first step is for me to fork this code in Github and then I can hack on it locally and if I get things working you can push/pull (whatever the proper git term is) :)

Jim

[Oscar Arevalo]

Yes, once you fork the code you can commit as much as you want, and when u have something working just send me the pull request and I'll merge your changes into the main code base.

Oscar

[Oscar Arevalo]

Hey Jim, just an FYI, the latest BugLogHQ release has official support for Oracle.

Oscar

[Jim Priest]

Yep - Brian and I were discussing already!  I wish I had time to tinker with it more - reading Brians blog post it sounds like it was fairly easy to implement due to your great code base! :)

Will definitely be setting it up here in the office soon and will let you and Brian know if we run into any issues.

Jim

--
 
---
You received this message because you are subscribed to the Google Groups "BugLogHQ" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bugloghq+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.