OK I got it to talk to MySQL.

Now when I login, using the only login in the DB it tells me login
failed. Here is the error log:

Mar 12 12:09:47 mod_sql/4.2.1[302]: defaulting to 'mysql' backend
Mar 12 12:09:47 mod_sql/4.2.1[302]: backend module 'mod_sql_mysql/4.05'
Mar 12 12:09:47 mod_sql/4.2.1[302]: backend api 'mod_sql_api_v2'
Mar 12 12:09:47 mod_sql/4.2.1[302]: >>> sql_sess_init
Mar 12 12:09:47 mod_sql/4.2.1[302]: entering mysql cmd_defineconnection
Mar 12 12:09:47 mod_sql/4.2.1[302]: name: 'default'
Mar 12 12:09:47 mod_sql/4.2.1[302]: user: 'proftp'
Mar 12 12:09:47 mod_sql/4.2.1[302]: host: '208.53.37.98'
Mar 12 12:09:47 mod_sql/4.2.1[302]: db: 'proftp'
Mar 12 12:09:47 mod_sql/4.2.1[302]: port: '3306'
Mar 12 12:09:47 mod_sql/4.2.1[302]: ttl: '0'
Mar 12 12:09:47 mod_sql/4.2.1[302]: exiting mysql cmd_defineconnection
Mar 12 12:09:47 mod_sql/4.2.1[302]: entering mysql cmd_open
Mar 12 12:09:47 mod_sql/4.2.1[302]: connection 'default' opened
Mar 12 12:09:47 mod_sql/4.2.1[302]: connection 'default' count is now 1
Mar 12 12:09:47 mod_sql/4.2.1[302]: exiting mysql cmd_open
Mar 12 12:09:47 mod_sql/4.2.1[302]: backend successfully connected.
Mar 12 12:09:47 mod_sql/4.2.1[302]: mod_sql engine : on
Mar 12 12:09:47 mod_sql/4.2.1[302]: negative_cache : off
Mar 12 12:09:47 mod_sql/4.2.1[302]: authenticate : users
Mar 12 12:09:47 mod_sql/4.2.1[302]: usertable : users
Mar 12 12:09:47 mod_sql/4.2.1[302]: userid field : username
Mar 12 12:09:47 mod_sql/4.2.1[302]: password field : password
Mar 12 12:09:47 mod_sql/4.2.1[302]: uid field : NULL
Mar 12 12:09:47 mod_sql/4.2.1[302]: gid field : NULL
Mar 12 12:09:47 mod_sql/4.2.1[302]: homedir(default) :
'/opt/lampp/htdocs/fddhosting.com'
Mar 12 12:09:47 mod_sql/4.2.1[302]: shell field : NULL
Mar 12 12:09:47 mod_sql/4.2.1[302]: homedirondemand : false
Mar 12 12:09:47 mod_sql/4.2.1[302]: SQLMinUserUID : 999
Mar 12 12:09:47 mod_sql/4.2.1[302]: SQLMinUserGID : 999
Mar 12 12:09:47 mod_sql/4.2.1[302]: <<< sql_sess_init
Mar 12 12:09:52 mod_sql/4.2.1[302]: >>> sql_pre_pass
Mar 12 12:09:52 mod_sql/4.2.1[302]: <<< sql_pre_pass
Mar 12 12:09:52 mod_sql/4.2.1[302]: >>> cmd_getpwnam
Mar 12 12:09:52 mod_sql/4.2.1[302]: entering mysql cmd_escapestring
Mar 12 12:09:52 mod_sql/4.2.1[302]: exiting mysql cmd_escapestring
Mar 12 12:09:52 mod_sql/4.2.1[302]: cache miss for user 'abarrett'
Mar 12 12:09:52 mod_sql/4.2.1[302]: : entering mysql cmd_select
Mar 12 12:09:52 mod_sql/4.2.1[302]: entering mysql cmd_open
Mar 12 12:09:52 mod_sql/4.2.1[302]: connection 'default' count is now 2
Mar 12 12:09:52 mod_sql/4.2.1[302]: exiting mysql cmd_open
Mar 12 12:09:52 mod_sql/4.2.1[302]: query "SELECT username, password
FROM users WHERE (username=3D'abarrett') LIMIT 1"
Mar 12 12:09:52 mod_sql/4.2.1[302]: entering mysql cmd_close
Mar 12 12:09:52 mod_sql/4.2.1[302]: connection 'default' count is now 1
Mar 12 12:09:52 mod_sql/4.2.1[302]: exiting mysql cmd_close
Mar 12 12:09:52 mod_sql/4.2.1[302]: exiting mysql cmd_select
Mar 12 12:09:52 mod_sql/4.2.1[302]: cache miss for user 'abarrett'
Mar 12 12:09:52 mod_sql/4.2.1[302]: user 'abarrett' cached
Mar 12 12:09:52 mod_sql/4.2.1[302]: + pwd.pw_name : abarrett
Mar 12 12:09:52 mod_sql/4.2.1[302]: + pwd.pw_uid : 65533
Mar 12 12:09:52 mod_sql/4.2.1[302]: + pwd.pw_gid : 65533
Mar 12 12:09:52 mod_sql/4.2.1[302]: + pwd.pw_dir :
/opt/lampp/htdocs/fddhosting.com
Mar 12 12:09:52 mod_sql/4.2.1[302]: + pwd.pw_shell :
Mar 12 12:09:52 mod_sql/4.2.1[302]: <<< cmd_getpwnam
Mar 12 12:09:52 mod_sql/4.2.1[302]: >>> cmd_auth
Mar 12 12:09:52 mod_sql/4.2.1[302]: entering mysql cmd_escapestring
Mar 12 12:09:52 mod_sql/4.2.1[302]: exiting mysql cmd_escapestring
Mar 12 12:09:52 mod_sql/4.2.1[302]: cache hit for user 'abarrett'
Mar 12 12:09:52 mod_sql/4.2.1[302]: >>> cmd_check
Mar 12 12:09:52 mod_sql/4.2.1[302]: checking auth_type Plaintext
Mar 12 12:09:52 mod_sql/4.2.1[302]: 'Plaintext' auth handler reports succe=
ss
Mar 12 12:09:52 mod_sql/4.2.1[302]: cache hit for user 'abarrett'
Mar 12 12:09:52 mod_sql/4.2.1[302]: <<< cmd_check
Mar 12 12:09:52 mod_sql/4.2.1[302]: <<< cmd_auth
Mar 12 12:10:09 mod_sql/4.2.1[302]: entering mysql cmd_exit
Mar 12 12:10:09 mod_sql/4.2.1[302]: entering mysql cmd_close
Mar 12 12:10:09 mod_sql/4.2.1[302]: connection 'default' closed
Mar 12 12:10:09 mod_sql/4.2.1[302]: connection 'default' count is now 0
Mar 12 12:10:09 mod_sql/4.2.1[302]: exiting mysql cmd_close
Mar 12 12:10:09 mod_sql/4.2.1[302]: exiting mysql cmd_exit

