Reading/Parsing a CRL with OpenSSL
Below command used to parse and give you a list of revoked serial numbers: openssl crl -inform DER -text -noout -in mycrl.crl Most CRLs are DER encoded, but you can use -inform PEM if your CRL is not binary. If…
MariaDB SSL CRL testing issue ?!
[usr@hostname pki]# openssl crl -inform DER -text -noout -in DBversity_Internal_DeviceCA_CRL.crl | grep -A1 ‘XXXXXXXXXXXXXX’ Serial Number: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Revocation Date: Dec 6 08:46:28 2016 GMT [usr@hostname pki]# [usr@hostname pki]# [usr@hostname pki]# date Fri Dec 9 06:04:44 EST 2016 [usr@hostname pki]# But…
MySQL/MariaDB vs MongoDB Privileges Comparision
privileges_comparision_mysql_or_mariadb_vs_mongodb
How to Transition from SQL to MongoDB
How to Transition from SQL to MongoDB It’s the ultimate question. Five years ago you would have looked at your company’s environment and you have said “we’re a SQL shop.” The same was true of MongoDB’s 3000+ customers before they…
MariaDB: What is buzzing ?!
MARIADB NEWSLETTER October 2016 Welcome to the MariaDB newsletter, which features our latest updates, news, events and more. There’s so much going on that we can’t possibly fit it all into one newsletter, so keep an eye on mariadb.com to learn…
MariaDB “JDBC/Connector J” Connection with SSL enabled.
[root@dbversity-com rh-mariadb101]# cat /etc/opt/rh/rh-mariadb101/my.cnf # This group is read both both by the client and the server # use it for options that affect everything [client-server] #################### <– Client-Server SSL Options–> ####################################### ssl ssl-cipher = AES128+EECDH:AES128+EDH ssl-ca = /etc/opt/rh/rh-mariadb101/pki/ca.pem ssl-cert…
MariaDB ODBC Driver (Connector/ODBC) testing
root@dbversity-com ]# ll -lhtr -rw-r–r– 1 698K Oct 4 06:42 mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# tar -zxvf mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz mariadb-connector-odbc-2.0.12-ga-linux-x86_64/lib64/libmaodbc.so mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/COPYING mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/README [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# ll -lhrt -rw-r–r– 1 698K Oct 4…
Configuring MariaDB With PAM/Kerberos
Please note below directions assume the system is already setup to use AD for user logins. What is here will enable a MariaDB to leverage a system’s current setup. It will not deploy AD from scratch. As of MariaDB 5.0,…
[MongoDB]: For loop to generate documents with array, sub and nested documents
Find below sample for loop to generate a document with array, sub-document, nested-document use mydb db.studentscol.drop() for(var i = 1; i <= 1000 ; i++){var r= Math.random().toString(36).substring(7); db.studentscol.insert( { _id:i, name:r, address: { address_id:i, state:r,country:”India”,street:{name:r,colony:{ name:r,pin:r}}}, hobbies: [{h1:r},{h2:r},{h3:r},{h4:r}] });} //…
MongoDB DBA : Roles and Responsibilities
Roles & Responsibilities 01) Defragmentation 02) Schema Design – working with Application/Development team 03) Query fine tuning 04) Shell scripts for Monitoring like ‘slow queries’, replication lag, nodes fails, disk usage .. etc 05) Backup and restores (…