Topic: secure db-connection from hosted website to sme7?!

[jester]

I've got a website (Joomla!) running at a host with a seperate part for my members behind a login. I want to make a page for these members that shows our current stock taken from the Sql-ledger db (Postgresql) running on my SME7 server.

I'll probably be able to come up with a php or pearl page that connects with the database and extracts the needed info, but i've got no clue how to do this in a secure way. The quickest probably would be to host this site on my own server but that would probably end up in a bandwith problem.

Someone got some pointers on how to tackle this one?!


Regards,
jester.

[CharlieBrady]

Someone got some pointers on how to tackle this one?!

For a start you should ask in the Contribs forum, since this forum concerns only unmodified servers.

[jester]

Thanx Charly for your kind response and enlightening me with the knowledge that this cannot be done with an unmodified SME server so that i can take this question to the contribs forum....  

jester.

[CharlieBrady]

Thanx Charly for your kind response and enlightening me with the knowledge that this cannot be done with an unmodified SME server ...

An unmodified server does not even run postgresql.

You should read the developers guide, under Development. That will tell you about opening ports in the firewall, and adding additional services. But you won't find any postgresql configuration information there - you'll need to look elsewhere.

[jester]

But without getting into a flame kind of conversation...

The focus is not on Postgres, it's about a secure link between my hosted server and my own sme-server.... this to me seems more standard SME stuff.

Me extracting information from a Postgres db over this secure link is not relevant it might just as well have been information from the standard SME supplied MySQL db.

But as stated above.... it SEEMS more standard SME stuff... so thats me not knowing for sure.... and therefore this question still could be on wrong forum. After reading the obove, please tell me if it is!

I know you are sometimes a grumpy 'old' bear, probably from coding/bugfixing day and night to get SME ready for us.... so i won't take it personal.  

regards,
jester.