Updates

Dear blog,

There is so many things that I wanted to write about but...

There is so many things that I wanted to talk about but...

There is so many things that I wanted to update but...

There is so many things that I wanted to let it out but...

BUT.. I am too busy, stressful and don't have much time to write..

So that's all that I can write for today after a few months.. at least you know that I have so many things to talk about..

Till then ...

ClearBox Connection to SQL Database

In previous section, I mentioned that I was not able to link it to SQL. But now, I am able to do so,

The problem lies in a few settings that you need to set before it could work with SQL.

Adding the SQL data source and creating a new realm with SQL queries is not enough to make it work with SQL. I've attached several screenshots below showing the settings that you need to set assuming that you have set the correct data source:


For testing purposes, I did login using a username and password that is stored is SQL. The authentication is successful. You won't be able to test authentication from SQL using client tool because it will keep on showing "connection error to host". So, you need to do it on the actual equipment and make use of online logging tool to know the settings that you need to set if there is an error.

I hope my simple guide would be something useful to you if you are using SQL database. I've spent about 1 - 2 months trying to connect clearbox to terminal server and SQL.

Finally, under the server setting, do check the box for unspecified mandatory/optional field. I don't know why. But, only if you check these 2 field, you will be able to authenticate using clearBox users or any other data source users.

SQL queries

Ok so, now I am having problem with configuring SQL queries and using clearBox client tool.

first, let me show you the succesfull authentcation from clearBox clint tool using users that I've created from ClearBox server itself.


The status will change to 'FAILED' if I key in users that are not created in ClearBox.

The same method is used to authenticate users that are created from external SQL server except that you need to key some queries in in the setting as shown below.


Here are the queries that I've tried so far :

SELECT password FROM Users WHERE username= $u ;

SELECT password FROM Users WHERE username= '".$u."'"

SELECT password FROM Users WHERE username= $u

SELECT password FROM Users WHERE username='%$u%';

"SELECT password FROM Users WHERE username ='$u'"

$sql = "SELECT password FROM Users WHERE username = '$u'";

SELECT password FROM Users WHERE username LIKE '$u' ;

SELECT password FROM Users WHERE username LIKE '%u%';

But, none of them work so far. From the response packet, it keep on displaying no such user. In case you are wondering whether the SQL server is connected to my AAA server or not, the screenshot is as shown below to prove you that it is connected.


And below is a screenshot of my database table which contain 2 variables only currently.


So, please do assist me in configuring the query as I have no SQL background at all. But, I'm learning it slowly.

Thanks in advance