ProFTPd-Admin icon indicating copy to clipboard operation
ProFTPd-Admin copied to clipboard

Published 20 hours ago • verified publisher icon ChristianBeer

postgres support

Open KristijanL opened this issue 10 years ago • 3 comments

Hi,

any plans to add postgres support?

Best Regards, Kristijan

KristijanL avatar Oct 07 '15 10:10 KristijanL

  • copy https://github.com/ezSQL/ezSQL/blob/master/postgresql/ez_sql_postgresql.php into includes
  • add $cfg['db_type'] == "postgresql" in AdminClass.php und config_example.php
  • adapt the db schema and change proftpd config
  • test

ChristianBeer avatar Oct 14 '15 09:10 ChristianBeer

I also want postgres support, but your file does not work (although it is a good starting point). You cannot insert anything, because you use double quotes for the values (postgres uses single quotes) (ERROR: zero-length delimited identifier at or near """"). Also there are errors like this

SELECT COUNT(*) FROM groups
<b>Warning</b>:  Creating default object from empty value in <b>/srv/www/proftpd-admin/includes/ez_sql_postgresql.php</b> on line <b>242</b>

hellow554 avatar Oct 19 '16 10:10 hellow554

This seems a bit more work than I outlined above. @punkkeks if you really need this get in touch with me and I will take a look at what can be done so mysql and postgres are both supported.

ChristianBeer avatar Nov 12 '16 15:11 ChristianBeer