Hello!
We are currently using MySQL 4.0.x to develop a project for a customer which
should be released in early February 2004. The MySQL Download Page states
that for new developments, 4.1.x can be used. I would also like to use this
version, since it allows subqueries, a feature that 4.0.x
On Wednesday 26 November 2003 08:42, Andreas Buschka (tops.net) wrote:
My question is: How is the general stability of the 4.1.x versions? Can it
be used for new projects, or is it so unstable that the risk is too high?
In my testing so far, the connection capability seems to be intermittent -
Hello all,
I'm using mysql 3.23.49 under Debian Linux and gcc 2.95.4.
I'm writing a mysql client in C, and therefore I link libmysqlclient.a in my program.
The problem is that I also use and link a static list-handling library I've written
some time ago.
And of course problem arises with
Paul Fine [EMAIL PROTECTED] wrote:
If I have two tables with the first table containing a field which is FK of
table 2, when I insert a value into this field, should it not automagically
insert a value into that PK in the second table?
No, it should not insert data in the child table. You
# uname -X
System = SCO_SV
Node = scospare
Release = 3.2v5.0.6
KernelID = 2000-07-27
Machine = PentII(D)
BusType = ISA
Serial = 3IG004365
Users = 5-user
OEM# = 0
Origin# = 1
NumCPU = 1
#
Stefaan Van Dooren .--.
Technical Support |o_o |
Kompas Automatisering
Kate Porter [EMAIL PROTECTED] wrote:
I am using 4.0.15 on RedHat 7.3 and ran it to a strangest problem today.
SELECT col FROM table WHERE site_id=123;
returns a list of data.
SELECT col FROM table WHERE site_id IN(123);
returns an empty set.
Upon further investigation, I found cases
What mysqldump does?
I dont know it because i am new in the world of databases
Andre Winarko [EMAIL PROTECTED] wrote:
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB
and presto - views the 'private' data !!!
Ideally I would like to know if there is any option in MySql to store the DB files
Zenzo [EMAIL PROTECTED] wrote:
What mysqldump does?
I dont know it because i am new in the world of databases
mysqldump makes dump of the database or databases:
http://www.mysql.com/doc/en/mysqldump.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Hi,
Version 4.1.0. crashing on my Windows 2000 box after this query:
SELECT * FROM `streets` where MBROverlaps(GeomFromText('Polygon(16345750
48185401, 16402348 48185401, 16402348 48156946, 16345750 48156946,
16345750 48185401)'), GEOM);
GEOM is field of type geometry inside streets table. I
Thomas,
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB and presto - views the 'private' data !!!
Well, someone should not have access rights to the DB files on the
first
a simple way is to do select $form as new_column_name from structure; as
the query.
thus the return value of you column will be in new_column_name.
Vinay
joffrey leevy wrote:
Would appreciate in anyone can help me.
Let's say I do a query in php, eg. $query = select
shed from structure;
thanks for reply - the requirement comes from a security audit - so try to think in
terms of a hacker
Obviously and (I had assumed)
1. - the files would have tight unix security file permissions applied
2. - indeed the key would be stored on an internal tightly managed box (or device)
On Wednesday 26 November 2003 13:22, Curley, Thomas wrote:
Another Assumption
--
Encrypting / decrypting all data on the fly would be too expensive and
grind the app to a halt
So the question again :-
Any ideas on how to avoid having data files stored with absolutely
Well, I'm not an expert on security, but I don't think this is a database
issue. It is really a file/operating system issue. I don't think you can do
anything in the database against copying the files. If somebody has access on
file system level, the dbms is powerless. So I think you need to
One of the first things that I did at my former job was to turn off all
external-facing network adapters to our DB machines. If you're fortunate
enough that your DB resides on it's own box and not the webserver itself,
then there's really no reason that you *need* to have it externally facing.
Mike
Correct and this is the architecture. The internet facing box has a routable IP, the
DB box is separate and is not ext routable.
The issue the security review highlighted strongly was the fact that if a hacker got
access to the box (however) then copying /var/lib/mysql/database would
On Wednesday 26 November 2003 13:43, Curley, Thomas wrote:
Mike
Correct and this is the architecture. The internet facing box has a
routable IP, the DB box is separate and is not ext routable.
The issue the security review highlighted strongly was the fact that if a
hacker got access to
Hi All;
The last MySQL newsletter linked to my article titled Protecting MySQL
Sessions With SSH Port Forwarding, available at
http://www.vbmysql.com/articles/sshtunnel.html. Response was positive, but
there were multiple requests for information on hosting SSH sessions on a
Windows server.
In
To the chap who siad its not a DB issue - I will check with Oracle but I'm
sure that dropping in a directory in oracle will not give you full access
to a database (a clear one that is)
The chap was me :-) I'm sure it does on oracle. Once you have an Oracle
installation and got hold of all
-- System: MySQL 4.0.13, 4.0.16 on Linux x86
-- Table type: MyISAM, InnoDB
-- Description / How-To-Repeat:
-- 1. When I use
-- SELECT id, type FROM test.report ORDER BY type, id;
-- the result is in wrong order
-- --
-- ++-+
-- | id | type|
-- ++-+
-- | 4 | general |
Hacker gets in this way:
-[Webserver][rooted]-[DBServer][rooted]-File_Access(/var/lib/mysql/database)
I'd say the major security breach is already when the Webserver is rooted.^
If he gets to your webserver he could still read WHATEVER DATA he wants from
your database with the information he
Andre Winarko wrote:
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
'[trx_temp2]' Table 'danamon.[trx_temp2]' doesn't
exist
I'm sure the trx_temp2 table in danamon
Hi!
On Nov 26, Curley, Thomas wrote:
thanks for reply - the requirement comes from a security audit - so
try to think in terms of a hacker
Obviously and (I had assumed)
1.- the files would have tight unix security file permissions
applied
2.- indeed the key would be stored on an
Why does only the [mysqld2] start see attached file
Does anybody have a my.cnf file for 3.23.58 since I cant
get it started with InnoDB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm using mySQL 4.0.14 Linux and the mySql CC 0.8.9 Beta.
I ran your script and I'm clear. So its version specific.
-Original Message-
From: Kriengkrai J. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 2:05 AM
To: [EMAIL PROTECTED]
Subject: Disorder result with ORDER BY
Hi,
I recently upgraded from MySQL v3.23 to MySQL 4, and converted
my tables from MyISAM to InnoDB by using the ALTER TABLE
command. I did this for 16 tables. I know that MyISAM creates
seperate data/index files for each table and InnoDB uses a single file
for data and log. My question is,
Hello - we would like to be able to run multiple servers (probably on
multiple networks) that all share one common database. By having more
than one MySQL server on seperate networks we can guarantee a higher
degree of resilience and stability.
Is this possible without writing code to send out
Inserting a NULL into a NOT NULL column used to automatically get the
DEFAULT value. I realize that it was non-portable, non-standard behavior,
but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql CREATE TABLE t (a INT NOT NULL DEFAULT 0);
Query OK, 0 rows affected
http://www.mysql.com/doc/en/Replication.html
On Wednesday 26 November 2003 17.49, Mark wrote:
Hello - we would like to be able to run multiple servers (probably on
multiple networks) that all share one common database. By having more
than one MySQL server on seperate networks we can guarantee
On Wednesday 26 November 2003 17.51, Millaway, John wrote:
Inserting a NULL into a NOT NULL column used to automatically get the
DEFAULT value. I realize that it was non-portable, non-standard behavior,
but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql CREATE
mysql CREATE TABLE t (a INT NOT NULL DEFAULT 0);
Query OK, 0 rows affected (0.00 sec)
mysql INSERT INTO t (a) VALUES (NULL);
ERROR 1048: Column 'a' cannot be null
Just leave the NOT NULL column out when inserting and it will
get set to its default.
It's not just one sql statement.
Stefan Kuhn wrote:
To the chap who siad its not a DB issue - I will check with Oracle but I'm
sure that dropping in a directory in oracle will not give you full access
to a database (a clear one that is)
The chap was me :-) I'm sure it does on oracle. Once you have an Oracle
installation
At 11:51 -0500 11/26/03, Millaway, John wrote:
Inserting a NULL into a NOT NULL column used to automatically get the
DEFAULT value. I realize that it was non-portable, non-standard behavior,
but the code relies on it. How do I get this behavior in the 4.0.x server?
mysql CREATE TABLE t (a INT NOT
This is my current setup, two MySQL servers. One master, the other slave.
Suppose I created a table with one column named 'image', which is of
type BLOB.
Now, if I inserted binary data from an image file (using perl or
something) into
that column on the master, how will replication be handled?
At 12:53 -0500 11/26/03, Mayuran wrote:
This is my current setup, two MySQL servers. One master, the other slave.
Suppose I created a table with one column named 'image', which is of
type BLOB.
Now, if I inserted binary data from an image file (using perl or
something) into
that column on the
Hello,
Let me just outline the table in question first.
I have a rather large (40,000,000 rows) table as follows:
Table: MessageIDs
Create Table: CREATE TABLE `MessageIDs` (
`mid_msgid` char(96) NOT NULL default '',
`mid_fileid` int(10) unsigned NOT NULL default '0',
`mid_segment`
Hi All;
I inherited an old Access database at work which was not at all normalized. I then
managed to normalize the schema, but I am running into problems. First let me show you
the two tables I need to query:
--
# Host: 10.1.1.14
You can't INSERT, but with mysql 4.0.15 and better, you can ON UPDATE
CASCADE and ON DELETE CASCADE
Daevid Vincent
http://daevid.com
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 1:24 AM
To: [EMAIL PROTECTED]
Subject: Re:
If so, could you ping me off-list? I'd just like to ask a few quick
questions.
Thanks,
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 73 days, processed 2,905,787,388 queries (455/sec.
I would rather see these questions and answers in the list if you don't
mind. We are setting-up a MySQL cluster right now with active/passive on the
master node and 6 slave nodes. We are using GLP/in-house tools for our setup
but we are always interested in seeing what else is out there.
Thanks!
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amt DateNot NullPrimary Key
operINT Not NullPrimary Key
amount Decimal(3,3)Null---
but when I choose fire it shows me
getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amtDateNot NullPrimary Key
operINTNot NullPrimary Key
amountDecimal(3,3)Null---
but when I choose fire it shows
At 20:50 +0100 11/26/03, getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amt DateNot NullPrimary Key
operINT Not NullPrimary Key
amount Decimal(3,3)Null
I'm new at SQL, and am teaching myself. I hope this isn't too basic a question, but I
can't find any reference to this and I'd like not to hunt-and-peck yet another issue,
just this once.
I have a PHP array which is just a sequence of numbers: $ARA = [3,4,7,2,6]. I would
like to stash this
Kriengkrai J. wrote:
-- System: MySQL 4.0.13, 4.0.16 on Linux x86
-- Table type: MyISAM, InnoDB
-- Description / How-To-Repeat:
-- 1. When I use
-- SELECT id, type FROM test.report ORDER BY type, id;
-- the result is in wrong order
-- --
-- ++-+
-- | id | type|
--
Description:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\
-DDATADIR=\/usr/local/var\
-DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H
-I./../include -I./../regex-I.
On Wed, Nov 26, 2003 at 02:30:42PM -0500, Mike Minard wrote:
I would rather see these questions and answers in the list if you don't
mind. We are setting-up a MySQL cluster right now with active/passive on the
master node and 6 slave nodes. We are using GLP/in-house tools for our setup
but we
I couldn't ask for more :)
Mike
On 11/26/03 3:40 PM, Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Wed, Nov 26, 2003 at 02:30:42PM -0500, Mike Minard wrote:
I would rather see these questions and answers in the list if you don't
mind. We are setting-up a MySQL cluster right now with
At 07:22 AM 11/26/2003, you wrote:
Another Assumption
--
Encrypting / decrypting all data on the fly would be too expensive and
grind the app to a halt
Not true. There are some databases that can encrypt records on the fly
without any speed degradation ( 1%) using either
Curley, Thomas wrote:
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB and presto - views the 'private' data !!!
As all the other posters have mentioned, you should have
At 16:13 -0500 11/26/03, Kevin Carlson wrote:
Curley, Thomas wrote:
I am trying to find a solution to the following security issue with
MySql DB on linux
- Someone copies the DB files to another box, starts a mysql
instance, loads the DB and presto - views the 'private' data !!!
As all the
Mayuran wrote:
Ive never used MySQL navigator, but I think you should assign the
primary keys
in the same line, like so:
dt_amtDateNot Null
operINTNot Null
amountDecimal(3,3)Null
primary key (dt_amt, oper)
thats, ok. It's a sql navigator bug! I had created the
Yeah the problem was the tables I created were not MyISAM. Once I changed
it; EVERYTING GONNA BE ALRIGHT!
/T
on 11/25/03 7:20, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am getting the following error when I try to access a merged table:
Greetings,
From what I can gather the Queries per second average quoted by status
is a pure division of Questions by Uptime in show status. Is there a
way to flush these figures periodically? I want to be able to set the bin
interval for this average, otherwise fluctuations get smoothed out.
My apologies. The answer was in PHP-land.
- Original Message -
From: Paul Freedman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 3:26 PM
Subject: putting an array in a column
I'm new at SQL, and am teaching myself. I hope this isn't too basic a
question,
Hello,
we currently have MySQL ver., 4.0.15 RPM installed on a RH/linux 7.3
system, and would like to enable SSL support, we have openssl
installed. The SHOW VARIABLES indicates that SSL support is disabled,
have_openssl=NO
Is it possible to enable with our my.cnf file
thx's
Mickalo
--
MySQL
At 0:05 + 11/27/03, [EMAIL PROTECTED] wrote:
Hello,
we currently have MySQL ver., 4.0.15 RPM installed on a RH/linux 7.3
system, and would like to enable SSL support, we have openssl
installed. The SHOW VARIABLES indicates that SSL support is disabled,
have_openssl=NO
Is it possible to enable
Hello,
I was wondering if someone could provide a brief description for both of
the following attributes within the 'db' table:
'create_tmp_table_priv' and 'References_priv'
Any information you can provide will be helpful.
Thanks,
Aaron
--
MySQL General Mailing List
For list
At 16:20 -0800 11/26/03, Aaron Efland wrote:
Hello,
I was wondering if someone could provide a brief description
for both of
the following attributes within the 'db' table:
'create_tmp_table_priv' and 'References_priv'
The first allows you to create temporary tables with CREATE TEMPORARY
On Wed, Nov 26, 2003 at 02:16:16PM -0800, trevor%tribenetwork.com wrote:
Greetings,
From what I can gather the Queries per second average quoted by
status is a pure division of Questions by Uptime in show
status. Is there a way to flush these figures periodically?
Yes, you can use FLUSH
On Wed, Nov 19, 2003 at 05:09:26PM -0800, kp gbr wrote:
How do I perform checkpoint in MySQL.
You cannot.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 74 days, processed 2,914,655,888 queries
Hi Chris,
It doesn't take MySQL any more or less time to update a unique index
than a non-unique one. :-)
Hope that helps.
Matt
- Original Message -
From: Chris Elsworth
Sent: Wednesday, November 26, 2003 12:14 PM
Subject: Unique Index efficiency query
Hello,
Let me just
I'm generating a dynamic UPDATE command in a loop. The problem is the stupid
comma.
Given this general idea, how do I handle the pesky comma. It's either in the
front and in the way, or on the trailing end and in the way...
I either end up with something like this:
mysql UPDATE contact_table SET
Well, how about that. Using PHP, it just get's better each time! I found
this little snippet and adjusted accordingly...
http://us2.php.net/manual/en/function.implode.php
while(list($column, $value) = each($FOO))
{
$upd[] = $column = '$value'; //this will loop until sql is built
}
Hi,
I'm trying to get the MySQL-4.0 for linux
(mysql-standard-4.0.16-pc-linux-i686.tar.gz), from the mirror
mysql.secsup.org but it has a problem when attempting to uncompress the file
(get unexpected EOF in archive). I'm getting this by using the ftp utility
on a Linux server. It clearly
hi all.,
i tried to compile mysql-3.23.58 source
distribution for windows using VisualStudio 6 and
found that MySqlManager.rc file missing and hence the
compilation failed , The MySqlManeger.rc file is not
available in the MySqlManager folder downloaded from
mysql home site.
plz help me out
hi all.,
i tried to compile mysql-3.23.58 source
distribution for windows using VisualStudio 6 and
found that MySqlManager.rc file missing and hence the
compilation failed , The MySqlManeger.rc file is not
available in the MySqlManager folder downloaded from
mysql home site.
plz help me out
At 03:21 PM 11/26/2003, you wrote:
If someone can copy your database files, you're hosed. All the attacker
need do is start the server with --skip-grant-tables, and he can can
connect to it with no password, and has complete access to any files
managed by the server.
Paul Curley,
this is in which version of MYSQL..
One cant write procedures and functions in MYSQL 4.0.12...
Regards
Swati kalia
http://www.mecklai.com
where risk meets its match
***
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Dear Mr Jeffrey Dyke
There are some queries regarding PHP 4.1.As you mentioned in php 4.1
register_globals=off. are set for security reasons.
Is it Required to have Form attribute as enctype=multipart/form-data if i
have a File Upload on the Particular Form.
form name=form1 action=test.php3
- Original Message -
From: Prashant A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 5:20 PM
Subject: [PHP] Urgent Two Queries / Problems to be Solved--Prashant
Akerkar
Dear Mr Jeffrey Dyke
There are some
72 matches
Mail list logo