cannot connect to ftp

[falko]

Originally Posted by denpark

1) could this be the root cause of the problem?

Yes.

Originally Posted by denpark

2) what would cause ftp users from being added to the ftp_users table? if this is empty, then from what table is the ispconfig admin gui getting the information from to display in the gui? it seems there might be a disconnect here.

thanks in advance,
Dennis

Are your database details in /usr/local/ispconfig/server/lib/config.inc.php and /usr/local/ispconfig/interface/lib/config.inc.php correct?

[denpark]

Falko - Thanks for the reply. While I didn't see any obvious mistakes in the details,..there were a few things that I observed. Please see below.

Originally Posted by falko

Yes.

Are your database details in /usr/local/ispconfig/server/lib/config.inc.php and /usr/local/ispconfig/interface/lib/config.inc.php correct?

here is what i am look at in 'usr/local/ispconfig/server/lib/config.inc.php'

starting at line 63

//**Database
$conf['db_type'] = 'mysql';
$conf['db_host'] = 'localhost';
$conf['db_database'] = 'dbispconfig';
$conf['db_user'] = 'ispconfig';
$conf['db_password'] = '~';
$conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")
$conf['db_new_link'] = false;
$conf['db_client_flags'] = 0;


here is what i observed:
i looked at the user table of the running mysql instance db and at the user table for the ispconfig entry. I see that in the ispconfig entry, all the *_priv columns are set to 'N'.


Question --
1) Could that be the problem?
2) How to remedy?
3) where in the setup did I go wrong for it to be this way?

4) is the mysql user that is set in the config -- 'ispconfig' the correct user? I see that root user and the sys maintenance users are the only ones where the _priv columns are set to 'Y'.

Thanks in advance,
Dennis

[till]

1) No, thats not related. The permissions of the ispconfig user are defined in the db table, not the user table. All mysql users that have only access to a specific database like the ispconfig user have their permissions set to "N" in user table and to "Y" in db table.

2) Test the login for the ispconfig mysql user:

mysql -u ispconfig -p dbispconfig

the command will ask you then for password. Please specify the exact password from the config.inc.php file.

4) The user ispconfig is the correct user and the permissions you describe are correct for the ISPCOnfig user. It is required that the priv columns are set to 'N' for the ispconfig user in the user table.

[denpark]

Hi Till - thanks for the response.

I've tried logging into phpmyadmin with the user: ispconfig and was able to successfully login with access to the dbispconfig database.

Any other suggestions?

thanks,
Dennis

[denpark]

As stated in earlier messages - shoudln't the table, ftp_users, be populated with the ftp_user? at least, that is what i observed in the:

/usr/local/ispconfig/server/lib/config.inc.php

file.

so there must be some config gap here -- how to remedy this?

[till]

As the FTP user is missing in the ftp_user table, it must be missing in ispconfig as well. FTP will not work until there is a FTP user, login to ispconfig and create the FTP user again and check if you get any errors displayed, as the FTP user is only created if you dont get a error.

[denpark]

Hi Till -- yes, i do see the ftp users there - that must have been a mistake on my part. I double checked and i do see the user there.

so then how can i troubleshoot this issue of the ftp user not being able to log into the system?

thanks in advance,
Dennis

[till]

Please see ISPConfig FAQ on how to debug pure-ftpd:

http://www.faqforge.com/linux/contro...-debian-linux/

[denpark]

RESOLVED!

after double checking everything, I finally got around to checking my router.

I'm embarrassed to admit it, but seems like it was a firewall problem!

my home router's port was not open for 8080 and the ftp ports. only ssh and 80.

lesson for me - double check the obvious things first! - thanks for your help everyone!