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:
|
1 |
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: Common Name: The FQDN (fully-qualified domain name) you want to…
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
|
1 |
sudo nano /etc/apache2/conf-available/phpmyadmin.conf |
|
1 2 3 4 |
#Restrict phpMyAdmin via IP address Order Deny,Allow Deny from All Allow from 10.1.1.10 |
|
1 |
sudo /etc/init.d/apache2 restart |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
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 <Directory /usr/share/phpmyadmin> #Restrict phpMyAdmin via IP address Order Deny,Allow Deny from All Allow from 10.0.9.0/24 Options FollowSymLinks DirectoryIndex index.php <IfModule mod_php5.c> AddType application/x-httpd-php .php php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_admin_flag allow_url_fopen Off php_value include_path . php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gette$ </IfModule> </Directory> # Authorize for setup <Directory /usr/share/phpmyadmin/setup> <IfModule mod_authn_file.c> AuthType Basic AuthName "phpMyAdmin Setup" AuthUserFile /etc/phpmyadmin/htpasswd.setup </IfModule> Require valid-user </Directory> # Disallow web access to directories that don't need it <Directory /usr/share/phpmyadmin/libraries> Order Deny,Allow Deny from All </Directory> <Directory /usr/share/phpmyadmin/setup/lib> Order Deny,Allow Deny from All </Directory> |
Completely remove SVN references from a folder recursively:
|
1 2 |
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:
|
1 2 |
cd <yourFolderPath> svn revert -R ./ |
