RE: Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

2008-06-21 Thread Swigg, Tom C
Much work still to be done. Congrats to the Open Source Community for producing such portable software. Regards Tom -Original Message- From: Joerg Bruehe [mailto:[EMAIL PROTECTED] Sent: Fri 20-Jun-08 6:57 PM To: Swigg, Tom C Cc: mysql@lists.mysql.com Subject: Re: Migration of mysql 3.23.32

Re: Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

2008-06-20 Thread Joerg Bruehe
Hi Tom, all, Swigg, Tom C wrote: I have been given the task of migrating some 200+ web sites fom Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1 Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the developers have long gone... The objective is to provide a 3.23.32 environment

Re: Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

2008-06-17 Thread Glennie Vignarajah
Le Tuesday 17 June 2008 vers 14:51, Swigg, Tom C("Swigg, Tom C" <[EMAIL PROTECTED]>) a écrit: Hello, > I have been given the task of migrating some 200+ web sites fom > Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1 > Many of these sites use PHP3 (3.0.18)

Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

2008-06-17 Thread Swigg, Tom C
I have been given the task of migrating some 200+ web sites fom Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1 Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the developers have long gone... The objective is to provide a 3.23.32 environment on RHEL 5.1 which will run in

MySQL 3.23.32 way faster than 3.23.46

2001-12-11 Thread lcalero
Hi. I've been testing some querys with this two versions of mysql and found weird results. First we try with 3.23.32: (foo)-/usr/local/mysql_3.23.32/bin# ./mysql -uroot publish Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.32-lo

Re: mysql-3.23.32-1.7.i386.rpm

2001-04-09 Thread Gerald Clark
The RPM on the CD has problems. Go to RedHat or MySQL and get a new one. "Harry C. Marotto Jr." wrote: > > I'm trying to set up a database system for the first time. I installed >mysql-3.23.32-1.7.i386.rpm > on my RedHat Linux version 7.0, but it doesn't se

mysql-3.23.32-1.7.i386.rpm

2001-04-06 Thread Harry C. Marotto Jr.
I'm trying to set up a database system for the first time. I installed mysql-3.23.32-1.7.i386.rpm on my RedHat Linux version 7.0, but it doesn't seem to have set up correctly. Is anyone familiar with how to proceed from the point of installing this RPM to getting the server conf

Re: Problem with MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)

2001-03-12 Thread Dan Nelson
In the last episode (Mar 12), [EMAIL PROTECTED] said: > >Description: >When I try and run scripts/mysql_install_db I get the error >'/usr/libexec/ld-elf.so.1: > /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same >error when I tried to run mysql using > /usr

Problem with MySQL Binary (mysql-3.23.32-unknown-freebsdelf4.2-i386)

2001-03-12 Thread drew
ow >Category: mysql >Class: sw-bug >Release: mysql-3.23.32 (Source distribution) >Environment: System: FreeBSD heffalump.ricshaw.com.au 4.1-RELEASE FreeBSD 4.1-RELEASE #0: Fri Jul 28 14:30:31 GMT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some pat

Mysql 3.23.32 (and other versions) on Slackware 7 crash with SIGSEGV

2001-03-08 Thread root
>Description: I have tried to install and run Mysql 3.23.32 source tarball with BerkeleyDB 3.2.3h. I also tried previous versions of Mysql (3.23.29, 27, 25) all with the same result. I have tried the following on 3 different systems which are detailed below. I have tr

mysql 3.23.32 compiled only works without BDB!!!

2001-03-07 Thread Andrei B.
I have mysql 3.23.32 source tarball and Berkely DB 3.2.3h source tarball. BDB : configure --enable-static --enable-cxx; make ; make install MySQL : configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --enable-thread-safe-client ; make ; make install

Re: auto_increment problem with mysql 3.23.32

