[TriLUG] Good Open-Source MySQL Portal-Maker?

[John Turner]

James,

I just ran across this today, I think it might work for your project,  
but I have no other knowledge of it.

http://dbflay.sourceforge.net/

John

On Feb 9, 2006, at 2:18 AM, John Turner wrote:

> If you are willing to write a little PHP you could use PEAR  
> DB_DataObject_FormBuilder.
> Some docs can be found at http://opensource.21st.de/13.html
>
> John
>
> On Feb 9, 2006, at 12:25 AM, James Brigman wrote:
>
>> Hey TriLUGers - Currently at work, we use a MS-SQL database for  
>> tracking
>> servers and various configuration parameters about said servers:  
>> CPU #
>> and speed, RAM, Disk, lease end date, etc. It's all manual, and  
>> it's an
>> extreme pain to use and update (manually). Worse yet, it's not
>> web-delivered, multi-user and remote sites can't use it at all. Plus,
>> performance over WAN links is terrible.
>>
>> This seems like a perfect application to host on MySQL fronted with a
>> web-form type front end. I'd love nothing better than to pull the  
>> data
>> out of the MS-SQL database and put it into MySQL, then serve it  
>> using an
>> authenticated, Apache-served web page.
>>
>> My question to the list is: has anyone built MySQL databases  
>> containing
>> your equipment inventories and fronted with web portals where you can
>> add/edit/delete the various bits of data?
>>
>> And if anyone is doing such a thing, is there a good tool for quickly
>> making such a database portal, or am I just being a database n00b by
>> assuming it's a major deal to do it from the ground up without a  
>> tool to
>> help? (I figure things like drop-downs, select fields and data typing
>> are non-trivial to do in a web form.)
>>
>> More importantly, is anyone using such a portal as a foundation for,
>> say, NAGIOS monitoring, such that the NAGIOS tool uses the  
>> database to
>> know what to monitor? What say you big pulsing *NIX brains of the
>> TriLUG?
>>
>> JKB
>>
>> -- 
>> TriLUG mailing list        : http://www.trilug.org/mailman/ 
>> listinfo/trilug
>> TriLUG Organizational FAQ  : http://trilug.org/faq/
>> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>