Perl/mysql On Linux
i am not getting the output for the following code (given below) in apache server on linux.
but i do get ouput in perl interpreter please replay me .
vinaykumarms@rediffmail.com
#!/usr/bin/perl
print "ContentType: text/plain
";
use DBI;
# Connecting to the database
# Replace DATABASENAME with the name of the database,
# HOSTNAME with the hostname/ip address of the MySQL server.
$drh = DBI->install_driver("mysql");
$dsn = "DBI:mysql:database=vinay;host=localhost";
$dbh = DBI->connect($dsn,"","");
# Select the data and display to the browser
my $sth = $dbh->prepare("SELECT * FROM login");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{'id'}, name = $ref->{'name'}
";
}
$sth->finish();
# Disconnect from the database.
$dbh->disconnect();
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL, Perl CGI
I'm developing a simple computer helpdesk system with MySQL as the backend and Apache/CGI/Perl as the user interface. I've sucessfully set up the part where a user enters an issue via HTML form and "submits" it to the MySQL database. My question is: I have it set up where the user posts the issue to the database, the database auto_increments an issue_id number field. How do I return that issue_id number back to Apache so that the user can see it (and use it as a reference number)?
View Replies !
Perl-DBD-MySQL
I have a binary distribution of MySQL 4.0.20 installed in /usr/local/mysql. Therefore, the only libmysqlclient file I have is libmysqlclient.a (static library). And also, Perl:DBI already installed. I'm trying to install perl-DBD-MySQL-2.9004 from source. What should I add to 'perl Makefile.PL' as arguments to make sure it finds the static library? I've tried 'perl Makefile.PL --libs=/usr/local/mysql/lib/libmysqlclient.a and gotten this: --------------------------------- [root@localhost DBD-mysql-2.9004]# perl Makefile.PL --libs=/usr/local/mysql/lib/lib/mysqlclient.a I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/include -mcpu=pentiumpro libs (Users choice) = /usr/local/mysql/lib/lib/mysqlclient.a nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Unrecognized argument in LIBS ignored: '/usr/local/mysql/lib/lib/mysqlclient.a' Using DBI 1.30 installed in /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBI Writing Makefile for DBD::mysql [root@localhost DBD-mysql-2.9004]# --------------------------------- What should I do to get DBD-MySQL to install correctly?
View Replies !
Using Perl With Mysql
I have heard that if you want a view with mysql, perl is one iof the best applications to use. I want to make a user interface with perl that will prompt the user to enter values and then those values will be stored into the database. I'm just started to learn how to use perl, can anyone give me a little help with writing the code?
View Replies !
Perl DBD::mysql - Using Arrayref
I have an app where I would like to display a returned table with column headings as specified in the inquiry (select), while preserving the column sequence of columns as specified in the original inquiry - without having access to the original inquiry. If I use the fetchrow_hashref method, I can determine the column headings, but I lose the sequence. If I use fetchrow_arrayref, I preserve the sequence, but I lose the column headings. I suspect there is an easy answer. Anybody have it?
View Replies !
Dealing With Mysql Through Perl
i'm working with a mySql database. i have accessed the database through perl. now i want to know how i can store images in the databases through perl and how to retrieve it.. does anyone have an idea abt this?
View Replies !
Perl And Mysql Datetime
I am trying to have an update form for a datetime field. I've been looking all morning and haven't been able to find any examples of how to do it. I have the date in the form formatted by perl like this: 08-14-2006 11:29:28 and when I do the update to mysql nothing happens. It does not work. I need to make it so the user can put the time the student left.
View Replies !
Verifying Mysql Writes (perl)
What is a proper way of verifying that a mysql write was successfull, and to retry if it wasnt? In my perl script I add records through: my $dbh=DBI->connect($dsn, $db_user_name, $db_password); my $sth=$dbh->prepare("insert into TABLE (X, Y, Z) values ('1', '2', '3')"); $sth->execute; $sth->finish; I have noticed that from time to time this fails, due to limitations of my webhost. I thus want to do a check after the write, that it actually happened, and if not redo.
View Replies !
Unable To Connect To Mysql Via Perl
I am attempting to connect to my mysql using a perl script, and keep getting an error message that tells me the I am missing a sub routine. I have installed DBI and DBD::mysql but still can not use my $dbh = open_dbi($db,$username,$password) I am assuming that open_dbi is not installed, does anyone know of another, or better way to access mysql via perl.
View Replies !
Installing MySQL 5 Perl DBI Must Be Installed?
the steps to installing MySQL 5 on Red Hat Linux 9? When I follow the steps as outlined in the manual or Red Hat text I get an error that Perl DBI must be installed. After attempting to download the Perl DBI; that failed because the server was not availabe. Eventually I was able to download some Perl stuff, but not the DBI. Here is the problem at its root. Where is the information to handle all of the error messages? Where is the source of knowledge to work around these problems?
View Replies !
Retreiving MySql Data With Perl (DBI)
I have been trying to retrive data out of MySql data file using DBI and Perl for a while with no luck. I get message "Can't locate loadable object for module DBI in @INC (@INC contains: C:/Program Files/Perl/lib C:/Program Files/Perl/site/lib .) at C:/Program Files/Perl/lib/DBI.pm line 258" I have DBI.pm in above respected directories. I have no problem retreiving data out of flat files ie simple text file with delimiters. I use windows xp,Perl,Apache server and MySql server at home with no other problems.
View Replies !
MySQL/Perl Book Recommendation For A Beginner?
Here's the situation: I have a Perl-based forum that I wrote myself. It currently supports user accounts, but these are stored in a flat text file (as is everything else for that matter). I'm looking to convert this to a MySQL database so that I can do more with that information, but with less processing time (reading through that huge text file to find something isn't very efficient). In the future I hope to move the whole forum over to MySQL, but I thought a good starter project would be just one aspect of it. At this point I am looking for recommendations on good books for someone moderately experienced with Perl, but who has NO experience with MySQL or anything similar. Since I'd prefer to integrate this with my existing script, I'd rather stick with Perl and not learn PHP at this time. So far it seems like "MySQL and Perl for the Web" is a good - are there others? I prefer reference-style texts with useful code examples, rather than lesson-style books.
View Replies !
Calling MySql Select Procedures In Perl
I am trying to call a "select" stored procedure from perl. I am not quite sure how to do it. Here is the stored procedure: CREATE PROCEDURE spTest() begin select x AS X from tblTest; It works fine when called from within MySQL. mysql> call spTest(): +------+ | X | +------+ | 24 | | 3 | +------+ I have the following code in perl: my $spt = $db->prepare("Call spTest()"); $spt->execute(); $spt->bind_columns($id); while($spt->fetchrow_array()){ print "X = $id"; } I get an error that says I need to use "select into". How do I call this procedure from perl?
View Replies !
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I can not seem to get any of the functions working on it. So I have now dopwnloaded the latest version hoping that this will fix the error. I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but i'm getting the following error message when I install MySQL-server-4.0.1-0.i386.rpm : Code:
View Replies !
Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.
View Replies !
MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account. Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.
View Replies !
Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?
View Replies !
How To Connect Remotely To Linux/MySQL Using MySQL Query Browser
http://dev.mysql.com/doc/query-brows...onnection.html I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system. I type server host and port 3306 user name admin + password and default schema and I get access denied message. I use putty to connect to the server using IP and port 22 and it connects to the server. What settings do I need to use to connect to MySQL using query browser?
View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
MySQL On Redhat Linux
To make a long story short, let me say I had MySQL working on Windows 98 and everything was fine. Well, I took the big leap and removed all traces of Windows and Microsoft from the computer. (hooray!) Once I had Linux running OK, I downloaded and installed MySQL using an RPM package. I guess the server is running (it says it is every time the computer starts and it stops successfully every time the computer shuts down) however, I cannot figure out how to get the MySQL prompt. I've searched the entire hard drive for MySQL, mysql, MySQL*, mysql* and probably some others, too. The only thing I found was a shell script called mysql that starts or stops the server if I am logged in to Linux as root. I cannot figure out how to start the interactive program that allows me to make select statements, inserts, updates, etc. I'm wondering about some things: Did I download and install the wrong thing? Am I just not looking for the correct thing? Did I install it incorrectly?
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for MySQL" in connection page I put Linux IP address as "Server host" and username/password I keep getting error: Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061) My question is: Do I need a client installation or configuration on Windows machine?
View Replies !
Installing MySQL RPM On Linux
I am trying to install MySQL with this command: rpm -ivh MySQL-server-4.0.13-0.i386.rpm I get bunch of errors regarding conflicts with the existing installation (files in /usr/share/mysql/.....) 1. Originaly mySQL was isntalled with Linux 7 install 2. I can't un-install mySQL via Linux Add/Remove program, I get an error stating sthat shared library option must be selected (it's is selected) 3. I have deleted /usr/share/mysql directly, but still have a problem.
View Replies !
MySQL, Linux, Ia32, >4GB RAM
I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32 (e.g., Xeon) with more than 4 GB RAM? Did you find a performance enhancement? With PAE mode on? How does this affect MySQL - being a multithreaded process, is there any benefit in having all that extra memory as anything other than a big disk cache?
View Replies !
Connection To MySQL On Linux
I am New to Linux PHP apache and MySQL (following the Book, Begining.PHP, Apache, MySQL Web Development). Got as far as chapter 3 without too many problems. Well no I'm stuck. I get the following error Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache2/test/createmovie.php on line 4 Database connection error, check your server connection when then following piece of code is executed $connect = mysql_connect("localhost", "mysql", "mysql" ) or die ("Database connection error, check your server connection" ); I'm, A bit lost about which file the path is stored.Has anyone came across this similar problem and found a fix for it?
View Replies !
User Mysql On Linux
I´m using Red hat Enterprice WS 3, when I install mysql (version 4.1.7) on linux, everything ok, but when I type # mysql error ocur: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
Mysql And Linux Script
I need your help with this. I am trying to write a linux script where I can connect to mysql database, use the select statment (count(*)) to get the number of rows, and store the results in a variable. Can you tell me how to put the result in the variable?
View Replies !
Mysql And Linux Users
I installed mysql using rpm. But I did not create a user for mysql. Mysql manual says something like that I should create a group and a user called mysql and that user should own the data directory. I do not understand that exactly. At the moment my mysql data directory is owned by root. Is it ok and do I have to create a user and group called mysql. Can you please tell me exactly what I should do? Other thing is as what user should I run mysql. WHat should I use for the --user option and --pid option.
View Replies !
Mysql Error On Linux
You have an error in your SQL syntax near '(course INNER JOIN round ON course.CourseID = round.CourseID) ON league.LeagueID' at line 1 I get this error when I run on linux.. Code: $SQL="SELECT RoundNum, RoundDate, CourseName, LeagueName, Format FROM league INNER JOIN (course INNER JOIN round ON course.CourseID = round.CourseID) ON league.LeagueID = round.LeagueID Where RoundID=".$RID.";"; Can Anybody help please? I also have another optional question. I cam across a sql function "FIRST()" Does anybody know the MYSQL equivalent?
View Replies !
Mysql Is Not Using ENOUGH Memory On Linux
Running mysql 3.23.56-1.9 (yes , upgrading soon!) on red hat. Our database: - data is 5GB or so - has approx 2GB of indices We have 4GB of memory on the machine. At least 2.5GB of that is free+cached [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = key_buffer=500M set-variable = myisam_sort_buffer_size = 64M set-variable = table_cache=600 set-variable = join_buffer=1M set-variable = thread_cache = 8 set-variable = sort_buffer =4M set-variable = record_buffer=4M set-variable = thread_cache_size = 64 set-variable = thread_concurrency=8 set-variable = max_allowed_packet = 16M set-variable = tmp_table_size = 64M But, no matter how much memory I set for key_buffer in /etc/my.cnf, mysql seems to use very little of it after running millions of queries: 14951 mysql 15 0 226M 221M 1308 S 3.3 5.5 89:55 0 mysqld
View Replies !
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it. When i try to connect the ODBC allways returns the following error: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001) I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc... The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.
View Replies !
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net. Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine So please tell me process 1 have to simply upload my mySql database in Public Html folder or else where i m using cPanel file manager to upload files
View Replies !
Linux Mdk Rpm MySql Installation
I just installed from rpms MySQL on a Mandrake10.1. I can't get trhough the can't connect to Local MySQL server through socket "/var/lib/mysql.sock" (113) There were already mentions to this problem but no solution on the forum. Could it be possible to tell us how to go through?? I've got a mysql.sock in the good path but it's 0bytes. If you don't know the solution, would it be possible to send a copy of your mysql.sock?
View Replies !
Linux And MySQL Access
I know MySQL account has nothing to do with Linux system account. I just wondering is there a way when I creates a new Linux account it will automatically creates a MySQL database account? Or do I have to write my own shell script to do that?
View Replies !
Uninstalling MySQL On Linux
I recently manually installed MySQL on linux/fedora 5 which caused problems as MySQL is built into the the RPM. Therefore I would like to uninstall my version of MySQL and revert back to original. As I am new to Fedora can anyone point me in the right direction to help me uninstall MySQL as there does not appear to be an unistall package/function.
View Replies !
Intalling Mysql On Linux
Before I begin, can I just state I have never installed anything on Linux server, so I am very new to this... Okay at the mo I have and using MYSQL version 3.23.58 on my Linux Sever, incase this is important, heres the details of my server: WEB SERVEUR Platform : Small - Fedora Core 3 Control panel : Plesk 100 Config : AMEN 2400 - AMD Athlon XP 2400+ Disk: 80 Gb - Memory: 512 Mb OK, I need to upgrade to the latest MYSQL version. So far, I have downloaded "mysql-standard-5.0.24a-linux-i686.tar" and unpacked the file uner /usr/local This is where I am stuck, I have no idea what to do next.. I need help for someone never done this before, preferbally a guide like... STEP by STEP, type this, then that etc.
View Replies !
Installing MySQL 5 On Linux
I have just been asked to install MySQL on a server which only has command line access. Despite having used MySQL on Linux for quite some time I have never carried out command-line installation before. The server is Redhat 9 and does not currently have any version of MySQL installed. Can anyone point me in the direction of a comprehensive installation guide which begins with post login via ssh which is where I can currently get to. ie..I need to know, how to download it AND how to then install it.
View Replies !
Perl DBI / SQL
I need to know how to retrieve through Perl DBI a listing of possible ENUM elements from a field for processing under a CGI script. If all I need for this is some form of SELECT statement, please provide a code snippet of this so I can do it. I want to make my code so I'm not having to edit hard-coded Perl CGI scripts if/when I add new elements to the ENUM field.
View Replies !
PHP Or Perl?
As part of my own learning mysql project I'm planning to build databases for all my books and DVD's. Stephen Hawking is probably a better typist than I am so I plan to use barcodes to get the info ,taking the information from various web sites. People tell me that PHP is THE way to do database work with mysql. The thing is, I'm familiar with Perl and it has all kinds of neat string manipulation stuff and LWP. Does PHP have comprable libraries (especially LWP) and how difficult is it to move from Perl.
View Replies !
Fw: PHP Or Perl?
Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Do you use some kind of "middleware" that your communicating to from Rebol via TCP/IP which gets the data for you?I'm actually a Delphi, Java, VB, Perl & Ruby developer (done alittle Rebol before) but found it strange that your using TCP/IP to communicate with mySQL
View Replies !
Installation Problem Mysql 4.0.13 On Red Hat Linux 6.2
I am facing problem in installing the mysql 4.0.13 on my linux 6.2 machine . I have pentium III server. When i give the command rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message " Only one major mode may be specified " I tried lot to install the mysql ver 4 on my machine but could not succeed .
View Replies !
Compiling Mysql For Arm On I386-linux
I am hopping to get mysql compiled for arm in an i386 redhat pc. I have the cross compiler and some arm distribution, the version of the gcc is 2.95.3, and mysql distribution is 3.23.57. (I also tried 4.0.14 withthe same results/error) I do a: ../configure --prefix=/usr/local/arm/arm-linux --host=arm-linux --build=i386-linux and after a while I get an error: =============================================== : checking "return type of sprintf"... configure: error: cannot run test program while cross compiling =====================================
View Replies !
|
TRACKER
