{"id":73,"date":"2006-09-21T16:14:00","date_gmt":"2006-09-21T22:14:00","guid":{"rendered":"http:\/\/thepizzy.net\/blog\/?p=73"},"modified":"2011-02-24T09:56:14","modified_gmt":"2011-02-24T15:56:14","slug":"oracle-and-tsnlocalnet","status":"publish","type":"post","link":"https:\/\/thepizzy.net\/blog\/2006\/09\/oracle-and-tsnlocalnet\/","title":{"rendered":"[[Oracle]] and tsnlocal.net"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1191\" data-permalink=\"https:\/\/thepizzy.net\/blog\/2007\/10\/oracle-upgrade\/oracle\/\" data-orig-file=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?fit=500%2C500&amp;ssl=1\" data-orig-size=\"500,500\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"oracle\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?fit=500%2C500&amp;ssl=1\" class=\"alignleft size-thumbnail wp-image-1191\" title=\"oracle\" src=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle-150x150.png?resize=150%2C150\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?resize=150%2C150&amp;ssl=1 150w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?resize=300%2C300&amp;ssl=1 300w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?resize=36%2C36&amp;ssl=1 36w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?resize=115%2C115&amp;ssl=1 115w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?w=500&amp;ssl=1 500w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/>I&#8217;ve spent the last two weeks working on getting [[Oracle]] into the role she was designed to play&#8230;but have found it to be a bit more involved than I realized.<\/p>\n<p>Originally, I set up the server to be a <a title=\"[[Oracle]] Reborn, tsnlocal goes up beta\" href=\"http:\/\/thepizzy.net\/blog\/2006\/09\/oracle-reborn-tsnlocal-goes-up-beta\/\" target=\"_blank\">web server with php and sql capabilities<\/a>. Then I realized I needed to FTP files to the web server, so I installed <a href=\"http:\/\/filezilla.sourceforge.net\/\" target=\"_blank\">FileZilla Server<\/a>. 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 <a href=\"http:\/\/www.jivesoftware.org\/index.jsp\" target=\"_blank\">Wildfire<\/a>.<\/p>\n<p>Wildfire is extremely easy to setup and install &#8211; so once I finished that, I looked for a Jabber client. My first choice was a VoIP client called <a href=\"http:\/\/www.jabbin.com\/int\/\" target=\"_blank\">Jabbin<\/a>, but I couldn&#8217;t get it to connect to the server &#8211; probably because I don&#8217;t have a VoIP Protocol on the server to support it. So I went with what we use at work, <a href=\"http:\/\/exodus.jabberstudio.org\/: target=\">Exodus<\/a>. It&#8217;s a fairly functional Jabber client &#8211; with chat rooms, IM rosters, subscriptions, and file transfer&#8230;and a bunch of other stuff, including plugins.<\/p>\n<p>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 &#8211; almost.<\/p>\n<p>So now you can join the jabber server with yourname@jabber.tsnlocal.net. 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&#8217;d recommend. Duck-Lap recommended qmail for linux, but mentined <a href=\"http:\/\/mailenable.com\" target=\"_blank\">MailEnable<\/a> 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&#8217;m looking for since most of these other services aren&#8217;t critical to the function of the server. BIND was about the only thing that was hell to configure&#8230;everything else was easily figured out once I had the info and a general grasp of what it does and how it does it.<\/p>\n<p>So now, [[Oracle]] does these things:<br \/>\n&#8211; Web Server (Apache, PHP, MySQL)<br \/>\n&#8211; FTP Server<br \/>\n&#8211; DNS Server<br \/>\n&#8211; Email Server<br \/>\n&#8211; Jabber Server<br \/>\n&#8211; TeamSpeak Voicechat Server<br \/>\n&#8211; Hamachi server<br \/>\n&#8211; Google Desktop distributed indexing server for the hamachi shares (the essence of tsnlocal)<br \/>\n&#8211; and a keep-alive for the dyndns service linking my IP to the dynamic domain<\/p>\n<p>That&#8217;s a lot for a little box&#8230;but I&#8217;m not done yet &#8211; I need to put ssh on it so I can telnet into it. I&#8217;m sure there are other things that I will find to do with it as time goes on too.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve spent the last two weeks working on getting [[Oracle]] into the role she was designed to play&#8230;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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1191,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[25,11,225,3,9,347,18,8,2,4],"tags":[414,415,422,409,413,407,420,397,410,411,421,418,406,233,412,120,423,405,391,417,408,152,424,121,213,425,292,404,416,374,36,419,231,402,139,948],"class_list":["post-73","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming","category-projects","category-servers","category-tech","category-the-spot-net","category-the-spot-network","category-thepizzy-net","category-tsnlocal-net","category-updates","category-oracle","tag-bind","tag-chat-rooms","tag-dns","tag-dns-control","tag-domain-name","tag-dyndns","tag-email","tag-email-server","tag-email-settings","tag-exodus","tag-filezilla","tag-ftp","tag-godaddy","tag-hamachi","tag-instant-messaging","tag-internet","tag-jabber","tag-jabber-client","tag-jabber-server","tag-jabbin","tag-nameserver","tag-php","tag-pop","tag-server","tag-setup","tag-smtp","tag-sql","tag-sql-capabilities","tag-voip","tag-web","tag-web-server","tag-webpage","tag-webserver","tag-wildfire","tag-windows","tag-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?fit=500%2C500&ssl=1","jetpack_likes_enabled":false,"jetpack_shortlink":"https:\/\/wp.me\/prOO4-1b","jetpack-related-posts":[{"id":72,"url":"https:\/\/thepizzy.net\/blog\/2006\/09\/back-into-the-swing\/","url_meta":{"origin":73,"position":0},"title":"Back into the swing\u00e2\u20ac\u00a6","author":"[[Neo]]","date":"September 17, 2006","format":false,"excerpt":"I am just now starting to get back into the swing of things for tsn. After working on some graphics for tsnlocal.net, and creating background for the [[Oracle]] server and my computer, I've begun work on the next theme for tsnX: tsnX-dark. This one is a bit tricky because there\u2026","rel":"","context":"In &quot;Servers&quot;","block_context":{"text":"Servers","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/servers\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":71,"url":"https:\/\/thepizzy.net\/blog\/2006\/09\/oracle-reborn-tsnlocal-goes-up-beta\/","url_meta":{"origin":73,"position":1},"title":"[[Oracle]] Reborn, tsnlocal goes up beta","author":"[[Neo]]","date":"September 11, 2006","format":false,"excerpt":"This weekend, I hung out with [wizard] and we worked on our servers. He created his [m3rlin] server, and I created my [[Oracle]] server. Originally, as you might recall from previous posts, [[Oracle]] is an IRC bot that we use for auto responding and chanserv purposes. Our bots are still\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?fit=500%2C500&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":74,"url":"https:\/\/thepizzy.net\/blog\/2006\/12\/link-trinity-myspot\/","url_meta":{"origin":73,"position":2},"title":"[[Link]] &#038; [[Trinity]], MySpot","author":"[[Neo]]","date":"December 12, 2006","format":false,"excerpt":"Updates are hard to come by these days - especially when in order to have an update, you have to build a new computer, learn a new operating system, and install\/learn\/configure a new software service. I'll start with [[Trinity]]. When [[Oracle]] crashed, in early October, I was left without any\u2026","rel":"","context":"In &quot;Projects&quot;","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":22,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/project-oracleserver-updated\/","url_meta":{"origin":73,"position":3},"title":"Update: [[Oracle]].Server","author":"[[Neo]]","date":"April 3, 2006","format":false,"excerpt":"I just built another computer, [[Oracle]].2, for this project and have set up a Google Account for the Oracle servers. I'm going to start distributed indexing for everyone that joins the tsnlocal network, which is going live April 12th, to commemorate the-spot.net's 3rd year running. I'll set up a webserver\u2026","rel":"","context":"In &quot;Projects&quot;","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2007\/10\/oracle.png?fit=500%2C500&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":31,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/update-tsnx-tsn-domain-issues-profile-cp\/","url_meta":{"origin":73,"position":4},"title":"Update: tsnX &#8211; tsn domain issues, profile cp, [[Oracle]]","author":"[[Neo]]","date":"April 9, 2006","format":false,"excerpt":"There have been problems lately with the dns server or something, according to my server people. I thought they had it fixed, but apparently it's broke again. I'll see what's up with that if it's not fixed soon. Also, I managed to fail my quiz (which wasn't for a grade)\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":48,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/tsnx-email-packages-and-plans\/","url_meta":{"origin":73,"position":5},"title":"tsnX: Email packages and plans!","author":"[[Neo]]","date":"April 27, 2006","format":false,"excerpt":"I have come to the point where I have acquired enough email addresses, that I can start issuing emails. What I have: @the-spot.net : 900 @tsnlocal.net : 49 @the-blot.net : 38 @the-blot.com: 40 The emails at the-blot.net and the-blot.com are hosted at hotmail, with the Microsoft Live Hotmail beta with\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":4,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":1198,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions\/1198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media\/1191"}],"wp:attachment":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}