There is some very exciting news from Sophos — Sophos Home has launched (in beta) for free, for non-commercial use. It is licensed to never expire, and it works on Mac and Windows. This is very good news for every home computer!
Archive for Blogs, Links, & Bookmarks
We just enabled the MSSQL extension via FreeTDS on a Media Temple DV 4 VPS. Here’s a line by line of how we did it, borrowing heavily from http://www.mavrick.id.au/2012/php-5-3-6-mssql-freetds/
, but adding the particulars for the MediaTemple DV and for the particular version of PHP (5.3.5) that we were using:
Make a directory to hold these sources:
cd / mkdir /source cd /source
Grab the source of FreeTDS:
wget http://mirrors.ibiblio.org/freetds/stable/freetds-stable.tgz tar zxvf freetds-stable.tgz cd freetds-0.91 ./configure –enable-msdblib –prefix=/usr/local/freetds make && make install
For some reason these files need to be copied over:
cp include/tds.h /usr/local/freetds/include cp src/tds/.libs/libtds.a /usr/local/freetds/lib cd /source
Adjust for your desired version of PHP (this example is 5.3.5):
wget http://museum.php.net/php5/php-5.3.5.tar.gz tar xvfz php-5.3.5.tar.gz cd php-5.3.5 cd ext/mssql phpize ./configure –with-mssql=/usr/local/freetds make
Now, when we first ran the make command we had to deal with a type redefinition in
Copy the extension to the proper directory… You can find out what directory it is with this command:
php -i | grep extension_dir
In our case it was /usr/lib64/php/modules.
cp modules/mssql.so /usr/lib64/php/modules
Edit php.ini file (this is the global one):
Then restart your web server:
Other PHP MSSQL Resources:
I compiled the pdo_dblib.so extension… but it looks like PHP is compiled with –disable-pdo. So I went back to mssql_connect as a connection method…
Logging in as the user to the bash shell, I could telnet to the database server’s ip at port 1433.
From the command line as well, I could run tsql (the diagnostic tool that comes with FreeTDS) and connect to the server, where I was able to verify that the hostname, instance, and dbname lookups are correct. I could even run T-SQL statements and query the database successfully from there.
I configured the FreeTDS conf file to have [appname] as a reference to the server, and then accessed via the following code in:
$hostname = 'appname'; $username = 'username'; $password = 'password';
$databasename = 'database';
//connection to the database $connection = mssql_connect($hostname, $username, $password)or die("Unable to connect to $hostname"); echo "
Connected to MSSQL
$result = mssql_query("SELECT TOP 1 field from table");
$row = mssql_fetch_array($result);
Result from sample query: ".$row."
Which outputs the expected:
Connected to MSSQL
Result from sample query: x
This was the missing puzzle piece:
Apparently FreeTDS looks in /usr/local/etc by default, not /etc.
We have been recommending these to everyone:
Just don’t buy up the whole stock of them as we have more clients to order them for!
It seems like there is finally a great replacement for iTunes on Windows: http://getmusicbee.com/
I just counted (html > spreadsheet > row count / 2) the number of labels I have in my primary* Gmail account: it came to over 80.
How many do I use on a regular (daily) basis? 0.
How many do I use on a weekly basis? Maybe a handful. 5-10.
I do special purpose creates for them, but more realistically it’s easier to throw an IMAP setup on Thunderbird and use ImportExport Tools to do any significant manipulation of email data.
So, yup, it’s pretty much time for them to go… even though they were the hit controversial thing, with Gmail pulling us away from “real” IMAP folders at the time.
*Gmail: You can’t have just one. At least no self-respecting geek can, anyway.
No website should say “Missing Plug-in.”
Just saying. Even if the techie that built the site *really thinks* that every user *must* have that plug in. 🙂
Think about the site from a usability perspective, and try to cater to the viewers. Please!
We bill in quarter-hour increments, so it would be perfect if this timer interface (the web timer) had preferences. It should be able to configure it to round to whatever increment needed; it should support up, down, or nearest rounding as well. Auto-rounding (based on the selected preferences) and a few seconds delay a la Timersync after hitting submit would be ideal.
The only reason the browser is in use at the moment is because this is on OS X (and the dashboard widget is outdated and a pain).
Details here: http://code.google.com/p/apt-cyg/