Ask your questions here

[Oscar Arevalo]

This group is to support BugLogHQ users. Use it to ask questions, send
suggestions, make comments or just to say whatever you want.

Oscar

[Robc]

SQL Error after initial install:  [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '`'.  I get this error when accessing the GUI as well as from my app application.cfc.   Same problem with buglog-1.7.1 and 1.6.4.  I'm using SQL Server 2008 r2 with install script mssql-2005.sql

Exceptions

15:54:48.048 - Database Exception - in C:/Users/Rob/Dropbox/DEV/SCDOE/apps/bugLog/components/lib/dao/dbDataProvider.cfc : line 35

	    Error Executing Database Query.
	    

Thanks

[Oscar Arevalo]

Hi Rob,

Usually this happens when using an MSSQL database and the "db.dbtype" setting in buglog-config.xml.cfm has not been updated to "mssql" (the default is mysql).

If you are still having the problem, please check the config file and see what is the dbtype. If it's other than mssql, then change it and reload the app.

Thanks,

Oscar

--
Oscar Arevalo

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

[Asher Densmore-Lynn]

Oscar,

Is BugLogHQ cluster-safe? I know that it's got scheduled tasks; if I have three BLHQ instances behind a load-balancer, are alerts going to be sent three times?

Thanks!

[Oscar Arevalo]

Short answer: not necessarily. 

This is how it works: If you have 3 instances of BugLog, each one will maintain its own in-memory queue of received messages. Rules are evaluated when the queue is processed on each instance and it is given a representation of the current message being processed. So the message is unique to only one instance of your cluster. However if the rule maintains any sort of internal state (example: timestamp of the last time an email was sent on the firstMessageAlert rule), then that state is going to be unique to that server.

What this means is that for rules that are based solely on the properties of the message being processed, they will ONLY be fired once, and only on the server that received the message. But for rules that maintain state across rule invocations they might be fired once for each instance on the cluster.

Having said that, the cluster-safe rules are:

- discard

- mailAlert

- mailRelay

You can still use firstMessageAlert, frequencyAlert and heartbeatMonitor but you might get duplicate alerts.

 

Making BugLogHQ cluster-friendly is one of the goals for the next major release.

Thanks,

Oscar

since each buglog server will have its own set of rule instances, any 

--
 
---
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.
 
 

[Adam Bennett]

After install, I can get the login page. After logging in I get the following error:

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character

The error occurred in C:\cfprojects\bugLog\components\lib\dao\dbDataProvider.cfc: line 40

.

.

.

38 : <cfquery name="qry" datasource="#DSN#" username="#username#" password="#password#"> 39 : SELECT * 40 : FROM #getSafeTableName(tableName)# 41 : </cfquery> 42 :

VENDORERRORCODE   911 SQLSTATE   42000 SQL    SELECT * FROM `bl_Extension` DATASOURCE   XXXXX

I've tried swapping from mysql to mssql, but get the same error.

Thanks!

Adam

[Oscar Arevalo]

Hi Adam, looks like you are using Oracle. Set the value of "db.dbtype" to "oracle" on bugLog/config/buglog-config.xml.cfm

https://github.com/oarevalo/BugLogHQ/blob/master/config/buglog-config.xml.cfm#L15

Oscar

--

 
---
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.
 
 

[Gavin Pickin]

I have a question about the discard rule.

Is there a wildcard option or anything like.

Ever disregard rule i have made does not seem to work. 

I entered this in the error message, which i copied from the Exception Message field

key [pages] doesn't exist (existing keys:DEMO,MAIN,ANYDAY,REGISTER,STUDENT)

I even left everything else blank, and they still keep showing up in the logs.

Do we have to escape anything?

The frequency rules etc, seem to work, but i'm having issues with this.

Any insight?

Thanks in advance, I really like the product.

[Oscar Arevalo]

Hi Gavin,

I'm not aware of any current issues on the discard rule. You shouldn't need to escape anything afaik. What version of BugLog are you using?

Also, the text that you are looking for is in which field of the bug report?

Thanks,

Oscar

--

 
---
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.

[Gavin Pickin]

Hi Oscar, I finally got back to this.

The most prominent error we see is related to this User Agent.

Mozilla/4.0 (compatible; Synapse)

If I added it to the Text Field, just the name "Synapse" without any special characters should it work?

Do I have to restart it, does it only process new items coming into the queue?

I made a few before, but continued to see the errors come in, unless the queue is a little slow and I saw items that were in the queue prior to making the rule.

Also, if I choose to Block something like 

Element '' is undefined in a Java object of type class coldfusion.runtime.CookieScope.

Should I only select a piece of it, or should it be the whole field.

What about the element followed by quotation marks, I wasn't sure about needing to escape them etc.

Sorry if I missed something obvious.

I'm attaching screenshots so you can see what  I have.

The Cookie one has been there for a couple of months, and racked up 3000+ plus errors, several today.

So I must be doing something wrong.

Thanks.

Much appreciated.

[Gavin Pickin]

Anyone have any insight? Do I need to restart the service? 

[Ross McMahon]

How do you go about changing the Session timeout for bugloghq? I'm finding myself logged out due to timeouts more times than I'd like.

Thanks!

[Oscar Arevalo]

Hi Ross,

BugLogHQ does not have any defined session timeout settings, so it just inherits whatever are your global defaults for your ColdFusion server. However if you want to override the sessionTiimeOut setting just for the BugLogHQ application, you can add the folllowing line to the Application.cfc located in /bugLog/hq/Application.cfc

this.sessionTimeout = createTimeSpan( 0, 0, 15, 0 ) 

(this example sets it to 15 minutes, but you can do use whatever you would like your timeout to be)

Thanks,

Oscar

[Ross McMahon]

Ah I see, wasn't sure if I could get away with extending the length in the app cfc, that's just what I needed.

Thanks for the response!

[PJH]

Oscar

Can BugLog be run from a subfolder?  mydomain.com/apps/code/hq/index.cfm.  When I try this all the image links are broken.

[Oscar Arevalo]

Hi Peter,

BugLog is pretty flexible on where you can run it, althought i've never tried on a subfolder 3 levels deep. Have you tried setting the "general.externalURL" setting on the config? Use this setting to indicate to BugLog how it can "find" itself. 

You can set it to be:

"/apps/code" or "http://mydomain.com/apps/code"

Thanks,

Oscar

 

On Wed, May 28, 2014 at 4:54 PM, PJH <peter.j...@gmail.com> wrote:

Oscar

Can BugLog be run from a subfolder?  mydomain.com/apps/code/hq/index.cfm.  When I try this all the image links are broken.

--

---
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/d/optout.

[Praveen V]

how can i get the history of buglog hq?