Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: dws4wdr on January 25, 2007, 06:59:45 PM

Title: MySql Data
Post by: dws4wdr on January 25, 2007, 06:59:45 PM

This may sound stupid but, where does sql store the different databases? We have Ruby running a custom data program and phpmyadmin doesn't pick the database. Are all the databases stored in one big database combined?

Title: MySql Data
Post by: byte on January 25, 2007, 07:43:19 PM

They are normally in /var/lib/mysql

Title: MySql Data
Post by: kruhm on January 28, 2007, 02:16:21 AM

Do you have ROR running?

Title: MySql Data
Post by: dws4wdr on January 29, 2007, 12:37:47 PM

Not currently on this box. Though that is my intent. We have ROR running on FEDORA and I need to consolodate three very unused boxes into one. I would like to be able to run our app (ROR app) in an Ibay as to add a bit more security. Have you be able to get it up and running yet?

Title: MySql Data
Post by: cactus on January 29, 2007, 03:48:18 PM

Quote from: "dws4wdr"

I would like to be able to run our app (ROR app) in an Ibay as to add a bit more security. Have you be able to get it up and running yet?

Do not install applications in ibays, that seems the easiest solution nut is not the savest or optimal way to configure your application. Install them in the /opt or the /var/www directory instead and create the necessary template files for the httpd.conf file.

More information about the templating system can be found in the developer guide: http://mirror.contribs.org/smeserver/contribs/gordonr/devguide/html/book1.htm

Title: MySql Data
Post by: kruhm on February 07, 2007, 02:28:36 AM

@dws4wdr
read the complete thread here:
http://forums.contribs.org/index.php?topic=30166.0

Title: MySql Data
Post by: raem on February 07, 2007, 04:29:22 AM

cactus

> Do not install applications in ibays
> Install them in the /opt or the /var/www directory instead
> and create the necessary template files for the httpd.conf file.

I'm aware of developer recommendation not to install web apps in ibays, but it doesn't meet everyones situations.
Part of the underlying reasoning is to limit potential security issues, and stop end users having easy access to web code etc, where they could introduce security issues in badly written code etc.

In a situation where end users do update web pages directly (by say VPN connections), then ibays is the only practical place to have web apps/sites.
This is particularly so where there are different groups of users administering different sites in different ibays, then Group membership can control who has access to the ibays. Practical access issues override the preferred developer recommendation in these cases. After all ibays were created for this very purpose.

I see developer recommendations more as "the better way of doing things", rather than "must do it this way", and I have had a fair bit of  contact with & received advice from Charlie & Gordon over the years, so I respect them greatly.