Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root and no password
But if I set a password on root or create a user with a password odbc fails
with
Client does not support authentication protocol requested by the server -
consider upgrading
Oh, and one other thing, you have to create the passwords AFTER you use
the switch! That was probably obvious to you but it took me a while to
figure out.
Randy
Randy Chrismon wrote:
Ken Brown wrote:
Just installed 4.1.1 on windows 2000 with current odbc layer
Connects fine with root
Here're a couple of tables:
create table company(CompanyID varchar(32),...);
create table contact(CompanyId varchar(32),...
INDEX (CompanyID),
FOREIGN KEY (CompanyID) REFERENCES company(CompanyID);
Now, my expectation is that if contact has a CompanyID but it does
not
match one already
If you run the app again, does it give errors on the same record again?
If you move the record in question up or down in the sequence of
inserts, does it still give errors on that record?
Don't know about the commit. I have set autocommit to 250 but that is
connection by connection and I'm using
I have an application that updated or inserted 26,000 records into a
MySQL INNODB table in about 12 minutes... A creditable performance as
far as I am concerned. However, the application failed on one of the
last insert/updates with a lock wait timeout. My script issues a
commit every 250
Well now, this is interesting. The agent mentione previously ran
flawlessly for a couple of weeks. The day I left for Christmas
vacation, I started getting the lock wait timeout error. The
difference? I altered the table to include a foreign key constraint.
Not sure how this could possibly be the
This isn't going to be a very good question because I don't really
understand what I'm being asked... I have an invoicing database with two
tables: An invoice header table; and a line items table. The line items
table includes a column for the foreign key to the invoice header, a
column for
First, is there a separate mailing list for MyODBC issues?
I have Lotus Script code that uses odbc in an attempt to write data
to
a MySQL table. I can't get even the very first record inserted
because
I consistently get the following error:
Field mapping failed due to a missing field,
Not sure if this is a MyODBC error or one in my code. I have code
that
inserts/updates records based on information from Lotus Notes
documents. The columns to be inserted/updated are defined statically
in the code so there's no way it's changing from one document to the
next. As the code runs, it
Kim G. Pedersen wrote:
BUT
just a little hint , u sure it not ur _ (underscore) in table name which
is a kind of wildcard that give u trouble ??
This raises an interesting question. I wrote earlier about troubles with
mismatch field count and missing field errors. I have both tables and
Randy Chrismon wrote:
Kim G. Pedersen wrote:
BUT
just a little hint , u sure it not ur _ (underscore) in table name
which
is a kind of wildcard that give u trouble ??
This raises an interesting question. I wrote earlier about troubles
with mismatch field count and missing field errors. I
I'm stumped...
I have a pretty standard invoice system:
create table invoice(
InvoiceNum varhcar(16),
ClientInfo
)
create table line_items(
InvoiceNum varchar(16),
ProductCode varchar(10),
Description varchar(25),
Quantity .
)
Three is, of course, a one-to-many relation
I'm stumped...
Now, I need to generate reports for a specific client. In the end,
for
a given month, I have to tell the client
1. Which invoices were for the purchase of blue widgets, only.
2. Which invoices were for the purchase of blue widgets and yellow
widgets, together.
3. Which invoices
My old Micro-Economics professor must be chortling in his grave...
The bosses told me a few minutes ago to quit pusing MySQL for an
internal project and to move my proof-of-concept tables from MySQL
running on a Linux desktop with 512mb of ram and the bloody DB on an
external USB to a DB2
I have a table wherein one column is SUPPOSED to be unique but I
strongly suspect isn't. Because I had this suspicion, I did not apply
a unique index to the column. Assuming there are no null values in
that column how would I find the instances of non-unique values? If I
try to alter table add
Please tell me it ain't so...
I am writing a Lotus Nots agent to feed data directly into a MySQL
table. The agent needs to either insert a new record or update an
existing record depending on whether a document in Nots is new or
updated. Because this app may be ported over to a DB2 server, I am
I have the complete Red Hat 9 rpm database installed but I guess I just
don't know how to query it. What provides libcrypto and libssl?
Particularly the versions required by MySQL (libcrypto.0.9.6 and
libssl.0.9.6)? I have both files on my system but they are version
0.9.7. and MySQL doesn't
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one comes from?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Jeremy Zawodny wrote:
On Wed, Oct 15, 2003 at 10:46:59PM -0400, Randy Chrismon wrote:
I'm trying to upgrade my KDE setup but it fails on a dependency for
libmysqlclient.so. I've looked at all the MySQL rpm files and none of
them seem to provide this file. Does anyone know where this one
Splain this to me: I use my laptop to connect to the test-bed MySQL
server residing on my desktop. Using this connection, I can do
anything: load 200K lines, do complex (for me) queries, whatever.
But,
open a MySQL console connection _on the desktop_ where the MySQL
server lives, I can't do a
Dathan Vance Pattishall wrote:
Look at your wait_timeout and interactive_timeout settings. They may be
set to a low value. If your connection sleeps for these 2 vars mysql
will disconnect you.
- Dathan Vance Pattishall
--Subject: Connection Time Out
--
--
--Splain this to me: I use my laptop
I'm not clear on this. What happens to duplicates under the following
scenario?
MyISAM table with either (or both!) a primary key or a unique index.
Alter table my_table disable keys.
Import 200K records.
Alter table my_table enable keys.
But it turns out there are duplicate records. Does MySQL
[EMAIL PROTECTED] wrote:
how to delete rows which table1.field=table2.field
thanks
delete t1 from t1,t2 where t1.field=t2.field
at least, that's how I read the manual. Works for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
This may be a Linux/Redhat question instead of MySQL -- I just
installed MySQL 4.0.15 on my RedHat 9 box. Runs fine but there's only
6 Gigs free on the drive. So, I have a new 60 gig drive I can use. My
question is can I mount the drive temporarily some place, copy the
entire contents of
Tried to do a load of data from a file in my home directory on Linux.
Got this message:
ERROR 13: Can't get stat of
'/home/rchrismon/mysql/ArchiveEC02-Invoices.txt' (Errcode: 13)
What does this mean and what can I do about it?
Thanks
Randy
--
MySQL General Mailing List
For list archives:
As I read the documentation, ALTER TABLE my_table DISABLE KEYS only
works on MyIsam tables. When I run the command against an InnoDB
database, however, I get no indication of a problem. I get the usual
Query OK message. So, can I temporarily disable keys on an InnoDB
database (say while doing a
I've been searching the Lotus site and have gotten kind of lost. Does
anybody have any experience using Lotus Notes as a front end to a MySQL
database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I
barking up the wrong tree?
Thanks.
Randy
--
MySQL General Mailing List
For list
I installed 4.1.0 alpha from the RPMS on Redhat 9. I had to use
--force (or is it --nodeps, I can never remember) because MySQL wants
libcrypto and libssl 0.9.6 and Redhat 9 has 0.9.7. First question
(coming from that other world) why aren't these dependencies 0.9.6,
or
greater, instead of being
Apologies for the length of this post.
We started off this little proof of concept project using MySQL
InnoDB
tables, in part because we figured we needed foreign key constraints,
row locking, and all the other bells and whistles that one gets with
DB2 (our production DB on a big - for us -
Does anyone have a recommendation for a good SQL cookbook? I can do
some basic selects, updates and deletes but I'm not comfortable with
some of the logic involved in joins or the proper use of group by,
etc. In addition, though a full exposition on the SQL language
might
be instructive, right
I need to know which id is not present in the other table.
Stefan:
A left join should do it:
select t1.id from t1 left join t2 on t1.id=t2.id where t2.id is null
I learned this from this mailing list about two weeks ago.
HTH.
Randy
--
MySQL General Mailing List
For list archives:
Do you use password when you connect to the local 4.1 MySQL server?
Yes. No password, no entry.
This is the answer why you can connect to the local 4.1 MySQL server with MySQLCC. Set up a password and you should get Client does not support .. error, too.
I guess I didn't make myself clear... I DO
Response should have been to problem connecting to 4.1.0
Sorry about that.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Don't think this is the issue. If it were, I wouldn't be able to use
MySQLCC on my own local database which is also 4.1.0 alpha, would I?
Do you use password when you connect to the local 4.1 MySQL server?
Yes. No password, no entry.
Can you connect without --protocol option using 4.1 mysql
Try taking out the identifier name for the primary key (pk_foo). The
way I read the documentation, MySQL does not support identifiers or
names for primary keys although it does for other index types.
HTH
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
This irritating rather than life-threatening: I can connect to the
MySQL database on my Linux box, from my Win2K box, using the command
line environment just fine:
c:mysql --protocol=TCP -h host_name -u my_name -p mysql
No matter what I try, however, I can't connect using MySQLCC. I
always
get
Victoria Reznichenko wrote:
MySQL 4.1 provides new password hashing mechanism. This error appears if you connect
with pre-4.1 client to the server 4.1. ook at:
http://www.mysql.com/doc/en/Password_hashing.html
In the above section of the manual you can find description of possible
I just ran the following on a table with ln_cash having about 190,000
records and cash_exceptions having about 6,000:
mysql delete ln_cash from ln_cash,cash_exceptions where
ln_cash.docunid=cash_exceptions.docunid;
Query OK, 6103 rows affected (3 min 10.21 sec)
Both tables have unique indexes
I'm using InnoDB tables and created a new one with an autoincrement
field to use for a primary key. These tables are being loaded from
text files that I create out of another database system (Lotus
Notes).
My question is what must I do in the text file structure to account
for the autoincrement
Please tell me it ain't so! My test user is using MyOBDC to connect
to
our 4.1.0 alpha server. She will be creating some Crystal Reports
from
the data. Her test DSN fails on an incompatible protocol error with a
message that she should upgrade to the newest client. Do I have to
download bitkeeper,
Seems to be a problem with the fact that the server is on a Linux
box.
I was having this problem connecting the mysql command environment to
the linux server until I added -protocol=TCP to the login statement.
Or maybe it's just that we use a TCP/IP network (doesn't everybody?).
Anyway, my test
I just loaded about 125,000 records, each containing about 30 columns
into an empty, newly created, mysql table. It took 56 minutes. Isn't
that a little long?
The table design was driven, in part, by an existing reporting
application. The data to populate the table is being exported from
Lotus
For LOAD DATA, it works better in 4.1.1, as indicated here:
I read that and immediately went looking on the MySQL site for 4.1.1.
All I can find is 4.1.0-alpha. Where can I get 4.1.1?
Thanks.
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Here's a snapshot from a mysql environment:
mysql LOAD DATA LOCAL INFILE 'c:/mysql/miamibilling-Cash.txt'
- REPLACE INTO TABLE ln_cash
- FIELDS TERMINATED BY '|'
- ENCLOSED BY '~'
- LINES TERMINATED BY '\r\n'
- ;
Query OK, 16374 rows affected (20.83 sec)
Records:
Egor Egorof said:
If I've got you right, you get Lost connection error when foreign
key constraints is turn on?
Could you provide your table structure and some data for testing?
Well, I designed the table with a foreign key constraint, then I
disabled keys, tried to LOAD and got the lost
I have several machines and wander from office to office as part of
the job. As I read the MySQL docs, I have two choices for granting
privileges:
grant ... to randy@'%'
or
grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the folks around here. The
second
form is too
All this discussion about the definition of NULL and its use in
database querying has been most interesting and enlightening. I
hadn't realized I was asking such a deep question. Unfortunately, I'm
still at the stage of designing tables where I KNOW I will be loading
thousands of records that,
I read the MysQL documentation re the Server Gone Away error but
nothing there applied to my situation. On a whim, I re-created the
table I was trying to import into but without the foreign key
constraint (I had only disabled the foreign key constraint in the
previous failed efforts). This time it
The MySQL documentation confuses me a bit. If I create a table with
property NOT NULL and default , does that mean that a record with a
column so defined will have a zero-length string in that column if I
don't provide a value? I guess what I'm asking is whether there's a
difference between a
Null is a special value and cannot be tested in the same manner as a
string
or other value. Yes, there is a difference. If the column is Null, a
comparison operation such as a.field == or a.field ==
something will
both return Null.
Maybe this document will help:
A.5.3 Problems with
Has anyone every connected Lotus Notes/Script to MySQL?
I'm not sure what you mean. Just five minutes ago, I finished writing
a LotusScript agent that exports Notes data to a text file. I then
used LOAD to bring that data into a MySQL table. Both Lotus/Notes and
MySQL have obdc drivers but I
I've tried this several times:
mysql source c:/mysql/import_cash.sql
with this error:
ERROR 2013: Lost connection to MySQL server during query
from the commandline, using:
C:\mysql -u myname -pmy_password my_database
c:/mysql/import_cash.sql
I get the same error. This happens immediately, so
52 matches
Mail list logo