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 P
> 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 c
>
> 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 t
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. T
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 -L'/usr/local/mysql/lib/mysql
idea, but this was discussed on the list a few months ago - check the
archives as I think 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
Jeremy Zawodny wrote:>
> On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
> >
> > The other solution is rsync. I dont know much about this guy yet,
> > but I have some concerns with using it to copy over large remote
> > files. For example, if I have a 1.2 gig table that has been hea
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 se
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
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
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
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 MyS
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 ma
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
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 mysqldum
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 :)
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
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 st
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'
CXX='/u
Dear All
I got very excited today when 3.23.34 worked (i.e now show tables bug) !
I then recomplied with optimisations and then with pgcc and bug
reappears.
I am now having a go with different CFLAGS and CXXFLAGS.
Not being a C / complier / libs expert I can not comment any further !
How weir
ATABASES under mysql
>
> >Fix:
>
> >Submitter-Id:
> >Originator:Greg Cope
> >Organization:
>
> >MySQL support: none
> >Synopsis: SHOW command possiblxky broken in 3.23.33
> >Severity: non-critical
> >Priority: low
> >Categ
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 ne
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
Paul DuBois wrote:
>
> I've been reading the thread about SHOW DATABASES and SHOW TABLES
> returning lists of blank entries or no results. Just out of curiosity,
> I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33
> and found that suddenly I had the problem too! However, then
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
Richard Ellerbrock 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
> >
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
> (
"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 go
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 upgra
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 meanin
Sinisa Milivojevic wrote:
>
> Greg Cope writes:
> > >Description:
> > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
> > a nice list of blanks - no of blank lines
> > equals number of databases / tables)
> >
> > >How-
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 se
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) th
>Description:
SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
a nice list of blanks - no of blank lines
equals number of databases / tables)
>How-To-Repeat:
Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
>Fix:
>Submitter-Id:
>Originato
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.0
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 16
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 t
mike thomas wrote:
>
> Hi all
>
> I am running mysql on linux (redhat 6.2) using a regular 18Gb
> EIDI hard drive. Does anyone know how much (ball park figure) a
> SCSI hard drive would speed up selects and inserts?
This is a how long is a piece of string question .
EIDE disks have nearly
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 ca
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 ;-)
Gre
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
"Ashley M. Kirchner" wrote:
>
> I downloaded both the 3.23.31 version of mySQL, as well as the
> patched BerkeleyDB (v3.2.3h) from mysql.com. I compiled BDB and
> installed it under /usr/local. Then I proceeded to mySQL and gave it
> the following configure args:
>
> ./configure --prefix=/
Thimble Smith 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 prope
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.
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
Dear All
I can't get mysql-3.23-31 to configure with Berkeley DB support
My configure line is thus:
./configure --prefix=/usr/local/mysql-3.23.31 \
--enable-assembler \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql \
--localstatedir=/var/lib/mysql \
--sysconfdir=/etc \
--with-ext
48 matches
Mail list logo
