Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th June 2013, 13:01
gabri231 gabri231 is offline
Junior Member
 
Join Date: Jun 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to connect PureFTP to a remote MySQL

I did followed the instruction in here....

Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On OpenSUSE 11.2

but pureftpd is not able to connect to my MySQL Box. My MySQL server is in different server so I modified the pureftd conf files as follow.

#cat /etc/pure-ftpd/db/mysql.conf
#MYSQLSocket /var/run/mysqld/mysqld.sock
MYSQLServer 192.168.1.62
MYSQLPort 3306
MYSQLUser pureftpd
MYSQLPassword ftpdpass
MYSQLDatabase pureftpd
#MYSQLCrypt md5, cleartext, crypt() or password() - md5 is VERY RECOMMENDABLE uppon cleartext
MYSQLCrypt md5
MYSQLGetPW SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetUID SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetGID SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetDir SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTAFS SELECT QuotaFiles FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")



# mysql -u pureftpd -p -h 192.168.1.62
Enter password:
ERROR 1045 (28000): Access denied for user 'pureftpd'@'mysql' (using password: YES)
root@web1:/home/administrador# mysql -u pureftpd -p -h 192.168.1.62
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 99
Server version: 5.5.31-0ubuntu0.12.04.2 (Ubuntu)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use pureftpd
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
-> ;
+--------------------+
| Tables_in_pureftpd |
+--------------------+
| ftpd |
+--------------------+
1 row in set (0.00 sec)

mysql>


I dont know what is happening
Can somebody helpme please, i searched so time
Reply With Quote
Sponsored Links
  #2  
Old 4th June 2013, 13:25
gabri231 gabri231 is offline
Junior Member
 
Join Date: Jun 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

OK!! the problem was solved

I didn't connect with a ftp client program, because the users were not created.

If you create a user, to see /home/userftp you must login with ftp to create the personal directory.

Thanks and sorry for my english
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Debian 5.0 -ISPConfig 3 install - Unable to connect to mysql server anushanw Installation/Configuration 6 24th November 2013 17:41
MySQL Error Nolan Installation/Configuration 12 16th February 2011 02:15
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 10:05
Mail Question: installed smf forum on centos perfect server setup with ispconfig happz Installation/Configuration 7 22nd August 2008 13:15
MySQL problem satimis Server Operation 5 25th June 2008 15:41


All times are GMT +2. The time now is 12:35.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.