Existing users, 
 CrushSQLPlugin - 1.9use SQL tables for CrushFTP users & user directories |
|
||||||||||||||
|
|||||||||||||||
Feedback Summary:
| This Version: | |||||
| Overall Rating: | Not rated (0.0) | Features: | Not rated (0.0) | Support: | Not rated (0.0) |
| Ease of Use: | Not rated (0.0) | Quality / Stability: | Not rated (0.0) | Price: | Not rated (0.0) |
Key to Types of Feedback:
Reviews 
Troubleshooting 
Usage Tips 
Developer Notes 
Commentary 
Featured Reviews
Instructions (I have just posted these to my website as well) - Version: 1.0, 3/25/2005 12:58PM PST
Ben Spink
Great idea - Version: 1.0, 3/25/2005 07:23AM PST
afterhours
The power of this plugin idea is exciting. Ben, can you document the download and install? Just getting placed into directories, I don't know what you want us to download or how to install it into CrushFTP, nor how to use it within Crush.
thx!
thx!
Most Recent Replies: View All 1 Replies
- Great idea
CrushFTP will need to be able to load the java driver for whatever SQL type you are using. On my plugins page I have the download link for mySQL.
Take the resulting driver's .jar file and place it in the Java path somewhere. I suggest "/System/Library/Java/Extensions/". This is a one time thing. CrushFTP will need to be restarted after this has been done for it to have access to the new .jar file.
mySQL Instructions
1) For mySQL, download these files from my plugin page:
CrushSQLPlugin.class
CrushSQL.properties
userTable.mysql
directoriesTable.mysql
2) Create a database in mySQL...name it something like "crushftp".
3) Use the two table scripts to generate the table structures in the "crushftp" database.
4) Edit the CrushSQL.properties file to match the SQL driver you are using. Also set the correct IP to the server, the correct database name (I currently have it set to "crushftp"), and a valid user/pass.
5) Create a folder in your CrushFTP folder called "plugins". Put the "CrushSQL.properties" file in this folder.
6) Put the "CrushSQLPlugin.class" into the "plugins" folder. If CrushFTP is running, the plugin is loaded instantly on the fly and is available. (If you need to edit the CrushSQL.properties file in the future, you will have to close CrushFTP and re-open it as it only checks this file when the plugin is initially loaded.) The only way CrushFTP lets you know the plugin was loaded is if you run CrushFTP from the command line "java -jar CrushFTP.jar -b".
7) You must have at least one "regular" CrushFTP user in the CrushFTP user manager for CrushFTP versions 3.8.1 and below. Future versions will not require this. So make yourself a user if you don't have one. Maybe make yourself and admin user.
8) Create a record in the users table. Give it a username and password...the rest can be left at their defaults.
9) Create a record in the directories table. The directory's ID must link to a user's ID. For example: ID=1,dirName=MyApps, dirFTPPath=/, dirLocalPath=/Applications/, privDownload=Y, privView=Y (leave the rest at their defaults.)
dirName is the display name CrushFTP will display this item as.
dirFTPPath is the FTP path at which this item should appear. (usually "/")
dirLocalPath is the local directory path this item links to. It MUST end and start with "/". If this is a path on windows it would be like this: "/C:\Program Files\/". If this is MacOS X "/Applications/".
10) Go login with an FTP client and test!