3 # 2. Create table t1 with primary key in mysql. Cache the table in csql.
4 # Check for user authentication:
5 # $ cacheverify [-U username] [-P password] -t t1
7 # a. correct username correct password - should pass
8 # b. correct username wrong password - should return error
9 # c. wrong username correct password - should return error
10 # d. wrong username wrong password - should return error
12 #Run this test only under csql/test or on this directory.
13 #Otherwise, it may fail
15 input
=${PWD}/cache
/CacheVerify
/inputtest4.sql
19 REL_PATH
=${PWD}/cache
/CacheVerify
21 cp $CSQL_CONFIG_FILE /tmp
/csql.conf
22 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
23 echo CACHE_TABLE
=true
>>$CSQL_CONFIG_FILE
24 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
25 DS
="$DSN $DBUSER $PASSWORD"
26 rm -f /tmp
/csql
/csqlds.conf
27 touch /tmp
/csql
/csqlds.conf
28 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
34 isql
$DS < ${REL_PATH}/inputtest4.sql
>/dev
/null
2>&1
40 rm -f /tmp
/csql
/csqltable.conf
41 touch /tmp
/csql
/csqltable.conf
42 #$CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/inputtest4.sql > /dev/null 2>&1
43 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t1
47 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
52 # check with correct username and correct password
53 $CSQL_INSTALL_ROOT/bin
/cacheverify
-U root
-P manager
-t t1
57 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
61 # correct username and wrong password
62 $CSQL_INSTALL_ROOT/bin
/cacheverify
-U root
-P MANAGER
-t t1
> /dev
/null
2>&1
65 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
69 # wrong username and correct password
70 $CSQL_INSTALL_ROOT/bin
/cacheverify
-U ROOT
-P manager
-t t1
> /dev
/null
2>&1
73 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
77 #wrong username and wrong password
78 $CSQL_INSTALL_ROOT/bin
/cacheverify
-U ROOT
-P MANAGER
-t t1
> /dev
/null
2>&1
81 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
85 rm -f /tmp
/csql
/csqltable.conf
86 touch /tmp
/csql
/csqltable.conf
87 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop.sql
> /dev
/null
2>&1
88 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1