3 problems Im having with Vault conversion

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Locked
wormwood
Peon
Posts: 21
Joined: Thu Aug 18, 2005 10:07 pm

3 problems Im having with Vault conversion

Post by wormwood » Tue Oct 11, 2005 4:23 pm

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.

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Tue Oct 11, 2005 5:57 pm

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 ?
No Support via PM

wormwood
Peon
Posts: 21
Joined: Thu Aug 18, 2005 10:07 pm

Post by wormwood » Wed Oct 12, 2005 12:22 pm

I used the vault conv. link on wc3mods.net website

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

And above are the errors I received

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Wed Oct 12, 2005 12:56 pm

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.
No Support via PM

User avatar
Lazarus Long
Lead PITA SOB
Posts: 618
Joined: Tue Jul 05, 2005 9:24 pm

Re: 3 problems Im having with Vault conversion

Post by Lazarus Long » Fri Oct 14, 2005 1:43 pm

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.
Lazarus

User avatar
Lazarus Long
Lead PITA SOB
Posts: 618
Joined: Tue Jul 05, 2005 9:24 pm

Post by Lazarus Long » Mon Oct 24, 2005 12:20 pm

No reply from original author within a week.

Locked.

(The original author should PM me to reopen it)
Lazarus

Locked