Accessing MySQL and Filemaker via PHP

[Mark Thiessen]

I'm running an internal siite using PHP-Nuke (a mysql content management system) and would like to access filemaker data to make it appear like its part of the Nuke site. Can I use Nuke's login scheme so users don't have to log in twice? Since I'm using PHP I'm assuming it would work. I can't move all Filemaker data to mySql since users need the Filemaker GUI.

cheers,

Mark

[Steve T.]

Hi, M! PHP Nuke is a fairly popular CMS but since it's open source, you can probably adapt it for your use as well, but I heard PHP Nuke has had security issues in the past and updates are common so if they change how they're security works, it can break yours. If PHP Nuke is cookie-based, you can probably use its cookie and validation functions for your own system, too, or maybe you can create your own cookie authentication which validates against PHP Nuke's tables or checks for a valid PHP Nuke cookie.

I'm not a security expert, though, and cannot recommend a "best practices" kinda answer. Plus, I think PHP Nuke has A LOT of junk in it, so I'm not sure how easy it will be to analyze.

--ST

[Garry Claridge]

If you use PHP to access FM you can "hide" the login within the PHP script.

All the best.

Garry

[herrix]

Although I am not formiliar with Nuke, I do use Mambo a lot... they store a session-variable with the username and password. Use those variables while loggin in to the filemaker database.

Open-source has its pros and cons, but passwords are all-over the cms. You'll probably not need to change a lot when they change stuff.

Remember, though. It is very well possible that they store an encoded password in their database. You'll need to store that encoded password in FileMaker, not the regular plain text one..

good luck,

Herrix