LinuxQuestions.org - Perl script updating one database but not another.

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - Perl script updating one database but not another. (https://www.linuxquestions.org/questions/programming-9/perl-script-updating-one-database-but-not-another-4175473245/)

Perl script updating one database but not another.

I have a script that works fine on one mysql database and fails to update in another.

Code:

use strict;

use warnings;

use DBI;



sub dbOpen {

    my $dsn; 

    my $dbh;



    $dsn = "DBI:mysql:database=DATABASEB;host=localhost;port=3306";

    $dbh = DBI->connect( $dsn, "USERNAME", "PASSWORD" ) ||

    print STDERR "FATAL: Could not connect to database.\n$DBI::errstr\n";

    $dbh->{ AutoCommit } = 0;

    return($dbh);

} # END sub dbOpen



my $Data;

$Data = &dbOpen();



my ($sql,$rs,$sql_update_result);



$sql = "update TABLENAME set option_value='http://URL' where option_value='http://STAGINGURL';";

$rs = $Data->prepare( $sql );

$rs->execute() || &die_clean("Couldn't execute\n$sql\n".$Data->errstr."\n" );

$Data->disconnect();

Since this works fine on DatabaseA and not on DatabaseB I presume it is a permission issue, but the username I am using has ALL permissions on *.* so I am a bit lost.

Thoughts?

What do your mysql logs say? They should report any errors in there so if the query is actually get to mysqld it should have the fatal error in there if there is in fact one.

So what does

Code:

$Data->errstr

say ?

Did you try it outside of your script? Also the username might have all the permission does it also have a allowed host set inside of mysql.user(s)?