#1  
Old 2nd June 2006, 18:22
Tortanick Tortanick is offline
Member
 
Join Date: Mar 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default Pureftpd exit 252

Whenever I start pureftpd useing MySQL it imediately responds with exit 252 <my startup command>

How can I fix this or at least work out whats causeing this?

P.S. I compiled pureftpd from source and start it with
Code:
sudo /usr/local/sbin/pure-ftpd -switches -l mysql:/ect/pureftpd/mysql.conf &
Reply With Quote
Sponsored Links
  #2  
Old 3rd June 2006, 14:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Is MySQL running? What's in /ect/pureftpd/mysql.conf?
Any errors in your log files?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 3rd June 2006, 21:45
Tortanick Tortanick is offline
Member
 
Join Date: Mar 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I got mysql-server, mysql-client and libMySQLclient12-dev client form the ubuntu repositories (probobly some dependencies too). and I can log in to MySQL and make databases, but I don't know the command to check if a program is running.

I couldn't see any room for improvement on the mysql.conf in your guide so I stuck with that.

I can give you the mysql.bin.##### logs if you want but I don't seem to have any pure-ftpd logs

Last edited by Tortanick; 3rd June 2006 at 21:51.
Reply With Quote
  #4  
Old 3rd June 2006, 21:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

Quote:
Originally Posted by Tortanick
I got mysql-server, mysql-client and libMySQLclient12-dev client form the ubuntu repositories (probobly some dependencies too). and I can log in to MySQL and make databases, but I don't know the command to check if a program is running.
Do you see it when you run
Code:
netstat -tap
?

Quote:
Originally Posted by Tortanick
I couldn't see any room for improvement on the mysql.conf in your guide so I stuck with that.
Do you use Debian on your system?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 3rd June 2006, 22:20
Tortanick Tortanick is offline
Member
 
Join Date: Mar 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yeah its their, tcp 0 0 localhost:mysql *:* LISTEN -


And I use Ubuntu server edition.
Reply With Quote
  #6  
Old 3rd June 2006, 22:29
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,721 Times in 2,562 Posts
Default

And your /etc/pure-ftpd/db/mysql.conf looks like this?

Code:
MYSQLSocket      /var/run/mysqld/mysqld.sock
#MYSQLServer     localhost
#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")
Does /var/run/mysqld/mysqld.sock exist?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 3rd June 2006, 22:32
Tortanick Tortanick is offline
Member
 
Join Date: Mar 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes to both, and I tried modifying the file to use TCP rather than the socket

Last edited by Tortanick; 3rd June 2006 at 22:38.
Reply With Quote
  #8  
Old 4th June 2006, 10:52
Tortanick Tortanick is offline
Member
 
Join Date: Mar 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Ok this is embaressing but I figured out the problem: typo.

Sorry to waste your time and thanks for all the help
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
postfix auth problem (sasl) lerra Installation/Configuration 40 10th May 2006 23:36
pureftpd and TLS unkn0wn Server Operation 5 14th April 2006 09:09
Can't receive mail burtathis Installation/Configuration 18 23rd March 2006 17:23
Trouble FTP'ing on Virtual Hosting with PureFTPD bluegrass Server Operation 1 17th February 2006 09:38
PHP version... ctroyp Installation/Configuration 102 10th November 2005 13:24


All times are GMT +2. The time now is 21:53.


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