Red Hat :: Installing Perl (v5.8.8) Module For Connecting To MySQL
Aug 2, 2010
I want to connect to MySQL Database installed on RHEL 5 using perl v 5.8.8.The available DBD perl drivers installed on my machine are:DBM, ExampleP, File, Pg, Proxy, Sponge..I downloaded DBD-mysql-2.1012 and tried installing DBD again but got the following error:Can't exec "mysql_config": No such file or directory at Makefile.PL line 167.readline() on closed filehandle PIPE at Makefile.PL line 169.On searching I found that I need to install libz-devel prior to installing driver for MySQL for Perl.
I'm attempting to set up a GIMP scripts for batch operations on groups of image files. Initially I started reading about the Script-Fu syntax but it looked too convoluted (at least for me, with 15 years of Perl experience at work) in a way it does the simpliest of things so I attempted to use Perl instead of Script-Fu. From reading the docs I see that I need to install "Gimp::Fu" Perl module. I installed "cpan" first, started it and issued the command:
install "Gimp::Fu"
and got a dependency problem:
Code:
cpan[1]> install "Gimp::Fu" CPAN: Storable loaded ok (v2.18) Going to read /root/.cpan/Metadata Database was generated on Thu, 28 Oct 2010 17:30:45 GMT
I have a permission to use several CentOS5 computers that are connected to a server where all shared programs sit. Accordingly, all Perl users for example have an identical path to Perl (e.g. /export/user/bin). The administrator suggested I'll install all the programs I need (specifically Perl and Mysql) in my personal space, and then add them to the path before the already installed ones. Accordingly, I could add/change modules without "sudo" privileges, and without changing the global setting.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
I recently reinstalled the B module for perl. Now I found out it didn't just do that, it installed a whole new copy of perl into /usr/local/bin/perl. When I type 'which perl' at the terminal, it says '/usr/local/bin/perl' instead of '/usr/bin/perl'. Normally, this wouldn't bother me. But I installed the one in local/bin without threading support. The one that comes with the system already is build with threading support, which is why I want to switch back to the system perl, and possibly remove the one in /usr/local/bin.
So how do I change it so that the result of 'which perl' returns as '/usr/bin/perl'? And what do I have to do to remove /usr/local/bin/perl?
The reason I need threading support is because I'm designing a file copier that copies several chunks of a file simultaneously to speed up the copying process. Guaranteed a useful script if it works.
I need to install the Perl DBI and DBI::mysql modules at Amazon Web Services. Perl 5.8.8 is installed there as part of the default Fedora linux that comes with an EC2 instance. I am not familiar with Fedora, but have been using Linux for a good while.If anyone could tell/show/direct me to the quickest way to do this.
I'm trying to write a script in Perl to download a file that requires NTLM authentication to access, stored on a machine on this network.The file exists, and can be accessed through a web-browser, btw.
I am trying to make use of the perl module WWW::Nike::NikePlus to retrieve the data from my ipod but apparently I have no idea what I am doing. I installed the package just as the readme said including all the dependencies. I cant really figure out how to run it, i searched for how to use it and found this : Example use that retrieves and prints your last run information
use WWW::Nike::NikePlus; my $username = 'my@email.address'; my $password = 'MySecretPassword'; my $locale = "en_us"; my $pin = nike_authenticate( $username, $password, $locale ); unless( $pin ) { print "Authentication failed "; } .....
#Details of the last run my ($unit, $last_run_dist, $last_run_duration_millisecs, $last_run_duration_friendly, $last_run_pace_friendly) = nike_last_run(); print "Last run: $last_run_dist$unit in $last_run_duration_friendly "; print "Last run pace: $last_run_pace_friendly per $unit ";
So I put it in a txt file and saved it with the extension .pl and of course I put in all my info in the username password fields then made it executable with the command sudo chmod +x nikeplus.pl and when I try to run it with either ./ or perl I get this output:
brandon@desktop:~/Apps/nikeplus$ ./nikeplus.pl ./nikeplus.pl: line 1: use: command not found ./nikeplus.pl: line 2: my: command not found ./nikeplus.pl: line 3: my: command not found ./nikeplus.pl: line 4: my: command not found ./nikeplus.pl: line 6: syntax error near unexpected token `(' ./nikeplus.pl: line 6: ` my $pin = nike_authenticate( $username, $password, $locale );' brandon@desktop:~/Apps/nikeplus$ perl nikeplus.pl Use of uninitialized value $ENV{"TEMP"} in concatenation (.) or string at /usr/local/share/perl/5.10.0/WWW/Nike/NikePlus.pm line 10. Use of uninitialized value $last_run_duration_millisecs in division (/) at /usr/local/share/perl/5.10.0/WWW/Nike/NikePlus.pm line 106. Use of uninitialized value $last_run_dist in division (/) at /usr/local/share/perl/5.10.0/WWW/Nike/NikePlus.pm line 107. Use of uninitialized value $last_run_duration_millisecs in division (/) at /usr/local/share/perl/5.10.0/WWW/Nike/NikePlus.pm line 107. Illegal division by zero at /usr/local/share/perl/5.10.0/WWW/Nike/NikePlus.pm line 107. brandon@desktop:~/Apps/nikeplus$
I have Apache/2.2.14 (Ubuntu) DAV/2 SVN/1.6.6 mod_fcgid/2.3.4 Phusion_Passenger/2.2.14 PHP/5.2.10-2ubuntu6 with Suhosin-Patch configured In UBUNTU 10.04 I like to install apache2 mod_perl I make apt-get install libapache2-mod-perl2 and I get: Quote: libapache2-mod-perl2 is already the newest version.
Ok I try sudo a2enmod mod_perl ERROR: Module perl does not exist! how I make Perl work in apache2 UBuntu 10.04
I need to get some information like cpu usage,free memory,swap memory and other information from a bunch of remote hosts.Can any one tell me of a good perl module which does that.I dont want to use Net::Rsh or Net:SSH.
I need to install different version of Perl with needed modules to Test Run a perl script (ASSP) without affecting the existing one as the old version of Perl is buggy with seg fault.
I have installed perl5.12.3 in a custom location, ( a NFS share). I have all the libraries created in the same location. This was an attempt not to disturb existing version of perl. I have succeeded doing this.Now, I need to install around 200 perl modules. I tried Bundle option in CPAN shell, it somehow did not work. Does anyone here know off any other better method of installing multiple perl modules. How do I use CPANPLUS to install all the modules. What changes do I make to Config.pm considering custom location of perl installation I have done.
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
I have spent over half of the day, literally, trying to get my server to parse perl and be able to use perl scripts to interact with my SQL server. Has anyone been able to get it to work? Only looking for answers to Slackware. There are a lot of resources for FC and Ubuntu, but that does me no good. I checked the Slackbuilds for their builds, and built the libdbi and libdbi-drivers package, but still cannot get it to communicate.
I'd like to use a perl script to update a fields in mysql database when pianobar (command line pandora radio player) starts a new song. Pianobar has the ability to run a script based on events, I'd like to take advantage of and use perl toparse the artist,song,album and update the corresponding fields. Then later retrieve them and display them with php/html. I am by no means proficient with perl. I started to use bash, but it looks like perl will be much more efficient and and less time consuming.
I have a small problem when you switch from your previous version to 9.10 (karmic). My problem is connected with TV tuners, who previously drove by the following commands:
sudo rmmod saa7134 saa7134_alsa tuner sudo modprobe saa7134 card=78 tuner=54 sudo modprobe tuner secam=l Information on these commands, I found it by: [URL]
Use a player who is TvTime. For now I have picture but no sound and I think that occur after the upgrade (as mentioned above). The error that I go when I enter the commands in the console is: The first command, the output is:
ERROR: Module saa7134 is in use by saa7134_alsa,saa7134_dvb ERROR: Module saa7134_alsa is in use ERROR: Module tuner is in use
And the other two:
WARNING: All config files need .conf: /etc/modprobe.d/options, it will be ignored in a future release. WARNING: All config files need .conf: /etc/modprobe.d/blacklist, it will be ignored in a future release.
As I mentioned on another thread, I have 2 Ubuntus - Jaunty and Meerkat - as separate drives on my secondary IDE channel. I am removing Jaunty. Meerkat blows it away. And is certainly my preferred OS. However I am looking for a replacement for Jaunty that is more flexible in certain key areas than Ubuntu appears to be.I dont want to be restricted to Debian versions of things like Perl, MySQL, PHP and others. I can run LAMPP, but I would prefer to compile and have the versions of my choice as part of a main test system (apart from Meerkat that is).
I have had enough nightmares in Jaunty with things getting broken and spiralling out of control. I want a distro that doesnt rely on the GUI and its attendant utilities, but can run them when called. Meerkat is stable and has resisted me breaking it so far, but I do not want to push my luck. I have too much time invested in it. I intend to use Meerkat as my primary system on the machine, but want an alternative to *PLAY* with.
and I get this error simply running the program from the command line: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./submit.cgi line 24.
is this the right syntax to use, both, for this line:
my (@param) = $cgi->param("firstname","lastname","type") ;
as well as this one:
$sth=$dbh->prepare ("SELECT firstname,lastname,type FROM dts WHERE firstname LIKE $param[0] AND lastname LIKE $param[1] and type LIKE $param[2]" );
or should there be quotes around the $param[0] or something? (also is it $param[0] or $param(0)?)
I am using fedora 7 ,i want to connect c++ program with mysql, i found mysql++ library for connecting c++ with mysql.when i used mysql++ rpm for installing and typed at shell prompt ./configure,then the error says unable to find mysql client library,can any one guide how to do the connection via a c++ program.
I have been tearing my hair out with this. As part of a backend perl script i am holding the Epoch time as session data using apache session and mysql so i can delete sessions after an expiry period. When I retrieve the time it is about three months old even when i only just set it. The code example below best describes the problem:
Well i have got a problem with connecting to a mysql database using php. I used this package "mysql-noinstall-5.1.44-win32.zip" and extracted it to c:mysql and added c:mysqlin to the PATH variable and used the following command in command prompt to start mysql: c:mysqlinmysqld --standalone
well mysql did start and everything went well accessing mysql in command prompt. Well under the database "mysql" in the table "user" i created a new user "php" with a password="****" and hostname = "localhost" but when i try to access this database with a following php routine:
And when i accesses it with my browser using localtost/test.php, all i get is "localhost" displayed on screen, "Connected to mysql" never gets displayed not i get any error..i am using windows 7(32-bit-ultimate)and mysql 5.1.44.
I have installed Tomcat on one machine and MySQL on another. When I run tomcat on the same machine as Mysql and use 'localhost' in the jdbc url, I have no problem accessing mysql through jdbc. So my problem is accessing a remote mysql instance. I have granted privileges in the following way from the MySQL prompt:GRANT ALL PRIVILEGES ON mydatabase.* TO myusername @192.168.0.103 IDENTIFIED BY 'mypassword';
FLUSH PRIVILEGES; Still I get : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Access denied for user 'myusername'@'192.168.0.103' to database 'mydatabase' sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) [Code]....
I have no idea whether this is a problem at the operating system level i.e. allowing networked hosts, or whether it is something to do with MySQL. I have commented out bindaddress and, on this version, there is no 'skip-networking' line to comment out.
