void test_mysqld_auth_empty_pw(void) {
const char raw_packet[] =
"&\0\0\1\205\246\3\0\0\0\0\1\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0root\0\0"
;
GString *packet;
network_mysqld_auth_response *auth;
auth = network_mysqld_auth_response_new();
g_string_assign(auth->username, "root");
auth->capabilities =
(CLIENT_LONG_PASSWORD |
CLIENT_LONG_FLAG |
CLIENT_LOCAL_FILES |
CLIENT_PROTOCOL_41 |
CLIENT_INTERACTIVE |
CLIENT_TRANSACTIONS |
CLIENT_SECURE_CONNECTION |
CLIENT_MULTI_STATEMENTS |
CLIENT_MULTI_RESULTS);
auth->max_packet_size = 1 << 24;
auth->charset = 8;
packet = g_string_new(NULL);
network_mysqld_proto_append_int8(packet, 38);
network_mysqld_proto_append_int8(packet, 0);
network_mysqld_proto_append_int8(packet, 0);
network_mysqld_proto_append_int8(packet, 1);
g_assert(0 == network_mysqld_proto_append_auth_response(packet, auth));
#if 0
g_message("%s: packet->len = %d, packet is: %d", G_STRLOC, packet->len, sizeof(raw_packet) - 1);
#endif
g_assert(packet->len == sizeof(raw_packet) - 1);
#if 0
for (i = 0; i < packet->len; i++) {
g_message("%s: [%d] %02x %c= %02x", G_STRLOC, i, packet->str[i], packet->str[i] == raw_packet[i] ? '=' : '!', raw_packet[i]);
}
#endif
g_assert(0 == memcmp(packet->str, raw_packet, sizeof(raw_packet) - 1));
network_mysqld_auth_response_free(auth);
g_string_free(packet, TRUE);
}
void test_mysqld_auth_with_pw(void) {
const char raw_packet[] =
":\0\0\1"
"\205\246\3\0"
"\0\0\0\1"
"\10"
"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"
"root\0"
"\24\241\304\260>\255\1:F,\256\337K\323\340\4\273\354I\256\204"
;
const char raw_challenge[] =
"%@R[SoWC" /* part 1 */
"+L|LG_+R={tV"; /* part 2 */
GString *packet, *challenge, *hashed_password;
network_mysqld_auth_response *auth;
auth = network_mysqld_auth_response_new();
g_string_assign(auth->username, "root");
auth->capabilities =
CLIENT_LONG_PASSWORD |
CLIENT_LONG_FLAG |
CLIENT_LOCAL_FILES |
CLIENT_PROTOCOL_41 |
CLIENT_INTERACTIVE |
CLIENT_TRANSACTIONS |
CLIENT_SECURE_CONNECTION |
CLIENT_MULTI_STATEMENTS |
CLIENT_MULTI_RESULTS;
auth->max_packet_size = 1 << 24;
auth->charset = 8;
challenge = g_string_new(NULL);
hashed_password = g_string_new(NULL);
g_string_append_len(challenge, raw_challenge, sizeof(raw_challenge) - 1);
network_mysqld_proto_password_hash(hashed_password, C("123"));
network_mysqld_proto_password_scramble(auth->response, S(challenge), S(hashed_password));
g_string_free(hashed_password, TRUE);
packet = g_string_new(NULL);
network_mysqld_proto_append_int8(packet, 58);
network_mysqld_proto_append_int8(packet, 0);
network_mysqld_proto_append_int8(packet, 0);
network_mysqld_proto_append_int8(packet, 1);
g_assert(0 == network_mysqld_proto_append_auth_response(packet, auth));
g_assert(packet->len == sizeof(raw_packet) - 1);
#if 0
for (i = 0; i < packet->len; i++) {
g_message("%s: [%d] %02x %c= %02x", G_STRLOC, i, packet->str[i], packet->str[i] == raw_packet[i] ? '=' : '!', raw_packet[i]);
}
#endif
g_assert(0 == memcmp(packet->str, raw_packet, sizeof(raw_packet) - 1));
network_mysqld_auth_response_free(auth);
g_string_free(packet, TRUE);
g_string_free(challenge, TRUE);
}
/**
* decode a packet into proto_field according to field->fielddef->type
*
* @param field field definition
* @returns 0 on success, -1 on error
*/
int network_mysqld_proto_append_myisam_field(GString *packet,
network_mysqld_myisam_field *field) {
guint64 length;
guint8 i8;
guint16 i16;
guint32 i32;
guint64 i64;
double d;
network_mysqld_column *column = field->column;
int err = 0;
switch ((guchar)column->type) {
case MYSQL_TYPE_TIMESTAMP: /* int4store */
case MYSQL_TYPE_LONG:
network_mysqld_proto_append_int32(packet, field->data.i);
break;
case MYSQL_TYPE_DATETIME: /* int8store */
case MYSQL_TYPE_LONGLONG:
network_mysqld_proto_append_int64(packet, field->data.i);
break;
case MYSQL_TYPE_INT24:
case MYSQL_TYPE_DATE: /* int3store, a newdate, old-data is 4 byte */
network_mysqld_proto_append_int24(packet, field->data.i);
break;
case MYSQL_TYPE_SHORT:
network_mysqld_proto_append_int16(packet, field->data.i);
break;
case MYSQL_TYPE_TINY:
network_mysqld_proto_append_int8(packet, field->data.i);
break;
case MYSQL_TYPE_ENUM:
switch (column->max_length) {
case 1:
network_mysqld_proto_append_int8(packet, field->data.i);
break;
case 2:
network_mysqld_proto_append_int16(packet, field->data.i);
break;
default:
g_error("%s: enum-length = %lu",
G_STRLOC,
column->max_length);
break;
}
break;
#if 0
case MYSQL_TYPE_BLOB:
switch (column->max_length) {
case 1:
err = err || network_mysqld_proto_get_int8(packet, &i8);
if (!err) length = i8;
break;
case 2:
err = err || network_mysqld_proto_get_int16(packet, &i16);
if (!err) length = i16;
break;
case 3:
err = err || network_mysqld_proto_get_int24(packet, &i32);
if (!err) length = i32;
break;
case 4:
err = err || network_mysqld_proto_get_int32(packet, &i32);
if (!err) length = i32;
break;
default:
/* unknown blob-length */
g_debug_hexdump(G_STRLOC, S(packet->data));
g_error("%s: blob-length = %lu",
G_STRLOC,
column->max_length);
break;
}
err = err || network_mysqld_proto_get_string_len(packet, &field->data.s, length);
break;
#endif
case MYSQL_TYPE_VARCHAR:
case MYSQL_TYPE_VAR_STRING:
case MYSQL_TYPE_STRING:
if (column->max_length < 256) {
network_mysqld_proto_append_int8(packet, strlen(field->data.s));
g_string_append_len(packet, field->data.s, strlen(field->data.s));
} else {
network_mysqld_proto_append_int16(packet, strlen(field->data.s));
g_string_append_len(packet, field->data.s, strlen(field->data.s));
}
break;
#if 0
case MYSQL_TYPE_NEWDECIMAL: {
/* the decimal is binary encoded
*/
guchar digits_per_bytes[] = { 0, 1, 1, 2, 2, 3, 3, 4, 4, 4 }; /* how many bytes are needed to store x decimal digits */
guint i_digits = column->max_length - column->decimals;
guint f_digits = column->decimals;
guint decimal_full_blocks = i_digits / 9; /* 9 decimal digits in 4 bytes */
guint decimal_last_block_digits = i_digits % 9; /* how many digits are left ? */
guint scale_full_blocks = f_digits / 9; /* 9 decimal digits in 4 bytes */
guint scale_last_block_digits = f_digits % 9; /* how many digits are left ? */
guint size = 0;
size += decimal_full_blocks * digits_per_bytes[9] + digits_per_bytes[decimal_last_block_digits];
size += scale_full_blocks * digits_per_bytes[9] + digits_per_bytes[scale_last_block_digits];
#if 0
g_debug_hexdump(G_STRLOC " (NEWDECIMAL)", packet->data->str, packet->data->len);
#endif
#if 0
g_critical("%s: don't know how to decode NEWDECIMAL(%lu, %u) at offset %u (%d)",
G_STRLOC,
column->max_length,
column->decimals,
packet->offset,
size
);
#endif
err = err || network_mysqld_proto_skip(packet, size);
break; }
#endif
default:
g_error("%s: unknown field-type to write: %d",
G_STRLOC,
column->type);
break;
}
return err ? -1 : 0;
}
