Topic: Web access to a database for SME

[toothandnail]

I've spent some time hunting the forums and wiki, but either I'm not using the right search terms or no-one has implemented something like this....

I have need to make a simple database available via a web browser from an SME server. What the database is dones't matter much - what I need would easily be handled by a flat file database (its a support database which needs to contain entries for a number of (mainly) laptop computers, and include such details as user, installed software and licences, an asset/tracking number, department, etc).

I've read instructions for making new MySQL databases, and making them available over the net. Apart from worries about server security in doing so, I still need a web interface that can be accessed both from the local network and over the internet. Something like phpmyadmin might do what I need, but I'm sadly lacking in knowledge in this area, so I'm hoping someone can point me to an existing solution.

I've also looked at phppgadmin, which would require a PostgrSQL install, but would at least be seperated from the SME MySQL databases, so hopefully less of a secutity risk.

The ability to enter data over the internet would be useful, but is not vital. The ability to view and search the database over the internet is.

The only thing I've found in my searching is metadot, but that appears to not have been updated in a long time, and also seems like overkill - a wide range of its features would not be used or needed in this application.

Can anyone point me to a database/frontend that I can use with SME?

Paul.

[cactus]

You already suggested phpmyadmin yourelf, any reason you did not install it? If you would have searched on phpmyadmin in this domain you would have found how to do so: http://wiki.contribs.org/PHPMyAdmin

[larieu]

for the first part
please look also to the OCS contrib

http://wiki.contribs.org/OCS_Inventory_Tools

I think you have everything there

I don't use very much the GLPI module
but probably is what you ask for

also for the second part as cactus suggested
you can put also the version for multiple users

http://wiki.contribs.org/Phpmyadminmulti

use it as a hint