search for: pgpassword

...hat: 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 that IP\r\n" exec "$@" fi CHECK_USER=`PGPASSWORD="somepass" /usr/local/pg950/bin/psql -q -t -U someuser -d maildb -c "select imap_allowed from __users where name = '$USER' LIMIT 1"` if [ $CHECK_USER == "f" ] ; then exit 0 fi if [ $CHECK_USER == "t" ] ; then exec "$@" fi Regards, Jack

...de/imap imap-postlogin : multiple processes are running still) and after some times there are too many processes and the limit is reached (imap proces_limit 1500): 1) #!/bin/sh case $IP in 10.10.1[1-2][0-7].*) exec "$@" ;; 10.11.2.4[0-9]) exec "$@" ;; esac CHECK_USER=`PGPASSWORD="password" /usr/local/pg952/bin/psql -h 10.11.1.3 -q -t -U postfixuser -d mail -c "select imap_allowed from users where name = '$USER' LIMIT 1"` if [ $CHECK_USER == "t" ] ; then exec "$@" fi if [ $CHECK_USER == "f" ] ; then exit 0 fi 2) P...

http://dev.rubyonrails.com/changeset/856 looks to me like it''s not going to work, since there''s no way of specifying a password to pg_dump/dropdb/createdb. If you set PGPASSWORD in your environment it might work, but that''s not documented anywhere and isn''t done automatically in the Rakefile. See http://thread.gmane.org/gmane.comp.lang.ruby.rails/3693 for the discussion we had a couple of weeks back about this. Did anyone try this before it got commi...

...han one web servers) ? > > > > My script: > > > > #!/bin/sh > > if [ "$IP" = "172.11.0.28" ] ; then > > printf "* [ALERT] Access allowed from that IP\r\n" > > exec "$@" > > fi > > > > CHECK_USER=`PGPASSWORD="somepass" /usr/local/pg950/bin/psql -q -t -U > > someuser -d maildb -c "select imap_allowed from __users where name = > > '$USER' LIMIT 1"` > > > > if [ $CHECK_USER == "f" ] ; then > > exit 0 > > fi > > > > if [...

Hi, We are trying to set up a Dovecot Docker image with dynamic database configuration based on environment variables, however the variables do not appear to be expanded in the "connect=" string of the SQL config. The documentation states that environment variables, being listed under global variables, work "everywhere":

...s 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 that IP\r\n" > exec "$@" > fi > > CHECK_USER=`PGPASSWORD="somepass" /usr/local/pg950/bin/psql -q -t -U > someuser -d maildb -c "select imap_allowed from __users where name = > '$USER' LIMIT 1"` > > if [ $CHECK_USER == "f" ] ; then > exit 0 > fi > > if [ $CHECK_USER == "t" ] ; then &g...

Hi everyone. I''m having a bit of a problem with an application I''m currently developing with Rails 1.2.3 and PostgreSQL, attempting to use test-first development. Here''s the scenario: * I have the usual three databases, with migrations. Testing has been working beautifully. * I need to store geographic data, so I add PostGIS to all three databases (along with