2001-02-28 Thread Bard dZen
D] >Subject: auto_increment problem with mysql 3.23.32 >Date: Wed, 14 Feb 2001 12:21:50 +0100 > >Hi, > >It's me again ;-) Now I have got a very serious problem. I've just >downloaded >3.23.32 and compile then run it without any major trouble. BUT my heada

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-26 Thread Florian G. Pflug
On Mon, Feb 26, 2001 at 04:45:50PM +0100, Thomas Spahni wrote: > On Wed, 21 Feb 2001, Hagen Hoepfner wrote: > > > I can normaly use mysql > > if I am root. But if i'm logged in as normal user or try to connect to mysql > > via php i got the following error message: > > > > MySQL Connection Fai

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-26 Thread Thomas Spahni
On Wed, 21 Feb 2001, Hagen Hoepfner wrote: > I can normaly use mysql > if I am root. But if i'm logged in as normal user or try to connect to mysql > via php i got the following error message: > > MySQL Connection Failed: Can't connect to local MySQL server through socket > '/var/lib/mysql/my

MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-21 Thread Hagen Hoepfner
Hello, I use SuSE Linux 7.1 with a 2.4 kernel. I have installed the normal SuSE-MySQL packages and creates the default tables. I can normaly use mysql if I am root. But if i'm logged in as normal user or try to connect to mysql via php i got the following error message: MySQL Connection Faile

Re: problem of use mysql 3.23.32

2001-02-20 Thread Mohamad Ilhami
On Tue, 20 Feb 2001, freelsq wrote: > I write a cgi problem of c++, and I compile it and run it normally in mysql 3.22.25. > but when I change the mysql to 3.23.32, I recompile the program and run it, > It display a error msg like this: > > shell>./test > ./test.fgi: error in loading shared l

problem of use mysql 3.23.32

2001-02-19 Thread freelsq
I write a cgi problem of c++, and I compile it and run it normally in mysql 3.22.25. but when I change the mysql to 3.23.32, I recompile the program and run it, It display a error msg like this: shell>./test ./test.fgi: error in loading shared libraries: libmysqlclient.so.10: cannot open s

RE: Please Help me ..Apache_1.3.17+php-3.0.16+mysql-3.23.32

2001-02-16 Thread Fabian Gonzalo
I can't to compile this I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd buildmark.

Apache_1.3.17+php-3.0.16+mysql-3.23.32

2001-02-16 Thread Fabian Gonzalo
I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd buildmark.o modules.o modules/

Re: auto_increment problem with mysql 3.23.32

2001-02-15 Thread Sinisa Milivojevic
William R. Mussatto writes: > On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: > > can an auto_increment column also have the attribute "unsigned" safely? > > Sincerely, > > William Mussatto, Senior Systems Engineer > CyberStrategies, Inc > ph. 909-920-9154 ext. 27 > > Yes it can.

Re: auto_increment problem with mysql 3.23.32

2001-02-14 Thread William R. Mussatto
On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: > Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET) > From: Sinisa Milivojevic <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: auto_increment problem with mysql 3.23.32 snip.. > > Hi!

Re: auto_increment problem with mysql 3.23.32

2001-02-14 Thread Gábor Lénárt
On Wed, Feb 14, 2001 at 04:21:31PM +0200, Sinisa Milivojevic wrote: > Hi! > > The above is actually documented behaviour. I've just realized that it's true (checked). But it was supported by older mysql versions and now I'm getting stuck with the old tables (MyISAM). > > Entering negative valu

Re: auto_increment problem with mysql 3.23.32

