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, 03: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, 14:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 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, 17: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 17:33.
Reply With Quote
  #4  
Old 27th December 2005, 19:26
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 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, 05: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 12:59
MySQL installing problem n!x Server Operation 7 24th November 2005 09:44
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 22:30
SUSE 10.0. x86-64 mysql problem hobit007 Installation/Configuration 2 21st October 2005 16:51
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 15:56.


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