From: Jim Faucette Date: April 1 1999 12:06am Subject: mysql - ip masking List-Archive: http://lists.mysql.com/mysql/1257 Message-Id: MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="0-1988996564-922925175=:29342" --0-1988996564-922925175=:29342 Content-Type: TEXT/PLAIN; charset=US-ASCII Here's a diff to add ip masking to MySQL's (3.22.20a) user, host, and db tables. This is hot-off-the-keyboard so there hasn't been extensive testing. jim... PS Monty, I believe there's an error in the file at line 699 in the original code. Shouldn't it be wild_one? --0-1988996564-922925175=:29342 Content-Type: TEXT/PLAIN; charset=US-ASCII; name="sql_acl.diff" Content-ID: Content-Description: Content-Disposition: attachment; filename="sql_acl.diff" Content-Transfer-Encoding: BASE64 Mzk5YTQwMCw0NDMNCj4gLy8NCj4gLy8gICBIYW5kbGVzIG1hc2tlZCBJUHMN Cj4gLy8NCj4gDQo+IGNvbnN0IHVpbnQgaXBfbWFza3NbXSA9IHsNCj4gMCww eDAwMDAwMDgwLDB4MDAwMDAwYzAsMHgwMDAwMDBlMCwweDAwMDAwMGYwLDB4 MDAwMDAwZjgsDQo+IDB4MDAwMDAwZmMsMHgwMDAwMDBmZSwweDAwMDAwMGZm LDB4MDAwMDgwZmYsMHgwMDAwYzBmZiwweDAwMDBlMGZmLA0KPiAweDAwMDBm MGZmLDB4MDAwMGY4ZmYsMHgwMDAwZmNmZiwweDAwMDBmZWZmLDB4MDAwMGZm ZmYsMHgwMDgwZmZmZiwNCj4gMHgwMGMwZmZmZiwweDAwZTBmZmZmLDB4MDBm MGZmZmYsMHgwMGY4ZmZmZiwweDAwZmNmZmZmLDB4MDBmZWZmZmYsDQo+IDB4 MDBmZmZmZmYsMHg4MGZmZmZmZiwweGMwZmZmZmZmLDB4ZTBmZmZmZmYsMHhm MGZmZmZmZiwweGY4ZmZmZmZmLA0KPiAweGZjZmZmZmZmLDB4ZmVmZmZmZmYs MHhmZmZmZmZmZn07DQo+IA0KPiBpbnQgaXBfbWFza19jb21wYXJlKGNvbnN0 IGNoYXIgKmlwLCBjb25zdCBjaGFyICp3aWxkKSB7DQo+ICAgY2hhciAqY2gg PSBOVUxMOw0KPiAgIHVpbnQgYml0cywgaXBfdmFsID0gMSwgd2lsZF92YWwg PSAwOw0KPiAgIA0KPiAgIGlmKChjaCA9IHN0cmNocih3aWxkLCAnLycpKSAh PSBOVUxMICYmIA0KPiAgICAgIChiaXRzID0gYXRvaShjaCsxKSkgPiAwICYm IGJpdHMgPCAzMykgew0KPiANCj4gICAgICBjaCA9IChjaGFyICopaXA7DQo+ ICAgICAgaXBfdmFsID0gYXRvaShjaCk7DQo+ICAgICAgaWYoKGNoID0gc3Ry Y2hyKGNoLCAnLicpKSAhPSBOVUxMKQ0KPiAgICAgICAgaXBfdmFsICs9IChh dG9pKCsrY2gpIDw8IDgpOw0KPiAgICAgIGlmKGNoICE9IE5VTEwgJiYgKmNo ICYmIChjaCA9IHN0cmNocihjaCwgJy4nKSkgIT0gTlVMTCkgDQo+ICAgICAg ICBpcF92YWwgKz0gKGF0b2koKytjaCkgPDwgMTYpOw0KPiAgICAgIGlmKGNo ICE9IE5VTEwgJiYgKmNoICYmIChjaCA9IHN0cmNocihjaCwgJy4nKSkgIT0g TlVMTCkgDQo+ICAgICAgICBpcF92YWwgKz0gKGF0b2koKytjaCkgPDwgMjQp Ow0KPiAgICAgIGlwX3ZhbCAmPSBpcF9tYXNrc1tiaXRzLTFdOw0KPiANCj4g ICAgICBjaCA9IChjaGFyICopd2lsZDsNCj4gICAgICB3aWxkX3ZhbCA9IGF0 b2koY2gpOw0KPiAgICAgIGlmKChjaCA9IHN0cmNocihjaCwgJy4nKSkgIT0g TlVMTCkNCj4gICAgICAgIHdpbGRfdmFsICs9IChhdG9pKCsrY2gpIDw8IDgp Ow0KPiAgICAgIGlmKGNoICE9IE5VTEwgJiYgKmNoICYmIChjaCA9IHN0cmNo cihjaCwgJy4nKSkgIT0gTlVMTCkgDQo+ICAgICAgICB3aWxkX3ZhbCArPSAo YXRvaSgrK2NoKSA8PCAxNik7DQo+ICAgICAgaWYoY2ggIT0gTlVMTCAmJiAq Y2ggJiYgKGNoID0gc3RyY2hyKGNoLCAnLicpKSAhPSBOVUxMKSANCj4gICAg ICAgIHdpbGRfdmFsICs9IChhdG9pKCsrY2gpIDw8IDI0KTsNCj4gICAgICB3 aWxkX3ZhbCAmPSBpcF9tYXNrc1tiaXRzLTFdOw0KPiAgIH0NCj4gLy8gIHNx bF9wcmludF9lcnJvcigNCj4gLy8JCSJpcDogJyVzJyAldSAtLSB3aWxkOiAn JXMnICV1IiwgaXAsIGlwX3ZhbCwgd2lsZCwgd2lsZF92YWwpOw0KPiANCj4g ICByZXR1cm4oIChpcF92YWwgPT0gd2lsZF92YWwpID8gMCA6IDEpOw0KPiB9 DQo0MThhNDYzDQo+IA0KNDI2YzQ3MSw0NzINCjwgCSAgKGlwICYmICF3aWxk X2NvbXBhcmUoaXAsYWNsX3VzZXItPmhvc3QpKSkNCi0tLQ0KPiAJICAoaXAg JiYgKCF3aWxkX2NvbXBhcmUoaXAsYWNsX3VzZXItPmhvc3QpIHx8DQo+ICAg ICAgICAgICAgICAgICAgICFpcF9tYXNrX2NvbXBhcmUoaXAsYWNsX3VzZXIt Pmhvc3QpKSkpDQo1OTJjNjM4LDYzOQ0KPCAJICAoaXAgJiYgIXdpbGRfY29t cGFyZShpcCxhY2xfZGItPmhvc3QpKSkNCi0tLQ0KPiAJICAoaXAgJiYgKCF3 aWxkX2NvbXBhcmUoaXAsYWNsX2RiLT5ob3N0KSB8fA0KPiAgICAgICAgICAg ICAgICAgICAhaXBfbWFza19jb21wYXJlKGlwLGFjbF9kYi0+aG9zdCkpKSkN CjYxNmM2NjMsNjY0DQo8IAkoaXAgJiYgIXdpbGRfY29tcGFyZShpcCxhY2xf aG9zdC0+aG9zdCkpKQ0KLS0tDQo+IAkoaXAgJiYgKCF3aWxkX2NvbXBhcmUo aXAsYWNsX2hvc3QtPmhvc3QpIHx8DQo+ICAgICAgICAgICAgICAgICAgICFp cF9tYXNrX2NvbXBhcmUoaXAsYWNsX2hvc3QtPmhvc3QpKSkpDQo2OTljNzQ3 LDc0OA0KPCAJICBzdHJjaHIoYWNsX3VzZXItPmhvc3Qsd2lsZF9tYW55KSkN Ci0tLQ0KPiAJICBzdHJjaHIoYWNsX3VzZXItPmhvc3Qsd2lsZF9vbmUpIHx8 DQo+ICAgICAgICAgICBzdHJjaHIoYWNsX3VzZXItPmhvc3QsICcvJykpDQo3 MzVjNzg0DQo8ICAgICBpZiAoIXdpbGRfY2FzZV9jb21wYXJlKGhvc3QsKmFj bCkpDQotLS0NCj4gICAgIGlmICghd2lsZF9jYXNlX2NvbXBhcmUoaG9zdCwq YWNsKSB8fCAhaXBfbWFza19jb21wYXJlKGhvc3QsKmFjbCkpDQo= --0-1988996564-922925175=:29342--