ProFTPd & DNS Zone Updating

[Andy11548]

Hello All,

I've currently got an issue after upgrading my MySQL to a later version due to vulnerabilities in the version I had installed.

I'm just wondering what updates the ProFTPd Database from the Sentora Database and what generates the Zone files for the DNS as these two components aren't working anymore. - Once I know how this works, I should be able to resolve the issues I'm having.



Kind Regards,
Andy

[Me.B]

Not quite sure how we can help.

Proftpd use a database for users access. Did you check logs for errors already?

MySQL release you are using now?

M B

[Andy11548]

Hello Me.B,


I'm currently using mysql  Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using  EditLine wrapper

----- UPDATE -----

Ok, so I've just manually run the daemon and I appear to be having errors which is probably why these aren't working correctly. The current error I have is:

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sentora_core.x_dns.dn_id_pk' which is not functionally dependent on columns in G' at line 1

----------------------

When I use the web interface to create a new FTP account, I can see it in the x_ftpaccounts table inside the sentora_core database but they're not appearing in ftpuser in the sentora_proftpd database. - Which file is meant to put it into the ftpuser table?

As for the DNS side of things, the Website is showing the DNS records, but it's not creating the zones on the server.

In regards to the logs, which logs should I look in? I can't see anything in the bind logs or proftpd logs that would indicate a problem.

I've just done some further testing and when I try and add a new DNS record, I get HTTP Error 500 but there isn't anything showing in any of the below logs for Sentora:

ErrorLog "/var/sentora/logs/sentora-error.log"
CustomLog "/var/sentora/logs/sentora-access.log" combined
CustomLog "/var/sentora/logs/sentora-bandwidth.log" common