[Proftpd-user] SQLConnectInfo environment variable substitution

Ian via Proftp-user <[email protected]>
Newsgroups gmane.network.proftpd.user
Message-ID <[email protected]>
re:  https://github.com/proftpd/proftpd/issues/507


The github ticket indicated that it has been fixed in 1.3.7 and also backported to 1.3.6    i am using Postgres +  proftpd 1.3.6 (compiled from scratch) but am still seeing similar issue
2018-02-23 22:11:42,477 mod_sql/4.3[5]: entering        postgres cmd_defineconnection2018-02-23 22:11:42,477 mod_sql/4.3[5]:  name: 'default'2018-02-23 22:11:42,477 mod_sql/4.3[5]:  user: 'file_dataconnect'2018-02-23 22:11:42,478 mod_sql/4.3[5]:  host: 'localhost'2018-02-23 22:11:42,478 mod_sql/4.3[5]:    db: ''2018-02-23 22:11:42,478 mod_sql/4.3[5]:  port: '5432'2018-02-23 22:11:42,478 mod_sql/4.3[5]:   ttl: '120'



2018-02-23 22:12:16,822 mod_sql/4.3[5]: message: 'could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?could not connect to server: Network is unreachable Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

this is my config directive 

SQLConnectInfo                   %{env:DB_NAME}@%{env:DB_HOST}:%{env:DB_PORT} %{env:DB_USER} %{env:DB_PASSWORD} %{env:DB_CONN_DURATION_SECS}

If I replace  %{env:DB_SCHEMA} with a real database name  then everything works as expected.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.