Problem using Perl to connect to MySQL database on remote server -

Problem using Perl to connect to MySQL database on remote server -

I have a Perl script that receives data from a database on a server (let's call it Server 1), Stuff it with it and writes it on server (server2) on another server. Both servers are remote from the server that runs the Perl script.

I can connect to DB on server 1 OK, but when I try to connect to DB on server 2, using the same DBI method, I get an error. Here, as the command line Pearl, the error is causing the error:

perl -MDBI -e 'dbi-> connect ("dbi: mysql: myDB: server2.whatever .co

And here's the error message:

DBi Connect ('UK', 'MyUser', 'Mypassword') or DBI-> IRSR; MyDB: server2.whatever.co.uk ',' myuser ', ...) Failure: The client does not support the authentication protocol requested by the server; Consider upgrading MySQL Client into E line 1 Client sir I do not support the authentication protocol requested by Via; I do not have root access, so I can not upgrade MySQL and I can not change the password to use the old password hashing algorithm , Which is the suggested solution in many places.

  Anyone considering?

  
  Accept connections only from a fixed address set as a security measure. The database can be prepared for this so if you are trying to use a prod database from a home laptop (for example), then it may refuse you, even if you have the proper credentials Try accessing from the place where it is known to use any other technique - for example, if you have a website that already access it, then there S is running Apache / Tomcat, and there try Prl. If this works, then this problem is. You can check the database settings continuously.


















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




Short URL Outbound Link Tracking in PHP and MySQL -



    I have a site that reduces the link based on this topic. I decided that it would be great if users click on a small URL, like HootSuite users can track their links. I currently have a database in which the short URL is placed with the actual URL and this click count will ideally update the click count column when that small URL is accessed by an external user.   In short, I am looking for a PHP / MySQL solution so that many small URLs can be clicked. . Any additional information gathered from the clicks will also be highly appreciated.      I'm assuming you followed the PHP version of your tutorial. If so, look at listing for service.php under "service of small URL". In section round line 11 where it determines the position of 301, you can redirect with the database update. Something like    $ query = mysql_query ("update`" $ database. "` .```_AL_DIRED`Set count = count + 1 where` small '=' ".mysql_escape_string ($ short) , $ Db); $ Line = ...






c# program list -



    Some body can provide me a program list which will open up my mind and help me to get a good code. I searched it on the net but did not find any good links.   Anything from a web link or anything will be highly appreciated.          






php - How do I set up pagination for an image gallery with image
thumbnails? -



    I have two tables:    gallery id | Name | Details Image ID | Title | Caption | Gallery ID    By listing all thumbnails or paging through thumbnails I got the code to create a simple image gallery. However, what I need to do is here something like gallery here Only completes without javascript and ajax:     I want a selection number to show below the main image as soon as the user clicks the thumbnail, the page Selected new Highlight the image and the series of thumbnails on boto goes forward one by one if its not the last image.   How do I do this? Do I need a quick and dirty way to do this? I am using php and mysql for the database here - just need code to show 'paged' images below the main image. I know how to install everything i.e. Thumbnail size etc ...      I do not know the number of your rows in MySQL for T-SQL As there is a ROWNUMBER () function, but to do this, it is a smart way to sequential numbering of your images in the database. From there, you ask something ...








Powered by Blogger