Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th December 2005, 04:34
chris_87 chris_87 is offline
Junior Member
 
Join Date: Dec 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem related to How-to Pureftpd-mysql

I followed all the steps and most of them are ok, but I've got an error when I input a new virtual user in mysql.
When I insert a new virtual user:
INSERT INTO `ftpd` ( `User` , `status` , `Password` , `Uid` , `Gid` , `Dir` , `ULBandwidth` , `DLBandwidth` , `comment` , `ipaccess` , `QuotaSize` , `QuotaFiles` ) VALUES ( 'test' , '1' , MD5 ( 'testtest' ) , '2001' , '2001' , '/home/test' , '100' , '100' , '' , '*' , '50' , '0' ) ;

It appears on my screen
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( 'testtest' ) , '2001' , '2001' , '/home/test' , '100' , '100'

Anyone would be able to help??

Thanks in advance
Reply With Quote
Sponsored Links
  #2  
Old 26th December 2005, 15:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Which MySQL version do you use?
Have you tried to add the user with phpMyAdmin? Do you get the same error there?
__________________
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 26th December 2005, 18:28
chris_87 chris_87 is offline
Junior Member
 
Join Date: Dec 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The version is mysql-server-4.0.24-10 (I copy and paste from the how-to article), I also try add in phpmyadmin, but it also have error, the 'MD5' is in red, I look for pure-ftpd-mysql readme file, it saids it doesn't support mysql new version. Is it the case?

Last edited by chris_87; 26th December 2005 at 18:33.
Reply With Quote
  #4  
Old 27th December 2005, 20:26
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Looks as if your MySQL installation has problems with the MD5 function, but I don't know why...
__________________
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 30th December 2005, 06:38
VayderX VayderX is offline
Junior Member
 
Join Date: Dec 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I had that problem too but removing the space in the command , MD5 ( 'testpw' ) to , MD5( 'testpw' ) , seemed to fix it..
__________________
Vayder X

Downtempo.Breakbeat.Electronica
http://www.vayderx.com
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
MySQL problem on install badben Installation/Configuration 12 20th December 2005 13:59
MySQL installing problem n!x Server Operation 7 24th November 2005 10:44
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 23:30
SUSE 10.0. x86-64 mysql problem hobit007 Installation/Configuration 2 21st October 2005 17:51
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37


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


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