Page 1 of 1

3 problems Im having with Vault conversion

Posted: Tue Oct 11, 2005 4:23 pm
by wormwood
I have been following the Mini HOWTO for my linux server. I have root access through SSH. MySQL is installed correctly (I run php from databases)

I currently have 3 challanges:

1.) This Line doesnt exists in my "my.cnf" file:

Code: Select all

bind-address=127.0.0.1
2.) When I try to assign the permissions I get:

Code: Select all

mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'38.113.137.7' ;
ERROR 1064: You have an error in your SQL syntax near 'TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'38.113.137.7'' at line 1

mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'war3ft.com' ;
ERROR 1064: You have an error in your SQL syntax near 'TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'war3ft.com'' at line 1
3.) When I try to use the vault.php.. I get 1 of 2 different errors.

First one:

Code: Select all

Warning: move_uploaded_file(d:/websites/war3ft.com/export/10112005181155) [function.move-uploaded-file]: failed to open stream: Permission denied in D:\Websites\war3ft.com\www\vault.php on line 42

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move 'C:\WINDOWS\TEMP\php5EA.tmp' to 'd:/websites/war3ft.com/export/10112005181155' in D:\Websites\war3ft.com\www\vault.php on line 42
Conversion successful. 
--Its not successful though--

Second one:

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '82.165.179.46' (10061) in D:\Websites\wc3mods.net\www\war3ft\vault.php on line 50
Could not connect : Can't connect to MySQL server on '82.165.179.46' (10061)

Any help is appreciated.

Posted: Tue Oct 11, 2005 5:57 pm
by Geesu
you should be using the vault conversion tool on

wc3mods.net/war3ft/

Where did you get the link to the vault conversion tool you used ?

Posted: Wed Oct 12, 2005 12:22 pm
by wormwood
I used the vault conv. link on wc3mods.net website

http://wc3mods.net/war3ft/vault.php

And above are the errors I received

Posted: Wed Oct 12, 2005 12:56 pm
by Geesu
There is no way you did... see the error:

D:\Websites\war3ft.com\www\vault.php

war3ft.com and wc3mods.net are on 2 different servers.... So you used the war3ft.com one.

Use the wc3mods.net one.

Re: 3 problems Im having with Vault conversion

Posted: Fri Oct 14, 2005 1:43 pm
by Lazarus Long
wormwood wrote:1.) This Line doesnt exists in my "my.cnf" file:

Code: Select all

bind-address=127.0.0.1
Just add it, no problem.
wormwood wrote:2.) When I try to assign the permissions I get:

Code: Select all

mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'38.113.137.7' ;
ERROR 1064: You have an error in your SQL syntax near 'TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'38.113.137.7'' at line 1

mysql> GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'war3ft.com' ;
ERROR 1064: You have an error in your SQL syntax near 'TEMPORARY TABLES , LOCK TABLES ON `amxx` . * TO 'amxx'@'war3ft.com'' at line 1
Please post your MySQL version number, it might not support the "CREATE TEMPORARY TABLES" directive, you can remove it from the statement without any problem at all.

Posted: Mon Oct 24, 2005 12:20 pm
by Lazarus Long
No reply from original author within a week.

Locked.

(The original author should PM me to reopen it)