HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Problem related to How-to Pureftpd-mysql (http://www.howtoforge.com/forums/showthread.php?t=1825)

chris_87 26th December 2005 03:34

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

falko 26th December 2005 14:12

Which MySQL version do you use?
Have you tried to add the user with phpMyAdmin? Do you get the same error there?

chris_87 26th December 2005 17:28

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?

falko 27th December 2005 19:26

Looks as if your MySQL installation has problems with the MD5 function, but I don't know why... :confused:

VayderX 30th December 2005 05:38

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


All times are GMT +2. The time now is 01:45.

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