Ah
I did not know that. Excellent.
Still does not get round the issue that MySQL in most default binary
distributions does not include SSL. Which I think is a shame, but then
again is probably a lib issue.
Thanks for that.
Greg
-Original Message-
From: Eamon Daly [mailto:[EMAIL
I need to connect to a remote MySQL database from a PC using
SSL. I would
prefer to connect using perl DBD. Does anyone have a
suggestion how I can
accomplish this task or an alternative solution?
What about stunnel or ssh tunnels and then use DBD::mysql on top.
ISTR that DBD::mysql
hi all,
i'm developing a web based application under r-g linux 9 with
MySQL 3.23.54a-11. i have planned to upgrade it to 4.0.20. it
seems that if i keep the current version of MySQL running for
more than 8 hrs, it times out with the web-server (tomcat
4.x) and dies out. due to this,
A probable reason is that these are in startup files and hence the interface
needs file system access.
AFAIAA There are plans to have dynamic settings that can be changed at
runtime, but these are still plans.
No idea on the rest of it thou.
Neat tool, and looks great! Like the backup tools.
Dear All
I've reverted back to 3.23.43 from 4.0.0 as I was unable to get it to
start on my (patched) Redhat 6.2 box.
Has anyone else managed to get the binary distro of 4.0.0-alpha to
start on a Redhat 6.2 box ?
Thanks
Greg
sql
Dear Mysqlers
mysql_config in the linux binary distro appears to have two similar bugs
...
When run it returns:
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags[-I'/usr/local/mysql/include/mysql']
--libs [-static
a few MySQL chipped in.
Sorry if this sounds a little negative and sarcastic, but I've delt with
a few projects where it got over complicated because of the use of
XML/XSLT, and managers whom want to use a product because its got nive
brochures and buzwords .
Greg Cope
Regards,
Gary SuperID
Pete Kuczynski wrote:
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
IBM Netfinity server
Dear All
I want to bind mysqld to one IP address on a multi-homed host.
A search of the manual has not revealed anything - have I missed
something or is this not an option ?
If its not an option can it be added ?
Thanks
Greg
Cesar Cabrera wrote:
Hello and thanks,
can you tell me where can I get information about the errors
presented by MySQL? I have that kind of trouble each time the server (the
machine) crash and it's no solved after myisamchk with any option.
a) perror [error number]
b)
Daniel wrote:
Scratch that, normally egcs and gcc are the same, at least on older
redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the
same as your gcc.
I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild
3.23.38 from the .src.rpm.
Both show tables,
Tonu Samuel wrote:
On 09 May 2001 09:43:59 +0100, Eugénio Veiga wrote:
Hi
Does any body if is possible in windows 9x to implement odbc for MySql
with ssl ?
There exists any driver for this ?
Well, I do not know much about ODBC. But anyway if you tell MySQL with
SSL then you mean
Sudhir wrote:
Hi,
I am a Sudhir, working as a Software Consultant in Unidux Technologies,
Singapore. My job here is to suggest Technology. Now we are planning to
purchase license for the application server JRun. Currently we are
developing a procurement engine in Java, using MySql as
Andy Sharp wrote:
Hi,
I'm facing an issue with my primary mySQL server. It powers a web site,
which loads almost 100% dynamic data. At peak times of the day, it
seems to me that the Database is becomming maxxed. (Thus bogging the
site)
I'm aware that there are simply too many
Peter Zaitsev wrote:
Hello Greg,
Saturday, March 17, 2001, 3:31:53 AM, you wrote:
GC It would be very handy if Innobase (and the GEMINI when it comes along)
GC where to support mysqldump in the standard way, as I assume it works as
GC such and I and many others would have to change
Michael Widenius wrote:
Hi!
The 3.23.35 mainly fixes a critical bug in 3.23.34 with ORDER BY. We
don't know how the ORDER BY bug slipped through our testing suite or
how fatal it's really is, but as we have got a couple of reports about
core dumps regarding this, we recommend 3.23.34
Michael Widenius wrote:
Hi!
Greg On the off chance any ideas when this (A Gemini THandler) 3.23.x release
Greg may be and when we might see a public 4.x alpha. I know the answer will
Greg probably be "When its ready" but a small clue would be nice :-)
Lets guess a bit :)
3.23.36
Michael Widenius wrote:
Hi!
Try:
mysqldump --tab=directory
This does basicly what you want.
After that, it's up to Heikki to fix Innobase to do delayed creation
of indexes.
It would be very handy if Innobase (and the GEMINI when it comes along)
where to support mysqldump in the
Dear All
The following C and CXX flags will work (/usr/local/bin/gcc is actually
pgcc).
Reading specs from
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs
gcc version pgcc-2.95.2.1 20001224 (release).
CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double'
Zoran Raskovic wrote:
so does the mysql have to be installed under
/usr/local/mysql ?
I made a symbolic link named mysql that points to the
/usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory
is that ok ?
yup
I go further and seperate data from binaries.
This helps with partion
lounge fly wrote:
Wow, did I ever screw up.
I meant to drop an unused development database and ended up dropping a used
production database.
Can I recover it?
If so, how?
Go find a backup ;-0
If you've not got any then you can, but it may not work, restore /
undelete files - their
Dear All
I've been using apachetoolbox - a shell script that installs apache with
the options of including lots of modules (php, mod_ssl, mod_perl etc
...). Its great for installing a custom apache (something I do all to
often ;-).
It offers a menu and will download / configure / complie any
: submitter ID
Originator:Greg Cope
Organization:
MySQL support: none
Synopsis: SHOW command possiblxky broken in 3.23.33
Severity: non-critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.33 (Source distribution)
Environment
Eugene Lineitzev wrote:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
How-To-Repeat:
Install RedHat 7.0 on Intel platform, apply all updates from RedHat
(up to
Canadian Lumberer wrote:
Hi,
I hope to be helpful for further investigation of the problem.
On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't
"MikeBlezien" wrote:
Hello All,
Was wonder if any knows of a Perl equivalent to the PHP's version of
phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
installed, and frankly, to lazy to do all the typing thru telnet session! :)
MysqlTool
Looks pretty good
Sinisa Milivojevic wrote:
As building process, nor system libs, may not be perfect, try using
our binaries.
Thanks Sinisa, but this does not solve the problem - I've several
machines (RedHat|SUSE|SUN) (7) that all have near identical (with
different data and binary dirs so that I can upgrade
Sinisa Milivojevic wrote:
HI!
In response to several mail messages on mailing list that were
centered around some misbehaviour of SHOW DATABASES / TABLES, I have
tested thoroughly (with several --user=... options) 3.23.33 and found
out that it works perfectly.
Hum
Not meaning to
Dear All
I've just installed mysql on a new host (3.23.33) and show databases
does not work ;-(.
The data directory is thus:
drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql
Inside it has:
[root@server1 lib]# ls -l mysql/
total 28
drwx--S---2 mysqlmysql4096 Feb
Rick Roberts wrote:
SHOW DATABASES;
Sorry my subject line had the last S missing:
mysql 010216 15:29:14 1 Query SHOW DATABASES
SHOW DATABASES;
+--+
| Database |
+--+
| |
| |
| |
| |
| test |
+--+
5 rows in set (0.01
:Greg Cope
Organization:
organization of PR author (multiple lines)
MySQL support: none
Synopsis: SHOW command possiblxky broken in 3.23.33
Severity: non-critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.33 (Source distribution)
Environment
Fred van Engen wrote:
On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote:
Dear All
I've just installed mysql on a new host (3.23.33) and show databases
does not work ;-(.
Maybe it would help to read (or search) the list before posting.
I have already searched the list
Rick Roberts wrote:
mysql select version();
+---+
| version() |
+---+
| 3.23.33 |
+---+
1 row in set (0.01 sec)
mysql SHOW DATABASES;
+--+
| Database |
+--+
| mysql|
| test |
+--+
2 rows in set (0.02 sec)
I'm using
Dave Hodgkinson wrote:
"mike thomas" [EMAIL PROTECTED] writes:
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be greatWould
I be correct in saying that a select of this type will always do
a table scan?
Lee Jenkins wrote:
Hello all.
We are currently using MS Access for a multi-user application (4-5 clients).
We sent out a system to a customer with NT Service enabled in anticipation
of switching over to MySQL.
We noticed that when activity on the MS database got heavy (if you can call
Dear All
Here is a quick / obvious hack to supportfiles/mysql.server.sh to add
restart command.
I added this as I sometimes do a hard restart, and thought it may be of
use to others.
Can this be patched to the one in the source by someone with CVS rights
- it should not break anything ;-)
Lee Martin wrote:
I would like to know whether the latest version of MySQL supports OO
databse design and the Enhanced Entity Relationship Model in particular
Specialization and Generalization.
As much as any (generalised) RDBMS. (i.e no).
The (excellent) Manual (online) outline what it
Matt Wagner wrote:
Greg Cope writes:
Chris Johnson wrote:
Description:
I just downloaded MySQL 3.23.31 and the "patched version" of
Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
with the option to enable the Berkeley DB, bu
Chris Johnson wrote:
Description:
I just downloaded MySQL 3.23.31 and the "patched version" of
Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
with the option to enable the Berkeley DB, but it fails, telling
me I don't have the proper
39 matches
Mail list logo