Character set encoding In Firebird 3.0, as is known in a field of a varchar or char type table, it is possible to define the type of encoding managed, or not specific. Through Firebird it is possible to record the content of the story from one set of characters and another simply with the SQL…
Read more
tested on Oracle XE 10g to make a simple bk from Oracle you can use dbms library like: create or replace directory dumpdir as ‘/home/[youruserpath]/’ /* ESPORTA DATI E METADATI DI UNO SCHEMA */ declare handle number; begin handle := dbms_datapump.open(‘EXPORT’,’SCHEMA’); dbms_datapump.add_file(handle,'[destination_file_name].dmp’,’DUMPDIR’); DBMS_DATAPUMP.add_file( handle => Handle, filename => ‘.log’, directory => ‘DUMPDIR’, filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE…
Read more
1)Purchase your Certificate SSL DVW (Domain Validated Wildcard ) from your provider. 2)Log in to your server’s terminal via Secure Shell (SSH). 3)Generate a private key and CSR by running the following command: openssl req -new -newkey rsa:2048 -nodes -keyout server.key -out server.csr Note: Replace “server” with the domain name you intend to secure. Enter the following CSR details when prompted:…
Read more
WebSocket is a technology that allows a bidirectional interaction between server and client, you will tell me, nothing new with a socket connection of the 90’s we did the same thing. True!!! The thing that makes this technology very advantageous is that first of all, it implements standards in data transmission and use protocols but…
Read more
Tested on Ubuntu 18.04 LTS sudo nano /etc/apache2/conf-available/phpmyadmin.conf #Restrict phpMyAdmin via IP address Order Deny,Allow Deny from All Allow from 10.1.1.10 sudo /etc/init.d/apache2 restart GNU nano 2.2.6 File: /etc/apache2/conf-available/phpmyadmin.conf # phpMyAdmin default Apache configuration Alias /phpmyadmin /usr/share/phpmyadmin An example of a full conf file, whereto we give full access to an entairly network addresses #Restrict…
Read more
Completely remove SVN references from a folder recursively: cd </yourFolderPath> find -name “.svn” | xargs /bin/rm -rf Undo add … if by mistake as often happens it is called “add” and involuntarily you add infinite files to be committed that you did not want to version, to go back before having committed just run: cd…
Read more
