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/
--
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/
