Edventures in Normalcy

I have recently run into an issue where I run one script that generated another (T-SQL), and for some reason, some of the output is cut off or truncated in SSMS.  I want to prevent this.  This truncation is caused by the settings below being too low for your case.  Altering these setting will significantly decrease the chance of truncation when creating T-SQL scripts in a loop.  Initially I was changing this in one place, and still had the truncation effect me.  Silly me, there are TWO place where you have to change the limit in order to make it function in all scenarios.

This one I do catch, Tools > Options. Expand the path of Query Results > SQL Server > Results to Text and change the Maximum number of characters displayed in each column to the fields maximum of 8192.

The second setting is the one I tend to fail to remember.  This is not just because the Query menu does not show in SSMS if a query window is not open or if you have clicked off the query window to the Object Explorer pane, for example. Open a new query window and ensure it has the focus, then go to Query > Query Options. Here you can see the setting is located in Results > Text.  Change the Maximum number of characters displayed in each column the fields maximum of 8192.

I recently went to find if two of my friends have the same friends, other than me. To get to the compare page for you and a friend, go to your friend’s wall. Click the down arrow on the Messages button and choose “see friendship”. Supposedly, once the page has loaded if you look in the same area on the right you will see another box which will allow you to compare other friendships.

You could also just replace the ‘[username1]’ and ‘[username2]’ fields below and browse to it.

https://www.facebook.com/[username1]?and=[username2]

So, I have a default (mostly) install of FileZilla Server:

I can connect just fine using FileZilla Client, but not Cyberduck (originally on a Mac, but I replicated the issue on Windows).

I kept getting this error:

Very useful, obviously, the log on the server only shows this:

(000098)1/7/2013 15:49:37 PM – (not logged in) (127.0.0.1)> Connected, sending welcome message…
(000098)1/7/2013 15:49:37 PM – (not logged in) (127.0.0.1)> disconnected.

My setup was straight forward, for FileZilla:

Host: [remove here in this post]

Port: 990

Protocol: FTP

Encryption: Require implicit FTP over TLS

Username: [remove here in this post]

Password: [remove here in this post]

This works, no problem, none.  I then imported this site into Cyberduck, and can no longer connect.  After messing with settings, I come to find out that for this to work, I had to set the port to 21.  That’s it as far as I can tell.  Below is a screen shot of the settings screen that worked (outside of obviously changed details).  Weird, this is more of a note in case I run into this again.

Is located here: C:\Windows\Media\Windows Notify.wav

Ok, I happened upon this recently, and it sort of blew my mind.  Section 4.2 of RFC 3986 provides for fully qualified URLs that omit protocol (the HTTP or HTTPS) altogether. When a URL’s protocol is omitted, the browser defaults to the underlying document’s protocol.  “Put simply, these “protocol-less” URLs allow a reference like this to work in every browser you’ll try it in:

//ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js

I have personally wondered of something like this for a long time.  “How do I include links to content I want to load without the secure/insecure message (assuming all content is available securely)?” I would ponder.  “the “protocol-less” URL is the best way to reference third party content that’s available via both HTTP and HTTPS.  On a page loaded through regular, unencrypted HTTP, script references using that URL will be loaded via HTTP and be cached as normal. Likewise, on a secure page that was loaded via HTTPS, script references targeting that protocol-less URL will automatically load the script from Google’s CDN via HTTPS and avoid the mixed content warning.  Thus, using the protocol-less URL allows a single script reference to adapt itself to what’s most optimal: HTTP and it’s full caching support on HTTP pages, and HTTPS on secured pages so that your users aren’t confronted with a mixed content warning.”  Originally found here: http://encosia.com/cripple-the-google-cdns-caching-with-a-single-character/.

It still amazes me that this is not well known to the hosting industry.  It does however make the usage of CDN with mixed (HTTP/HTTPS) content much easier to utilize, which is also how I last saw this in practice, just days after seeing it was a possibility.

On Windows 2008 and 2008 R2, when running the ColdFusion 9.0.1 updater it will fail to complete successfully.  Each time failing with the same message in the install log  (The Adobe_ColdFusion_9.0.1_InstallLog.log is not written to until the upgrade installer is closed. As long as it is still open, it has not written to the log file. The default location of the log file is C:\ColdFusion9.):

ANT Script Error:

Rename the dll while ColdFusion is stopped and retry the Upgrade.  It should complete successfully this try.  On a side note, I find it supremely easier to run the upgrade AS SOON AS you complete the installation of ColdFusion 9 if at all possible, otherwise, just install 9.0.1 (I think there is an actual installer for that version).   There is a ColdFusion® 9.0 Update 2 package which seems to be a better choice as of current.  Thanks goes to CFExecute for a bulk of this post.

Determining the version of ColdFusion can be a task you need to perform from time to time, to find out the version, create a page on the site with the following content:

As far as I can tell, there is not a simpler way of obtaining version without access to the ColdFusion Administrator Interface.

ColdFusion does not create the proper tables for client variable storage when using MySQL as the database engine.  This is valid in ColdFusion 9 and also still present in ColdFusion 10.  These tables should be created manually for client variable storage to function.

Two tables are required. CDATA and CGLOBAL. Details about theses tables are as follows:

The CDATA table must have the following columns:

Column | Data type

cfid | CHAR(64), TEXT, VARCHAR, or any data type capable of taking variable length strings up to 64 characters

app | CHAR(64), TEXT, VARCHAR, or any data type capable of taking variable length strings up to 64 characters

data | MEMO, LONGTEXT, LONG VARCHAR, CLOB, or any data type capable of taking long, indeterminate-length strings

The CGLOBAL table must have the following columns:

Column | Data type

cfid | CHAR(64), TEXT, VARCHAR, or any data type capable of taking variable length strings up to 64 characters

data | MEMO, LONGTEXT, LONG VARCHAR, CLOB, or any data type capable of taking long, indeterminate-length strings

lvisit | TIMESTAMP, DATETIME, DATE, or any data type that stores date and time values

If the database has not yet been created, you can create the database and tables with this:

To create the tables, the following queries can be used (this is if you have already created the database and have an appropriately privileged user that is able to access the database):

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

CF can not open a TCP socket to the database server. Check that the database server is actually running, listening on port 3306 and not locked by a firewall.

System Information
Server Details
Server Product ColdFusion
Version 9,0,2,282541
Edition Standard
Serial Number XXXXXXXXXXXXXXXXXXXX
Operating System UNIX
OS Version 2.6.32-279.11.1.el6.x86_64
Adobe Driver Version 4.1 (Build 0001)
JVM Details
Java Version 1.6.0_29
Java Vendor Sun Microsystems Inc.
Java Vendor URL http://java.sun.com/
Java Home /opt/coldfusion9/runtime/jre
Java File Encoding UTF8
Java Default Locale en_US
File Separator /
Path Separator :
Line Separator Chr(10)
User Name nobody
User Home /
User Dir /opt/coldfusion9/runtime/bin
Java VM Specification Version 1.0
Java VM Specification Vendor Sun Microsystems Inc.
Java VM Specification Name Java Virtual Machine Specification
Java VM Version 20.4-b02
Java VM Vendor Sun Microsystems Inc.
Java VM Name Java HotSpot(TM) 64-Bit Server VM
Java Specification Version 1.6
Java Specification Vendor Sun Microsystems Inc.
Java Specification Name Java Platform API Specification
Java Class Version 50.0

Can be downloaded here