net2ftp Unable to execute the SQL query.

[tunda]

After installing EHCP I logged in, as admin, and chose to "Add new (quick)" a domain. I then logged out and logged back in under the newly created domain. I selected WebFtp (net2ftp) and got the following.

Unable to execute the SQL query.

The error occured in file /var/www/vhosts/ehcp/net2ftp/includes/authorizations.inc.php on line 728.

* function logAccess (/var/www/vhosts/ehcp/net2ftp/main.inc.php on line 213)
* function net2ftp (/var/www/vhosts/ehcp/net2ftp/index.php on line 38)
o argument 0: sendHttpHeaders

I have installed and currently use a previous version of EHCP and did not have this problem. Thanks in advance for your help.

Restored from old drupal forum, for user uid:1267 username:tunda
You may reset your password to access your new account here.

[ehcpdeveloper]

somehow, your installer did not put correct password in net2ftp's configuration file

so,
after installing new ehcp,
if you are not able to use net2ftp,

open file
<code>/var/www/vhosts/ehcp/net2ftp/settings.inc.php

in your server console,
find line with:
<code>$net2ftp_settings["dbpassword"]='';

put correct mysql ehcp user pass in quotes.. your webftp should work hereafter.

i checked the installer again, to see if everything ok; will check again..



Restored from old drupal forum, for user uid:1267 username:tunda
You may reset your password to access your new account here.

[kjameson]

The error occured in file /var/www/vhosts/ehcp/net2ftp/includes/authorizations.inc.php on line 728.
function logAccess (/var/www/vhosts/ehcp/net2ftp/main.inc.php on line 213)
function net2ftp (/var/www/vhosts/ehcp/net2ftp/index.php on line 38)
argument 0: sendHttpHeaders

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[tunda]

I opened
/var/www/vhosts/ehcp/net2ftp/settings.inc.php

and found
$net2ftp_settings["dbpassword"]='xxxxxxxx';

this is the correct password.

after looking at the file I decided to make a change to the following
$net2ftp_settings["use_database"] = "yes"; // "yes" or "no"

I changed the yes to a no and I can now access net2ftp.


Restored from old drupal forum, for user uid:2949 username:kjameson
You may reset your password to access your new account here.

[djanym]

Hello. I have the same issue and in the /var/www/vhosts/ehcp/net2ftp/settings.inc.php there is correct password

Restored from old drupal forum, for user uid:1267 username:tunda
You may reset your password to access your new account here.

[ehcpdeveloper]

can you attache here your settings.inc.php, (after deleting your pass),
i will check..

here is a portion of mine:
<code>$net2ftp_settings["use_database"] = "yes"; // "yes" or "no"
// Enter your MySQL settings
$net2ftp_settings["dbusername"] = "ehcp";
$net2ftp_settings["dbpassword"]='xxxx';
$net2ftp_settings["dbname"] = "ehcp";
$net2ftp_settings["dbserver"] = "localhost"; // on many configurations, this is "localhost"


if you say "no" to use_database, then, you will not be able to use some db features of net2ftp, nevertheless, your net2ftp will work in that case too.

Restored from old drupal forum, for user uid:2968 username:djanym
You may reset your password to access your new account here.

[tunda]

$net2ftp_settings["use_database"] = "no"; // "yes" or "no"

// Enter your MySQL settings
$net2ftp_settings["dbusername"] = "ehcp";
$net2ftp_settings["dbpassword"]='xxxxxxxx';
$net2ftp_settings["dbname"] = "ehcp";
$net2ftp_settings["dbserver"] = "localhost"; // on many configurations, this is "localhost"

of course that was "yes" before

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[ehcpdeveloper]

this net2ftp error is completely fixed in ehcp ver 0.29.13 and later

Restored from old drupal forum, for user uid:1267 username:tunda
You may reset your password to access your new account here.