Koozali.org: home of the SME Server

MySql Data

Offline dws4wdr

  • **
  • 25
  • +0/-0
    • Web Design and Graphics
MySql Data
« 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?
David

Offline byte

  • *
  • 2,183
  • +2/-0
MySql Data
« Reply #1 on: January 25, 2007, 07:43:19 PM »
They are normally in /var/lib/mysql
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline kruhm

  • *
  • 680
  • +0/-0
MySql Data
« Reply #2 on: January 28, 2007, 02:16:21 AM »
Do you have ROR running?

Offline dws4wdr

  • **
  • 25
  • +0/-0
    • Web Design and Graphics
MySql Data
« Reply #3 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?
David

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
MySql Data
« Reply #4 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
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline kruhm

  • *
  • 680
  • +0/-0
MySql Data
« Reply #5 on: February 07, 2007, 02:28:36 AM »
@dws4wdr
read the complete thread here:
http://forums.contribs.org/index.php?topic=30166.0

Offline raem

  • *
  • 3,972
  • +4/-0
MySql Data
« Reply #6 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.
...