well its not that spectacular but for me it couldn’t be better:

In my Application which i’m developing over a year now i need to access the radius database for user modifications. say simple: in my app i want to control who can access the internet.
I opend the database port 3306 by uncommenting the bindto=127.0.0.1 in /etc/mysql/my.cnf or similar, which is not very clean. A xml connection for simple crud would be better but i am under time pressure ….
With hibernate i was able to connect to the radius db besides the app database by defining another “dataSource” like this:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">


 <property name="driverClassName" value="@DB-DRIVERNAME@"/>

 <property name="url" value="@DB-URL@"/>

 <property name="username" value="@DB-USERNAME@"/>

 <property name="password" value="@DB-PASSWORD@"/>

 <property name="maxActive" value="100"/>

 <property name="maxIdle" value="30"/>

 <property name="maxWait" value="1000"/>

 <property name="defaultAutoCommit" value="true"/>

 <property name="removeAbandoned" value="true"/>

 <property name="removeAbandonedTimeout" value="60"/>

</bean>
<bean id="dataSourceRadius" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">


 <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

 <property name="url" value="jdbc:mysql://x.x.x.x/radius?zeroDateTimeBehavior=convertToNull"/>

 <property name="username" value="radius"/>

 <property name="password" value="somepwd"/>

 <property name="maxActive" value="100"/>

 <property name="maxIdle" value="30"/>

 <property name="maxWait" value="1000"/>

 <property name="defaultAutoCommit" value="true"/>

 <property name="removeAbandoned" value="true"/>

 <property name="removeAbandonedTimeout" value="60"/>

</bean>

i tried to modify the hotspotlogin.cgi perl script but i’m not really getting it. AND what i hate the most of all is that html code is printed line by line, in my eyes that is sooo messy … i heared that other login pages are out there so i have to study them today. I also want to control the logout process from my app, this is a little bit tricky too i need to access the adress http://10.1.0.1:3990/logoff but with this addy i can’t say which user to log off …