Sql setting server

Discussion in 'ISPConfig 3 Priority Support' started by DavideR, Feb 12, 2019.

  1. DavideR

    DavideR Member HowtoForge Supporter

    tcp6 0 0 [::]:mysql [::]:* LISTEN 807/mysqld

    this is the output
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That's ok. Did you enable remote access now in the db settings, does your application work now?
     
  3. DavideR

    DavideR Member HowtoForge Supporter

    Connection failed: Access denied for user 'user'@'fqdn.server' (using password: YES)
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Is the IP 127.0.0.1 in /etc/hosts connected with 'localhost'? Not that it is connected with 'fqdn.server'.
     
  5. DavideR

    DavideR Member HowtoForge Supporter

    this is:


    127.0.0.1 localhost

    internalIP PublicFQDN HOSTNAME
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Are you sure TCP/IP v6 connectivity is set up properly? Have you verified it does work?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    That should be fine. To sum it up, the mysql login works fine, as tested with the mysql command, so the user and database created by ispconfig is ok. Your application seems to connect to a different host than localhost, at least the mysql error implies that, and that's probably why the login from your application to mysql fails, maybe your application still even connects to another server? Maybe Florian from Business support should check that by remote login for you, this might be way faster the do further guessing here in the forum.
     
  8. DavideR

    DavideR Member HowtoForge Supporter

    to get rid of the doubt now I move a working site on another host and I see that mistakes brings me.
    I would not want there to be something in the current one that does not work
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Does logging in with this user and password through phpmyadmin work?
     
  10. DavideR

    DavideR Member HowtoForge Supporter

    yes under phpmyadmin i can connect from everywhere.
    now i can't connect in ftp under my local lan.
    there's a way to open Ftp with username password without TLS?
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    FTP is open with and without TLS by default.
     
  12. DavideR

    DavideR Member HowtoForge Supporter

    HI,
    sorry for delay but in these days I can't working on server.
    I've solved all problem and generate some site working perfectly. the only issues is around ftpd service that stop working.
    This server is on DMZ.
    by command
    tail -f /var/log/syslog | grep pure-ftpd
    I get this error
    Feb 25 12:38:31 cloud pure-ftpd: (?@PUBLIC_IP_OF_SERVER) [INFO] New connection from PUBLIC_IP_OF_SERVER

    Feb 25 12:38:31 cloud pure-ftpd: (?@PUBLIC_IP_OF_SERVER) [ERROR] TLS renegociation

    Feb 25 12:38:36 cloud pure-ftpd: (?@PUBLIC_IP_OF_SERVER) [INFO] New connection from PUBLIC_IP_OF_SERVER

    Feb 25 12:38:36 cloud pure-ftpd: (?@PUBLIC_IP_OF_SERVER) [ERROR] TLS renegociation

    where i can find the problem?
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe your FTP client tries to enforce TLS 1.3 which is not supported by pure-ftpd yet?
     
  14. DavideR

    DavideR Member HowtoForge Supporter

    I'm on Macos Mojave and use filezilla ftp client,
    From one minute to the next I've Lost the function, it's possible?
    No update or similar
     
  15. DavideR

    DavideR Member HowtoForge Supporter

    Hi,
    without tls Filezille stop on read folder and get error impossible to read folder
     
  16. till

    till Super Moderator Staff Member ISPConfig Developer

    Does filezilla show a connect log, if yes, may you please post that connect log.
     
  17. DavideR

    DavideR Member HowtoForge Supporter

    This is with TLS
    Stato: Risoluzione dell'indirizzo IP test.rizzus.tech in corso

    Stato: Connessione a IPPUBLIC:21...

    Stato: Connessione stabilita, in attesa del messaggio di benvenuto...

    Stato: Inizializzazione TLS in corso...

    Stato: Verifica del certificato in corso...

    Stato: Connessione TLS stabilita.

    Comando: USER

    Errore: Errore GnuTLS -110: The TLS connection was non-properly terminated.

    Stato: Il server non ha correttamente chiuso la connessione TLS

    Errore: Impossibile collegarsi al server

    Stato: In attesa di un nuovo tentativo...
     
  18. DavideR

    DavideR Member HowtoForge Supporter

    This without TLS
    Stato: Risoluzione dell'indirizzo IP ghost.rizzus.tech in corso

    Stato: Connessione a IP:21...

    Stato: Connessione stabilita, in attesa del messaggio di benvenuto...

    Stato: Accesso effettuato

    Stato: Lettura elenco cartelle...
    60second

    Comando: PWD

    Risposta: 257 "/" is your current location

    Comando: TYPE I

    Risposta: 200 TYPE is now 8-bit binary

    Comando: PASV

    Risposta: 227 Entering Passive Mode (80,91,63,203,94,166)

    Comando: MLSD

    Errore: Timeout connessione dopo 20 secondi di inattività

    Errore: Non è stato possibile leggere il contenuto della cartella
     
  19. till

    till Super Moderator Staff Member ISPConfig Developer

  20. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page