[RESOLVED] data Inporter

[spiritssight]

Hello All,

I justed switched to a different web hosting company as the one I had was not allowing a number of things that I needed.

Any how I have a script writen to allow the file to be taken and then upload the data to the database but I get a error. the error is:

Access denied for user 'IRS-EOML'@'%' (using password: YES)

<?php

 $db_conn = mysql_connect("mysqlxxxx.servage.net",
                            "IRS-EOML",
                            "************");
mysql_select_db("IRS-EOML", $db_conn);

// INSERT the data into the database table
	$query = "LOAD DATA INFILE '/mounted-storage/www/uploads/EOA01.LST'
        INTO TABLE IRS_EOML
        (@var1)

   SET
	col0 = substr(@var1,0,9),
	col1 = substr(@var1,9,70),
	col2 = substr(@var1,79,35),
	col3 = substr(@var1,114,35),
	col4 = substr(@var1,150,1)";

$result = mysql_query($query);
	if(!$result) die(mysql_error());
	else { $affected++; }

// printf("File inserted: %d records\n", $affected);

// closes the mysql database connection
mysql_close($db_conn);

?>

what is so wrong with this that I would get the above error

[NogDog]

Either the database host name is wrong (usually you can just use "localhost"), the database user name is wrong, and/or the database password is wrong.

[spiritssight]

thats what I would think except that its the same information form another scrpt that works (I copyed and pasted the info any other throughts?

[NogDog]

Which line is failing?

[spiritssight]

Its not giving me a line but it is giving me the error as stated above

but if I put // in the areas as show below it then does not give a error but it also does not put it in the database like it should

    col4 = substr(@var1,150,1)";

$result = mysql_query($query);
    if(!$result) die(mysql_error());
    else { $affected++; }

// printf("File inserted: %d records\n", $affected);

Thanks again for the help!
Christopher

[bradgrafelman]

If you login to the Servage control panel, click MySQL Databases on the navigation menu to the left, and click Connection Info for the database you're trying to access, you'll see a code snippet that you can copy and paste into your script.

It looks like this is the code snippet you copied, but I would recommend going back and re-copying it just to be sure. If that doesn't solve it... which server did you set up a database on? A v4, v5, or v5 Remotely Accessible server?

EDIT: Also note that once we get the connection part working, you'll need to fix the path in your SQL statement; your account path can be found by clicking "Documentation" on the navigation menu to the left and choosing "Account Paths".

[wilku]

Could this be, that your account doesnt have FILE privilege for this database? It is needed for LOAD DATA INFILE.

[NogDog]

wilku wrote:

Could this be, that your account doesnt have FILE privilege for this database? It is needed for LOAD DATA INFILE.

I think you might have something there. That sounds more in accordance with what the error message is saying.

[spiritssight]

IS there a peice of scrpt that would allow me to test if the stuff is setup this file stuff or what not?

[wilku]

http://dev.mysql.com/doc/refman/5.0/en/show-grants.html

[spiritssight]

Hello I have checked and this is what shows:

Grants for IRS-EOML@%
GRANT USAGE ON . TO 'IRS-EOML'@'%' IDENTIFIED BY...
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP...

so how do you put File priv on

[bradgrafelman]

Looks like you'll have to open a support ticket with Servage and see if they will grant you the FILE privilege.

[spiritssight]

Thank You, I await them to respone about this.

Now this should take away the error msg good!

Sincerely,
Christopher