[OpenSIPS-Users] TLS_MGM module with DB(MYSQL)

[Callum Guy]

You need to insert the certificate contents into the table rather than a
file, to my understanding - you'd probably want to convert the certs to PEM
format prior to doing this.





On Tue, 25 May 2021 at 14:20, Saurabh Chopra <saurabhc at 3clogic.com> wrote:

> Hi Opensips Team/Razvan,
>
> I am using the TLS_MGM module to validate my certificate file through a
> database (mysql) but getting the below error.
>
> May 25 12:41:28 ip-20-0-36-64 /usr/local/sbin/opensips[16297]:
> NOTICE:tls_mgm:init_tls_dom: no crl for tls, using none
> May 25 12:41:28 ip-20-0-36-64 /usr/local/sbin/opensips[16297]: *ERROR:tls_mgm:load_certificate_db:
> Unable to load certificate from buffer*
> May 25 12:41:28 ip-20-0-36-64 /usr/local/sbin/opensips[16297]:
> WARNING:tls_mgm:init_tls_domains: Failed to init TLS domain 'default',
> skipping...
>
> The data i have put in DB is depicted below:-
>
> insert into tls_mgm
> (id,domain,match_ip_address,match_sip_domain,type,method,verify_cert,require_cert,certificate,private_key,crl_check_all,crl_dir,ca_list,ca_dir,
> cipher_list,dh_params,ec_curve) values
> ('1','default','20.0.xx.xx:443','','1','SSLv23','1','0','xxxx2021.der','xxxx.der','0','','xxxxx2021.der','','ALL','','');
>
> *.der* files are the binary file for certificate file, private key file
> and ca_list .  However the same is working fine through the configuration
> script.
>
> Can anybody confirm what I am doing wrong ?
>
>
> Best Regards
> Saurabh Chopra
> +918861979979
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-- 





*0333 332 0000  |  x-on.co.uk <https://www.x-on.co.uk>  |   ** 
<https://www.linkedin.com/company/x-on>   <https://www.facebook.com/XonTel> 
  <https://twitter.com/xonuk> **  |  Coronavirus 
<https://www.x-on.co.uk/service/surgery-connect/coronavirus.htm>**  |  
Practice Index Reviews <https://practiceindex.co.uk/gp/x-on>*


THE ITSPA 
AWARDS 2020 <http://www.itspa.org.uk/itspa-awards> AND Best ITSP - Mid 
Market, Best Software and Best Vertical Solution are trade marks of the 
Internet Telephony Services Providers' Association, used under licence.

*Our new office address: 22 Riduna Park, Melton IP12 1QT.*

X-on
is a 
trading name of Storacall Technology Ltd a limited company registered in
England and Wales.

Registered Office : Avaland House, 110 London Road, 
Apsley, Hemel Hempstead,
Herts, HP3 9SD. Company Registration No. 2578478.

The information in this e-mail is confidential and for use by the 
addressee(s)
only. If you are not the intended recipient, please notify 
X-on immediately on +44(0)333 332 0000 and delete the
message from your 
computer. If you are not a named addressee you must not use,
disclose, 
disseminate, distribute, copy, print or reply to this email. Views
or 
opinions expressed by an individual
within this email may not necessarily
reflect the views of X-on or its associated companies. Although X-on 
routinely
screens for viruses, addressees should scan this email and any 
attachments
for
viruses. X-on makes no representation or warranty as to the 
absence of viruses
in this email or any attachments.










-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20210526/b8dbdfc2/attachment-0001.html>