However, with the downturn in the economy (and my slightly-better-than-arbitrary prediction of a <7,000 point stock market by the end of the month…Spring Break at the latest), I figure it’s time to start taking into consideration other possible sources of income. Not for fear of losing my job, but rather to help get my bills in check Credit Cards, primarily, who have decided it is time to raise the minimum payment – which is the only thing enabling me to devote a greater portion of my money to one in order to pay it off, while keeping the others at par until it is their turn. Continue reading
I’ve been part of the Google Connect beta since shortly after it came out – but it wasn’t until recently that I actually implemented it on my blog and the parent site, www.thepizzy.net. So, if you read this (and I know there has to be at least 4 other people in the world that do), go ahead and hit the Join button on it, and let me know y’all are out there. (it helps to know one is writing to an audience instead of providing technical articles to the etherworld.)
You don’t have to worry about spam or anything – I don’t like it either.
In other news, I’m also working on a tutorial entry that describes how to get data from a Google Docs Spreadsheet. Normally, I wouldn’t worry about trying to release this code, but since it was such a pain for me to figure out (like the UT3 Server setup), I’m sure it’s a pain for others to figure out as well.
The code creates a secure-authenticated session to Google Accounts, and then requests the data from a particular cell on a spreadsheet. My code goes one step further though, and posts that data to Twitter – which means it also creates an authenticated POST request via the Twitter API.
“Why do that?’ you ask…Well, if you want to be able to update a spreadsheet from, say an iPhone or other Mobile Browser, Google Docs will not let you. But I’ll explain more in the coming entry. Be looking for that sometime this week (I hope).
Surprisingly there are no complete blog postings or forum topics that tell you how to set up a UT3 Internet Server from start to finish…so here we go: Continue reading
I’ve spent the last two weeks working on getting [[Oracle]] into the role she was designed to play…but have found it to be a bit more involved than I realized.
Originally, I set up the server to be a web server with php and sql capabilities. Then I realized I needed to FTP files to the web server, so I installed FileZilla Server. Once that was done, I started working on the webpage for tsnlocal.net. I got it up, and then wanted to play around with some other type of server, and decided on a Jabber server for instant messaging. I installed Wildfire.
Wildfire is extremely easy to setup and install – so once I finished that, I looked for a Jabber client. My first choice was a VoIP client called Jabbin, but I couldn’t get it to connect to the server – probably because I don’t have a VoIP Protocol on the server to support it. So I went with what we use at work, Exodus. It’s a fairly functional Jabber client – with chat rooms, IM rosters, subscriptions, and file transfer…and a bunch of other stuff, including plugins.
Once the Jabber service was set up, and I figured out how to connect to it, I realized that telling people to use my dyndns domain name was not going to work. So I had to figure out how to get my Godaddy.com domain name to link directly to my IP address. But, come to find out, I have to have a Top Level Domain for an IP address, or my dyndns must be a nameserver registered with the NS Registry, in order to use it as a nameserver. I spent 2 days setting up BIND on Windows XP (because there was very little help on the internet for how to do it). Then I jacked around with the Total DNS control settings on godaddy, and got the webserver to work like it should – almost.
So now you can join the jabber server with email@example.com. Now that I had that working, I noticed that there were email settings like pop.tsnlocal.net and smtp.tsnlocal.net that could be set up, so I decided to look into running my own email server. I got in #bloodshotgamer on irc.gamesurge.net and asked some of the tecky people I talk to in there what they’d recommend. Duck-Lap recommended qmail for linux, but mentined MailEnable for Windows. I was hoping for an IMAP service so I could run the webpage side of it, but that was not included with this. I might upgrade the service to something new later on, but for now, this was easy to install, and has easy administration, which is what I’m looking for since most of these other services aren’t critical to the function of the server. BIND was about the only thing that was hell to configure…everything else was easily figured out once I had the info and a general grasp of what it does and how it does it.
So now, [[Oracle]] does these things:
- Web Server (Apache, PHP, MySQL)
- FTP Server
- DNS Server
- Email Server
- Jabber Server
- TeamSpeak Voicechat Server
- Hamachi server
- Google Desktop distributed indexing server for the hamachi shares (the essence of tsnlocal)
- and a keep-alive for the dyndns service linking my IP to the dynamic domain
That’s a lot for a little box…but I’m not done yet – I need to put ssh on it so I can telnet into it. I’m sure there are other things that I will find to do with it as time goes on too.
I’m backing up the tsnX.3 Beta’s Database (with the posts, forums, and accounts) and going to start moving the tsnV database into the tsnX site. The site is going to be down for a bit, while I do this, and iron out the kinks of auth-access, and conversions. If things don’t go properly after a bit, I’ll restore the tsnX.3 database, and continue working on converting tsnV to tsnX again. There are some things that I can’t test just by looking at the SQL Code, and that I have to implement for it to be tested.
So check the pizzy for updates if the forums aren’t working. If, in the meantime, the server goes down for some reason, and you can’t get to thepizzy or tsn, then go to http://tsnblog.blogspot.com to fing out why.