wheewww….I mentioned in my previous blog that our school will be using Squid + Dansguardian for our proxy server. Now, I already seen the problem why I was not able to configure the SafeSquid properly and decided to use it instead of the above setup. The problem I encounter when I was setting it up was every time I change the Run Level of the safesquid or to start it during boot time, it always hang. Yesterday after noon, I checked the init.d script of the safesquid and I saw the problem. The installation I've downloaded from their website install the safesquid script to init.d. At the status part of the script, I saw an infinite loop because the script calls the status function inside the status function causing it to have infinite loop. So I tried to remove the line that caused the infinite loop and then after that I was able to configure the safesquid properly to start it during boot. So now, we're using it …
What I like with SafeSquid is it contains a web-interface for configuring its options (by means of http://safesquid.cfg/) and its website support and forum that offers help and information regarding the configuration of the server. Try it…
I'm a kind of guy who loves to study new things and new versions of operating system. Last year I setup a file server for our school to serve at least 100 computers to be used by our students as their workspace. I use the FreeBSD 6.0 + Samba for that purpose. Now this summer I setup a different O.S. for the school, that would be openSUSE 10.2, (honestly I'm still average when it comes to setting-up Linux systems and I'm still studying!!!)
Now I'm done with the configuration of the setup. Well the final output is I use openSuse 10.2 as router with proxy server + web filtering content. I use two LAN Cards, one connected to the myPLDT DSL and the 2nd LAN Card connected to the school's local area network.
For the standard installation of the openSUSE 10.2, KINTERNET was not installed so i add the package then configure the DSL connection through YAST2 (SUSE's Control Panel).
The first problem I encounter when I configure the server as router was the gateway that I should specify for the 2nd LAN. I try to use "route -n' to determine the gateway and 0.0.0.0 address was returned to me by the command. Now, I've read some article from a Novell's Cool Solution (http://www.novell.com/coolsolutions/feature/16022.html). After reading this material I set the gateway for the 2nd LAN as 10.0.0.138 (Modem's IP Address) and I set the IP address for the 2nd LAN as 10.0.1.1
Then I configure my Windows XP workstation's IP Address as 10.0.1.2 … then I checked the browser if I can connect to internet 
and luckily it did!
For the proxy server, I install the Squid proxy server then dansguardian as the web-filtering content program. I tried SafeSquid but I decided later to use Squid+Dansguardian and I'm done with it. I configure the firewall of the server to prevent our LAN to access the internet directly so I can force users to use the proxy server.
Well, I try to have detailed instructions with pictures for the configuration that I made. I'll gather all the snapshots … later …
Now of course. you will not tell your client to pay another fee just to repair the database or re-encode their data, you might get in trouble hehehe…For cure, try using previous version of Visual Foxpro 8.0 like version 7.0, now its your problem to look for it. Open your table using the previous version and copy it to a different name (using: COPY TO newname), reconstruct its indices and re-open it in version 8.0, rename.
But of course prevention is always better than cure! Try to put a code in your program that automatically creates a duplicate copy of your tables, index files and databases and automatically copy to good file from your duplicates if in case the error triggers (use ON ERROR). Set-up a back-up routine. Inform the user to properly shutdown the computer and regularly perform back-up. Use UPS for power back-up. Better is to use MySQL as your database instead of the native database/tables of VFP but this will be a different story.
Basic Tips on Webpage designing and SEO (Search Engine Optimization) for Web Designers (Capiz, Philippines)
Graphics & Lay-out
1. Use small graphics for your designs (10-20 KB per image). Large file will make your pages to load very slow. Search Engines hate slow pages.
2. Avoid a 'NO TEXT, ALL GRAPHICS' page. Search engines can't read text within your graphics. All Graphics page will make your page good in the eyes of the viewer but it will be very invisible for the Search Engine Crawlers.
3. Do not use images that blink or move or change or rotate or flash or do anything on your page. Or use them sparingly. There have been many studies that show that flashing graphics are distracting and annoying to people. In fact, in one focus group I watched the browsers actually physically cover up flashing graphics so that they could read the rest of the page. (from about.com)
4. Choose the appropriate TITLE for your website. Avoid acronyms.
5. Avoid hidden text. Hiddent texts are text/keyword typed that are intentionally resized to the smallest font and colored as the same color with the background. Google penalized it as a spam and may ban the website/page.
Links
1. Avoid 'DEAD LINKS'. Dead links are hyperlinks that point a page or link that does not exist. Search engine hate this too.
2. Avoid unrelated links. Try to put external links (links that does not belong to your domain / website), that is relevant to your site.
3. Create a blog that discuss the launch of your website and discuss anything about your website and put a link that will point to your website. Blog's are usually crawled or visited by Search Engines faster than an ordinay web site. Usually every 72 hours Blogs are visited by Crawlers. If your blog will be crawled, your site will be followed and seen by SE through the blog.
4. Try to create a page that contains links of all the pages of the website (a sitemap). Put a link to your main page (index.htm) that will point to the sitemap page.
Submit your URL
1. Submit your website to leading search engines and directory like Google, Yahoo, MSN Live, and DMOZ.ORG. Don't worry its free.
Find more tips on the internet there are many good samaritans all over the WWW that gives good tips for SEO and web page designs, look for it.
Visual FoxPro is one of the fastest database program in the market. It is used for small scale database applications. Its limit of 2GB for its database tables makes it for small scale only. It does not have a feature that secures the data (unlike MS Access you can assign a password for your database). I will recommend Visual Foxpro + MySQL5 + FreeBSD or LINUX platform to solve this kind of problem and boost the speed and data security of client/server applications for a smaller fee (actually MySQL5 and FreeBSD or LINUX are all downloadable for free from their respective websites. Of course, you can purchase a copy of Visual Foxpro from Microsoft 
).
This combination for me is more practical and cheapest compare to other software combinations.
For Filipino computer programmers and students studying DBMS and Visual Foxpro, you can start the study of MySQL and FoxPro combo by installing first the MySQL5, MySQL .NET Connector and other MySQL GUI Tools. Download all this programs and tools from the official website of MySQL.
Then look for the topics from the help file of Visual Foxpro regarding the SQLCONNECT and other SQL commands. Study the topics that deals with creating Remote Views and Local Views. That will be the beginning.
If I have time after I'm done with my recent project, I'll try to prepare a demo program that uses this combo. For FreeBSD, visit their website at www.freebsd.org for info and downloads. Good luck
For online storing of receipts, organizing and managing your expenses, use an Expense Management Software with their system to help you quickly prepare your expense report, what you could ask for?
