Viewing posts by scoopseven

Installing MySQL JDBC driver for ColdFusion MX 6.1

Posted by: scoopseven in ColdFusion MySQL 17 years, 6 months ago

download latest version of mySQL JDBC driver from MySQL website (mysql-connector-java-3.2.0-alpha-bin.jar) currently running on FADWEB

read more / 0 comments

MySQL: Windows v Linux

Posted by: scoopseven in MySQL 18 years ago

I beat my head against my desk once already, and I'm sure it'll happen at least once more finding out about the differences between MySQL running on a Windows 2003 Enterprise server and a Mindrake Linux 1o.o server. In one of my applications I'm setting a default variable, thisMonth, to a null string. The target column is defined as an integer. When I do the insert into my table i use single quotes around my variable, even though it's an int. Although this may not be a best practice it works fine when my variable isn't defined and I want to insert a null value into thisMonth... on the linux server anyway.

read more / 0 comments

Sorbs Sucks

Posted by: scoopseven in MediaPost 18 years ago

My own personal experience with Sorbs is that they suck. They incorrectly listed us as part of a dynamic IP range likely to generate spam. WRONG! Apparently they're using a database of IPs that hasn't been maintained since 2003. Why bother? My advice to anyone looking to curb spam is to use a RBL, but whatever you do don't use Sorbs. Taken from: http://cpbotha.net/weblogs/cpbotha/archives/002023.html

 
• Why SORBS Sucks
• SORBS Sucks
• Why I agree that SORBS sucks!
• Google results for "sorbs sucks"
 

read more / 0 comments

MySQL Madness

Posted by: scoopseven in MySQL 18 years, 1 month ago

Spent a good deal of time today learning about MySQL's limits when it comes to non-indexed tables. I had 4 column table which included a date, IP address and 2 integers. The CFMX server started going bananas, taking a long time to finish requests. I lowered the timeout, so long running requests would die and I increased the number of simultaneous requests in the ColdFusion administrator from 8 to 100! the server would eventually use all 100 connections and then start queuing requests, then die. Finally I decided to check out our MySQL database server, which is never the problem, and found tons of locked queries trying to select/insert/update into my 4 column table.

read more / 0 comments

Fusebox 4.1 and Application.cfm

Posted by: scoopseven in ColdFusion 18 years, 1 month ago

In Fusebox4.1 it's impossible to achive the ideal directory structure for MediaPost.com. I'd like to have n different sites, two for now, mediapost.com and publications.mediapost.com, each having a different fusebox.xml.cfm so that they have their own circuits (which may point to the same physical folder) share a Application.cfm file, so a user session can span the two sites. Because the Fusebox4.1 core (fusebox.xml.cfm) depends on the name attribute in the cfapplication tag this doesn't work. It's supposed to be fixed in Fusebox5.0, according to Hal Helms.

read more / 0 comments