2001-02-14 Thread Sinisa Milivojevic
Gábor Lénárt writes: > On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote: > > Hi! > > > > I have just tested your case on my Linux and it worked just fine. > > > > What OS is that and are you using our binaries. If not, please do. > > OK, I will (but it takes some time

Re: auto_increment problem with mysql 3.23.32

2001-02-14 Thread Gábor Lénárt
On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote: > Hi! > > I have just tested your case on my Linux and it worked just fine. > > What OS is that and are you using our binaries. If not, please do. OK, I will (but it takes some time to download). Till that I have got a more acc

Re: auto_increment problem with mysql 3.23.32

2001-02-14 Thread Sinisa Milivojevic
Gábor Lénárt writes: > Hi, > > It's me again ;-) Now I have got a very serious problem. I've just downloaded > 3.23.32 and compile then run it without any major trouble. BUT my headache > is about this: > > > mysql> insert into cikk values (NULL,'Beta','','','','','N','','',NULL,0,0,0,0

auto_increment problem with mysql 3.23.32

2001-02-14 Thread Gábor Lénárt
Hi, It's me again ;-) Now I have got a very serious problem. I've just downloaded 3.23.32 and compile then run it without any major trouble. BUT my headache is about this: mysql> insert into cikk values (NULL,'Beta','','','','','N','','',NULL,0,0,0,0); mysql> select * from cikk where cim='Beta'

problem with configure Mysql-3.23.32 on INTEL/SOLARIS8

2001-02-13 Thread Remy . Mary
I try to install Mysql-3.23.32 on INTEL/SOLARIS8 the command ./configure --prefix=/usr/local/mysql returns following error : checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes

Re: Building php4.0.4pl1 with mysql 3.23.32

2001-02-12 Thread Irmund Thum
Scott Brown schrieb: > Does anyone have any suggestions??? As near as I can tell mysql_fetch_array > is failing - but there is a return result otherwise I'd be getting an error > message out of this routine... > > I'm really confused here. sounds strange! I've no problems using php4.04pl1 with

Building php4.0.4pl1 with mysql 3.23.32

2001-02-11 Thread Scott Brown
I've got a real weird problem happening after building 4.0.4pl1 and mysql 3.23.32 on my test machine. I previously had 4.0.1 up and running with an earlier version of mysql - I think it was 3.22.xx - and this combination worked fine. I *seem* to successfully connect to my mysql dat

Re: FW: mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1 V5.1

2001-02-09 Thread Sinisa Milivojevic
Hanneke Kroon writes: > See bugreport below. > > -Original Message- > From:[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent:Friday, 09 February, 2001 10:38 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: mysql-3.23.32-dec-os

FW: mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1 V5.1

2001-02-08 Thread Hanneke Kroon
See bugreport below. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, 09 February, 2001 10:38 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthread error in OSF1 V5.1 MySQL binary 3.23.32

Building mysql-3.23.32 on AIX-4.3.2 with IBM's C++ v5 compiler...

2001-02-08 Thread Ciaran.Deignan
Hi All, I've built previous versions of mysql with gcc/g++ or other IBM C++ compilers, but I'm having some problems with their VisualAge C++ V5.0.1 compiler. Curently I have an error while compiling sql/sql_lex.cc. My command-line (reduced to the minimum) is xlC_r -DMYSQL_SERVER -DHAVE

RE: Installing MySQL 3.23.32 on Solaris 8 Intel

2001-02-06 Thread Summanen,Jack
TECTED] Subject: Installing MySQL 3.23.32 on Solaris 8 Intel Hi, I attempted to install MySQL 3.23.32 on a Solaris 8 Intel. The version of cc I have is gcc 2.95.2. The version of tar I have is gnu tar 1.13. I encountered a problem while issuing this command : o ./configure --prefix=/usr/local/mysql Th

Installing MySQL 3.23.32 on Solaris 8 Intel

2001-02-06 Thread Yeo Lip Hong
Hi, I attempted to install MySQL 3.23.32 on a Solaris 8 Intel. The version of cc I have is gcc 2.95.2. The version of tar I have is gnu tar 1.13. I encountered a problem while issuing this command : o ./configure --prefix=/usr/local/mysql The error message is : o checking return type of

Re: mySQL 3.23.32 memory optimization ....

2001-02-03 Thread Michael Widenius
Hi! > "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes: Tim> On Fri, Feb 02, 2001 at 05:48:41PM +0100, Marcello Giovagnoli wrote: >> > >> > Do you mean that mysql_store_result() should store everything to a >> > local file and and mysql_fetch... should read from this file? >> > This should not

Re: mySQL 3.23.32 memory optimization ....

2001-02-03 Thread Michael Widenius
Hi! > "Marcello" == Marcello Giovagnoli <[EMAIL PROTECTED]> writes: >> Do you mean that mysql_store_result() should store everything to a >> local file and and mysql_fetch... should read from this file? >> This should not be that hard to do. Marcello> Yes, you can use the actual SQL_CURSOR

Re: mySQL 3.23.32 memory optimization ....

2001-02-02 Thread Tim Bunce
On Fri, Feb 02, 2001 at 05:48:41PM +0100, Marcello Giovagnoli wrote: > > > > Do you mean that mysql_store_result() should store everything to a > > local file and and mysql_fetch... should read from this file? > > This should not be that hard to do. Like SQL_BUFFER_RESULT, but at the client inst

Re: mySQL 3.23.32 memory optimization ....

2001-02-02 Thread Marcello Giovagnoli
> > Do you mean that mysql_store_result() should store everything to a > local file and and mysql_fetch... should read from this file? > This should not be that hard to do. > Yes, you can use the actual SQL_CURSOR_FORWARD_ONLY that is unused at this moment, to call mysql_store_result_on_file()

Re: mySQL 3.23.32 memory optimization ....

2001-02-01 Thread Michael Widenius
Hi! > "Marcello" == Marcello Giovagnoli <[EMAIL PROTECTED]> writes: Marcello> Hi Monty, >> Why do you need to retrieve so many rows to the client? Can't you use >> LIMIT to restrict the number of result rows? Marcello> The point is that the program scans the entire table and process each

Re: mySQL 3.23.32 memory optimization ....

2001-02-01 Thread Marcello Giovagnoli
Hi Monty, > Why do you need to retrieve so many rows to the client? Can't you use > LIMIT to restrict the number of result rows? The point is that the program scans the entire table and process each row in a diffrent way, executing other queryes inside the main SQLFetch() loop. Someting like th

Re: mySQL 3.23.32 memory optimization ....

2001-02-01 Thread Sinisa Milivojevic
Marcello Giovagnoli writes: > Hi Monty, > > > Why do you need to retrieve so many rows to the client? Can't you use > > LIMIT to restrict the number of result rows? > > The point is that the program scans the entire table and process each row > in a diffrent way, executing other queryes

mySQL 3.23.32 memory optimization ....

2001-02-01 Thread Marcello Giovagnoli
Hi, firstly thanks for your answer, [EMAIL PROTECTED] works very very well ! We are doing a very hard work with mySQL , used as main database inside our ERP Oasi. (instead of DB2 or ORACLE). We have a performance problem with memory usage. the process accesses to database via ODBC (iodbc2-12+

Slackware AND mySQL 3.23.32 memory problems ....

2001-02-01 Thread Michael Widenius
hi! > "Marcello" == Marcello Giovagnoli <[EMAIL PROTECTED]> writes: Marcello> Hi, Marcello> I'm sorry, for my previus question "To thread or not to thread " Marcello> but now all it's OK. :) Marcello> Looking at /etc/my.cnf, i could see two variables: Marcello> set-variable= thre

Re: Slackware AND mySQL 3.23.32 memory problems ....

2001-02-01 Thread Sinisa Milivojevic
Marcello Giovagnoli writes: > Hi, > > I'm sorry, for my previus question "To thread or not to thread " > but now all it's OK. :) > > Looking at /etc/my.cnf, i could see two variables: > > set-variable= thread_cache=8 > set-variable= thread_concurrency=8 # Try number of C

Slackware AND mySQL 3.23.32 memory problems ....

2001-01-31 Thread Marcello Giovagnoli
Hi, I'm sorry, for my previus question "To thread or not to thread " but now all it's OK. :) Looking at /etc/my.cnf, i could see two variables: set-variable= thread_cache=8 set-variable= thread_concurrency=8 # Try number of CPU's*2 this should set the edge to the maximum threads