I don't assign UID or GID, could that be a problem?



On Wed, Mar 12, 2008 at 12:07 PM, Jorge Bastos wr=
ote:
> Do you have a running socket for mysql on:
>
> /var/run/mysqld/mysqld.sock ?
>
>
>
>
>
>
>
> -----Original Message-----
> From: proftp-user-bounces@lists.sourceforge.net
> [mailtoroftp-user-bounces@lists.sourceforge.net] On Behalf Of Adam Ba=

rrett
> Sent: quarta-feira, 12 de Mar=E7o de 2008 17:45
> To: proftp-user@lists.sourceforge.net
> Subject: [Proftpd-user] Not Seeing MySQL
>
> My FTP error log is showing that I am not able to connect to MySQL
> through the sock
>
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: defaulting to 'mysql' backend
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: backend module 'mod_sql_mysql/4.0=

5'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: backend api 'mod_sql_api_v2'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: >>> sql_sess_init
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: entering mysql cmd_defineconnect=

ion
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: name: 'default'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: user: 'proftp'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: host: 'localhost'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: db: 'proftp'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: port: '3306'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: ttl: '0'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: exiting mysql cmd_defineconnect=

ion
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: entering mysql cmd_open
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: exiting mysql cmd_open
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: unrecoverable backend error
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: error: '2002'
> Mar 12 11:36:48 mod_sql/4.2.1[32500]: message: 'Can't connect to local
> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
>
> I don't know why that is?
>
> When I connect to mysql through my command line the login works just fi=

ne...
>
> I did notice that the error log states trying to use
> /var/run/mysqld/mysld.sock
>
> That is not where it is on my server. Can I change this in ProFTPd
> somewhere?
>
> --
> Adam Barrett
> dragen@gmail.com
>
> -----------------------------------------------------------------------=

--
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> ProFTPD Users List
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html
>
>
> -----------------------------------------------------------------------=

--
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> ProFTPD Users List
> Unsubscribe problems?
> http://www.proftpd.org/list-unsub.html
>




--
Adam Barrett
dragen@gmail.com



-- =

Adam Barrett
dragen@gmail.com

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
ProFTPD Users List
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html