Welcome to PCCS-Linux.COM Hello, and welcome to the PCCS-Linux Home Page.
Your last visit was !!!
Your Browser is running on Other
Main Menu
>> Home
>> Knowledgebase
>> MySQLDatabase Admin
>> NukeLayout Class
>> Resume
>> Mugshot
>> Downloads
>> Changelog
>> Feedback
>> Readme


Quick Links
MySQL Function def
pgSQL Function def
SNMP Function def
PHP Function def

Presentations
Using ucd-SNMP-Utils
MySQL Administration
Intro to PHP
Cheap Network Sniffer

Today's Links

Site Powered by L.A.M.P
  • Linux
  • Apache
  • MySQL
  • PHP

MySQL

This page has been viewed 23936 times ...

America United
Terminate Those who Threaten our way of Life. No QUESTIONS asked!!!!!

 
PCCS-Linux.COM CHANGELOG ...
  • released NukeLayout PHP Class v1.0
    -- Fixed - bug where layout would fail if php was configured
       using the --disable-short-tags which doesn't allow <?
    -- As a result I removed the mixture of HTML and now using only php calls 
    -- cleaned up code... more readable
    
    
    
  • released NukeLayout PHP Class
    A PHP class that allows you to develop web pages that look and feel like 
    PHPNuke./ PostNuke It was designed for ease of use little programming knowledge
    is required to use the class. 
    
    With out the need for a database and alot of programming...  it allows you to focus on content!
    
    Started developing a site for NukeLayout!
    
    
  • decided to update changelog
    I've been very busy with my new job.
    
    Written an number of small PHP applications for internal task.
    PO report module getting data from eEnterprise
    NewUser Request Form
    Change Management Request Form
    
    Making heavy changes to IRM 1.0.3 for inventory
    
    Implemented Keystone Helpdesk software w/Postgresql
    
    Implementing snort for IDS w/portsentry and logcheck
    
    Testing DEMARC snort interface
    
    Implemented Bugzilla for Bug Tracking system
    
    Implemented MRBS for conference room management 
    
    Made major changes to pccs-linux.com: almost a complete
    rewrite of the site. (re hack)
    
    I have alot more work to do on the new site layout. 
    At the moment I think it's usable for my goal(s)
    
    changed the way I create my note(s) pages
    the migration of the content is not complete, still have
    content to merge...
    
    
  • Added more notes...
    PHP Part 25 using the MSSQL functions - playing with
    FreeTDS
    PHP Part 26 using the LDAP functions - against Exchange
    5.5
    PHP Part 27 using NT security & PHP - using UserServer
    
    Had a good week at work, since I was able to
    Follow our notes and again restore Exchange 5.5 --- just
    testing (+: 
    
    
  • Released ms-access db port
    This is another one of those MS office wizarded
    databases, 
    ported to PHP/MySQL just to be doing something...
    
    
  • 02-2001 Exchange / Recover
    Had my first lesson on Exchange Recovery...
    
    if you don't have a plan in place .... START NOW!!!
    I'm working on a step-by-step for my notes... 
    will post sometime in the future..
    
    BTW I was able to recover, but it SU KED!!!
    Consider brick level backups unless you want to restore
    the
    entire Directory and Information Store.... 
    
    Restore software: ArcServeIT 6.61 + Exchange Agent
    
    CREATE A PLAN...
    
    
  • New Job
    Title: Network Administrator
    Task:
    WinNT/Citrix MetaFrame load balanced between 5 servers,
    Exchange 5.5
    30 + Cisco 1600 Series Routers (Frame Relay)
    Web Application Developer ( Intranet Site / PO Report
    Genrator)
    I'm using PHP/FreeTDS/Userserver to develop these
    applications (+:
    Netware 3.12, 4.11, 5.00x
    Backup Operator ArcServeIT
    
    Currently there are about 13 WinNT Domains and 15 NDS
    trees (remote), 
    ... plans to merge in to one NT dom and NDS Tree. are
    NO. 1 goal...
    
    
    
  • took a look at PHPxref
    I write alot of scripts and small applications using php
    and sometimes
    need a way to look at my code base. After browsing for a
    while I found
    phpxref. This
    tool allows me to 
    execute ./phpxref -c filename.cfg and get some very
    useful output...
    I ran this tool across my PCCS MySQLDatabase Admin tool
    version 1.3.4 and got these
    results
    
    The results allow me to browse the source tree of my
    application
    and view the variables, functions and source of each
    script.
    If you have time you are more than welcome to browse the
    source tree.
    
    I also ran the tool over the msaccess database port to
    php 
     Memebership Database
    Port  
    NOTE: This app is not finished it's ALPHA code...
    
    
  • writing code ...
    Still writing code... started porting a msaccess
    database to php.
    I exported the database schema to mysql using the win32
    ODBC driver,
    dumped the database set the primary keys and
    auto_increment on the 
    id fields. 
    The core of the application is based on the functions
    I'm hacking to 
    demo at the Web Technology SIG starting Feb 10, 2001 
    
    
    
  • New screenshots for DB TOOL
    Took a break from coding to update screenshots..
    View them  here 
    
    Updated my  MySQLDatabase Admin
    Tool  page.
    Added a few links
    
    PHPBuilder.com -- this is the site I used to teach
    myself PHP
    and a link back to my main site PCCS-Linux.COM
    
    
  • fixing bugs in version 1.3.4
    A bug in the mysqldb_backup.php that prevents Backups
    from the DB Admin 
    menu. I failed to change these file after defining tmp/
    as the directory
    to dump files to.
    
    Updating copyright to 2001 and adding GPL statement to
    scripts, where is
    was missing...
    
    
    
    
    
    
  • Released 1.2.8 of PCCS MySQLDatabase Admin Tool

    Minor changes to the code base, support for MySQL 3.23.xx, a modified backup.sh to dump backups to a directory inside apps root directory, use of the mkdir()function to create a directory for scripts written using genapp, a restore option and support for restoring to new database, and some bugfixes.

    Made some minor changes to this web site.

    • Somewhere between and I added server policy, added a mugshot of myself, and made some code changes to this site. I also released version 1.2.7 of my database tool on . I been very busy.

      Just completed the installation of 2 cisco 2900 XL series switches. Connecting a remote site at via 4 100MB/FX multi-mode (800MB) Cisco ISL Trunk. One switch was configured with 3 vlans and while the other switch only had 2. Each vlan was given access to the ISL trunk, vlan 1 gpn network and vlan 2 pcn behind a firewall. Vlan 3 was split up into 2 FastEthernet port groups used to for network backups.

      Waiting on 2 48 port 3500 series and getting ready to redeploy some BayStack 450 24Ts. In with the new out with the old (+:

      Upgraded MRTG to fix a sort issue...

      Deployed a FreeBSD box with ntop to monitor traffic usage to server network

      Deployed another Linux server for MRTG and ntop -wportnumber

      Starting the help administer 3 HP 9000 unix network servers (DNS/DHCP)

    • Made some minor changes to the site.
    • Release 1.2.6 of PCCS MySQLDatabase Admin tool
    • Started to put date on changelog entries
    • Made a few changes to PCCS-Linux.COM
      Added this page and the /README link.
      This site and hlug.org two of the sites that I maintain for myself. I own both domain and use them to provide support forsource products.
      I also maintain web.wt.net/~cthorn, but haven't updated it for about 2 years..
    • Wrote a very simple php download application for a friend. Don't know if it will be released.
    • Redocumented a network node Model 5000 with over 50 fiber connections and more than 35 RJ45 connections going out to 3 other Model 5000 nodes.
    • Just completed 2 network expansions. One was 78+ GPN port installation and a 28 port Private network, where I was responsible for making sure 24 pair fiber, CAT3 for phone and CAT5 for Data was installed along with 7 BayNetwork D5000s for GPN portion of network.
      The other expansion was a new installation where 8 network data drops, 6 pair fiber, CAT3/5 a Synoptics 2814 was uplinked via the fiber to provide network access.
    • Installed and configured a video server using Microsoft's Media Server and Windows NT 4.0 on a DELL midrange server with 60GB of disk storage. Configured the media server to allow only certian subnets to connect. I will be putting all the servers related to the project on a single switch and modify my MRTG html pages to better display the server's traffic on the BaySwith 450-24T port number
    • Participated in the expansion of our data center. Moved 6 servers to the new section with the possibility of 10+ more being added. These servers will be running Windows NT 4.0 on Compaq servers
    • Reconfigured hlug.org to be a support site for Linux Apache MySQL PHP and the Linux Terminal Server. This is where I provide FREE support for the stated products. I also hang out a phpbuilder.com putting in my 2 cents and helping with support questions.
    • Using FLUKE technology I was able to clean up and free network ports in over 65 network IDFs.
    • Gave a presentation at the Houston Linux User Group DEMOing the Linux Terminal Server.
    • Setup the network environment for a Development/Test DataCenter that will house 6-10 DELL Midrange servers.
    • Installed and configured MRTG to have a visual picture of the traffic going to and from about 100+ network devices.
    • Surveyed and redocumented the locataion of 95% of ALL network devices on the network.
    • Installed and Configured Cheops the monitor important subnets.
    • Wrote, installed and configure PHP/SNMP Network Admin Tool, populating the applications database with ALL of the network devices on the network. In an effort to get realtime data via a web browser. This application is available for download.
    • Wrote, installed and configured PCCS Network Resource Manager, populating it with data relating to over 900 DELL/COMPAQ desktops, 300 Network printers, and 190 windows applicataions.
    • Installed ntop on a SPARC box running Linux. This server just sits and gathers sample data. Very good tool for seeing what networked stations are using the most network traffic and what type of traffic it is. (Web,Ftp,etc)
    • Started using nmap to gather information about the services running on my LAN. How many stations are providing web services? What ports areon these workstations?

      Putting this stuff into a database provides valuable information when looking at your network from a security administration point.

    • Was leader of the Hardcore Linux User Group, while the group has no membership, I still maintain a slot for the group by keeping the domain available hlug.org. We had meeting/classess at MicroCenter where I gave about 10 presetations ranging from MOSIX, SAMBA, PHP to just talking about Linux.
    • Installed and configured a 5 node cluster using MOSIX




This web site is prepared and maintained by Chauncey Thorn.
The information contained in this site was valid at the time of posting.
Chauncey Thorn, assumes no liability for damages incurred directly or indirectly as a result of errors, omissions or discrepancies.

Remember most of the content here are my notes...

All logos and trademarks in this site are property of their respective owner. All the rest © 2000 - 2001 by PCCS-Linux.COM

PCCS-Linux.COM ::ource Advocate Articles catalogue
2000 2002