[strongSwan] Strongswan Manual mysql entries

[Andreas Steffen]

Hello Henry,

here is a short HOWTO giving some information on the manual
configuration of SQL-based connections.

http://wiki.strongswan.org/projects/strongswan/wiki/SqlLite

Regards

Andreas

On 20.12.2010 21:02, Henry R. Prins wrote:
> Does anyone have a how-to on adding connections and PSK’s to the
> Strongswan Database when using SQL?  I see examples like the
> moon.ipsec.sql but it doesn’t explain what it is doing or how it came up
> with the value its entering.
> 
> For Instance:
> 
> * *
> 
> *INSERT**INTO*identities(
> 
> *type*,*data*
> 
> )*VALUES*(//* sun.strongswan.org *//
> 
> 2,*X*'73756e2e7374726f6e677377616e2e6f7267'
> 
> );
> 
>  
> 
> How does it relate with other tables?
> 
>  
> 
> What does 2 stand for ?
> 
>  
> 
> Why does it have to be in hex?
> 
>  
> 
> And I know this is not Strongswan specific, what is an easy way to
> obtain hex from text?

======================================================================
Andreas Steffen                         andreas.steffen at strongswan.org
strongSwan - the Linux VPN Solution!                www.strongswan.org
Institute for Internet Technologies and Applications
University of Applied Sciences Rapperswil
CH-8640 Rapperswil (Switzerland)
===========================================================[ITA-HSR]==