SSL certs from MYSQL

[XanderXander]

I love OpenLiteSpeed and plan to use it in future and now I'm faced with a big problem, is it possible to manage SSL for virtual hosts not from separate files but from one database? And also how to manage "home dir" for vhosts from MYSQL too? is it possible here?

Thanks in advance

Regards,
Alex

 

[Cold-Egg]

Hi,
It's probably out of my knowledge. Could you share some examples of how to manage SSL from a database? And how is vhosts can be handled by MYSQL?

 

[XanderXander]

Hello! In Lighttpd its very easy create mysql vhost and get homedir location from there
https://redmine.lighttpd.net/projects/lighttpd/wiki/Mod_vhostdb

As for SSL records from MySQL I did not found it elsewhere and it will be brilliant to realize it in Openlitespeed

 

[XanderXander]

server app just make a lookup through database:
SELECT `docroot`, `ssl_key_path`, `ssl_crt_path` WHERE domain='domain.com'

 

[Cold-Egg]

No, I don't think OLS supports mod_vhostdb module and create mysql vhost method.
To create vhost for OLS, you can configure it via web admin, SSH console, or script.

 

[nongdan9x]

For managing SSL with OpenLiteSpeed, you can set it up to use a database by configuring the server to pull SSL info from MySQL, but it might take some custom scripting. As for the home directory, you could store paths in the database and use a similar approach to dynamically set them in your vhost configs.

 

[XanderXander]

For managing SSL with OpenLiteSpeed, you can set it up to use a database by configuring the server to pull SSL info from MySQL, but it might take some custom scripting. As for the home directory, you could store paths in the database and use a similar approach to dynamically set them in your vhost configs.

Hello! It should be good with LUA scripting. Or may be you already have a solution with small code for that?