Re: RPM Install appears to have failed

2002-10-03 Thread Chris Becker
t'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

Re: RPM Install appears to have failed

2002-10-03 Thread Chris Becker
gain. 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, >Pr

Archive of this mysql list

2002-10-03 Thread Chris Becker
>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:

Perl & MySQL installed with rpm's vs binaries combination

2002-10-03 Thread Chris Becker
ts/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 h

RPM Install appears to have failed

2002-10-02 Thread Chris Becker
ctory 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] --

Re: ADO API support?

2002-03-20 Thread Chris Becker
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 stat

Access denied for user: 'root@localhost'

2002-03-15 Thread Chris Becker
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.

Re: Query

2002-03-14 Thread Chris Becker
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 numbe

Re: VB/MySql/CrystalReport Problem?

2002-03-14 Thread Chris Becker
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

Re: Encrypted table

2002-03-11 Thread Chris Becker
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

MySQL and MSAccess

2002-03-11 Thread Chris Becker
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

MySQL and MSAccess

2002-03-11 Thread Chris Becker
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 solutio

RE: VBA/VB DAO/ADO MS Access to MySQL?

2001-05-29 Thread Chris Becker
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 b

RE: Telnet into MySQL

2001-05-21 Thread Chris Becker
Tera Term Pro -Original Message- From: Tim Thorburn [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 1:21 PM To: [EMAIL PROTECTED] Subject: Telnet into MySQL Hello, Can someone here recommend a good Telnet program (with SSH) that I can use to connect to my servers MySQL database?

RE: Unusual dependency error w/ rpm??

2001-05-02 Thread Chris Becker
stall & 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

Unusual dependency error w/ rpm??

2001-05-02 Thread Chris Becker
Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysql>rpm -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 M

Unusual dependency error w/ rpm??

2001-05-01 Thread Chris Becker
I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysql>rpm -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

INSTALL rpm over tar.gz??

2001-05-01 Thread Chris Becker
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 -

perl DBD make test errors??? Please Help (PROBLEM SOLVED, I think...)

2001-05-01 Thread Chris Becker
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

perl DBD make test errors??? Please Help

2001-04-30 Thread Chris Becker
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 =

RE: Perl MySQL Interface

2001-04-11 Thread Chris Becker
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

Perl DBD Errors???

2001-04-11 Thread Chris Becker
ving 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] === ---

RE: Perl - DBD:DBI Errors

2001-04-10 Thread Chris Becker
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 Bec

RE: Perl - DBD:DBI Errors

2001-04-06 Thread Chris Becker
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:DB

RE: Perl - DBD:DBI Errors

2001-04-06 Thread Chris Becker
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: > >

RE: Perl - DBD:DBI Errors

2001-04-05 Thread Chris Becker
: [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 &g

RE: Perl - DBD:DBI Errors

2001-04-04 Thread Chris Becker
[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

RE: Perl - DBD:DBI Errors

2001-03-28 Thread Chris Becker
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

(sin asunto)

2001-03-28 Thread Chris Becker
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!! a

Perl - DBD:DBI Errors

2001-03-27 Thread Chris Becker
bye the bye, I'm running RH6.2 on Intel 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

Perl - DBD:DBI Errors

2001-03-27 Thread Chris Becker
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.c

RE: STUPID QUESTION

2001-03-26 Thread Chris Becker
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

RE: STUPID QUESTION

2001-03-26 Thread Chris Becker
-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 si

Can't connect err

2001-03-23 Thread Chris Becker
Hi All, I installed MySQL on my RH6.2 intel box to the default directory specified by the install /usr/local/mysql. After following the installation instructions, I was able to perform the Post-Install test ok, the server started, I queried the test dbase, etc. 2 days post install I booted up

Uninstall

2001-03-23 Thread Chris Becker
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

Uninstall

2001-03-23 Thread Chris Becker
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 ar

Can't connect err

2001-03-23 Thread Chris Becker
Hi All, I installed MySQL on my RH6.2 intel box to the default directory specified by the install /usr/local/mysql. After following the installation instructions, I was able to perform the Post-Install test ok, the server started, I queried the test dbase, etc. 2 days post install I booted up t