Awhile back i did an article on cleaning the Dude database. Alex Nordeen has a very in-depth article on SQL Lite and it’s many features. Check out the article and Guru99.com for more stuff.
Categories
Category: Uncategorized
Categories
Arin announces new fee schedule
https://www.arin.net/fees/2016_fee_schedule.html
| Service Category | Fee | IPv4 Block Size | IPv6 Block Size |
|---|---|---|---|
| 3X-Small * | $250 | /24 or smaller | /40 or smaller |
| 2X-Small | $500 | Larger than /24, up to and including /22 |
Larger than /40, up to and including /36 |
| X-Small | $1,000 | Larger than /22, up to and including /20 |
Larger than /36, up to and including /32 |
| Small | $2,000 | Larger than /20, up to and including /18 |
Larger than /32, up to and including /28 |
| Medium | $4,000 | Larger than /18, up to and including /16 |
Larger than /28, up to and including /24 |
| Large | $8,000 | Larger than /16, up to and including /14 |
Larger than /24, up to and including /20 |
| X-Large | $16,000 | Larger than /14, up to and including /12 |
Larger than /20, up to and including /16 |
| 2X-Large | $32,000 | Larger than /12, up to and including /10 |
Larger than /16, up to and including /12 |
| 3X-Large | $64,000 | Larger than /10, up to and including /8 |
Larger than /12, up to and including /8 |
| 4X-Large | $128,000 | Larger than /8, up to and including /6 |
Larger than /8, up to and including /4 |
| 5X-Large | $256,000 | Larger than /6 | Larger than /4 |
Categories
Capstan hoist 10 tips
From the folks who make the most popular capstan hoist
http://www.hubbellpowersystems.com/literature/lineman/BR09023E.pdf
Categories
Cleaning the Dude Database
So as installs of the Dude v4beta are aging they are experiencing some database issues. This is due to a 2gig limit of the SQL version embedded with the Dude. So, if your dude database is crashing, complaining about being full, or just plain running slow it may be time for a cleaning. You can easily verify this by looking in the dude/data and at the “dude” db file. If this is around 2 gig it’s time for a cleaning.
To start you will need SQLLite for your version of Windows. These are available from https://www.sqlite.org/download.html. Simply get the precompiled binary for your OS. For ease of sake Put your SQLite3 .exe in the same director as your dude database. This makes commands much simpler.
Follow these steps to clean the database:
1. Stop Dude service
Make sure to kill the dude process. Simply closing out of it does not fix. I had to go into task manager and end “dude.exe”
2. Dump DB to text with SQLite. (echo .dump | sqlite3.exe dude.db > dude.sql)
3. Rename dude.db, delete any dude.db-journal and dude.viw files. Something like dude.db.old
4. Start Dude service, this should create a new, blank dude.db
5. Stop Dude service
6. Open the dude.sql you created in step 2. Delete everything from dude.sql except for the lines that say INSERT INTO “objs” (including the lines that create the tables and indexes and stuff, just the INSERT INTO “objs” lines should be left)
7. Open dude.db with SQLite and delete everything from the objs table (DELETE FROM objs;)
8. Read old objs values into new DB (.read dude.sql)
9. Start Dude service
20,000 records took me a few hours to read back in. Just let it run. If you are curious on progress have the window open with the dude.db file. You should see the size of it growing during the read process.
Categories
xISP news Friday November 13 2015
Some notable news for the xISP world.
Netflix Releases Streaming reports for the national ISPs
50% off your first year: 3G4MDXY7KYQYPE
Visit our new Online Store
Categories
Online OSHA Certifications
http://www.compliancetrainingonline.com/osha_certification_training.cfm
Great for Tower climbers and working at facilities which require OSHA certifications.
Categories
Towers and pricing
One of the more common questions is what does a tower cost me to put up? As many of you know this can vary quite a bit. We are going to approach this from a single vendor perspective. What this means is I am going to take what it would cost to buy a commercially available tower from Texas Towers and put it in the air.
Disclaimers
1.I am not endorsing Texas Towers nor am I affiliated with them. They are one of the few tower manufacturers who publish prices.
2.Consumable costs will vary depending on where you are, time of year, state regulations, and maybe even the cycle of the moon.
3.This is geared toward small deployments.
4.Pricing is based upon the information I had available at time of this writing.
- Texas towers makes a self supporting 100 foot tower (Model HD8-100). This tower is rated to support 7.4 square feet of load in 110MPH winds. Cost $4,409.
- The base which goes in the ground costs $225
- Freight costs vary
- Concrete. The base for this tower requires 6 cubic yards of concrete. Pricing near me is $95 per yard plus a $30 delivery fee with a 3 yard minimum.
- If you are doing the 100 foot tower a small 80-100 foot crane can put this up. The tower weighs around 500 pounds so a small crane is sufficient. In my area a crane this size would be around $400 for a half day. Since it’s not a huge crane it doesn’t require special permits in indiana
- Engineering Fees for the base run around $1000.
So total cost for the tower: $5734 plus freight.
There are some other factors to consider. Permitting, labor to assemble tower, standoffs, etc. But this gives you a good ballpark estimate.
Categories
Helpful OSPF times
OSPF can be a mystery to some. Understanding the default timeouts can be helpful in troubleshooting. Some vendors change these times so it is very important to realize this stuff if you start mixing vendors in your OSPF domains.
10 Seconds
Default OSPF hello timer on broadcast and point-to-point links
30 Seconds
Default OSPF hello timer on nonbroadcast links
40 Seconds
Default OSPF hold timer on broadcast and point-to-point links
120 Seconds
Default OSPF hold timer on nonbroadcast links
30 Minutes
OSPF LSA refresh timer
60 Minutes
OSPF LSA expiration timer
You must be logged in to post a comment.