perl mysql problem

[yeller2]

I've created a script that performs a simple select query on a mysql db table. When I run the script on one computer I don't receive any results back. When I run the same script on another computer, but setting the db host to the first computer, I get results. Any ideas?

 

[tviman]

Need more info...

Where does the Mysql database reside?
How are the computers connected?
Does your error log provide any clues?
Can you supply an example of your code?

 

[travs69]

If you run it on the first computer.. but leave the dbhost info in (also point to the first computer) do you get the same results? Are your running identical versions of perl?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those Who Say It Cannot Be Done Are Usually Interrupted by Someone Else Doing It; Give the wrong symptoms, get the wrong solutions;

 

[stevexff]

I think you are probably going to have to post the code in order for us to help you...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[yeller2]

Something goofy is going on, now it's working. Thanks anyway.

 

[yeller2]

What I found was that I was having an issue with certain tables when I used tried to read them using a host other than localhost from the local computer. The permissions were the same in the mysql user table, but someone told me that a permission issue could be somewhere else. I'll just settle for reading the tables using a localhost account.