WampServer

I still learning how to use this WampServer and Im trying to install Invision Power File Manager but some things im not shore about

Your SQL Environment
SQL driver : mySQL
SQL host : localhost
SQL username : root
SQL password :
SQL database : file_manager
SQL table prefix : ipfm

Your Server Environment
Script directory : C:/wamp/www/
Script URL : [localhost]

Your Admin Account
Username : ********
Password : ********
Password confirmation : ********
Email address : ********


I get this error when I try to submit the above info

Database error
There was an error creating the SQL tables, the error returned was: 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 'sql, dbhost, dbuser, dbpass, dbname, root_url, root_path, user_space, language) ' at line 1

Go back and try again

can some one tell me how to set the SQL username & SQL password, Also?

Hi,

I'm not really familiar with Invision Power File Manager, but for set up permission, you can follows these tips:

Set password:
1. Set password in privilleges in phpMyAdmin.
2. Set password in config.inc.php.

Set the permission to access PHPmyadmin and SQLitemanager (credited to Joshua).

1. open httpd.conf

2. find the lines
# Controls who can get stuff from this server.
#
Order allow,deny
Allow from all
</Directory>

3. after the </directory> line above add the following:

<Directory "C:/Internet/wamp/www/phpmyadmin">
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>

<Directory "C:/Internet/wamp/www/sqlitemanager">
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>

4. change location of the directories as your might be different from "C:/Internet/wamp/www/phpmyadmin"

5. Also in Alias folder (/wamp/Apache2/conf/alias), [this credit to myself ;-) ] replace these lines in phpmyadmin.conf and splitemanager.conf:

Order allow,deny
Allow from all

By these lines:

Order deny,allow
Deny from all
Allow from 127.0.0.1

Remember with this setup, anyone in your LOCAL NETWORK will have permission to access; therefore, if you don't want it that way, you should use .htaccess and .htpasswrd instead.

Hope this help,

yfastud



Post Edited (03-14-06 15:22)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Make sure IBFM is compatable with MySQL 5.0.x . There are some differences between this newest version and older version of MySQL 4.x that can cause this SQL snytax errors.

good post yfastud, I also suggest you add authentication to phpmyadmin so to enter phpmyadmin you must login first, to keep people from getting to your databases.

First, make sure you set the blowfish setting so phpmyadmin can use encryption.

Line 45:
$cfg['blowfish_secret'] = ';

Add some alpha numeric (letters and numbers) text to that setting. For security reasons use 20+ characters. The max length is 46.

Now, to add the authentication to phpmyadmin, change this on line 71:
$cfg['Servers'][$i]['auth_type'] = 'config';

to:
$cfg['Servers'][$i]['auth_type'] = 'cookie';