similar to: cant install psql adapter for rails 2.0

It''s one of those things that seems like it should work but does not. My rails app (and ''rails console'') clearly knows where my data is as I can see my data. When I run ''rails dbconsole'' I can not get in, I get this error: Couldn''t find database client: psql. Check your $PATH and try again. Up to now I just log in to pgsql directly and I am

FIXME this patch isn't complete, still need to figure out the ldap command to wait for that service, something along the lines of: ldapsearch -b dc=priv,dc=ovirt,dc=org -x (but how will we parse the base from the installer? also this cmd fails, how to fix?) --- installer/modules/ovirt/manifests/ovirt.pp | 8 +++++- installer/modules/ovirt/manifests/postgres.pp | 13 ++++++---

hello list, yesterday i installed a fresh rails installation with a proper upgrade of gem to version 1.0.1 i saw, there is still a gem package to support postgresql known as postgres-0.7.9.2008.01.09 on rubyforge, its the newest one of stable postgres support for ruby additionally i installed, of course, a the postgres database on my machine to C:\Programme\PostgreSQL\8.2 after setting up a new

am in a bit of a quandry... I have asked postgresql-users list and haven''t gotten anything to work with... > > How do I change the owner of a schema? > > > > ALTER SCHEMA "public" OWNER to "some_user"; #? > > http://www.postgresql.org/docs/current/interactive/sql-alterschema.html > > The docs explain this very situation. HTML

Hello, When I try to run "rake clone_structure_to_test" on my project, I get the following errors: $ rake clone_structure_to_test (in /home/www/cedscreening) psql:db/development_structure.sql:8: ERROR: permission denied to set session authorization psql:db/development_structure.sql:16: ERROR: permission denied for schema public psql:db/development_structure.sql:34: NOTICE: CREATE

hi, Im running the following sql statment which returns 1 result. pSql = "SELECT sum(amount) FROM payments WHERE expected_pay_date LIKE ''"+pWholeDate+"%'' AND invoice_id IS null " aResult = Payment.find_by_sql(pSql) how can I get the result of this? (when doing @aResult.inspect it

Hello, I would like to find a few to use files available in a module for the execution of a particular resource, without having to stage the file explicitly onto the client and possibly having to clean it up afterwards. (This could also apply to content coming from templates.) The use-cases I have in mind are: running a SQL file (to set up some content in a database), extracting an archive

i have installed database POSTGRESQL for storing call details. when i restart database i get the error. [root at localhost server]# psql -h 127.0.0.1 -U asterisk Password psql: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? THIS IS MY /VAR/LIB/PGSQL/DATA/POSTGRESQL.CONF # CONNECTIONS AND

ok, so I removed the default postgresql install and installed it from the software collections.. following the instructions at https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ and I get this [root at home1p /home/jason]$scl enable rh-postgresql95 bash [root at HOME1P jason]# postgresql-setup --initdb * Initializing database in

Hi I have the following code, which makes use of an sql statment to get the results required. However this just doesnt seem right for rails, as ive managed to develop the whole project without using any other pure sql. Is there a cleaner way of doing this, but gaining the same results. thanks scott #sql to find all invoices pSql = "SELECT DISTINCT invoices.id,

hi friends, i had installed postgres database for call log,call detail. it has restarted succesfully but when i check tcp connection i dont get any welcome message by psql. [root at localhost ~]# # psql -h 127.0.0.1 -U asterisk password [root at localhost ~]# th in advance. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Because my problem involves the RdbiPgSQL package, I sent a message similar to this one to the Bioconductor list. But while awaiting moderator approval of my message (because I am not a member of that list), it occurred to me to send it to R-help as the problem may be more general than just RdbiPgSQL. Here's my situation: I have been using RdbiPgSQL successfully for a year or two. I

Hello, I have tried to install the salted hash login generator by following the quick start guide at: http://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart. Everything seems to work fine until I try to run the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in

On Sat, 26 Aug 2017 18:35:31 -0700 Ira Sharenow via R-help <r-help at r-project.org> wrote: Can you access the postgres database through psql or some other route? Also, do you require a password to access the database from these alternatives? JWDougherty

Hi List Apologies if this isn''t the correct place for this query (I''ve tried a search of the mail archives but not had much joy). I''m running R (2.14.0) on a Mac (OSX v 10.5.8, 2.66GHz, 4GB memory) and am having a few performance issues with reading data in from a Postres database (using RPostgreSQL). My query / code are as below # -----------------------------

I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the following error appears..: Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so

http://dev.rubyonrails.org/ticket/1117 I''ve attached a patch to ticket 1117 which fixes it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of

I have a shell script (sh) where I create a user and import data to a postgres database <snip> su -c "createuser -A -D -P $PG_user" postgres su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql " postgres </snip> when the script executes those command, it ask for a password, how could I do this without have to enter the passwd, I would like that

Hi, I would like to prepare postlogin a script that allow imap connection to roundcube for all but restrict imap access for selected users. My question is that: Is possible in condition IF use IP addresses as range or with mask (because I've more than one web servers) ? My script: #!/bin/sh if [ "$IP" = "172.11.0.28" ] ; then printf "* [ALERT] Access allowed from

I am currently facing the following log output: Apr 26 16:40:28 h2290750 dovecot: auth: Error: pgsql(localhost): Connect failed to database mail: could not connect to server: Permission denied Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011Is the server running on host "localhost" (::1) and accepting Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011TCP/IP connections on port 5432?