Unable to GRANT REPLICATION REQUIRE X509 and SSL

2006-11-30 Thread Amit Dor-Shifer
Is it possible to require both secure connections and x509 verification on a replication user? If so, what's the syntax? I couldn't find references to this use in the manual, lists or bug tracking system. Using mysql 4.1.21 10x, Amit -- MySQL General Mailing List For list archives: http://lists.m

using SSL certificates when connecting to mysqld

2006-11-29 Thread Amit Dor-Shifer
Hi. mysql --version mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using readline 5.1 I'm trying to secure a replication connection between a master and a slave. However, seems to me that the issue I'm facing relates to any SSL client<->server connection, so the scenario I'll be specifyi

Logging aborted_connects to error log instead of gen. log

2006-11-29 Thread Amit Dor-Shifer
It is noted in http://dev.mysql.com/doc/refman/4.1/en/communication-errors.html: The server increments the |Aborted_connects| status variable when the following things happen: * A client doesn't have privileges to connect to a database. * A client uses an incorrect password

How to calculate max number of rows in a MyISAM table (default MAX_ROWS) ?

2006-11-28 Thread Amit Dor-Shifer
Hi. I've created the following table, with default value for MAX_ROWS. As the following shows, it has a max. size of 4G. I'm wondering: Is the expected max number of rows in this table = Max_data_length \ Avg_row_length? If not, what might it be? How do I calculate it? mysql> show table status fro

bind-address: settable via /etc/mysql/my.cnf only?

2006-11-26 Thread Amit Dor-Shifer
Hi, I tried setting 'bind-address' as an option from ~/.my.cnf: (amit0:~) # cat ~/.my.cnf [mysqld] bind-address 127.0.0.1 (amit0:~) # mysqld 061126 16:08:54 [ERROR] mysqld: unknown option '--bind-address 127.0.0.1' 1. Is 'bind-address' then not an 'option'? 2. As 'bind-address' IS settable

Replication error: Unable to get certificate

2006-11-23 Thread Amit Dor-Shifer
Hi I've followed the replication procedure, as instructed on the online manual. I want to use replication over SSL. I've followed this procedure to create test SSL certificates, keys, etc. http://dev.mysql.com/doc/refman/4.1/en/secure-create-certs.html On slave machine: mysql> show slave statu

Re: AUTOCOMMIT. displaying and setting

2006-11-21 Thread Amit Dor-Shifer
check with 2 connections; try inserting or updating in one connection; > check > in the other with select. > > This variable was added in MySQL 4.1.2. > > > - Original Message - From: "Amit Dor-Shifer" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, No