mysql-3.23.32/client/mysql.cc

2001-01-31 Thread Peter Dyballa
tune=ultrasparc -felide-constructors -fno-exceptions -fno-rtti" compilation stops with: gmake[2]: Entering directory `/opt/www/Diele/mysql-3.23.32/client' gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -Wa,-xarch=v8plusa -O6 -mcpu=v9

FreeBSD 4.2-stable + MySQL 3.23.32 sig 11 problem

2001-01-27 Thread Artem Koutchine
Hi! I am having this weird problem that MySQL just dies with signal 11 several time per day when loads get just a bit hight (the load is very low, about 1 q/s and on some export ops it gets a bit high two time per 24 hours). Any way, FreeBSD 4.2 is not RELASE but STABLE which is cvsupped pretty o

Re: Upgrading to MySQL 3.23.32

2001-01-25 Thread Ed Carp
James R. Butzen ([EMAIL PROTECTED]) writes: > Hi All, > > We are thinking to upgrade our MySQL servers to MySQL 3.23.32. Have any one > experienced any unexpected problem due to upgrade. We upgraded our production and development servers from 3.23.7 to 3.23.32 today. The only

Upgrading to MySQL 3.23.32

2001-01-25 Thread James R. Butzen
Hi All, We are thinking to upgrade our MySQL servers to MySQL 3.23.32. Have any one experienced any unexpected problem due to upgrade. Thanks in advance for any comments. James R. Butzen NEBIS Tech. Support http://www.nebis.com

