RE: ProFTPd & DNS Zone Updating
03-03-2018, 09:23 PM
(This post was last modified: 03-03-2018, 10:17 PM by 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
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
