RPM Install appears to have failed
RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl MySQL installed with rpm's vs binaries combination
Perl was installed from my RedHat 6.2 install media, I remember a problem of installing MySQL using the binaries would cause conflicts with a rpm installed Perl. That is what someone in this newsgroup told me about a year ago. Is this true? I couldn't get the MySQL to install with the RPM's. Is it safe to install using the binary version of MySQL, will I encounter any problems using Perl to access the database with the Perl(rpm) MySQL(binary) versions? Will I need to re-install Perl Thanks Chris Previous Post, no answer yet: To: [EMAIL PROTECTED] Subject: RPM Install appears to have failed Date Sent: 10/2/02 RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Archive of this mysql list
Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM Install appears to have failed
Thanks Praveen, So Max is not a server version, it sure is difficult to determine that on the download page: MySQL database server standard clients: · MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52 · · 3.23 -- Default package (use this if you are unsure) · · 3.23 Max -- Package with maximum features Should I now download 3.23 (Default pkg) and run the rpm, how will this affect what happened on my server below? Is there a way to un-install the client and Max? Or should I just install 3.23 and all will be better? Thanks again. Chris At 06:23 PM 10/3/2002 -0700, you wrote: Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED] wrote: RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db shell cd mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM Install appears to have failed
Your right - Max is a server, thank you. Directories you listed do not exist. That rpm is all honked up. Is there an UN-install flag for rpm? I would like to cleanly reverse what was done w/ the rpm and install from the binary, is this possible? The workaround provided below does not seem to be tested, before I cause any more damage I would like to clean the orig install up, if it even did anything... Thanks. Found this thread: Subject: MySQL-Max-3.23.52-1.i386.rpm is missing many files. From: alg Date: Sat, 21 Sep 2002 20:17:05 -0400 Description: I'm trying to install MySQL MAX 3.23.52 (MySQL, with transactions enabled). My rpm attempts goes like this... 1. Check for installed MySQL... [root@Zeke mysql]# rpm -q -a | fgrep -i mysql [root@Zeke mysql]# 2. Nothing, so I attempt an install... [root@Zeke mysql]# rpm -i MySQL-Max-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.34280: /etc/rc.d/init.d/mysql: No such file or directory QUESTIONS 1. Why is the mysql start/stop script missing? 2. In addition, OTHER FILES are missing, as compared to the tar/gzip binary: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz Thanks in advance. /AL How-To-Repeat: 1. Download the Intel Linux RPM file: MySQL-Max-3.23.52-1.i386.rpm 2. su as root 3. rpm -i MySQL-Max-3.23.52-1.i386.rpm 4. See the error /etc/rc.d/init.d/mysql: No such file or directory Fix: BETTER FIX: 1. Re-build the rpm file for MySQL-Max-3.23.52 2. While you guys are at it, provide the rpm for the other modules (ask RedHat for help on this, if necessary). If you want me to do some of the work, I'll volunteer the time. ... Just give me some RH linux box to login to. ... I have only 1 box at home, which I use to support my consulting clients, so I can't fool around with the box too much. WORKAROUND: 1. Install the RPM file, in spite of its problems: MySQL-Max-3.23.52-1.i386.rpm 2. Install tar/gzip file: mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz ...This way, other rpm files that depend on MySQL-Max-3.23.52-1 won't have problems (assuming that they are properly installed). Submitter-Id: [EMAIL PROTECTED] Originator:alg Organization: Al G, WowSignal.Com MySQL support: none Synopsis: MySQL-Max-3.23.52-1.i386.rpm is missing many files. Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-3.23.52-max (Official MySQL-max binary) At 11:04 PM 10/3/2002 -0400, John Coder wrote: Max is a server. your install directory out of an RPM should be /var/lib/mysql if you are root su to root and see if it's there. It should tell you this in /usr/share/doc/packages/Mysql thwere's a manual there or it should be. John Coder On Thu, 2002-10-03 at 21:55, Chris Becker wrote: Thanks Praveen, So Max is not a server version, it sure is difficult to determine that on the download page: MySQL database server standard clients: · MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52 · · 3.23 -- Default package (use this if you are unsure) · · 3.23 Max -- Package with maximum features Should I now download 3.23 (Default pkg) and run the rpm, how will this affect what happened on my server below? Is there a way to un-install the client and Max? Or should I just install 3.23 and all will be better? Thanks again. Chris At 06:23 PM 10/3/2002 -0700, you wrote: Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED] wrote: RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram. Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp folder as root and chmod 777 Followed the install instructions - which only included: To perform a standard minimal installation, run: shell rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm (No user or group or environment setup instructions before running rpm's???) So logged in as root I executed the following, and got the result below [root@plinux tmp]# rpm -i MySQL-Max-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm Giving mysqld a couple of seconds to restart var/tmp/rpm-tmp.10346: /etc/rc.d/init.d/mysql: No such file or directory Was this successful? Where did mysql install to? The post installation steps say to: shell ./scripts/mysql_install_db
Re: ADO API support?
I have had very much success with passing sql commands via ado over the myodbc layer. I wouldn't trust addnew and update batch methods nor have I tested how or if they work, it's better to keep your connections to the database stateless for performance purposes. Meaning to execute dml statements use the ado connection object to establish the connection and pass your sql command to the db, then close your connection. Get in, get out. Don't hold anything open as your looping thru your rs... imho Same with retrieving recordsets, I recommend using disconnected recordsets which work terrific. Make your connection, pass your select, get your rs back, close your connection and manipulate your new disconn rs object using the full scope of adodb.rs methods props. hth chris www.mydba2000.com From: Kelvin Lam [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: ADO API support? Date: Tue, 19 Mar 2002 17:43:56 -0800 Hi, I tried to read the documentation, but there are only examples instead of specific/explicit documentation My question is-which ADO objects/methods/properties does myODBC support? I can easily found the entire ADO programming model, all the objects, and their methods/properties in MSDN. But, I haven't been able to found the same quality work on myODBC documentation (or am I blind?) For example, not until I try it out, I realized, as posted in newsgroup, that the UpdateBatch is not support in myODBC. Please advise. I am using the stable release 2.50. If people had better experience and performance with newer version, please let me know. Any pointer would be greatly appreciated! Kelvin Lam Software Engineer Orbit Technology Corp 1528 Brookhollow Dr, Suite 66 Santa Ana, CA 92705 Phone: (714)427-0555 Fax: (714)427-0556 - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access denied for user: 'root@localhost'
root login failing??? why? anonymus failing too?? I just installed the following on Win2k Server: Ver 8.23 Distrib 3.23.47, for Win95/Win98 on i32 Server version 3.23.47-max-nt Install goes seemingly ok. I test whether or not MySQL is working and have problem with this command below... C:\mysql\binmysqlshow -u root mysql mysqlshow: Access denied for user: 'root@localhost' (Using password: NO) C:\mysql\binmysql mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' C:\mysql\bin\mysql test (this works ok) tia chris _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VB/MySql/CrystalReport Problem?
IMHO - I would use ADO over the MyODBC layer to retrieve disconnected recordsets representing your report data from MySQL, then pass said adors to Crystal Report's viewer. To learn more about this approach, search seagate.com for ado disconn. rs, which utilizes ttx files (tab delimited text files) to create the report in design view. hth Chris mcdba mcse www.mydba2000.com From: yue cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: VB/MySql/CrystalReport Problem? Date: Thu, 14 Mar 2002 08:09:57 -0800 (PST) Dear folks, Now i try to migrate my Visual Basic Application from MS SQL Server to My SQL, I met problem when my crystal report connect ot My SQL, Below is my code: CrystalReport1.connect = DSN=testDB;uid=amy;pwd=test CrystalReport1.Destination = 0 CrystalReport1.ReportFileName = c:\localfolder\test.rpt sql = select * from score CrystalReport1.SQLQuery = sql CrystalReport1.Action = 1 when execute the last line, Following error message come up: Run-time error: '20534': Error detected by database dll. But when i connect to MS SQL Server, everything work fine. Anybody give me a hand ? __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query
select u.name, sum(p.id) from usertable u, posts p where u.userid = p.poster group by u.name order by 2 desc //chris www.mydba2000.com From: Laban [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Query Date: Fri, 15 Mar 2002 02:18:27 +0100 Hi I need a query that counts the number of posts each user have made in my forum and then sort the userlist by that. How? table posts id, int (post id) thread, int (which forum the post belong to) poster, int (Who posted. ID from users table) string, text (post text) category, int (forum category) timestamp, int (timestamp) SELECT poster, COUNT(*) AS num FROM posts GROUP BY poster ORDER BY num DESC; this showes how many posts each user has, sorted by the number of posts. Most posts come first. Now, how do I implent this in the following query? SELECT * FROM users ORDER BY ? poster is the ID from the user table. //Laban - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and MSAccess
Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office solution. Thanks in advance. Chris _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and MSAccess
Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Encrypted table
encrypted table, no. encrypted data - yes! check out this AES algorithm, it can be used with C, C++, and there is even a VB implementation. I highly recommend. Chris www.MyDBA2000.com From: Tripp Scott [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Encrypted table Date: Tue, 12 Mar 2002 03:57:16 +0700 The downside of putting users' data in a MySQL database is that the sysadmin knows everything. Is there an implementation of an encrypted table in MySQL? t - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: VBA/VB DAO/ADO MS Access to MySQL?
I've done it by installing the MyODBC driver on NT4.0 WS running VB6sp2, and connecting to a RHLinux6.2 box running MySQL vs .36 - I've only done it w/ ADO over the ODBC layer, and it seems to work fine, however I am using disconnected recordsets and have not attempted binding a control to the backend... Good Luck. ChrisB MCSE MCDBA -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 11:14 AM To: Thompson, Mike; [EMAIL PROTECTED] Subject: Re: VBA/VB DAO/ADO MS Access to MySQL? Yes it can, via ODBC. I've never done it though. (I don't work in VB) Cal - Original Message - From: Thompson, Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:37 PM Subject: VBA/VB DAO/ADO MS Access to MySQL? Howdy, I currently have an application which uses DAO and ADO coding in VBA/VB as well as databound objects in VB to access a MS Access database. Can DAO and ADO in VBA/VB and databound objects in VB be made to work with a MySQL database? Anybody done this successfully? Cheers, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unusual dependency error w/ rpm??
Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1 /mysqlcd /bin /binls -l | grep sh -rwxr-xr-x 1 root root60592 Feb 3 2000 ash -rwxr-xr-x 1 root root 263064 Feb 3 2000 ash.static -rwxr-xr-x 1 root root 446800 Feb 2 2000 bash2 lrwxrwxrwx 1 root root3 May 27 2000 bsh - ash lrwxrwxrwx 1 root root4 May 27 2000 csh - tcsh lrwxrwxrwx 1 root root4 May 27 2000 sh - bash /bincd /usr/bin /usr/binls -l | grep perl -rwxr-xr-x 1 root root12872 Feb 2 2000 find2perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl5.00503 -rwxr-xr-x 1 root root31722 Feb 2 2000 perlbug -rwxr-xr-x 1 root root26305 Feb 2 2000 perlcc -rwxr-xr-x 1 root root16807 Feb 2 2000 perldoc -rws--x--x 2 root root 531516 Feb 2 2000 sperl5.00503 -rws--x--x 2 root root 531516 Feb 2 2000 suidperl /usr/bin Thank in advance, ChrisB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unusual dependency error w/ rpm??
because of problems w/ MySQL:Perl:DBD I need to either install MySQL from an rpm, or re-install Perl from a binary. The MySQL installed from binary ok, so I guess I'll keep it and recompile Perl. Perl was originally installed on my box from an rpm. I assume a recompile means uninstall reinstall. How do I UnInstall my current Perl version? Thanks, Chris B -Original Message- From: Scott Baker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 4:18 PM To: Chris Becker; [EMAIL PROTECTED] Subject: Re: Unusual dependency error w/ rpm?? Odd... could be different versions or something. If you're sure you have them install the RPM with --nodeps I still HIGHLY recommend a source install, it's very simple and you have a lot more control. At 04:09 PM 5/2/2001 -0700, Chris Becker wrote: Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1 /mysqlcd /bin /binls -l | grep sh -rwxr-xr-x 1 root root60592 Feb 3 2000 ash -rwxr-xr-x 1 root root 263064 Feb 3 2000 ash.static -rwxr-xr-x 1 root root 446800 Feb 2 2000 bash2 lrwxrwxrwx 1 root root3 May 27 2000 bsh - ash lrwxrwxrwx 1 root root4 May 27 2000 csh - tcsh lrwxrwxrwx 1 root root4 May 27 2000 sh - bash /bincd /usr/bin /usr/binls -l | grep perl -rwxr-xr-x 1 root root12872 Feb 2 2000 find2perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl5.00503 -rwxr-xr-x 1 root root31722 Feb 2 2000 perlbug -rwxr-xr-x 1 root root26305 Feb 2 2000 perlcc -rwxr-xr-x 1 root root16807 Feb 2 2000 perldoc -rws--x--x 2 root root 531516 Feb 2 2000 sperl5.00503 -rws--x--x 2 root root 531516 Feb 2 2000 suidperl /usr/bin Thank in advance, ChrisB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] By working faithfully eight hours a day you may eventually get to be boss and work twelve hours a day. - Robert Frost, 1874 - 1963 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
perl DBD make test errors??? Please Help (PROBLEM SOLVED, I think...)
I actually read the readme for DBD ;) and found what looks like the cause of the problem below: The Error means... that your linker doesn't include libgcc.a. You have the following options: a) Either recompile Perl or Mysql, it doesn't matter which. The important thing is that you use the same compiler for both. This is definitely the recommended solution in the long term. b)A simple workaround is to include libgcc.a manually. Do a make clean and make and in the output wait for a line like LD_RUN_PATH=/usr/lib/mysql:/lib egcs -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql -L/usr/lib/mysql -lmys qlclient -lm Repeat the same line in the shell by adding -L/usr/lib/gcc-lib/i386-redhat-linux/gcc-2.7.2.3 -lgcc ***QUESTION: I'll opt for the recompile Mysql. Perl was intalled from the RedHat install CD, Mysql I installed from the tar.gz file. I beleive I'll recompile Mysql - do I use and rpm to do this? In other words, how do I re-compile Mysql to have it use the same compiler as Perl? Thanks in advance. Chris B -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:07 PM To: [EMAIL PROTECTED] Subject: perl DBD make test errors??? Please Help RedHat 6.2 on Intel, ...36 MySQL, and perl5, DBI installed correctly. I ran perl Makefile.PL, seemed to run ok, no errors seen. Ran make, same thing. Then the following from make tets: /perlmods/DBD10make test make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00 503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbos e); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DB D/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: und efined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Te st/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error 2 Please Help - am I installing DBD in the wrong directory? MySQL is installed in /usr/local/mysql - should I be running this make file there??? Thank in advance, Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSTALL rpm over tar.gz??
I currently have Mysql .36 loaded on RH6.2 intel, installed from tar. How do I remove the .36 version so I can install the rpm version .37?? This is not an upgrade, I need to replace or recompile mysql - Is there a Un-Install process to remove the 36 version? Thank You in advance, ChrisB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unusual dependency error w/ rpm??
I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1 /mysqlcd /bin /binls -l | grep sh -rwxr-xr-x 1 root root60592 Feb 3 2000 ash -rwxr-xr-x 1 root root 263064 Feb 3 2000 ash.static -rwxr-xr-x 1 root root 446800 Feb 2 2000 bash2 lrwxrwxrwx 1 root root3 May 27 2000 bsh - ash lrwxrwxrwx 1 root root4 May 27 2000 csh - tcsh lrwxrwxrwx 1 root root4 May 27 2000 sh - bash /bincd /usr/bin /usr/binls -l | grep perl -rwxr-xr-x 1 root root12872 Feb 2 2000 find2perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl -rwxr-xr-x 2 root root 527856 Feb 2 2000 perl5.00503 -rwxr-xr-x 1 root root31722 Feb 2 2000 perlbug -rwxr-xr-x 1 root root26305 Feb 2 2000 perlcc -rwxr-xr-x 1 root root16807 Feb 2 2000 perldoc -rws--x--x 2 root root 531516 Feb 2 2000 sperl5.00503 -rws--x--x 2 root root 531516 Feb 2 2000 suidperl /usr/bin Thank in advance, ChrisB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
perl DBD make test errors??? Please Help
RedHat 6.2 on Intel, ...36 MySQL, and perl5, DBI installed correctly. I ran perl Makefile.PL, seemed to run ok, no errors seen. Ran make, same thing. Then the following from make tets: /perlmods/DBD10make test make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00 503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbos e); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DB D/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: und efined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Te st/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error 2 Please Help - am I installing DBD in the wrong directory? MySQL is installed in /usr/local/mysql - should I be running this make file there??? Thank in advance, Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl DBD Errors???
I installed DBI just fine, now I'm installing DBD and am getting the following error message from 'make test'. Can anyone translate??? [root@clx Msql-Mysql-modules-1.2210]# make test make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00 503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbos e); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DB D/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: und efined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Te st/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error 2 [root@clx Msql-Mysql-modules-1.2210]# Thanks in advance, Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl MySQL Interface
go to perl.com - click CPAN and look for DBI and DBD, and look for docs on how to install a perl module. You need to install DBI first, then DBD... hope this helps. Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === -Original Message- From: Brian Cassidy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 3:59 PM To: [EMAIL PROTECTED] Subject: Perl MySQL Interface I have installed MySQL 3.23 on RedHat 7 using the rpms. Installing the bench rpm gives "MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.36-1". I can't seem to locate any version of this dbi which will install. I see that mysql.com has a perl dbd module for MySQL but that is not an rpm. Is that what I need? If so, how do I install it? --- Brian Cassidy [EMAIL PROTECTED] http://people.unb.ca/~bpc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl - DBD:DBI Errors
Hi Gerald, I installed ldconfig, and then zlib. Now went back to install DBD and get the following when running make test (looks similar to original problem): [root@clx Msql-Mysql-modules-1.2210]# make test make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00 503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbos e); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DB D/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: und efined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Te st/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error 2 [root@clx Msql-Mysql-modules-1.2210]# Thanks, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Monday, April 09, 2001 6:12 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Then load the ldconfig RPM. Chris Becker wrote: Gerald - My rpm was hosed. I downloaded from a rh ftp site and got it installed. Now back to installing zlib - see command below: /linuxrpmsrpm -ivh zlib-1.1.3-6.i386.rpm failed dependencies: /sbin/ldconfig is needed by zlib-1.1.3-6 I'm not having any luck figuring this out... Again - Thanks for your patience and working this thing through with me! Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 10:28 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Looks like you may have trashed rpmrc. Does it exist? If not, you have a problem. Check with Red Hat. Chris Becker wrote: yes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 5:59 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You are logged in as root, are you not? Chris Becker wrote: Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root. Any ideas? Thanks, Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, April 04, 2001 10:23 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Chris Becker wrote: I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package with the following command and get the following error: rpm -ivh zlib-1.1.3-6.src.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. When I originally installed the os I selected a custom install and checked every option provided. Why can I not use the rpm utility? Do I need to install that? I have an rpm entry in the man pages??? I am logged in as root. Please help, and... Thanks Again, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib
RE: Perl - DBD:DBI Errors
yes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 5:59 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You are logged in as root, are you not? Chris Becker wrote: Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root. Any ideas? Thanks, Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, April 04, 2001 10:23 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Chris Becker wrote: I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package with the following command and get the following error: rpm -ivh zlib-1.1.3-6.src.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. When I originally installed the os I selected a custom install and checked every option provided. Why can I not use the rpm utility? Do I need to install that? I have an rpm entry in the man pages??? I am logged in as root. Please help, and... Thanks Again, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker That is a source RPM. Your looking in the wrong directory. look on RedHat/RPMS - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl - DBD:DBI Errors
Gerald - My rpm was hosed. I downloaded from a rh ftp site and got it installed. Now back to installing zlib - see command below: /linuxrpmsrpm -ivh zlib-1.1.3-6.i386.rpm failed dependencies: /sbin/ldconfig is needed by zlib-1.1.3-6 I'm not having any luck figuring this out... Again - Thanks for your patience and working this thing through with me! Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 10:28 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Looks like you may have trashed rpmrc. Does it exist? If not, you have a problem. Check with Red Hat. Chris Becker wrote: yes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 5:59 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You are logged in as root, are you not? Chris Becker wrote: Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root. Any ideas? Thanks, Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, April 04, 2001 10:23 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Chris Becker wrote: I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package with the following command and get the following error: rpm -ivh zlib-1.1.3-6.src.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. When I originally installed the os I selected a custom install and checked every option provided. Why can I not use the rpm utility? Do I need to install that? I have an rpm entry in the man pages??? I am logged in as root. Please help, and... Thanks Again, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker That is a source RPM. Your looking in the wrong directory. look on RedHat/RPMS - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
RE: Perl - DBD:DBI Errors
Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root. Any ideas? Thanks, Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, April 04, 2001 10:23 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Chris Becker wrote: I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package with the following command and get the following error: rpm -ivh zlib-1.1.3-6.src.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. When I originally installed the os I selected a custom install and checked every option provided. Why can I not use the rpm utility? Do I need to install that? I have an rpm entry in the man pages??? I am logged in as root. Please help, and... Thanks Again, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker That is a source RPM. Your looking in the wrong directory. look on RedHat/RPMS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl - DBD:DBI Errors
I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package with the following command and get the following error: rpm -ivh zlib-1.1.3-6.src.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. When I originally installed the os I selected a custom install and checked every option provided. Why can I not use the rpm utility? Do I need to install that? I have an rpm entry in the man pages??? I am logged in as root. Please help, and... Thanks Again, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(sin asunto)
try INSERT INTO tblDomains (field1, field2) VALUES (1, 'trlinux.com.'); ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cesar Martinez Sent: Wednesday, March 28, 2001 12:40 PM To: [EMAIL PROTECTED] Subject: (sin asunto) that such!! an excuseme for my english,I am installing postaci 1.1.3 with mysql 3.23., and when inserting the domain in the tblDomains , accorfing to this syntax: INSERT INTO tblDomains VALUES (1,'trlinux.com.'); it marks me the following error syntax error near unexpected token '(1' could somebody help? thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl - DBD:DBI Errors
Is the zlib on CPAN? like module Compress::Zlib ? Many Thanks Gerald! ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: STUPID QUESTION
Note that foreign keys in SQL are not used to join tables, but are used mostly for checking referential integrity (foreign key constraints). If you want to get results from multiple tables from a SELECT statement, you do this by joining tables: SELECT * from table1,table2 where table1.id = table2.id; or use alias SELECT t1.ID, t2.Name from table1 t1, table2 t2 where t1.id = t2.id ChrisB -Original Message- From: GERARDO GALLARDO [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 3:57 PM To: [EMAIL PROTECTED] Subject: STUPID QUESTION I'm new to MySQL and SQL in general. I have been searching and searching but I can't find an answer to a question which I know is simple. I have read a book called Teach Yourself MySQL in 21 days. It talkes about defining relationships between tables but it never actually shows you how you would create these relationships or reference data from one table in another table. How do I do this? Please help. Gerardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Uninstall
I'm going to try an Un-Install, then Re-Install Mysql. How do I Un-Install?? Thanks, Chris B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php