Does anyone have any recommendations on a tool that can produce a
graphical representation of a database stored within MySQL?
(i.e., if pointed at a database, will produce a graphical
representation of each table contained therein, including links to
foreign keys, etc...)
I've looked at a coup
Alec,
Thanks for the info, however I'm struggling to understand how it applies to
my case. Following is the piece of code in question, and the error is due to
the SELECT following the INSERT (insert works fine; LIGHTBOX_ID is on
AUTO_INCREMENT) :
// add a LIGHTBOX row ...
rs = stmt.executeQuery(
Assuming you have table staff with an id and name,
and title with id and title,
You create a join table.
Staff_id Title_id
1 1
1 2
2 1
2 3
Then:
Select name,title
FROM staff s , title t, jointable j
WHERE s.id=j.staff_id AND j.title_id=t.id;
Mark Worsdall wrote:
>
>
Please address answer to [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
you need a join table between the two tables. It would contain the primary
keys of both tables. This way for any given staffID, you could have 0-n
records that contain staffId & subjectTitles_id.
To get all the subjectTitles for a given staff you would
Select * from staff_subjectTitles where sta
I am attempting to migrate data from a mysql database to a mssql7 database.
There seem to be some differences between the two. Can anyone help me in
determining what needs to be changed in my sql script (mysqldump) to allow
me to recreate my schema in mssql7. Or, can someone steer me to a good
r
I wondered the same thing (I didnt write the original query). But using
'or' will not select rows with null values as using the outer join (+) in
oracle does. Hence, incorrect rows.
Heres the original Oracle query:
select distinct subsnp_pk, chrom, chrompos, locus, locusid, source,
sourceid, a
I have a query question I can't figure out on my own. Any help is
appreciated...
I have three tables:
create table courses (
rec_num int(5) not null default '0' auto_increment,
name varchar(255),
description varchar(255),
class_time varchar(255),
professor_id int(5),
unit
mysql client is not running.
and there is a problem in database connectivity too.
it says acess denied using Password="YES".This was the error when mysql was
running.It's on Apache Web Server.
Please suggest me what changes are to be made in the configuration and
reflect on the point about passw
mysql client is not running.
and there is a problem in database connectivity too.
it says acess denied using Password="YES".This was the error when mysql was
running.It's on Apache Web Server.
Please suggest me what changes are to be made in the configuration and
reflect on the point about passwor
First of all, since you are not a programmer, it is going to be
difficut. I have done something similar but for a travels site using php
and mysql. I suggest you send me a private mail I will help you if I can
Adrian
I've got mysql and php installed on my server and i was wondering if
anyone c
Hi,
I have a table called staff which currently has a column called
subjectTitles_id which is the type INTEGER.
I have another table called subjectTitles which contains 12 subject
titles.
So that is how a member of staff is assigned a subject.
Trouble is I need to be able to assign a multipl
on 3/20/01 1:20 PM, Bryan Coon at [EMAIL PROTECTED] wrote:
> Sorry for the ambiguity, I was trying to make a really generic select
> statement. I just meant that if 'where a = A.a' has no matches, but 'where
> b = B.b' or 'where c = C.c' does match, the query returns what did match,
> and just r
I went into my database today and noticed that there was 102,000 entries.
Somehow a whole pile of crap was added to the end of the database. I think
it can easily be fixed but am not sure. Is there a way that I can eliminate
all entries with a field that is blank? ie:
if the table product
Well as soon as I sent that previous message, I figured out
how to accomplish what I needed.
Thanks anyways.
Jeff Jones
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
Dear MySQL Sirs,
I have been trying to compile and build the GUI for MySQL (in Linux) and
apparently the last stage of the installation has been given me a very
hard time...I have followed the instructions from the website and the
last error ocurred when I tried to run "make" within /mysqlgui-1.7.
Hi Everyone,
This question may have been asked before, but i could not find it in the
archives, so i was wondering if someone could help me out.
Say i had the following table:
+++-+
| id | address| domainalias |
++
Hi.
On Mon, Mar 19, 2001 at 04:19:32PM +0800, [EMAIL PROTECTED] wrote:
> I want to use mysql_affected_rows to determine whether the sql statement is
> executed or not found.
> If mysql_affected_rows return 0,I take it as not found.
> But If I update a value to the value it already was,
> (It mean
Hi.
On Mon, Mar 19, 2001 at 02:40:43PM -0500, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I'm new to MySQL and am puzzled by a curious problem. This join syntax has
> always worked fine for me on SQLServer but it seems to work like an inner
> join on MySQL:
>
> SELECT d.doccat_ID, d.doccatname
> FRO
I just downloaded the latest version on MySQL as well as the MYSQLGUI
program. I have MySQL installed and I can access it from the mysql
command line but I just can't get MYSQLGUI to connect. It keeps giving
me - Can't connect to local MySQL server through socket " (111) -
Can you tell me whe
Hi.
On Mon, Mar 19, 2001 at 09:06:49PM -0700, [EMAIL PROTECTED] wrote:
> > hist.id will never be NULL and 5 at the same time. Your clauses conflict
> > with each other.
> > You need to re-write your query.
>
> This is ture, except the query suceeds if there is records in 'hist'
> Even if it is
I am using mysqld_multi to have several different mysql servers start. I have
finally gotten it to work with php when I connect to a non-standard socket,
such as /tmp/mysql.sock2. Does anyone know how to connect to a database with
perl through that socket? I have tried the following with no lu
Hi.
On Tue, Mar 20, 2001 at 12:22:19PM +0100, [EMAIL PROTECTED] wrote:
> Hi!
>
> On Mar 20, Basil Hussain wrote:
> > Hi all,
> >
> > The original message below was posted to the BugTraq mailing list. Have the
> > developers seen this? I know it talks about version mysql-3.20.32a (which is
> > a
The query returns 2 different result sets depending on whether the table on
the right side of a LEFT JOIN has records or not. I just don't see how this
is acceptable behavior. Either it should always return the result set or it
should always return the empty set. The size of the right table should
Hi.
Disk speed and memory is more relevant than CPU speed most times, so
you should include that info in your comparison. And how big is your
table in bytes (not rows).
I would start with comparing the output of
mysqladmin variables
of all installation. Maybe some simply have a bigger key bu
I'm trying to diagnose a segmentation fault we're getting in mysql so I can
send a slightly decent bug report about it, and would like to get a core dump.
I CANNOT get it to dump core. I'm using the --core-file option. I've made
sure my ulimit to coredump size is set big enough. It just won't d
Hello,
Still trying to get jpegs into my database. I have a blob column setup, How do I get
the jpeg into the blob column?
Thanks for the help
Mike
It would be my guess that you're trying to store inet_aton()'s value
into a signed integer column, which is in the range of roughly -2G - 2G-1,
while inet_aton()'s result is unsigned, in the range 0 - 4G-1. Whenever
inet_aton() happens to return a value > 2G-1, MySQL truncates it and stores
into
Hi.
Ah okay, I as thought, I misunderstood your objection.
The behaviour is how Standard SQL defines it and what is to be
expected. You may want consider to do some reading on relational
database theory (don't take this proposal wrong...).
Aside from that, I agree, that sometimes the behaviour
On Wed, Mar 21, 2001 at 05:07:59AM +0300, [EMAIL PROTECTED] wrote:
> please tell me about this error:
>
> > Fatal error: Call to unsupported or undefined function mysql_pconnect() in
>mainfile.php on line 17
> or
> > Fatal error: Call to unsupported or undefined function mysql_pconnect() in
>./
Hi.
On Tue, Mar 20, 2001 at 02:09:48PM -0800, [EMAIL PROTECTED] wrote:
> ok... this is stumping me perhaps I'm doing something wring, but It
> doesn't appear that I am
>
> Am I doing, or not doing something that makes the INET_ATON function
> default to 127.255.255.255 ?
No, as you shou
Hello,
is there anyway to execute a mysqldump command via the web and have the dump
stored on a file on the server. do any of the webinterfaces offer that?
any scripting languages?
thanks
randy
-
Before posting, please chec
> > Fatal error: Call to unsupported or undefined function mysql_pconnect()
> in ./db_mysql.php on line 73
Wrong list. Help can be found via several lists: http://www.php.net
Before posting you really should read the manual, also found at php.net
Or try at least a few examples from:
www.phpbui
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND
m.match
My slave stopped getting data from the master. Every 60 seconds, I get
an entry like this in the log file:
010321 2:23:07 Error reading packet from server: bogus data in log
event (read_errno 0,server_errno=65535)
I believe this occurs when I run an insert with a a very large (100's of
thous
I just downloaded the latest version on MySQL as well as the MYSQLGUI
program. I have MySQL installed and I can access it from the mysql
command line but I just can't get MYSQLGUI to connect. It keeps giving
me - Can't connect to local MySQL server through socket " (111) -
Can you tell me whe
I appreciate your explanation. You may be correct about Standard SQL,
however I do not believe that this can be explained as a simple
cross-product. If a LEFT JOIN were implemented starting with a cross product
then NO LEFT JOIN would EVER return NULL in the right table. A pure cross
product would
On 20-Mar-01 Jason Bell wrote:
> ok... this is stumping me perhaps I'm doing something wring, but It
> doesn't appear that I am
>
> Am I doing, or not doing something that makes the INET_ATON function
> default to 127.255.255.255 ? why does it work for 24.18.10.5, but not
> 192.168.50.5
Sorry for the ambiguity, I was trying to make a really generic select
statement. I just meant that if 'where a = A.a' has no matches, but 'where
b = B.b' or 'where c = C.c' does match, the query returns what did match,
and just returns null where it didnt. I will look at the CASE WHEN...THEN.
T
On 21-Mar-01 [EMAIL PROTECTED] wrote:
> please tell me about this error:
>
>> Fatal error: Call to unsupported or undefined function mysql_pconnect() in
>> mainfile.php on line 17
> or
>> Fatal error: Call to unsupported or undefined function mysql_pconnect() in
>> ./db_mysql.php on line 73
>
>
Regarding to the manual there is no difference between blob and text fields,
except that searching on text fields is case-insensitive and searches on
blobs are binary safe.
However, i'm quite stunned if you say you cannot use mysql_query to query
binary data, i've never experienced this problem:
m
On Wed, Mar 21, 2001 at 01:32:11AM -0700, [EMAIL PROTECTED] wrote:
> I appreciate your explanation. You may be correct about Standard SQL,
> however I do not believe that this can be explained as a simple
> cross-product. If a LEFT JOIN were implemented starting with a cross product
> then NO LEFT
Hi i got a problem.. =P
Im doing some test programming using Delphi and the myODBC driver in windows 2000 and
i get some strange stuff..
Example table in these examples
PICAB (table)
IDCounter int
NamnCHAR 100
EPostCHAR 100
Example 1.
Dont optimize column width and with
On 21-Mar-01 WCBaker wrote:
> Hi,
>
> I can store and retrieve binary data in the form of image or sound files.
> However, I wanted to store up to say, 10,000 bytes of textual data. Since
> varchar has a 255 byte ceiling I thought that mediumblob might be nice for
> this. I can store the stuf
You are building a "many to many" relationship.
How to do it:
* Each staff member should have an unique ID (eg StaffMember_ID) in the
Staff table;
* Each subject has an ID in the SubjectTitles table;
* and you need a third table, with two fields: StaffMember_ID and
SubjectTitle_ID, plus extra da
Get your RH7 RPMS for 3.23.35!
http://www.moongroup.com/stories.php?story=01/03/20/4439095
--
Chuck Mead, csm -AT- moongroup.com, Owner, MoonGroup.com
(Note: html formatted email sent to me is filtered & deleted unread)
GnuPG Public Key Available: http://wwwkeys.us.pgp.net
---
On Tue, Mar 20, 2001 at 03:44:44PM -0800, Marcus Ouimet wrote:
> I went into my database today and noticed that there was 102,000 entries.
> Somehow a whole pile of crap was added to the end of the database. I think
> it can easily be fixed but am not sure. Is there a way that I can eliminat
On 20-Mar-01 John Nielsen wrote:
> Hi Everyone,
>
> This question may have been asked before, but i could not find it in the
> archives, so i was wondering if someone could help me out.
>
> Say i had the following table:
>
>
> +++-+
>| id | address
Thanks for the info, however I'm struggling to understand how it applies to
> my case. Following is the piece of code in question, and the error is due
to
> the SELECT following the INSERT (insert works fine; LIGHTBOX_ID is on
> AUTO_INCREMENT) :
>
> // add a LIGHTBOX row ...
> rs = stmt.executeQ
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND
m.match
Hi,
> We're are a little worried about the ratio of tmp_disk_tables to
> tmp_tables. We are assuming the created_tmp_tables from `mysqladmin
> extended-status` represents the total number of temporary tables created
> and created_tmp_disk_tables from `mysqladmin extended-status` represents
> the
> Disk speed and memory is more relevant than CPU speed most times, so
> you should include that info in your comparison.
This is the fun part :). Machine which is the fastest with old mysql
and Debian has IDE HDD and 128 MB RAM, RH7 machine (dual PIII and new
mysql) has SCSI RAID and 512 MB RAM
On Tue, Mar 20, 2001 at 03:12:39PM -0600, Jeff Jones wrote:
> I am using mysqld_multi to have several different mysql servers start. I have
> finally gotten it to work with php when I connect to a non-standard socket,
> such as /tmp/mysql.sock2. Does anyone know how to connect to a database wit
Hi John,
On Wed, Mar 21, 2001 at 09:51:10AM +1000, John Nielsen wrote:
> Hi Everyone,
>
> This question may have been asked before, but i could not find it in the
> archives, so i was wondering if someone could help me out.
>
> Say i had the following table:
>
>
> ++--
I have GNU GCC 2.96 and when I run configure, I get the following error:
configure: error: installation or configuration problem: C++ compiler cannot
create executables.
any solution to this? Is 2.96 incompatable? Should I have a different
compiler?
Thanks,
Jason
On 20-Mar-01 Mike Baerwolf wrote:
> Hello,
>
> Still trying to get jpegs into my database. I have a blob column setup, How
> do I get the jpeg into the blob column?
>
localhost.dread$ grep LOAD_ $MANUAL
`LOAD_FILE(file_name)'
SET blob_column=LOAD_FILE("/tmp/picture")
*
Dear,
I use MySQL 3.23.30-gamma for unknown-freebsdelf4.2 (i386)
and found some problem when I try to use SELECT for Thai
text. Ok... I try to use this query...
SELECT Nickname FROM resume WHERE Nickname='ÀÕÁÐ';
ÀÕÁÐ = ASCII #192 #213 #193 #208
but I get the result 'ÀÕÃÐ' instead.
ÀÕÃÐ = ASCI
On 21-Mar-01 Randy Johnson wrote:
> Hello,
>
>
> is there anyway to execute a mysqldump command via the web and have the dump
> stored on a file on the server.
yes.
$cmd="/usr/local/bin/mysqldump -u user -ppasswd db
$cmd .=" > /path/to/dump/db.dmp";
system($cmd);
> do any of the webinterface
Hi.
Don mailed this only to me, but from the content it was obviously
intended for the list (or at least [EMAIL PROTECTED]).
- Forwarded message from Don Read <[EMAIL PROTECTED]> -
> From: Don Read <[EMAIL PROTECTED]>
> To: Benjamin Pflugmann <[EMAIL PROTECTED]>
> Subject: Re: update
>
Hi.
On Wed, Mar 21, 2001 at 11:57:09AM +0200, [EMAIL PROTECTED] wrote:
> > Disk speed and memory is more relevant than CPU speed most times, so
> > you should include that info in your comparison.
>
> This is the fun part :). Machine which is the fastest with old mysql
> and Debian has IDE HDD
Bonjour,
I have a table with 111619 rows in it.
"show table status" and "select count(*)" don't return the same
number of rows.
Is this know ?
mysql> show table status like 'livequote_FSE';
+---+--++++-+--
> Okay, that means, memory is no problem. And disks shouldn't be a
> problem either, because the table fits into memory. (Sorry, don't
> remember the test case anymore. Did it contain INSERTs/UPDATEs?)
No, only one SELECT with 3 joins. Just in case i send this query again:
SELECT f.foto_id, f.im
David Reid writes:
> I just downloaded the latest version on MySQL as well as the MYSQLGUI
> program. I have MySQL installed and I can access it from the mysql
> command line but I just can't get MYSQLGUI to connect. It keeps giving
> me - Can't connect to local MySQL server through socket
[EMAIL PROTECTED] writes:
>
> On 20.03.2001 14:48:58 Sinisa Milivojevic wrote:
>
> > Also, do you have clients that do not call mysql_close at the end ,
> > like PHP programs ?
>
> Huh? According to the PHP manual, I always thought that it is unnecessary to
> explicitly call mysql_clos
Hi!
Sorry, but the trace log does not contain any references to either
signal 14 nor to signal 11 (which is SIGSEGV) that is reported !
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_
BAUMEISTER Alexandre writes:
> Bonjour Sinisa,
> SM> The above could indicate some timeout problem.
>
> SM> Can you build mysql --with-debug and start it with --debug and see in
> SM> the trace file when are the above timeouts reported ??
>
> SM> Also, do you have clients that do not call
Nick Pasich writes:
>
> After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
> when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
>
> I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
> 3.23.35.
>
>
> The command
> ---
> my
Rafael Martinez writes:
> Hei
>
> If I send a SELECT sql-request to my DB and this request returns an
> "Empty set" ...
>
> mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK
> but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-)
>
> Why? Am I missing anyth
On Tue, Mar 20, 2001 at 03:12:39PM -0600, Jeff Jones wrote:
> I am using mysqld_multi to have several different mysql servers start. I have
> finally gotten it to work with php when I connect to a non-standard socket,
> such as /tmp/mysql.sock2. Does anyone know how to connect to a database wit
Heikki Tuuri writes:
> Alex,
>
> I looked at the new debug log you sent and obviously some client is
> making connections to your server. This cannot come from
> Innobase, there must be some client process running on your machine.
>
> >From the debug log I find the following:
> .
Michelle DeCurtis writes:
> I am running linux 6.2 (2.4 kernel) with MySQL3.23 installed. This kernel
> allows MySQL3.23 to support large file sizes, up to 4 Gigs.
> It looks like the mysqldump utility is still bound by the 2 GB file size
> limit. Does anyone know how to get mysqldump to rec
S Lemmon writes:
> Hi,
>
> My main experience is with Informix databases, but am trying MySQL on
> our web server (ver 3.23.33 running on Linux 2.2.16-3). In general
> it's working well, but being a MySQL newbie I'm a bit mystified by
> some odd select behavior.
>
> With Informix, doing
On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote:
> Hi,
>
> I've just ported from SQLServer where this query ran fine, however MySQL
> gives an "invalid use of group function" error.
>
> Any ideas?
>
> thx
>
> dan
>
> select us.username, us.id as userid, count(*) as tips from User
thanks I worked it out. SQLServer requires SELECT Count(*) as fieldname ...
ORDER BY Count(*). MySQL requires SELECT count(*) as fieldname ... ORDER BY
fieldname
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Fred van Engen
Sent: Wednesday, 21 March 20
Voytek Lapinski writes:
> I'm trying to diagnose a segmentation fault we're getting in mysql so I can
> send a slightly decent bug report about it, and would like to get a core dump.
>
> I CANNOT get it to dump core. I'm using the --core-file option. I've made
> sure my ulimit to coredump
On 21.03.2001 00:01:16 Mike Baerwolf wrote:
> Hello,
>
> Still trying to get jpegs into my database. I have a blob column setup, How
do
> I get the jpeg into the blob column?
Read the file into a variable and insert it. Make sure to either escape NULLs
or to make the data "safe" in other ways
Hi!
On Mar 21, Benjamin Pflugmann wrote:
> Hi.
>
> On Tue, Mar 20, 2001 at 12:22:19PM +0100, [EMAIL PROTECTED] wrote:
> > Hi!
> >
> > On Mar 20, Basil Hussain wrote:
> > > Hi all,
> > >
> > > The original message below was posted to the BugTraq mailing list. Have the
> > > developers seen this
Thalis A. Kalfigopoulos writes:
> Dear Santa,
> here is my wishlist:
> I wish that the mysql utility had support for the shell's history functions. I catch
>mysql so many time doing something like !show
>
> regards,
> thalis
>
Hi!
First of all, Christmas is far away.
Second, m
Benjamin Pflugmann writes:
> Hi.
>
> On Tue, Mar 20, 2001 at 12:22:19PM +0100, [EMAIL PROTECTED] wrote:
> > Hi!
> >
> > On Mar 20, Basil Hussain wrote:
> > > Hi all,
> > >
> > > The original message below was posted to the BugTraq mailing list. Have the
> > > developers seen this? I k
Sinisa,
SM> Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM> that you are using.
I though filedescriptors could be the problem. I only had 256. I
modified the system in order to have 1024 :
===
BAUMEISTER Alexandre writes:
> Sinisa,
>
> SM> Alex, you ran out of filedescriptors or out of anodes, depending on OS
> SM> that you are using.
>
> I though filedescriptors could be the problem. I only had 256. I
> modified the system in order to have 1024 :
>
> ===
Hello.
I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by
O'Reilly states that for a table named book under a database Test following is the
structure:
book.ISM
book.ISD and
book. frm
On my system MySQL 3.23.27 beta the structure is different.
book.MYI
book.MYD
Yes, I think this is the problem. But how can I make a read/write lock with
only one lock?
Best regards,
Fabio.
> --
> De: Gerald L. Clark[SMTP:[EMAIL PROTECTED]]
> Enviado el: Martes, Marzo 20, 2001 04:33 PM
> Para: Fabio Galarraga
> CC: 'Mysql mailing list'
> Asunto:
Sinisa,
SM> Do you use thread cacheing ??
SM> Please turn it off temporarily and see if problem reccurs.
Currently I have :
my.cnf
set-v
Sinisa,
SM> > SM> Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM> > SM> that you are using.
SM> >
SM> > I though filedescriptors could be the problem. I only had 256. I
SM> > modified the system in order to have 1024 :
SM> >
SM> > ==
BAUMEISTER Alexandre writes:
> Sinisa,
>
> SM> Do you use thread cacheing ??
>
> SM> Please turn it off temporarily and see if problem reccurs.
>
> Currently I have :
>
>
> my.cnf
>
BAUMEISTER Alexandre writes:
> Sinisa,
>
> SM> > SM> Alex, you ran out of filedescriptors or out of anodes, depending on OS
> SM> > SM> that you are using.
> SM> >
> SM> > I though filedescriptors could be the problem. I only had 256. I
> SM> > modified the system in order to
Sinisa,
SM> > SM> Do you use thread cacheing ??
SM> >
SM> > SM> Please turn it off temporarily and see if problem reccurs.
SM> >
SM> > Currently I have :
SM> >
SM> >
SM> > my.cnf
SM> > ===
BAUMEISTER Alexandre writes:
> Sinisa,
>
> SM> > SM> Do you use thread cacheing ??
> SM> >
> SM> > SM> Please turn it off temporarily and see if problem reccurs.
> SM> >
> SM> > Currently I have :
> SM> >
> SM> > ===
Sinisa,
SM> > SM> > SM> Alex, you ran out of filedescriptors or out of anodes, depending on
OS
SM> > SM> > SM> that you are using.
SM> > SM> >
SM> > SM> > I though filedescriptors could be the problem. I only had 256. I
SM> > SM> > modified the system in order to have 1024 :
S
Sinisa,
SM> Ok, do not erase your binary, save it and try our binary for 2.7.
SM> If you still get TCP errors, rebuilding MySQL will be the sole
SM> solution.
First, we don't know if it's TCP errors isn't it ?
Second, the binary I'm using now is one I built on my own from the
sources.
BAUMEISTER Alexandre writes:
> Sinisa,
>
> Yes, for now. But in the final application, there will be a lot of
> connections from network.
>
>
>
This entire problem with signal 14 can be due to PHP not using
mysql_close.
Please try to explicitely close connection at the programs
Sinisa,
SM> Ok, do not erase your binary, save it and try our binary for 2.7.
SM> If you still get TCP errors, rebuilding MySQL will be the sole
SM> solution.
Another thing to underscore, is that with Mysql-3.23.33 built on my
own from the sources, I never had these messages in the log.
0
BAUMEISTER Alexandre writes:
> Sinisa,
>
> SM> Ok, do not erase your binary, save it and try our binary for 2.7.
>
> SM> If you still get TCP errors, rebuilding MySQL will be the sole
> SM> solution.
>
> First, we don't know if it's TCP errors isn't it ?
>
> Second, the binary
Bonjour Sinisa,
SM> BAUMEISTER Alexandre writes:
SM> > Sinisa,
SM> >
SM> > Yes, for now. But in the final application, there will be a lot of
SM> > connections from network.
SM> >
SM> >
SM> >
SM> This entire problem with signal 14 can be due to PHP not using
SM> mysql_close.
S
BAUMEISTER Alexandre writes:
> Bonjour Sinisa,
>
>
> I've no PHP scripts accessing Mysql for now.
>
> Only some little programs written in C which are connecting to Mysql
> and doing some UPDATE on a few tables.
>
> Alex.
>
>
>
And you have mysql_close at the end of the
Sinisa,
SM> > I've no PHP scripts accessing Mysql for now.
SM> >
SM> > Only some little programs written in C which are connecting to Mysql
SM> > and doing some UPDATE on a few tables.
SM> >
SM> > Alex.
SM> >
SM> >
SM> >
SM> And you have mysql_close at the end of them ??
Hi.
All your arguments are irrelevant regarding my post: Sergei stated
that MySQL 3.23 would not be vulnerable to the posted exploit and I
proved it is (respecting the rules given in the exploit). I never
argued about the impact of the exploit.
To be true, I am worried about the answers we get.
Alonso Guarisma writes:
> Dear MySQL Sirs,
> I have been trying to compile and build the GUI for MySQL (in Linux) and
> apparently the last stage of the installation has been given me a very
> hard time...I have followed the instructions from the website and the
> last error ocurred when I tr
Benjamin Pflugmann writes:
> Hi.
> Of course, that why I was explicitly talking about the fact, that the
> user needs CREATE privileges (FILE privileges are not needed, If I am
> not mistaken).
>
>
>
>
First of all, it is easy to reproduce a test case.
Second, that FILE privilege
1 - 100 of 254 matches
Mail list logo