RE: Query problem in mysql.3.23.32

2001-01-24 Thread jgomez
OK,here goes more information about my problem: I have a table with the next structure: flag char(1) nextval bigint(20) unsigned autoincrement The query i execute with no problems in mysql 3.22 is: select * from table; REPLACE INTO table values (\'\',nextval+1)

mysql 3.23.32 & table problems

2001-01-24 Thread Peter Zaitsev
Hello monty, I'm using mysql 3.23.32 on linux and it looks like there is a problem with check/auto-recovery left: On many of my servers I find the above in a log file: 24.Jan 23:45:07 : pid:1412 counter:32256 AllInOne MySqlEr Query - #1034 [tor.local] - Incorrect key file for

RE: Query problem in mysql.3.23.32

2001-01-24 Thread Don Read
On 24-Jan-01 Jesús Gómez Pastor wrote: > I have a problem in 3.23.32, > The query > > select * from table > repalce table values('','nextval+1) ^^ ^ these might be a problem, in addition to your select/replace/(update) confusion. > > returns me always nextval=1. n

Query problem in mysql.3.23.32

2001-01-24 Thread Jesús Gómez Pastor
I have a problem in 3.23.32, The query select * from table repalce table values('','nextval+1) returns me always nextval=1. table has 1 row and the query runs fine in mysql 3.22.x Any idea? Thanks.

php 4.0.4 + MySQL 3.23.32 with charset different from latin1

2001-01-24 Thread Boril Yonchev
I have a problem with mysql_connect() when use character set for MySQL server different from default (latin1). Every time when I change charset PHP says: Warning: MySQL Connection Failed: Can't initialize character set 17 (path: default) I've try to recompile PHP when MySQL compiled by defaul

Problem on Installing a MySQL 3.23.32 Source Distribution on Sun Solaris 2.6 ???

2001-01-23 Thread Michel Tignyemb
I have done the source installation of MySQL 3.23.31 on Sun Solaris 2.6. I execute tests found in .../mysql-test directory using 'force' option to continue after aborted tests ( ./mysql-test-run --force). How can I do with those aborted cases, known that I have to install master-slave replica

MySQL 3.23.32 charset problem between big5/latin1

2001-01-23 Thread ljm
>Fix: Dunno... >Submitter-Id: >Originator:ljm >Organization: >MySQL support: none >Synopsis: >Severity: serious >Priority: medium >Category: mysql >Class: support >Release: mysql-3.23.32 (Source distribution)

MySQL 3.23.32

2001-01-22 Thread Michael Widenius
Hi! Because of the core-dump bug when getting an Aborted Connecting when running a mysqld compiled for debugging, we decided to make a new release almost at once. This also fixes a timing problem in replication. Hopefully we don't need to do many more 3.23 releases :) Changes in release 3.23