Re: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG?

2010-12-04 Thread Brian Guy
Hi Varuna, the signature file links have been put back on the web site.  
Can you please try again?  Thanks


On 12/2/2010 5:57 PM, Brian Guy wrote:
Sorry Varuna, I received your email with no context and incorrectly 
assumed you were one of our consulting customers (I work in our 
consulting team).


I have sent your question to our web site team, as I similarly do not 
see the signature files.


Sorry for the confusion.

Thanks,
Brian

On Dec 2, 2010, at 3:53 PM, Varuna Seneviratna 
varunasenevira...@gmail.com mailto:varunasenevira...@gmail.com wrote:




Hello Brian!
 What do you mean!, Who do u intend by account manager._I am using 
community server 5.1_


On 3 December 2010 02:30, Brian Guy brian@oracle.com 
mailto:brian@oracle.com wrote:


Hi Varuna,

Sorry, I do not know the answer to this.  Who is your account
manager, and I can ask him/her to find out for you?

If you do not know your account manager, please let me know your
company name and location, and we can find out who your account
manager is.

Thanks,
Brian

Oracle http://www.oracle.com/
Brian Guy | MySQL Consulting Practice Manager, Americas
OracleMySQL
Seattle, Washington USA

Green Oracle http://www.oracle.com/commitment   Oracle is
committed to developing practices and products that help protect
the environment



On Dec 2, 2010, at 6:12 AM, Varuna Seneviratna wrote:


Hi Brian
 I am contacting you according the mail I got from Brian
Miezejewski I suppose, As you can see from the below reply I got
after posting to the mailing list.My question is described below

According to the Doc
http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html
the  Signature file for a MySQL package can be obtained from the
download page.But I am not able to locate it?

-- Forwarded message --
From: brian.miezejew...@oracle.com
mailto:brian.miezejew...@oracle.com
Date: 2 December 2010 19:34
Subject: Auto Reply: How can I obtain the corrosponding
Signature file for a MySQL package to verify package Intergrity
Using GnuPG?
To: varuna.senevira...@gmail.com
mailto:varuna.senevira...@gmail.com


Hi,

I am on Medical Leave. Please contact Brian Guy at
brian@oracle.com mailto:brian@oracle.com in my absense.

Cheers,
Brian




-- 
Kind Regards

Varuna Seneviratna






--
Kind Regards
Varuna Seneviratna



Re: Auto Reply: How can I obtain the corrosponding Signature file for a MySQL package to verify package Intergrity Using GnuPG?

2010-12-04 Thread Brian Guy
Sorry Varuna, I received your email with no context and incorrectly assumed you 
were one of our consulting customers (I work in our consulting team).

I have sent your question to our web site team, as I similarly do not see the 
signature files.

Sorry for the confusion.

Thanks,
Brian 

On Dec 2, 2010, at 3:53 PM, Varuna Seneviratna varunasenevira...@gmail.com 
wrote:

 
 Hello Brian!
  What do you mean!, Who do u intend by account manager.I am using community 
 server 5.1
 
 On 3 December 2010 02:30, Brian Guy brian@oracle.com wrote:
 Hi Varuna,
 
 Sorry, I do not know the answer to this.  Who is your account manager, and I 
 can ask him/her to find out for you?
 
 If you do not know your account manager, please let me know your company name 
 and location, and we can find out who your account manager is.
 
 Thanks,
 Brian
 
 
 Brian Guy | MySQL Consulting Practice Manager, Americas
 Oracle MySQL
 Seattle, Washington USA
 
   Oracle is committed to developing practices and products that help 
 protect the environment
 
 
 
 On Dec 2, 2010, at 6:12 AM, Varuna Seneviratna wrote:
 
 Hi Brian
  I am contacting you according the mail I got from Brian Miezejewski I 
 suppose, As you can see from the below reply I got after posting to the 
 mailing list.My question is described below
 
 According to the Doc  
 http://dev.mysql.com/doc/refman/5.1/en/checking-gpg-signature.html the  
 Signature file for a MySQL package can be obtained from the download 
 page.But I am not able to locate it?
 
 -- Forwarded message --
 From: brian.miezejew...@oracle.com
 Date: 2 December 2010 19:34
 Subject: Auto Reply: How can I obtain the corrosponding Signature file for a 
 MySQL package to verify package Intergrity Using GnuPG?
 To: varuna.senevira...@gmail.com
 
 
 Hi,
 
 I am on Medical Leave. Please contact Brian Guy at brian@oracle.com in 
 my absense.
 
 Cheers,
 Brian
 
 
 
 
 -- 
 Kind Regards
 Varuna Seneviratna
 
 
 
 
 
 -- 
 Kind Regards
 Varuna Seneviratna
 


LEFT JOIN problem

2005-11-05 Thread Guy Brom

I have the following tables:

languages
language_id int,
language_title varchar(80)

objects
object_id int
object_language_id int
object_title varchar(100)

I want to select ALL available languages, and match the translated object 
(if it is exists) for a specific object_id. If it does not exists for that 
specific language_id, I want to have NULL.


Because I'm using mysql 4.0, no subqueries allowed. Is there any way to 
rewrite the following?


SELECT
language_id,
language_title,
(SELECT object_title FROM objects WHERE object_id = ? AND object_language = 
l.id) AS object_title

FROM
languages l

Thanks! 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



compound foreign key(s)

2005-10-13 Thread Guy Brom

I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK

