Author Topic: mod_conf_sql: Can't use module to store configuration in Postgresql  (Read 1014 times)

Offline Roman Grekov

  • New user
  • *
  • Posts: 1
    • View Profile
HI
I use proftpd + mod_sql + mod_sql_postgres + mod_conf_sql.
I can add users to my postgres db and everything is Ok, but I can't use mod_conf_sql to store limit like this:
Code: [Select]
<IfUser default>
  <Limit LOGIN>
    Order allow, deny
    Allow from 192.168.x.x
    DenyAll
  </Limit>
</IfUser>

I've compiled proftpd with all needed modules. Created all needed tables in DB. Addded code to proftp.conf:
Code: [Select]
<IfModule mod_conf_sql.c>
Include sql://user:password@localhost/db:proftp/ctxt:ftpctxt:id,parent_id,name,value/conf:ftpconf:id,name,value/map:ftpmap:conf_id,ctxt_id
</IfModule>
to tell proftpd where to get additional options, but
Proftpd show me an error:
Code: [Select]
warning: unable to include 'sql://user:password@localhost/db:proftp/ctxt:ftpctxt:id,parent_id,name,value/conf:ftpconf:id,name,value/map:ftpmap:conf_id,ctxt_id': Bad file descriptorI check manually if I can connect to DB with this credentials and it works, but proftpd still can't include it.
If anyone have worked with it, please advice