int main(int argc, char *argv[])
{
TestConnections * Test = new TestConnections(argc, argv);
Test->set_timeout(30);
Test->check_log_err((char *) "Unexpected parameter 'укпоукц'", true);
Test->check_log_err((char *) "Unexpected parameter 'hren'", true);
Test->check_maxscale_processes(0);
int rval = Test->global_result;
delete Test;
return rval;
}
int main(int argc, char *argv[])
{
TestConnections * Test = new TestConnections(argc, argv);
Test->set_timeout(100);
Test->execute_maxadmin_command((char *) "show monitors");
sleep(5);
Test->check_log_err((char *) "Failed to start monitor", true);
Test->check_log_err((char *) "fatal signal 11", false);
Test->check_maxscale_processes(1);
int rval = Test->global_result;
delete Test;
return rval;
}
int main(int argc, char *argv[])
{
TestConnections *test = new TestConnections(argc, argv);
Config config(test);
config.create_all_listeners();
config.create_all_listeners();
test->check_maxscale_processes(1);
config.create_monitor("mysql-monitor", "mysqlmon", 500);
config.reset();
sleep(1);
test->check_maxscale_alive();
int rval = test->global_result;
delete test;
return rval;
}
int main(int argc, char *argv[])
{
TestConnections::skip_maxscale_start(true);
TestConnections * Test = new TestConnections(argc, argv);
int local_result;
char str[4096];
char sql[4096];
char pass_file[4096];
char deny_file[4096];
char rules_dir[4096];
FILE* file;
sprintf(rules_dir, "%s/fw/", test_dir);
int N = 10;
int i;
for (i = 1; i < N + 1; i++)
{
Test->set_timeout(180);
local_result = 0;
Test->stop_maxscale();
sprintf(str, "rules%d", i);
copy_rules(Test, str, rules_dir);
Test->start_maxscale();
Test->connect_rwsplit();
sprintf(pass_file, "%s/fw/pass%d", test_dir, i);
sprintf(deny_file, "%s/fw/deny%d", test_dir, i);
Test->tprintf("Pass file: %s\n", pass_file);
Test->tprintf("Deny file: %s\n", deny_file);
file = fopen(pass_file, "r");
if (file != NULL)
{
Test->tprintf("********** Trying queries that should be OK ********** \n");
while (fgets(sql, sizeof(sql), file))
{
if (strlen(sql) > 1)
{
Test->tprintf("%s", sql);
local_result += execute_query(Test->conn_rwsplit, sql);
}
}
fclose(file);
}
else
{
Test->add_result(1, "Error opening query file\n");
}
file = fopen(deny_file, "r");
if (file != NULL)
{
Test->tprintf("********** Trying queries that should FAIL ********** \n");
while (fgets(sql, sizeof(sql), file))
{
Test->set_timeout(180);
if (strlen(sql) > 1)
{
Test->tprintf("%s", sql);
execute_query(Test->conn_rwsplit, sql);
if (mysql_errno(Test->conn_rwsplit) != 1141)
{
Test->tprintf("Query succeded, but fail expected, errono is %d\n", mysql_errno(Test->conn_rwsplit));
local_result++;
}
}
}
fclose(file);
}
else
{
Test->add_result(1, "Error opening query file\n");
}
if (local_result != 0)
{
Test->add_result(1, "********** rules%d test FAILED\n", i);
}
else
{
Test->tprintf("********** rules%d test PASSED\n", i);
}
mysql_close(Test->conn_rwsplit);
}
Test->set_timeout(180);
Test->stop_maxscale();
// Test for at_times clause
Test->tprintf("Trying at_times clause\n");
copy_rules(Test, (char *) "rules_at_time", rules_dir);
Test->tprintf("DELETE quries without WHERE clause will be blocked during next 2 minutes\n");
Test->tprintf("Put time to rules.txt: %s\n", str);
Test->ssh_maxscale(false, "start_time=`date +%%T`; stop_time=` date --date "
"\"now +2 mins\" +%%T`; %s sed -i \"s/###time###/$start_time-$stop_time/\" %s/rules/rules.txt",
Test->maxscale_access_sudo, Test->maxscale_access_homedir);
Test->start_maxscale();
Test->connect_rwsplit();
Test->tprintf("Trying 'DELETE FROM t1' and expecting FAILURE\n");
execute_query(Test->conn_rwsplit, "DELETE FROM t1");
if (mysql_errno(Test->conn_rwsplit) != 1141)
{
Test->add_result(1, "Query succeded, but fail expected, errono is %d\n", mysql_errno(Test->conn_rwsplit));
}
Test->tprintf("Waiting 3 minutes and trying 'DELETE FROM t1', expecting OK\n");
Test->stop_timeout();
sleep(180);
Test->set_timeout(180);
Test->try_query(Test->conn_rwsplit, "DELETE FROM t1");
mysql_close(Test->conn_rwsplit);
Test->stop_maxscale();
Test->tprintf("Trying limit_queries clause\n");
Test->tprintf("Copying rules to Maxscale machine: %s\n", str);
copy_rules(Test, (char *) "rules_limit_queries", rules_dir);
Test->start_maxscale();
Test->connect_rwsplit();
printf("Trying 10 quries as fast as possible\n");
for (i = 0; i < 10; i++)
{
Test->add_result(execute_query(Test->conn_rwsplit, "SELECT * FROM t1"), "%d -query failed\n", i);
}
Test->tprintf("Expecting failures during next 5 seconds\n");
time_t start_time_clock = time(NULL);
timeval t1, t2;
double elapsedTime;
gettimeofday(&t1, NULL);
do
{
gettimeofday(&t2, NULL);
elapsedTime = (t2.tv_sec - t1.tv_sec);
elapsedTime += (double) (t2.tv_usec - t1.tv_usec) / 1000000.0;
}
while ((execute_query_silent(Test->conn_rwsplit, "SELECT * FROM t1") != 0) && (elapsedTime < 10));
Test->tprintf("Quries were blocked during %f (using clock_gettime())\n", elapsedTime);
Test->tprintf("Quries were blocked during %lu (using time())\n", time(NULL) - start_time_clock);
if ((elapsedTime > 6) or (elapsedTime < 4))
{
Test->add_result(1, "Queries were blocked during wrong time\n");
}
Test->set_timeout(180);
printf("Trying 20 quries, 1 query / second\n");
for (i = 0; i < 20; i++)
{
sleep(1);
Test->add_result(execute_query(Test->conn_rwsplit, "SELECT * FROM t1"), "query failed\n");
Test->tprintf("%d ", i);
}
Test->tprintf("\n");
Test->set_timeout(180);
Test->tprintf("Stopping Maxscale\n");
Test->stop_maxscale();
Test->tprintf("Trying rules with syntax error\n");
Test->tprintf("Copying rules to Maxscale machine: %s\n", str);
copy_rules(Test, (char *) "rules_syntax_error", rules_dir);
Test->tprintf("Starting Maxscale\n");
Test->start_maxscale();
Test->connect_rwsplit();
Test->tprintf("Trying to connectt to Maxscale when 'rules' has syntax error, expecting failures\n");
if (execute_query(Test->conn_rwsplit, "SELECT * FROM t1") == 0)
{
Test->add_result(1, "Rule has syntax error, but query OK\n");
}
Test->check_maxscale_processes(0);
int rval = Test->global_result;
delete Test;
return rval;
}