I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang` as 
foreign (cascade-delete) keys to the master tables.


However mysql throws error (Cannot create table..) when I try to define 
`cid` as a foreign key to country.id


country.id and countrytext.cid are both smallint(5)

Any help? 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



re: SQL Dump

2004-12-08 Thread IT Guy
Hello,

I am new to mySQL. Someone gave me a dump file and i need to do an
import from linux. How can i go about doing this can someone help me?

Thanks!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Rank beginnner - very basic question

2004-06-13 Thread Guy Merritt
I have zero experience, really, with Mysql although I compiled it on a Linux box and 
it works well for a couple of sites and messageboards that I host from my house.  I do 
this strictly for fun and would like to let some friends and family members have 
websites as well.  

Here's what I don't get (well, a tiny protion of what I don't get): when I paid for 
webhosting I could set up a php messageboard and (if I recall correctly) and I was 
issued a unique username and password for the mysql database.  As it is now, I am 
required to use my root account and username - and use a different prefix for each 
instance of phpBB2 (a messageboard) when I install something.  Is there a way that 
users can have sectors, or tables, or whatever that are allocated to them and which 
they access with their own usernames and passwords?

I know I can change my password with /.mysqadmin -u root password my_password - I know 
of few basics and that's it. And it does work fine - I just don't want to pass out the 
root account password to people to let them have access for a messageboard or 
whatever...

Thanks

Guy Merritt


Possible drawbacks of suggested mysql install?

2004-03-03 Thread Defryn, Guy

Hi there,


I would like to know some professional opinions on the following:

-Are there any drawbacks on installing Mysql on a windows server? Would it be possible 
to install it on the same server that hosts SQL server? Can they coexist properly?

I do not expect too much usage of the Mysql server. We want to provide the MySQL 
service to our staff but might not be able to justify seperate servers.

Are there any good articles available on this matter

Cheers




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Specs for a dedicated MySQL server

2003-12-08 Thread Defryn, Guy
This looks like a flash server. I am not sure if we will have enough
Mysql use to justify this. Does anyone have an idea for what kind of use
(amount of db etc) that I would use this kind of server?

Guy

-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 9 December 2003 7:32 a.m.
To: Defryn, Guy
Cc: [EMAIL PROTECTED]
Subject: Re: Specs for a dedicated MySQL server

There's actually a MySQL Database Appliance out there. Have you looked 
at that yet?

http://pogolinux.com/mysql/index.html

You could run MySQL on any number of different machines. Intel, Athlon, 
PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X.

- Gabriel

On Dec 7, 2003, at 4:41 PM, Defryn, Guy wrote:

 Hi there,



 I have been asked to investigate a solution to offer MySQL to our 
 staff.
 I am not sure how many people will make use of it at this stage.
 Most people would most likely use it as a backend for message boards

 And to store information on whatever they are doing. I am sure it will
 be for web purposes only.

 I cannot see the need for transactions etc.



 My employer usually goes for HP DL380 G3 servers. Any tips on
 redundancy, backup etc?

 Also, Is there anyone who uses Windows on a Mysql production server? I
 want to use FreeBSD or Linux but that might not be up to me.

 What License do I need? Basically we are an ISP for our departments



 Cheers



 GUY



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Specs for a dedicated MySQL server

2003-12-08 Thread Defryn, Guy
There is one server that we have and that I can possible use

Dual Pentium 1.2 ghz CPU
1 gig of Ram
18 gb SCSI
0+1 Raid

What performance can I expect from this machine. What usage would it be
able to handle?

cheers

-Original Message-
From: Defryn, Guy 
Sent: Tuesday, 9 December 2003 9:01 a.m.
To: [EMAIL PROTECTED]
Subject: RE: Specs for a dedicated MySQL server

This looks like a flash server. I am not sure if we will have enough
Mysql use to justify this. Does anyone have an idea for what kind of use
(amount of db etc) that I would use this kind of server?

Guy

-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 9 December 2003 7:32 a.m.
To: Defryn, Guy
Cc: [EMAIL PROTECTED]
Subject: Re: Specs for a dedicated MySQL server

There's actually a MySQL Database Appliance out there. Have you looked 
at that yet?

http://pogolinux.com/mysql/index.html

You could run MySQL on any number of different machines. Intel, Athlon, 
PowerPC, etc. Linux, FreeBSD, Windows, Mac OS X.

- Gabriel

On Dec 7, 2003, at 4:41 PM, Defryn, Guy wrote:

 Hi there,



 I have been asked to investigate a solution to offer MySQL to our 
 staff.
 I am not sure how many people will make use of it at this stage.
 Most people would most likely use it as a backend for message boards

 And to store information on whatever they are doing. I am sure it will
 be for web purposes only.

 I cannot see the need for transactions etc.



 My employer usually goes for HP DL380 G3 servers. Any tips on
 redundancy, backup etc?

 Also, Is there anyone who uses Windows on a Mysql production server? I
 want to use FreeBSD or Linux but that might not be up to me.

 What License do I need? Basically we are an ISP for our departments



 Cheers



 GUY



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Disk Configuration

2003-12-08 Thread Defryn, Guy
I have another question regarding specs for a server.

I have talked to a DBA who has no mySQL knowledge but did work with
Oracle, etc

 

He said I should do some more investigation on disk configuration and
how mysql benefits from

Separating log files, data files, etc.

 

All feedback welcome!

 

 



Specs for a dedicated MySQL server

2003-12-07 Thread Defryn, Guy
Hi there,

 

I have been asked to investigate a solution to offer MySQL to our staff.
I am not sure how many people will make use of it at this stage.
Most people would most likely use it as a backend for message boards

And to store information on whatever they are doing. I am sure it will
be for web purposes only.

I cannot see the need for transactions etc.

 

My employer usually goes for HP DL380 G3 servers. Any tips on
redundancy, backup etc?

Also, Is there anyone who uses Windows on a Mysql production server? I
want to use FreeBSD or Linux but that might not be up to me. 

What License do I need? Basically we are an ISP for our departments

 

Cheers

 

GUY



Reliability of _rowid over multiple database accesses

2003-10-20 Thread Guy Smith
I'd like to use the _rowid capability of MySQL to improve the efficiency of a project, 
but I have concerns about the reliability of the number it returns.  I understand that 
_rowid may change over time depending on many factors, but I'd like to know whether 
this is true if the row is locked.  In particular, can I perform a select on a row 
which returns a _rowid, modify the row data, and later do an UPDATE using the _rowid 
as index, without worrying that the _rowid has changed?  Any help will be much 
appreciated.

Guy L. Smith
Lead Developer
[EMAIL PROTECTED]

Mysql embeded

2003-07-07 Thread Guy Smadja
Hello,

The application I'm dealing with, is writen in java, jsp, jdbc, mysql 4.0...
I use a broker between java classes and mysql db.

broker creates n connections when the server tomcat start and shares
connections.
Here is the code to create connections :
for (int i = 0; i  n; i++) {
Class.forName (com.mysql.jdbc.Driver);
connPool[i] = DriverManager.getConnection
(jdbc:mysql://localhost/dbname,username,pwd);
}

Calls to mysql from java classes looks like:
try {
connection = Mem.getBrokerdb().getConnection();
pstmt = connection.prepareStatement(...);
pstmt.setString(1, var);
pstmt.executeUpdate();
} finally {
Mem.getBrokerdb().freeConnection(connection);
}

Does someone know how to embed Mysql and what consequence there is in java
code.
What mysql files or folders do I have to include in setup and what do I have
to exclude from setup.

Thanks for answers

Guy

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: distributed database architecture for a large database

2003-07-03 Thread Guy Davis
On June 28, 2003 05:33 am, Aodhan Cullen wrote:
 6/27/03 6:37:49 PM, Jeremy Zawodny [EMAIL PROTECTED] wrote:
  My read/update ratio would be something along the lines of 1:3, 3
  updates for every read. So it is highly unusual, and more or less
  rules replication out of the picture.
 
 I'm unclear why you can't use replication for this.  There must be an
 assumption about what you're doing that we do not share.
 
 If you read from the slave and write to the master, why does this not
 work?

 A slave would simply not be able to keep up, replication works really well
 if you have a lot of reads, and a small number of updates. This is reverse
 ways, and needs a different approach.

Actually, I've found MySQL replication to be extremely fast.  Our database is 
also atypical having over 70% writes to 30% or less reads.  However, we have 
yet to have a slave (of 2 or 3) not be able to keep up.  In fact, I can bring 
a slave that has been pasued for a few days (as a snapshot) up to speed again 
within an hour or two.

Here's some stats on our setup:
- Queries per second avg: 117.236
- Generating over a 1GB of binlog entries per day.
- Running with ~120 GB of live data now (used to be 200+ but we have 
  an archival scheme now)

Not sure how this compares to your situation.

-- 
Guy Davis http://www.guydavis.caCalgary, Alberta, Canada


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Apache/PHP question

2003-03-13 Thread Defryn, Guy


I have set apache 2.0 and PHP 4.3.1 as well as mysql.
I was wondering how I can disable PHP per user directory?.
At the moment everyone can put php scripts on their personal website.
I want to limit it to a few users.

Cheers

Sql,query


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



startup and install issues

2003-03-12 Thread Defryn, Guy


I have installed 4.0.9 from source.

After compiling it I want to start it with

/usr/local/mysql/bin/mysqld_safe --user=mysql 

and the message mysqld ended appears.


When I move the startup script to the appropriate directory and reboot
I get the following error

Can't execute @bindir@/mysqld_safe from [EMAIL PROTECTED]@

Any ideas?

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Auto-completion

2003-02-13 Thread Defryn, Guy


Is auto completion a feature that only works in Mysql4?

Cheers

Sql,query 


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: RE: Auto-completion

2003-02-13 Thread Defryn, Guy


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 February 2003 11:03 a.m.
To: Defryn, Guy
Subject: Re: RE: Auto-completion 

Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:

sql,query,queries,smallint

If you just reply to this message, and include the entire text of it in
the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for
example.

You have written the following:



However, I have never noticed it to work on Windows.  Are you using
Windows?

I am the moment so that explains why it did not work

Cheers


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Is it my English or does this sound bad?

2003-02-05 Thread Defryn, Guy


I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this

Animal sex can be represented in a variety of ways

My mother tongue is not English but doesn't it sound rude ? :-)



mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
- species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

VARCHAR is a good choice for the name, owner, and species columns
because the column values will vary in length. The lengths of those
columns need not all be the same, and need not be 20. You can pick any
length from 1 to 255, whatever seems most reasonable to you. (If you
make a poor choice and it turns out later that you need a longer field,
MySQL provides an ALTER TABLE statement.) 

Animal sex can be represented in a variety of ways, for example, m and
f, or perhaps male and female. It's simplest to use the single
characters m and f.

Query/mysql

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: 'mysqladmin slave-st(art|op)' - is it implemented?

2003-01-30 Thread Guy Waugh
Hello again,

Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a 
'mysqladmin --help'. Grepping the source found it.

- GW.

Date: Wed, 29 Jan 2003 11:19:06 +1100
To: [EMAIL PROTECTED]
From: Guy Waugh [EMAIL PROTECTED]
Subject: 'mysqladmin slave-st(art|op)' - is it implemented?

Hello,

I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and 
'slave-stop' have at least been thought of at some stage (they're listed in the 
COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just 
been through the change logs for version 4, and can't find any mention of them in 
there...

Can anyone tell me whether these options for mysqladmin are implemented? If not, can 
anyone tell me whether I can tell mysqld to stop or start replicating from a shell 
script rather than the mysql client?

Thanks in advance,
Guy.


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




'mysqladmin slave-st(art|op)' - is it implemented?

2003-01-29 Thread Guy Waugh
Hello,

I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and 
'slave-stop' have at least been thought of at some stage (they're listed in the 
COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just 
been through the change logs for version 4, and can't find any mention of them in 
there...

Can anyone tell me whether these options for mysqladmin are implemented? If not, can 
anyone tell me whether I can tell mysqld to stop or start replicating from a shell 
script rather than the mysql client?

Thanks in advance,
Guy.

-- 
Guy Waugh 
Unix Team 
Information Technology  Telecommunication Services 
Southern Cross University 
P.O. Box 157 
Lismore NSW 2480 
Ph: 61 2 6620 3196 
Fax: 61 2 6620 3033 
www.scu.edu.au/admin/it 
--


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Replication error: 'Could not initialize master info'

2003-01-28 Thread Guy Waugh
Hi list,

My original post concerning this issue is below - it was a week or so ago. No replies 
were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have 
figured it out, and my slave is now replicating from the master.

The problem was that the mysql data directory was owned by root, not mysql. While the 
database directories within the data directory were owned by mysql, the data directory 
itself was root:root 755. Changing the data directory to be owned by mysql obviously 
allowed the master.info file to be written there when I did the 'change master to...' 
command.

Original post here:

*
Hi there,

I'm trying to set up replication between two RH7.2 Linux servers running MySQL 
3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual 
(section 4.10 Replication in MySQL), and when I do the following command on the slave:

change master to master_host='db1', master_user='not shown here', 
master_password='not shown here', master_log_file='db1-binary-log.004', 
master_log_pos=38456522;

, mysql tells me:
ERROR:
Could not initialize master info

I can't find anything in the error log, and I've set up the replication user on the 
master as outlined in the manual. Both master and slave are currently using databases 
with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of 
course, MyISAM). I'm not using InnoDB tables.

Can anyone give me an idea of how to troubleshoot this one?

Thanks,
Guy.

*


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Mod_Auth_MySQL for Apache 2 and Windows?

2003-01-24 Thread Guy Davis
Just wondering whether anyone had a working, compiled mod_auth_mysql
module for doing basic auth against a MySQL database on a Windows system
(XP to be exact).  If not, has anyone ever compiled one on Windows?

I found one for Apache 2.0.43 at this site:
http://www.pcp-computer.de/gkn/apache/httpd-2.0/win32/modules/

but it only crashes the Apache server.  (Other people have had the same
problem with this version as well.)

-- 
Guy Davis  Phone: (403) 301-3426   Fax: (403) 301-3499
Pason Systems  Calgary, AlbertaCanada

Digitally signed by GnuPG (DSA ID 759A998E at www.keyserver.net)
PGP Fingerprint: F685 97D0 0FC6 F016 E9EB CCD3 F183 1BC7 759A 998E 

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Mod_Auth_MySQL for Apache 2 and Windows?

2003-01-24 Thread Guy Davis
Just wondering whether anyone had a working, compiled mod_auth_mysql
module for doing basic auth against a MySQL database on a Windows system
(XP to be exact).  If not, has anyone ever compiled one on Windows?

I found one for Apache 2.0.43 at this site:
http://www.pcp-computer.de/gkn/apache/httpd-2.0/win32/modules/

but it only crashes the Apache server.  (Other people have had the same
problem with this version as well.)

-- 
Guy Davis http://www.guydavis.caCalgary, Alberta, Canada

Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net)
PGP Fingerprint: 8DC8 4A6F C1AD 393B 39DB CDBF 196D 31D0 30D5 2F0

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Detecting Mysql servers on the network

2003-01-21 Thread Defryn, Guy


Is it possible to detect mysql servers on the network without knowing the hostname?

cheers

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Replication error: 'Could not initialize master info'

2003-01-21 Thread Guy Waugh
Hi there,

I'm trying to set up replication between two RH7.2 Linux servers running MySQL 
3.23.54a (mysql RPMs). I've followed the instructions in the MySQL online manual 
(section 4.10 Replication in MySQL), and when I do the following command on the slave:

change master to master_host='db1', master_user='not shown here', 
master_password='not shown here', master_log_file='db1-binary-log.004', 
master_log_pos=38456522;

, mysql tells me:
ERROR:
Could not initialize master info

I can't find anything in the error log, and I've set up the replication user on the 
master as outlined in the manual. Both master and slave are currently using databases 
with ISAM tables rather than MyISAM tables (although the 'mysql' database is, of 
course, MyISAM). I'm not using InnoDB tables.

Can anyone give me an idea of how to troubleshoot this one?

Thanks,
Guy.

-- 
Guy Waugh 
Unix Team 
Information Technology  Telecommunication Services 
Southern Cross University 
P.O. Box 157 
Lismore NSW 2480 
Ph: 61 2 6620 3196 
Fax: 61 2 6620 3033 
www.scu.edu.au/admin/it 
--


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




data directory in 4.0.9

2003-01-15 Thread Defryn, Guy
Where does mysql places the databases in 4.0.9 when installing from source?
The var directory does not seem to be there anymore



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Unable to install 4.08 or 4.09

2003-01-13 Thread Defryn, Guy
I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error
After running gunzip  mysql-4.0.9-gamma.tar.gz (source install)

Mysql-4.0.9-gamma/bdb/
Mysql-4.0.9-gamma/bdb/db/
Mysql-4.0.9-gamma/bdb/db/db_upg.c
Mysql-4.0.9-gamma/bdb/db/db.c 
Mysql-4.0.9-gamma/bdb/db/tags

Tar : skipping to next header
Tar: archive contains obsolescent base-64 headers

Gunzip: stdin: invalid compressed data --crc error
Tar: error exit delayed from previous errors

Does anyone know why this happens. I am using a fresh freebsd 4.7 install

Cheers

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Unable to install 4.08 or 4.09

2003-01-13 Thread Defryn, Guy
Thanks Paul,

It's working now.

cheers

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, 14 January 2003 3:41 p.m.
To: Defryn, Guy; '[EMAIL PROTECTED]'
Subject: Re: Unable to install 4.08 or 4.09

At 15:31 +1300 1/14/03, Defryn, Guy wrote:
I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error
After running gunzip  mysql-4.0.9-gamma.tar.gz (source install)

Mysql-4.0.9-gamma/bdb/
Mysql-4.0.9-gamma/bdb/db/
Mysql-4.0.9-gamma/bdb/db/db_upg.c
Mysql-4.0.9-gamma/bdb/db/db.c
Mysql-4.0.9-gamma/bdb/db/tags

Tar : skipping to next header
Tar: archive contains obsolescent base-64 headers

Gunzip: stdin: invalid compressed data --crc error
Tar: error exit delayed from previous errors

Does anyone know why this happens. I am using a fresh freebsd 4.7 install

You're not transferring the distribution in binary (image) mode, and
you're ending up with a corrupted download as a result.  At least,
that's the most common reason for errors such as these.

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




host table in mysql database

2003-01-09 Thread Guy Waugh
Hi there,

I'm cleaning up MySQL permissions on one of my servers, and I see that in the 
mysql.host table, there are 8 rows. All 8 rows contain specific hosts in the 'Host' 
column (i.e. no wildcards) and specific databases in the 'Db' column. Further, all 
rows in all privilege columns in the host table contain 'Y'.

I see from reading Paul DuBois' MySQL book that MySQL ANDs privileges in the host 
table with privileges in the db table, allowing administrators to revoke particular 
privileges for users connecting from particular hosts.

Can anyone tell me, then, if the host table is currently having any effect on 
permissions? I'm thinking not, as a logical AND of the host table 'Y' and the db table 
'Y' or 'N' will result in the privilege recorded in the db table.

Also, Paul's book says that the host table is only checked if the 'Host' column in the 
relevant client's row in the db table is blank, and all rows in the db table contain 
values in the 'Host' column. So on that fact alone, it looks like I can delete all 
rows in the host table without permissions being affected...?

Just wanted some opinion/advice before I potentially get myself into trouble ;-)

Thanks in advance,
Guy.


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Mysql.sock gets deleated

2003-01-05 Thread Smart Guy
I installed mysql from rpm package on redhat linux 8.0
and it works fine, but next time i reboot the machine
/var/lib/mysql.sock gets deleated and mysql stops
working  

PLEASE HELP ITS URGENT.. 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: secure replication

2002-10-28 Thread Guy Davis
On Thu, 2002-10-24 at 20:26, Lists @ Apted Technologies Inc. wrote:
 i am going to be setting up four mysql servers, three of which will
 replicate data off of the primary. i know that in more recent versions of
 mysql client/server communciations can be encrypted internally.  but is
 there any way to encrypt replication communcations between these mysql
 servers internally so i don't need to set up a vpn or ssl tunnel?  thanks
 all.

Setting this up with SSH is quite easy.  I have a How-To on it at:

http://www.guydavis.ca/projects/oss/docs/ssh_mysql.jsp

-- 
Guy Davis http://www.guydavis.caCalgary, Alberta, Canada

Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net)
PGP Fingerprint: 8DC8 4A6F C1AD 393B 39DB CDBF 196D 31D0 30D5 2F0

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




small bug in mysqlcheck

2002-10-26 Thread Guy Cohen
Hi,

When trying to check/repair/analaiz a table with a name like 'table-name'
mysqlcheck (from source package 3.23.53) fails with:
mysqlcheck: Got error: 1064: You have an error in your SQL syntax near '-name'
at line 1 when executing 'CHECK TABLE ...

Here's the patch for it:

--- mysqlcheck.old  Sat Oct 26 11:37:49 2002
+++ mysqlcheck.cSat Oct 26 11:35:12 2002
@@ -521,7 +521,7 @@

   if (!(query =(char *) my_malloc((sizeof(char)*(length+110)), MYF(MY_WME
 return 1;
-  sprintf(query, %s TABLE %s %s, op, tables, options);
+  sprintf(query, %s TABLE `%s` %s, op, tables, options);
   if (mysql_query(sock, query))
   {
 sprintf(message, when executing '%s TABLE ... %s, op, options);

HTH.
  Guy


-- 
http://www.uadm.com |   Local and Remote Unix/Linux
[EMAIL PROTECTED]   |   Administration. No outsourcing.
Phone: +972 3 6201373   |   Security, Installations, Support
http://www.uadm.com/pgp.key |   Upgrades and Maintenance.

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Vaibhav Difference between amount null and amount is not null

2002-09-12 Thread compo guy

  What is the difference between the following sql queries written 
to
extract tuples with the field amount having non null value:
  select loan_number from loan where amount  null (It 
returns
an empty set)
  select loan_number from loan where amount is not null(It
returns the expected result).



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mysock.sql problem

2002-09-02 Thread Defryn, Guy



I have installed mysql from the ports collection on FreeBSD and it was working fine.

I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I
Created a my.cnf file with the following options
[mysqld]
port=3306
socket=/usr/local/mysql/mysql.sock

I take down the mysql server and restart but it refuses to work. It is still looking 
in the /tmp directory

What am I doing wrong? Could this be a permission thing on the sock file?
What permissions does this file need?

Cheers

Guy





Sql

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Problem with LOAD LOCAL DATA INFILE

2002-08-21 Thread compo guy

I am using MySQL version 3.23.11-alpha on Win98. I have created a 
database with a table borrower whose description is as follow:

mysql describe borrower;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| customer_name | varchar(20) | YES  | | NULL|   |
| loan_number   | varchar(5)  | YES  | | NULL|   |
+---+-+--+-+-+---+
2 rows in set (0.00 sec)

I use the following to load the data stored in borrower.txt into 
the table borrower :

mysql load data local infile c:\\data\\borrower.txt into table 
borrower;
Query OK, 8 rows affected (0.00 sec)
Records: 8  Deleted: 0  Skipped: 0  Warnings: 1

Case 1:
The file borrower.txt looks like the following :

Adams   L-16
Curry   L-93
Hayes   L-15
Jackson L-14
Jones   L-17
Smith   L- 11
Smith   L-23
WilliamsL-17

When I run a select query i get the following output :
mysql select * from borrower;
+---+-+
| customer_name | loan_number |
+---+-+
| Adams | L-16|
| Curry | L-93|
|| L-15
|n   | L-14
|| L-17
| Smith | L- 11   |
|| L-23
| Williams  | L-17|
+---+-+
8 rows in set (0.06 sec)

Case 2:
When the contents of borrower.txt is changed to no spaces in 
between name and loan_number :

AdamsL-16
CurryL-93
HayesL-15
JacksonL-14
JonesL-17
SmithL-11
SmithL-23
WilliamsL-17

The data stored in the table is:

mysql select * from borrower;
+---+-+
| customer_name | loan_number |
+---+-+
 | NULL|
 | NULL|
 | NULL|
   | NULL|
 | NULL|
 | NULL|
 | NULL|
  | NULL|
+---+-+
8 rows in set (0.00 sec)


Why was the data not correctly loaded into the table? Please Help 
me.

Regards,
Vaibhav Jha.

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Another one on lost connections( using web interface)

2002-08-18 Thread Defryn, Guy


I also have a problem with lost connections.
I have small mysql database (version 3.23.49 on FreeBSD 4.5)

I have created a website interface to enter and retrieve data.
I used ASP to do this. Sometimes when I go to the website
I get the error can't connect or lost connection to server.

The mysql install has been done with default settings and
There are never more than 2 people using the database at the same time.

I also created a PHP interface to the database and I received the same error.

The error does not occur all the time and when it occurs it goes away by refreshing 
the web browser.

I never have any problems when working on the mysql server from the command line.

Any ideas?


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Lost connection to mysql server

2002-07-16 Thread Defryn, Guy

I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88

When I refresh it works fine. It seems to me it's like a 
Timeout thing.

This is my connection to the database

set oconn = server.createobject(Adodb.connection)
oconn.connectionstring = 
server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd
oconn.open

Any ideas?

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Lost connection to mysql server

2002-07-16 Thread Defryn, Guy


I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88

When I refresh it works fine. It seems to me it's like a 
Timeout thing.

This is my connection to the database

set oconn = server.createobject(Adodb.connection)
oconn.connectionstring = 
server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd
oconn.open

Any ideas?

Sql query

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Lost connection to mysql server

2002-07-16 Thread Defryn, Guy




I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88

When I refresh it works fine. It seems to me it's like a 
Timeout thing.

This is my connection to the database

set oconn = server.createobject(Adodb.connection)
oconn.connectionstring = 
server=192.168.1.73;driver=MySQL;db=supplies;uid=myname;pwd=mypwd
oconn.open

Any ideas?

Sql query

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Joins, ANSI 92 or the old way

2002-07-16 Thread Defryn, Guy



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, 17 July 2002 1:59 p.m.
To: Defryn, Guy
Subject: Re: Joins, ANSI 92 or the old way 

Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:

sql,query

If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.

You have written the following:



I was wondering what advantages one has over
the other.

I think the old way is easier but is it good enough?

Cheers

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Calculations in mysql

2002-07-15 Thread Defryn, Guy



Hi there,

I am creating a tracking system for the consumables we give
away to our staff. It is working but I need to know if there is a better practice than 
I what I did

I need to print reports via a website so I used ASP

It needs name,product, amount per item, price per item and total per order.
This is pretty straightforward 

My query looks like this

sqltext1 = Select orders.orderdate AS orderdate,orders.user AS user , 
products.productname AS productname, orders.amount as amount,products.price AS Price,
sqltext1 = sqltext1   (amount* price) AS subtotal from orders,products where 
orders.product = products.productid
sqltext1 = sqltext1   and cluster = '  cluster  ' and orderdate  '  printdate 
 '  order by orderdate;

Now the other thing I need is the total of all orders so I created a 2nd query

sqltext2 = Select sum(orders.amount * products.price) AS total from orders,products 
where orders.product=products.productid AND cluster = '  cluster  'and orderdate  
'  printdate  ';

I have the required result but is there some way I can have everything in one query

G

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Calculations in mysql

2002-07-15 Thread Defryn, Guy





Hi there,

I am creating a tracking system for the consumables we give
away to our staff. It is working but I need to know if there is a better practice than 
I what I did

I need to print reports via a website so I used ASP

It needs name,product, amount per item, price per item and total per order.
This is pretty straightforward 

My query looks like this

sqltext1 = Select orders.orderdate AS orderdate,orders.user AS user , 
products.productname AS productname, orders.amount as amount,products.price AS Price,
sqltext1 = sqltext1   (amount* price) AS subtotal from orders,products where 
orders.product = products.productid
sqltext1 = sqltext1   and cluster = '  cluster  ' and orderdate  '  printdate 
 '  order by orderdate;

Now the other thing I need is the total of all orders so I created a 2nd query

sqltext2 = Select sum(orders.amount * products.price) AS total from orders,products 
where orders.product=products.productid AND cluster = '  cluster  'and orderdate  
'  printdate  ';

I have the required result but is there some way I can have everything in one query

G

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Mysql certification

2002-07-10 Thread Defryn, Guy




I was wondering if anybody heard about a possible release of books that help you 
prepare for the Mysql certification?

Cheers

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Join problem in MYSQL

2002-07-07 Thread Defryn, Guy


sql,query


Can anyone have a look at my join.
It returns errors

Select O.name, O.amount , P.Productname, P.price
From Orders AS O
JOIN Products AS P ON O.product=P.Productid
Where O.cluster= 'ANP';


It works fine when I use

Select O.Name, O.amount, P.productname , P.price
From Orders as O, Products as P 
Where O.product=P.productid
AND O.cluster = 'ANP';


When I use the first example  with INNER JOIN it works as well.
The book I use as study guide is a few years old so maybe the syntax has changed ??


Any ideas



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: find record using MYSQL command in ASP

2002-07-07 Thread Defryn, Guy

Hi there,


Try this

%
 dim objconn, objrs
 dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic
 adopenkeyset=1
 adlockoptimistic=3
 set objconn = server.createobject(adodb.connection)
 set objrs = server.createobject(adodb.recordset)

objconn.connectionstring=server=192.168.0.1;driver=MySQL;db=clientdb;uid=us
er;pwd=user
 objconn.open connectionstring
 sqltxt = select * from client
 criteriatxt = name like 'TELE*'
 objrs.open sqltxt, objconn, adopenkeyset, adlockoptimistic
 objrs.find criteriatxt
 if objrs.eof then
  response.write(record is not exist!)
 else
  response.write objrs(code)  objrs(name) 
objrs(address)  br
 end if
 objrs.close
 objconn.close
 set objrs = nothing
 set objconn = nothing
%

Hope this helps

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Insert with ASP into mysql

2002-07-02 Thread Defryn, Guy


Hi there,

I want to insert data in a mysql database. When I submit
I don't get any errors. It takes me to the page that processes everything

However, when I check the database the records are not there.

Selecting data from the website works fine. My code is below
but I don't think anything is wrong because I don't get any errors.

Any ideas?

%

dim  product,amount,cluster,user,orderdate,entered,comment,oconn,sqltext,arrdate

function newstr(str)
   newstr=replace(replace(str,',''),chr(34),quot;)
End function

product=request.form(product)
amount=request.form(amount)
cluster=request.form(cluster)
user=newstr(request.form(user))
orderdate=request.form(orderdate)
comment=newstr(request.form(comment))
entered=request.form(entered)


set oconn = server.createobject(Adodb.connection)
oconn.connectionstring = 
server=130.123.80.73;driver=MySQL;db=supplies;uid=itsupport;pwd=itsupport
oconn.open 
sqltext = Insert into 
orders(orderid,product,amount,cluster,user,orderdate,comment,entered)
sqltext = sqltext   values(NULL,  product  ,  amount  ,'  cluster  ',' 
 user  ',#  orderdate  #,'  comment  ','  entered  ')
oconn.close
set oconn = nothing

%


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Setting up a mysql server for the web

2002-06-26 Thread Defryn, Guy



I hope someone can tell me a bit more
on how to integrate a MYSQL server with a windows network.

I have a web server that is running IIS5.
The internet user account is IUSR_Machinename.

I do not want to run the database on the web server.
When I tried this with Access it did not work because
the IUSR_machinename only exists on the web server.

How can I give internet users access to a database
That is on another server? I would rather use mysql than Access and preferably run 
mysql on Unix but it is not a must.

Hope this makes sense

Thanks

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




insert into multiple tables??

2002-05-15 Thread Defryn, Guy



Is it possible to insert data into different tables with one insert 
statement.


For example , I have one form on my web page and the data needs to go 
into different tables( first 5 entries to table A and the rest to table 
B)?

Mysql

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Insert dates with PHP

2002-05-15 Thread Defryn, Guy



I am working with PHP for the first time and I need a form
To insert some details and a date.

When I check the mysql database the date is displayed as -00-00

Here is my php script:

? 
$query = Insert into 
computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values . 
(NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' 
,'$datebought');
  
mysql_query($query) or die (mysql_error());

?

Everything else works fine. When I enter the date into mysql itself it works fine. 

Thanks


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Insert dates with PHP

2002-05-15 Thread Defryn, Guy




I did forget to mention that I was using that format.
So it must be something else??

Guy

-Original Message-
From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, 16 May 2002 4:09 p.m.
To: Defryn, Guy
Cc: [EMAIL PROTECTED]
Subject: Re: Insert dates with PHP


you have to enter ur date as in this format

-MM-DD 

for example: 2002-04-04


Hope this will work
Uma


On Thu, 16 May 2002, Defryn, Guy wrote:

DG
DG
DGI am working with PHP for the first time and I need a form
DGTo insert some details and a date.
DG
DGWhen I check the mysql database the date is displayed as -00-00
DG
DGHere is my php script:
DG
DG? 
DG$query = Insert into 
computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values . 
(NULL,'$itnumber','$hdsize','$processor','$ram','$monitor','$os','$invoice' 
DG,'$datebought');
DG  
DGmysql_query($query) or die (mysql_error());
DG
DG?
DG
DGEverything else works fine. When I enter the date into mysql itself it works fine. 
DG
DGThanks
DG
DG
DG-
DGBefore posting, please check:
DG   http://www.mysql.com/manual.php   (the manual)
DG   http://lists.mysql.com/   (the list archive)
DG
DGTo request this thread, e-mail [EMAIL PROTECTED]
DGTo unsubscribe, e-mail 
[EMAIL PROTECTED]
DGTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DG

-- 

Love and you shall be loved by others

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Help: SIGSEGV inside mysql_connect to remote server

2002-05-02 Thread Guy Davis

On Thu, 2002-05-02 at 00:38, Jeremy Zawodny wrote:
 On Wed, May 01, 2002 at 04:24:05PM -0600, Guy Davis wrote:
 
  I am having a really strange problem with a in-house C application
  that calls mysql_connect() and generates a segfault deep within
  uname() when I configure it to contact a remote server.  Using a
  local MySQL server works fine as uname is never called.
  
  Have any of you ever seen anything like this?
 
 Is that remote server's info in /etc/hosts on the client?  If not, see
 if that makes a difference.


Yes, adding the remote server's line to /etc/hosts clears up the
problem.  Does that meant that our DNS server is somehow misconfigured. 
Issuing 'host dev.pason.com' at the command line gives me the correct IP
address.  

Here's /etc/host.conf:   order hosts,bind

Thanks.

-- 
Guy Davishttp://www.guydavis.ca
PGP: D2E2 76D4 0C9C 5D99 42AA  EB6B B9C2 68CA 2DC7 F2E4

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Help: SIGSEGV inside mysql_connect to remote server

2002-05-01 Thread Guy Davis

I am having a really strange problem with a in-house C application that
calls mysql_connect() and generates a segfault deep within uname() when
I configure it to contact a remote server.  Using a local MySQL server
works fine as uname is never called.

Have any of you ever seen anything like this?  Here's the backtrace from
gdb:

Program received signal SIGSEGV, Segmentation fault.
0x0807a086 in uname ()
(gdb) bt
#0  0x0807a086 in uname ()
#1  0x4011da96 in getdomainname (name=0x4019f240 , len=1024)
at ../sysdeps/generic/getdomain.c:40
#2  0x40191ae6 in nis_local_directory () at nis_local_names.c:68
#3  0x40181cb0 in _nss_create_tablename (errnop=0x808c720)
at nss_nisplus/nisplus-hosts.c:183
#4  0x40182223 in internal_gethostbyname2_r (name=0xb5b0
dev.pason.com, 
af=2, host=0x40170620, buffer=0x808fda0 \177, buflen=1024, 
errnop=0x808c720, herrnop=0xb178, flags=0)
at nss_nisplus/nisplus-hosts.c:338
#5  0x401825ca in _nss_nisplus_gethostbyname_r (
name=0xb5b0 dev.pason.com, host=0x40170620, buffer=0x808fda0
\177, 
buflen=1024, errnop=0x808c720, h_errnop=0xb178)
at nss_nisplus/nisplus-hosts.c:447
#6  0x40135cc0 in __gethostbyname_r (name=0xb5b0 dev.pason.com, 
resbuf=0x40170620, buffer=0x808fda0 \177, buflen=1024, 
result=0xb174, h_errnop=0xb178) at ../nss/getXXbyYY_r.c:200
#7  0x401356da in gethostbyname (name=0xb5b0 dev.pason.com)
at ../nss/getXXbyYY.c:131
#8  0x0805b8cc in mysql_real_connect ()
#9  0x0805d90c in mysql_connect ()
#10 0x08070385 in ssConnectDB (databaseName=0x8073c85 hub) at
_ssmysql.c:52

Any idea what this could be?  Any idea on how I could try to track it
down?  My feeling is that this is most likely something wrong with our C
application.  However, it calls ssConnectDB right near the beginning of
main(), so there isn't much opportunity for memory errors.

Thanks.

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Creating MySQL database using DAO

2002-04-04 Thread Guy-Maurice Lepoutre

Hello,

I would like to create a MySQL database using DAO and
Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
know there is a Create() method on CDaoDatabase but I
cannot figure out how to use it to create a mysql
database. Does anyone know how to do this?

Moreover, do you know which files are created while we
create a new database and what they contain?


Thank you very much for your help.
Guy-Maurice

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Rotation of binary logs on replication master?

2002-03-22 Thread Guy Davis

On Thu, 2002-03-21 at 13:07, Shawn McCool wrote:
 /usr/local/bin/mysql -hhostname -uusername -ppassword -e flush logs;

I guess I wasn't clear that I wanted old binary logs removed.  I don't
want to have to manually worry about disk space due to ever increasing
binary logs.

It seems to me FLUSH LOGS just opens a new binary log.  The old, unused
ones are still left in place.  I'm looking for a rotating set of say 4
kept.  Anything older is deleted.  Logrotate does this for Apache's logs
for example.

The RESET command seems to delete all binary logs.  I don't want them
all deleted, just very old ones.  Any ideas?  Thanks.

Flush logs did the following:

[root@nachos root]# du -h /var/lib/mysql/nachos*
4.0k/var/lib/mysql/nachos-bin.001
700M/var/lib/mysql/nachos-bin.002
4.0k/var/lib/mysql/nachos-bin.003
1.1G/var/lib/mysql/nachos-bin.004
350M/var/lib/mysql/nachos-bin.005
4.0k/var/lib/mysql/nachos-bin.006
189M/var/lib/mysql/nachos-bin.007
384M/var/lib/mysql/nachos-bin.008
4.0k/var/lib/mysql/nachos-bin.009
1.1G/var/lib/mysql/nachos-bin.010
289M/var/lib/mysql/nachos-bin.011
1.1G/var/lib/mysql/nachos-bin.012
1.1G/var/lib/mysql/nachos-bin.013
684M/var/lib/mysql/nachos-bin.014
4.0k/var/lib/mysql/nachos-bin.index
332k/var/lib/mysql/nachos-slow.log
4.0k/var/lib/mysql/nachos.us.pason.com.pid

mysql FLUSH LOGS;

[root@nachos root]# du -h /var/lib/mysql/nachos*
4.0k/var/lib/mysql/nachos-bin.001
700M/var/lib/mysql/nachos-bin.002
4.0k/var/lib/mysql/nachos-bin.003
1.1G/var/lib/mysql/nachos-bin.004
350M/var/lib/mysql/nachos-bin.005
4.0k/var/lib/mysql/nachos-bin.006
189M/var/lib/mysql/nachos-bin.007
384M/var/lib/mysql/nachos-bin.008
4.0k/var/lib/mysql/nachos-bin.009
1.1G/var/lib/mysql/nachos-bin.010
289M/var/lib/mysql/nachos-bin.011
1.1G/var/lib/mysql/nachos-bin.012
1.1G/var/lib/mysql/nachos-bin.013
684M/var/lib/mysql/nachos-bin.014
4.0k/var/lib/mysql/nachos-bin.015
4.0k/var/lib/mysql/nachos-bin.index
332k/var/lib/mysql/nachos-slow.log
4.0k/var/lib/mysql/nachos.us.pason.com.pid

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Rotation of binary logs on replication master?

2002-03-21 Thread Guy Davis

Just wondering if any Linux users of MySQL out there had written a
logrotate configuration file for dealing with MySQL binary logs on a
replication Master.

I want to rotate these logs (6.5 GB now) as some are over a month old. 
However, I don't want to confuse any of the replicating slaves.  Any
tips?

Thanks.

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Problem with using INSERT INTO [table] SQL string

2002-03-17 Thread Donald Guy

Hi all,

Please excuse any ignorance I may show with this question - as I am not a
programmer and I am trying to do something that is out of my experience.  I
feel truly out of my element in this and am hoping that the list expertise
will help me.  I have looked at the manual - but still am confused.

Basically, I am trying to set up forms using Microsoft FrontPage 2000 where
the results (form input) will be sent to a database (Microsoft Access 2000)
and to an email address.  I am following instructions outlined in a
Microsoft white paper which has specifically been written to address this
topic (found at
http://download.microsoft.com/download/fp2000/whitep/1/NT5XP/EN-US/cdonts200
0.EXE)

My problem is that I can only get one form field value to be inserted into
my table.  I think I have followed the instructions that the white paper
gives for building the mySQL string that is used to insert the form
information into the database - but I am having no success in getting all
the form information inserted into the databse.

--
The mySQL syntax given by the white paper is the following:

mySQL = INSERT INTO [your_table_name] 
mySQL = mySQL  ([database_field_names]) 
mySQL = mySQL  VALUES ('[form_field_names]')

--
The example mySQL string in the white paper is:

mySQL= INSERT INTO Employees 
mySQL= mySQL  (FirstName,LastName,Address,City,Region,PostalCode) 
mySQL= mySQL  VALUES ('  Request.Form(FirstName)  ','
mySQL= mySQL  Request.Form(LastName)  '
mySQL= mySQL  ,'  Request.Form(Address)  '
mySQL= mySQL  ,'  Request.Form(City)  ','
mySQL= mySQL  Request.Form(Region)  ','
mySQL= mySQL  Request.Form(PostalCode)  ')

---
The white paper gives the following my SQL syntax to help with customizing
the SQL string:

INSERT INTO [table] ([DBfield1],[DBfield2]) VALUES
('[form_field1]','[form_field2]')

mySQL = INSERT INTO [table] (DBfield) VALUES (' 
Request.Form(form_field)  ')

--
Background:

The Microsoft Access 2000 database table I want to insert information into
is named Action

The form field names or VALUES I am trying to insert information from (from
the FrontPage 2000 form) are:

RequestDate
CommerceID
LastName
FirstName
Email
DepartmentNumber
Sector
StreetAddress
City
State
ZipCode
LocationCode
MailDrop
TelephoneNumber
FaxNumber
RequestType
Library
Request

The Microsoft Access 2000 database table field names (to which I want to
insert information into) are:

RequestDate
CommerceID
Client
FirstName
Email
DepartmentNum
Sector
StreetAddress
City
State
ZipCode
LocCode
MailDrop
TelephoneNum
FaxNum
ServiceName
InternalGroup
Request

The form field values correspond to the table colums in the following way:

RequestDate (value from form) insert RequestDate (database field name)
CommerceID (value from form) insert into CommerceID (database field name)
LastName (value from form) insert into Client (database field name)
FirstName (value from form) insert into FirstName (database field name)
Email (value from form) insert into Email (database field name)
DepartmentNumber (value from form) insert into DepartmentNum (database field
name)
Sector (value from form) insert into Sector (database Field name)
StreetAddress (value from form) insert into StreetAddress (database field
name)
City (value from form) insert into City (database field name)
State (value from form) insert into State (database field name)
ZipCode (value from form) insert into ZipCode (database field name)
LocationCode (value from form) insert into LocCode (database field name)
MailDrop (value from form) insert into MailDrop (database field name)
TelephoneNumber (value from form) insert into TelephoneNum (database field
name)
FaxNumber (value from form) insert into FaxNumber (database field name)
RequestType (value from form) insert into ServiceName (database field name)
Library (value from form) insert into InternalGroup (database field name)
Request (value from form) insert into Request (database Field name)

-
What I have tried and the results:

I have tried the following mySQL string - based on the example given in thw
white paper (did not include all form fields as I wanted to see if it would
work using the example given as a template).  This string gave me error
messages...

mySQL= INSERT INTO Action 
mySQL= mySQL  (RequestDate,CommerceID,Client,FirstName,Sector,Request) 
mySQL= mySQL  VALUES ('  Request.Form(RequestDate)  ','
mySQL= mySQL  Request.Form(CommerceID)  '
mySQL= mySQL  ,'  Request.Form(Client)  '
mySQL= mySQL  ,'  Request.Form(FirstName)  ','
mySQL= mySQL  

Re-baselining replication slaves?

2002-03-01 Thread Guy Davis

I started replicating the MySQL DB on our production server last month. 
I was wondering if anyone who has been doing replication for a while has
seen the need to resync the slave.  (i.e. snapshot the master, install
on slave, and re-start replication from snapshot)

Are there systems out there that have been replicating for a year plus
with no troubles?  Thanks.

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Running Without TCP Port

2002-02-22 Thread Guy Davis

On Fri, 2002-02-22 at 11:09, havoc wrote:
 Is it possible to run mysqld without binding to a TCP port?
 As in run using only unix sockets?

Start with --skip-networking:

http://www.mysql.com/doc/C/o/Command-line_options.html

or put skip-networking into your my.cnf file.

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: insert picture file in MySQL (+php)

2002-02-14 Thread Guy Davis

On Thu, 2002-02-14 at 08:42, Eric Torr Klopper wrote:
 How would you go about doing this. Could somebody send me some sample
code and also explain how to get the image link into the database so I
can access the image. I'm fairly new to MySql and 
 PHP so any help on this will be appreciated.

I use this for the photo album on my web site (http://www.guydavis.ca).
It's not a high traffic site by any means, so performance isn't an
issue.  Can't show you PHP, but here's what I did in an Java servlet. 
It handles uploaded (POST) images from friends.  byte_out is a
ByteArrayOutputStream.  imageIcon is an Icon that I create using JDK
1.4's headless AWT support to allow me to calculate the image's
thumbnail dimensions.

  Connection con = WebUtils.getConnection();
  String st = INSERT INTO photos (location, description, date_shot,
filename, mimetype, img_data, ;
  st += height, width, thumb_height, thumb_width, category, access,
title) ;
  st += VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
  PreparedStatement stmnt = con.prepareStatement(st);
  stmnt.setString(1, ((String) params.get(location)));
  stmnt.setString(2, ((String) params.get(description)));
  stmnt.setString(3, date);
  stmnt.setString(4, (image.getFileName()));
  stmnt.setString(5, image.getContentType());
  stmnt.setBytes(6, byte_out.toByteArray());
  stmnt.setInt(7, imageIcon.getIconHeight());
  stmnt.setInt(8, imageIcon.getIconWidth());
  stmnt.setInt(9, thumb_height);
  stmnt.setInt(10, thumb_width);
  stmnt.setInt(11, Integer.parseInt((String) params.get(category)));
  stmnt.setString(12, (String) params.get(access));
  stmnt.setString(13, ((String) params.get(title))); 
  stmnt.executeUpdate();

Given that most of the photos posted by myself and friends are personal,
I needed an access control system and I wanted something more robust
than a publicly accessible image with a random name.  The only way to do
that is to have a servlet or CGI read in a image from disk or database
(where's it's not web accessible) and write the data out to the client.

Here's the relevant code from my PhotoServlet:

  String query = SELECT * FROM photos WHERE id=+id;
  ResultSet rs = WebUtils.doSQL(query);
  if (!rs.first()) {
displayError(request, response);
return;
  }  

  // if it's marked personal, only logged in people should see it
  if ((rs.getString(access).equalsIgnoreCase(Personal))  
(session.getValue(login) == null)) {
displayError(request, response);
return;
}

  if (rs.getString(filename).toUpperCase().indexOf(.GIF) =
0)  
response.setContentType(image/gif);   
  else
response.setContentType(image/jpeg);  

  Blob img_blob = rs.getBlob(img_data);
  InputStream in = img_blob.getBinaryStream();
  while (in.available()  0)
  buf_out.write(in.read());
  buf_out.flush();
  buf_out.close();  


Here's the CREATE TABLE for my photos table:

photos | CREATE TABLE `photos` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `location` varchar(255) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `date_shot` date NOT NULL default '-00-00',
  `filename` varchar(255) NOT NULL default '',
  `mimetype` varchar(50) NOT NULL default '',
  `height` smallint(5) unsigned default NULL,
  `width` smallint(5) unsigned default NULL,
  `thumb_height` smallint(5) unsigned default NULL,
  `thumb_width` smallint(5) unsigned default NULL,
  `img_data` longblob,
  `category` smallint(5) unsigned default NULL,
  `access` enum('Public','Personal') default 'Personal',
  `title` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM


I don't see why you shouldn't be able to do something similar in PHP.
Hope this helps.

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




ADO to MySQL interface?

2002-02-13 Thread Guy Davis

Hi all,

The company I work for is a Linux shop using MySQL almost exclusively, 
however we're partnering with Windows-only shop to tie their application
into our overall product offering. 

Their app uses ADO as it's database interface and they say it will work
with Oracle, MS SQL Server, and MS Access.  I'm wondering if there is an
ADO adapter out there that will work with MySQL.  I know of the ODBC
connector, but I'm told ADO replaces ODBC(?).

If possible we'd like to stick with MySQL, rather than paying large
licensing fees for either Oracle or SQL Server.

-- 
Guy Davis   Phone:   (403) 301-3426   
Pason Systems   Fax: (403) 301-3499
PGP: 65BA 484B 0B96 5F3B 4D40  DCA2 B2AE 6B5A F52B 1445

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Possible Index problem?

2002-01-29 Thread teck guy

I am using mysql verison 3.23.41-nt

I am working with the following two tables.

mysql show create table table1;
| Table   | Create Table
-
| table1 | CREATE TABLE `table1` (
  `Column1` varchar(63) NOT NULL default '',
  `Column2` varchar(31) default NULL
  PRIMARY KEY  (`Column1`)
) TYPE=MyISAM |


mysql show create table table2;
| Table  | Create Table
--
| table2 | CREATE TABLE `table2` (
  `Column1` varchar(63) default NULL
  KEY `idx1` (`Column1`)
) TYPE=MyISAM |
++


1) When i run the first query through explain the
expected results happen

mysql explain SELECT table1.column1 FROM table1,
table2 WHERE table1.column1 = table2.column2;
+-+---+---+-+-+---+---+-+
| table   | type  | possible_keys | key |
key_len | ref   | rows  | Extra  
|
+-+---+---+-+-+---+---+-+
| table1  | index | PRIMARY   | PRIMARY | 
63 | NULL  | 57379 | Using index |
| table2  | ref   | idx1  | idx1| 
64 | table1.column1| 1 | Using index |
+-+---+---+-+-+---+---+-+

However, when i select an additional column, the
following unexpected results happen

mysql explain SELECT table1.column1, table1.column2
FROM table1, table2 WHERE table1.column1 =
table2.column2
+-+--+---+--+-+---+---+-+
| table   | type | possible_keys | key  | key_len
| ref   | rows  | Extra   |
+-+--+---+--+-+---+---+-+
| table1  | ALL  | PRIMARY   | NULL |NULL
| NULL  | 57379 | |
| table2  | ref  | idx1  | idx1 |  64
| table1.column1| 1 | Using index |
+-+--+---+--+-+---+---+-+


2) Also, look at the following scanario


mysql explain SELECT table1.column1 FROM table1,
table2 WHERE table1.column1 = table2.column2 order by
table1.column1 asc;
+-+---+---+-+-+---+---+-+
| table   | type  | possible_keys | key |
key_len | ref   | rows  | Extra  
|
+-+---+---+-+-+---+---+-+
| table1  | index | PRIMARY   | PRIMARY | 
63 | NULL  | 57379 | Using index |
| table2  | ref   | idx1  | idx1| 
64 | table1.column1| 1 | Using index |
+-+---+---+-+-+---+---+-+

However, when i select an additional column, the
following unexpected results happen

mysql explain SELECT table1.column1, table1.column2
FROM table1, table2 WHERE table1.column1 =
table2.column2 order by table1.column1 asc
+-+--+---+--+-+---+---++
| table   | type | possible_keys | key  | key_len
| ref   | rows  | Extra  |
+-+--+---+--+-+---+---++
| table1  | ALL  | PRIMARY   | NULL |NULL
| NULL  | 57379 | Using filesort |
| table2  | ref  | idx1  | idx1 |  64
| table1.column1| 1 | Using index|
+-+--+---+--+-+---+---++


I am baffled as to why simple selecting an extra
column results in the index no longer being used even
though 
the where clause has not changed.  

If anybody could provide me an explain as to why this
is occuring with a solution, it would be greatly
appreciated.


TIA

__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Linking problems

2002-01-25 Thread Guy-Maurice Lepoutre

Hi,

I did all that but I still have the linking problems:
it seems that it doesn't find the MysqlConnection
implementation.



NOTES:
--
1) The main workspace and project for the mysql++ API
are located in the root
   directory
2) This project, when built, will yield the static
library mysql++.lib in the
   /lib directory
3) This library needs the header files in the /include
and /mysql/include
   directory, and libmysql.lib in the mysql/lib
directory
4) All programs using MySQL++ need libmysql.dll
(located in the /mysql/lib
   directory) to be able to run. You have to put it
into the same directory
   as the executable, or for example copy it into the
windows/system directory
5) In the /example directory a workspace and project
have been made for
   building the (non-MFC) examples
6) In the /example/MFC_example an example for using
MySQL++ in an MFC project
   has been made

PROBLEMS:
-
1) Visual C++ doesn't provide full functionality for
longlongs, such as
   strtoll and ostream operator , so all longlongs
have been replaced with
   ints in the examples
2) The example custom4.cpp could not be compiled
3) There are still some problems with the functions
for static result sets.
   They seem to work alright with vectors, but might
not work for the other
   STL containers
4) In every project you make with MySQL++ support, you
need to use the
   multithreaded DLL run-time library. This can be set
in Project Settings,
   C/C++ tab, category Code Generation, Use run-time
library listbox.
   If you don't want to change your run-time library,
change the run-time
   library in the MySQL++ project and rebuild
mysql++.lib (warning: this is
   not recommended and may yield linker errors in your
project!)

HOW TO RUN THE EXAMPLES
---
1) You should have mysql server installed on your
localhost with user root and
   no password.
2) Run resetdb.exe example in order to create test
database.
3) Run other examples

HOW TO ADD MYSQL++ TO AN EXISTING VISUAL C++ PROJECT

1) Add mysql++.lib to the project
2) Go to Project Settings, C/C++ tab, category
Preprocessor, and add the
   directories include and mysql/include to the
Additional include
   directories edit box
3) In the source files, in which you want to use
MySQL++, add the line
   #include mysql++
   after all other included header files (especially
those of MFC)
4) If errors occur, see the Problems section



Thanks a lot for your help


--- Sinisa Milivojevic [EMAIL PROTECTED] wrote:
 Guy-Maurice Lepoutre writes:
  Hello,
  
  I am using Visual C++ 6.0 and I have some linking
  problems while trying to run the example program
  MFC_ex.cpp included in the downloading files in
 the
  mysql.com website.
  Here are the errors I get:
  
  
  MFC_ex.exe - 18 error(s), 0 warning(s)
  
  
  Thanks a lot for your help
  
  
 
 Hi!
 
 You have to link in MySQL C API library too ...
 
 -- 
 Regards,
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa
 Milivojevic [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime
 Developer
 /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
___/   www.mysql.com
 


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Linking problems

2002-01-24 Thread Guy-Maurice Lepoutre

Hello,

I am using Visual C++ 6.0 and I have some linking
problems while trying to run the example program
MFC_ex.cpp included in the downloading files in the
mysql.com website.
Here are the errors I get:

Configuration: MFC_ex - Win32
Debug
Linking...
MFC_ex.obj : error LNK2001: unresolved external symbol
public: __thiscall
MysqlConnection::~MysqlConnection(void)
(??1MysqlConnection@@QAE@XZ)
MFC_ex.obj : error LNK2001: unresolved external symbol
class std::basic_ostreamchar,struct
std::char_traitschar   __cdecl operator(class
std::basic_ostreamchar,struct std::char_traitschar
 ,class mysql_ColDataclass const_string const 
)
(??6@YAAAV?$basic_ostream@DU?$char_traits@D@std@@@std@@AAV01@ABV?$mysql_ColData@Vconst_string@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
public: __thiscall
MysqlConnection::MysqlConnection(char const *,char
const *,char const *,char const *,bool)
(??0MysqlConnection@@QAE@PBD000_N@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
public: __thiscall MysqlResUse::~MysqlResUse(void)
(??1MysqlResUse@@QAE@XZ)
MFC_ex.obj : error LNK2001: unresolved external symbol
_mysql_num_rows@4
MFC_ex.obj : error LNK2001: unresolved external symbol
_mysql_fetch_lengths@4
MFC_ex.obj : error LNK2001: unresolved external symbol
_mysql_fetch_row@4
MFC_ex.obj : error LNK2001: unresolved external symbol
_mysql_data_seek@12
MFC_ex.obj : error LNK2001: unresolved external symbol
public: class std::basic_stringchar,struct
std::char_traitschar,class std::allocatorchar  
__thiscall SQLQuery::str(class SQLQueryParms const
)const  (?str@SQLQuery@@QBE?AV?$basic_strin
g@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@ABVSQLQueryParms@@@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
public: class std::basic_stringchar,struct
std::char_traitschar,class std::allocatorchar  
__thiscall SQLQuery::str(class SQLQueryParms const
,enum query_reset) (?str@SQLQuery@@QAE?AV?$
basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@ABVSQLQueryParms@@W4query_reset@@@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
public: class MysqlRes  __thiscall
MysqlConnection::store(class
std::basic_stringchar,struct
std::char_traitschar,class std::allocatorchar 
const ,bool) (?store@MysqlConnection@@QAE?AVM
ysqlRes@@ABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@_N@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
protected: virtual class std::fposint  __thiscall
std::strstreambuf::seekoff(long,short,int)
(?seekoff@strstreambuf@std@@MAE?AV?$fpos@H@2@JFH@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
public: unsigned int __thiscall
MysqlResUse::num_fields(void)const 
(?num_fields@MysqlResUse@@QBEIXZ)
MFC_ex.obj : error LNK2001: unresolved external symbol
private: void __thiscall MysqlFieldNames::init(class
MysqlResUse const *)
(?init@MysqlFieldNames@@AAEXPBVMysqlResUse@@@Z)
MFC_ex.obj : error LNK2001: unresolved external symbol
private: void __thiscall FieldTypes::init(class
MysqlResUse const *)
(?init@FieldTypes@@AAEXPBVMysqlResUse@@@Z)
nafxcwd.lib(thrdcore.obj) : error LNK2001: unresolved
external symbol __endthreadex
nafxcwd.lib(thrdcore.obj) : error LNK2001: unresolved
external symbol __beginthreadex
Debug/MFC_ex.exe : fatal error LNK1120: 17 unresolved
externals
Error executing link.exe.

MFC_ex.exe - 18 error(s), 0 warning(s)


Thanks a lot for your help



__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Compiling problem: error in type_info1.hh

2002-01-19 Thread Guy-Maurice Lepoutre
:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(63) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(72) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(83) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(88) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(93) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(98) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(103) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(108) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(113) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(122) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(123) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(126) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(142) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(147) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(152) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(162) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(172) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(177) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(182) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(187) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(195) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(196) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(199) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(217) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(222) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(227) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(237) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(247) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(252) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(257) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(263) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(272) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(273) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(276) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(292) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(297) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(306) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(317) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(322) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(327) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(336) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(337) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(340) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\manip1.hh(345) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(56) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(56) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(71) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(71) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(88) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(88) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(99) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\vallist1.hh(99) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\null2.hh(7) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\null2.hh(7) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\set3.hh(23) : error C2872:
'ostream' : ambiguous symbol
c:\sqlplus\include\set3.hh(23) : error C2872:
'ostream' : ambiguous symbol
Error executing cl.exe.

prog.obj - 98 error(s), 6 warning(s)



--- Sinisa Milivojevic [EMAIL PROTECTED] wrote:
 Guy-Maurice Lepoutre writes:
  Hello,
  
  I have troubles compiling this program:
  
  #include iostream.h
  #include iomanip.h
  #include c:/sqlplus/sqlplus.hh
  
  int main()
  {return(0);}
  
  As you can see, the program itself isn't very
  complicated.
  When I run this program (using MS Visual C++),
 here
  are the errors I get. Can anybody help me please.
 I
  would really appreciate it. You can reply me using
 my
  mail adress: [EMAIL PROTECTED]
  
  Thanks
 
 Please download and use

Compiling problem: error in type_info1.hh

2002-01-18 Thread Guy-Maurice Lepoutre

Hello,

I have troubles compiling this program:

#include iostream.h
#include iomanip.h
#include c:/sqlplus/sqlplus.hh

int main()
{return(0);}

As you can see, the program itself isn't very
complicated.
When I run this program (using MS Visual C++), here
are the errors I get. Can anybody help me please. I
would really appreciate it. You can reply me using my
mail adress: [EMAIL PROTECTED]

Thanks

Configuration: prog - Win32
Debug
Compiling...
prog.cpp
c:\sqlplus\type_info1.hh(31) : error C2758:
'_base_type' : must be initialized in constructor
base/member initializer list
c:\sqlplus\type_info1.hh(27) : see declaration
of '_base_type'
c:\sqlplus\type_info1.hh(31) : error C2758: '_default'
: must be initialized in constructor base/member
initializer list
c:\sqlplus\type_info1.hh(28) : see declaration
of '_default'
c:\sqlplus\type_info1.hh(69) : error C2252: 'offset' :
pure specifier can only be specified for functions
c:\sqlplus\type_info1.hh(70) : error C2258: illegal
pure syntax, must be '= 0'
c:\sqlplus\type_info1.hh(70) : error C2252:
'unsigned_offset' : pure specifier can only be
specified for functions
c:\sqlplus\type_info1.hh(71) : error C2258: illegal
pure syntax, must be '= 0'
c:\sqlplus\type_info1.hh(71) : error C2252:
'null_offset' : pure specifier can only be specified
for functions
c:\sqlplus\type_info1.hh(72) : error C2258: illegal
pure syntax, must be '= 0'
c:\sqlplus\type_info1.hh(72) : error C2252:
'unsigned_null_offset' : pure specifier can only be
specified for functions
c:\sqlplus\type_info1.hh(79) : error C2258: illegal
pure syntax, must be '= 0'
c:\sqlplus\type_info1.hh(79) : error C2252:
'string_type' : pure specifier can only be specified
for functions
c:\sqlplus\type_info1.hh(163) : warning C4800:
'unsigned int' : forcing value to bool 'true' or
'false' (performance warning)
c:\sqlplus\type_info1.hh(176) : warning C4800: 'int' :
forcing value to bool 'true' or 'false' (performance
warning)
c:\sqlplus\type_info1.hh(180) : warning C4800: 'int' :
forcing value to bool 'true' or 'false' (performance
warning)
c:\sqlplus\type_info1.hh(184) : warning C4800: 'int' :
forcing value to bool 'true' or 'false' (performance
warning)
c:\sqlplus\type_info1.hh(188) : warning C4800: 'int' :
forcing value to bool 'true' or 'false' (performance
warning)
c:\sqlplus\coldata1.hh(60) : error C2039:
'string_type' : is not a member of 'mysql_type_info'
c:\sqlplus\type_info1.hh(62) : see declaration
of 'mysql_type_info'
c:\sqlplus\coldata1.hh(125) : see reference to
class template instantiation 'mysql_ColDataStr'
being compiled
c:\sqlplus\coldata1.hh(63) : error C2039:
'string_type' : is not a member of 'mysql_type_info'
c:\sqlplus\type_info1.hh(62) : see declaration
of 'mysql_type_info'
c:\sqlplus\coldata1.hh(125) : see reference to
class template instantiation 'mysql_ColDataStr'
being compiled
c:\program files\microsoft visual
studio\vc98\include\strstream(52) : error C2039:
'openmode' : is not a member of 'ios'
c:\program files\microsoft visual
studio\vc98\include\ios.h(106) : see declaration of
'ios'
c:\program files\microsoft visual
studio\vc98\include\strstream(52) : error C2061:
syntax error : identifier 'openmode'
c:\program files\microsoft visual
studio\vc98\include\strstream(54) : error C2039:
'openmode' : is not a member of 'ios'
c:\program files\microsoft visual
studio\vc98\include\ios.h(106) : see declaration of
'ios'
c:\program files\microsoft visual
studio\vc98\include\strstream(54) : error C2061:
syntax error : identifier 'openmode'
c:\program files\microsoft visual
studio\vc98\include\strstream(91) : error C2629:
unexpected 'class std::ostrstream ('
c:\program files\microsoft visual
studio\vc98\include\strstream(91) : error C2238:
unexpected token(s) preceding ';'
c:\program files\microsoft visual
studio\vc98\include\strstream(109) : error C2629:
unexpected 'class std::strstream ('
c:\program files\microsoft visual
studio\vc98\include\strstream(109) : error C2238:
unexpected token(s) preceding ';'
c:\program files\microsoft visual
studio\vc98\include\xtree(118) : warning C4786:
'std::_Treestd::basic_stringchar,std::char_traitschar,std::allocatorchar
,std::pairstd::basic_stringchar,std::char_traitschar,std::allocatorchar
 const ,
int,std::mapstd::basic_stringchar,std::char_traitschar,std::allocatorchar
,int,std::lessstd::basic_stringchar,std::char_traitschar,std::allocatorchar
 ,std::allocatorint
::_Kfn,std::lessstd::basic_stringchar,std::char_traitscha
r,std::allocatorchar  ,std::allocatorint ' :
identifier was truncated to '255' characters in the
debug information
c:\program files\microsoft visual
studio\vc98\include\map(46) : see reference to class
template instantiation
'std::_Treestd::basic_stringchar,std::char_traitschar,std::allocatorchar
,std::pairstd::basic_stringchar,std::char_traits
char,std::allocatorchar  const

relationships between databases

2001-12-17 Thread Defryn, Guy



This is my first post to the list

What is the best way of making a relationship between tables in Mysql.
Do you set it up when you are creating the tables or is it done with the
insert statement

I am a newbie to Mysql, BTW

Guy

-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




downloaded file problem

2001-07-23 Thread Guy A

hi, 
I have download manual-split.tar.gz and couldn't open it (from www.mysql.com).
tried with winzip but had the following error:
Invalid Compressed Data - unable to inflate

which program should I use?
why not Zipping the files?

Guy.



Replication and redirection

2001-06-19 Thread Guy Smith

OS:   RedHat 6.2 on master and slave
mySQL:3.23.32 on master and slave

Problem:  Replication is not working.  Symptoms include:

* Connecting OK.  'Show slave status' reports nominally.

* Position on the log file increments correctly when updates occur on the
master.

* The tables do not get updated.

The web hosting service (20after4.com = recommended - very helpful people
there) has performed a replication between two of their servers, using the
same master for my replication attempt as the master for theirs.  Their
replication worked.

The main difference is that they did not use redirection and I did.  Having
the development database on this system, I do not want to replicate
directly.  So, when we synced I created a local database here (xxxprod),
copied the snapshot of the production database to the xxxprod data directory
here, then initiated replication.

We have tried putting the replication commands in the my.cnf file and using
the 'change master to' command, and get the same results.  Here is the
current my.cnf file.

[mysqld]
server-id=11
replicate-do-db=xxx
replicate-rewrite-db=xxx-xxxprod

Anyone have an idea what we may have done wrong?


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: aggravating failure symptoms and steps to remedy them...

2001-06-19 Thread Guy Smith

Not sure I'll be helpful, but I ran into something similar yesterday.  Not
exactly sure how I fixed it, but this is what I believe.

1) You should create a virgin data directory per the standard procedures on
the production machine (install_db and safe_mysqld).

2) Then, if you have existing data, copy over the existing data directory.

 -Original Message-
 From: Peter H. Burris [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 19, 2001 1:49 PM
 To: [EMAIL PROTECTED]
 Subject: aggravating failure symptoms and steps to remedy them...


 I'm a sysadmin who created mysql installs for users on linux x86 boxen;  I
 had to create self-contained, architecture-specific packages to comply
 with our in-house means of handling software in my department.  That took
 three weeks to fine-tune and distribute and mysql seemed to run out of the
 box, after some tuning on my build-host.

 Everything LOOKED good...until the user who called and said, did you
 change my password?  uh, no.  Why can't I get on Mysql, then? uh, did
 you do a ps -ef? nothing happens.

 well, the host.some.domain.err says the following:

 010619 16:39:30  mysqld started
 010619 16:39:30  /usr/local/mysql/libexec/mysqld: Can't find file:
 './mysql/host.frm' (errno: 13)
 010619 16:39:30  mysqld ended

   searches on dejanews.com (or 'googlegroups, as they are known)
 revealed someone had run into this and had been advised to run the
 installdb script;  I did that again, but now it doesn't do me much good,
 so I try linking over /usr.../mysql/var/mysql to /usr/../,ysql/libexec,
 but to no visible change in behavior, judging by stdout and the *.err log.

 What painfully simple, stupid thing am I missing?


 -
 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 PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Start fails after upgrade to 3.23.32 - no host.ISM file

2001-06-18 Thread guy

Description:

Upgraded from 3.22.27 to 3.23.32.  Built from source.

When attempting to start the daemon, it immediately terminates.  Log file shows Can't 
find file: 'host.ISM' (errno: 2).  I checked the old data directory (from where I 
copied the database files) and there never has been a host.ISM file.  I don't see a 
reference to this in the trouble shoot guides.

Please note:  I cannot go to the current version as this machine (development) cannot 
be on a higher version that the production machine, which is on 3.23.32.

How-To-Repeat:

Use either safe_mysqld or mysql.server to start.  Same symptoms.

Fix:

Looking for fix.

Submitter-Id:  submitter ID
Originator:Guy Smith
Organization:  FundTheCause, Inc.
MySQL support: none
Synopsis:  Start fails after upgrade to 3.23.32 - no host.ISM file
Severity:  serious
Priority:  medium
Category:  mysql
Class: support
Release:   mysql-3.22.32 (TCX binary)

Environment:

System: Linux linus 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown
Architecture: i586

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS='-O6 -mpentium -fomit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors'  LDFLAGS='-static'
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX binary' 
--enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static 
--disable-shared


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Upgrade and start-up failures

2001-06-18 Thread Guy Smith

I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).

I copied the /data directory to the new home.  When I try to start mySQL, it
halts and the log file has the entry Can't find file: 'host.ISM' (errno:
2).  I checked the old mySQL /data directory, and there never was any such
file.  I can still start the old server without error.

Any suggestions are welcome.

OS:RedHat Linux 6.2
DIST: Built from source



Upgrade and start-up failures

2001-06-18 Thread Guy Smith

I just upgraded from 3.23.27 to 3.23.32 (can't go higher than that - have to
sync development with production systems).

I copied the /data directory to the new home.  When I try to start mySQL, it
halts and the log file has the entry Can't find file: 'host.ISM' (errno:
2).  I checked the old mySQL /data directory, and there never was any such
file.  I can still start the old server without error.

Any suggestions are welcome.

OS:RedHat Linux 6.2
DIST: Built from source



RE: Upgrade and start-up failures

2001-06-18 Thread Guy Smith

Tried both.  1st copied the data tree (wherein there is a host.frm,
host.MYD, and host.MYI files).

When that didn't work, I did the mysql_install_db, but that had no effect.

I suspect that there is a ./configure option I missed that declares the
default data file format to use, and that they were built differently.  But
I cannot yet find that in the docs.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
 Behalf Of Steve Brazill
 Sent: Monday, June 18, 2001 6:11 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: Upgrade and start-up failures


 It's looking for the host table (physical files) within the
 'mysql' data area
 (not your own data area).

 Did you run mysql_install_db after installing the new version ?
  (or copy the
 mysql subdirectory from the old version)

 Guy Smith wrote:

  I just upgraded from 3.23.27 to 3.23.32 (can't go higher than
 that - have to
  sync development with production systems).
 
  I copied the /data directory to the new home.  When I try to
 start mySQL, it
  halts and the log file has the entry Can't find file:
 'host.ISM' (errno:
  2).  I checked the old mySQL /data directory, and there never
 was any such
  file.  I can still start the old server without error.
 
  Any suggestions are welcome.
 
  OS:RedHat Linux 6.2
  DIST: Built from source


 -
 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 PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MyODBC and #Delete

2001-01-21 Thread Guy Smith

OS: NT 4.0, SP6
MDAC:   2.6
MyODBC: 2.50.36
MS-Access:  2000 (9.0.3821 SR-1)

MySQL-OS:  Linux, RedHat 6.2
MySql: 3.23.27-beta

Symptom: Two of seven tables return all columns and rows as "#Deleted" (and
wouldn't you know it, the two most important tables in the database).  have
been through the install process several times without a change in symptoms.

Oh, the correct number of rows are returned - the data is just unusable.
Any help is appreciated.


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mm.mysql.jdbc-1.2c and applets

2001-01-17 Thread Guy Payne

Signing the applet will allow the applet to make the connection.  The user
of the applet will have to accept and install the certificate use to sign
the applet.


- Original Message -
From: "Carfield Yim" [EMAIL PROTECTED]
To: "Paulo Mora de Freitas" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 17, 2001 8:35 AM
Subject: Re: mm.mysql.jdbc-1.2c and applets


 Applet don't allow bulid new socket connection, which will do when you
 make a connection from applet to database.
 The solution is writing a servlet to let applet call it.

 On Wed, 17 Jan 2001, Paulo Mora de Freitas wrote:

 
   Dear All,
 
   Could someone help me to access my mysql database from an applet with
  mm.mysql.jdbc-1.2c?
 
   The problem is that when trying to access a mysql database from an
  applet using Netscape it get an AppletSecurityException (described at
  end of this message). But the mm.mysql.jdbc-1.2c documentation says that
  "it allows Java developers to make connections to MySQL servers from
  both Java applications and applets", so I don't understand what is
  wrong. The same piece of code works nice if running as an application.
 
   Cheers, Paulo Mora de Freitas.
 
  Nestacape error message:
 
  netscape.security.AppletSecurityException: security.Couldn't connect to
  'aldebaran.in2p3.fr' with origin from 'local-classpath-classes'.
at
  netscape.security.AppletSecurity.checkConnect(AppletSecurity.java:776)
at java.lang.SecurityManager.checkConnect(SecurityManager.java:718)
at java.net.InetAddress.getAllByName0(InetAddress.java:457)
at java.net.InetAddress.getByName(InetAddress.java:367)
at java.net.Socket.init(Socket.java:123)
  * at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:114)
at org.gjt.mm.mysql.Connection.init(Connection.java:229)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(DriverManager.java:90)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at SimpleApplet.paint(SimpleApplet.java:50)
at java.awt.Component.dispatchEventImpl(Component.java:1734)
at java.awt.Container.dispatchEventImpl(Container.java:946)
at java.awt.Component.dispatchEvent(Component.java:1715)
at
 
java.awt.EventDispatchThread$EventPump.dispatchEvents(EventDispatchThread.ja
va:83)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:135)
at
 
netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(DerivedAppl
etFrame.java:911)
  SQLException: Cannot connect to MySQL server on aldebaran.in2p3.fr:3306.
  Is there a MySQL server running on the machine/port you are trying to
  connect to? (netscape.security.AppletSecurityException)
  SQLState: 08S01
  VendorError:  0
 
 
 


 -
 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 PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php