similar to: case-blinding db table and column names

I''m looking for the cleanest way to force the Rails framework to use a lower-case version of the table and column names in a database when creating records. I need this for a Rails application that displays the status of an existing backup system. The backup system (Bacula; Nice backup system, BTW) can use either Postgres or Mysql as its database engine. Unfortunately, the table and

Hi I''m building a Rails app that intereacts with several legacy databases, all on Postgres 7.4 and running into a few quirky problems. I seem to have a lot of inconsistencies w/ quoting field names in Postgres. I''ve written another app from scratch using Postgres and encountered quoting trouble there too. But it seemed tied to the machine I was serving the app from.

On Wed, 2018-09-19 at 08:55 +0200, Alessandro Baggi wrote: > Il 18/09/2018 17:14, Gordon Messmer ha scritto: > > On 9/17/18 11:38 PM, Alessandro Baggi wrote: > > > Il 17/09/2018 22:12, Gordon Messmer ha scritto: > > > > That doesn't look right.? It should look more like 1) stop or > > > > freeze? > > > > all of the services (httpd and

Dear all, I get a message from root as follows; 09-Feb 11:26 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula". 09-Feb 11:26 bacula-dir JobId 0: Fatal error: postgresql.c:227 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 09-Feb 11:26

Hi everyone, I''ve been working on a module for bacula, and I''m having a problem requiring resources I''ve defined in other modules. At the moment, I have the following (simplified): /etc/puppet/modules/bacula/manifests/init.pp: class bacula { ... define configure ( $gui="true", $db_password ) { ... postgresql::create_db {

Hello list, I am soliciting opinion here as opposed technical help with an idea I have. I've setup a bacula backup system on an AWS volume. Bacula stores a LOT of information in it's mysql database (in my setup, you can also use postgres or sqlite if you chose). Since I've started doing this I notice that the mysql data directory has swelled to over 700GB! That's quite a lot and

You were doing this (looking at the mysql.db table) on your "db.example.com" machine, correct? ------------ Original Message ------------ > Date: Saturday, August 15, 2015 19:32:25 -0400 > From: Tim Dunphy <bluethundr at gmail.com> > To: CentOS mailing list <centos at centos.org> > Subject: Re: [CentOS] wordpess can't connect to DB but mediawiki can >

If the ::1 ipv6 loopback entry is missing in pg_hba.conf rake db:migrate will fail rake aborted! FATAL: no pg_hba.conf entry for host "::1", user "ovirt", database "ovirt_development", SSL off --- installer/modules/ovirt/manifests/postgres.pp | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git

Hi Richard, I actually made some progress on this. The problem was SSL. Once I I took the SSL requirement out of the picture for the user everything worked. The test php script and the wordpress site both. Originally when I setup my wiki it NEEDED SSL. Because there was some sensitive data in it. My website, however, is just a goofball toy project of mine. And doesn't really need that. But

I''ve followed the tutorial and just don''t get it. How do I connect my ruby/rails sample app to my postgres database. I did follow step 1-4 of the tutorial, I go to step 5: (http://wiki.rubyonrails.org/rails/pages/TutorialStepFive) and try the "rake" commmand and get this: rake aborted! no such file to load -- postgres so I ran with -trace and get this:

> > "Use" that db and then issue: > select * from db where Db='jfwiki' or Db='jokefire' order by Host; Well yeah. I used the mysql database before I issued that command. MariaDB [(none)]> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Then if I

My ruby app always created the databases on postgres just fine, but, a days ago, I''ve tried to create a new project and when I execute the command "db:create:all" i got the following error: Couldn''t create database for {"encoding"=>"unicode", "username"=> "-my username-", "adapter"=>"postgresql",

I''ve got a MySQL app, which I''m moving to a new server which is using Postgres. This seems like the perfect application of migrations. (Note: I don''t mean "using migrations to switch from MySQL to Postgres" so much as "Hey, I''ve _been_ using migrations all along, and this is where I cash in".) There were some odd bugs when working with the

My Rails App makes quite a few calls (all different queries) to our Postgres DB. Each time I make a find_by_sql method call, a connection opens and then stays idle. Of course, after 500 or so of these idle postgres processes running, the DB refuses to let me make any more (and I can''t really add more to the postgres.conf). How do I make sure these connections get closed after each query?

> > You were doing this (looking at the mysql.db table) on your > "db.example.com" machine, correct? db.example.com is a load balanced VIP. The VIP is being handled by keepalived and HA/Proxy. There are two DB's setup in master/master replication. The two databases and two load balancers are on AWS. The web server and varnish servers are on digital ocean. I setup a grant

I am using active record sessions and everything works fine. I am integrating it with phpbb however so i need some extra fields populated in the session table. In application.rb i put a before_filter to update the session table I have a model for the sessions $ more app/models/session.rb class Session < ActiveRecord::Base set_primary_key "session_id" set_table_name

How to empty DB in heroku<http://stackoverflow.com/questions/4820549/how-to-empty-db-in-heroku> I have a Postgres database on Heroku. It is one of the free beta ones. Locally, when testing, I often run rake db:drop && rake db:create && rake db:migrate as a way to reset the database. However, when I try to run this on Heroku, I get the error:\[code\]Couldn''t drop

I need to do some precise math, going to 12-14 decimal places, so I''m using BigDecimal. How can I store this in a db? I''m using postgresql 8.1.0, if that matters at all. I found a plugin [1] but it gives me the error "You have a nil object when you didn''t expect it! The error occurred while evaluating nil.each_pair," with no line number. The plugin itself

After browsing "Remote timing attacks are practical" (Boneh & Brumley, <http://crypto.stanford.edu/~dabo/abstracts/ssl-timing.html>), I wonder if it might be a good idea to add calls to RSA_blinding_on() before the OpenSSL RSA decryption routines are invoked. The issue is not a LAN-only issue, BTW. Packet delay variation is usually higher in LANs than in WANs. -- Florian

I''m not sure if it''s due to setting up multiple mongrel servers and proxying them with lighty, but something is keeping postgres connections around. I only have a couple Rails apps running on a new server, with not a whole lot of traffic, yet today I actually maxed out my connection limit of 100 for postgres. How do I turn off persistent connections in Mongrel? Joe --