SmartFB is our internal tool to manage Firebird & Interbase databases, so we use smartFB instead IBExpert. SmartFB is a simple VCL program that we use to have an access to our databases in every PC and Virtual Machines where we not need a simple access to our databases. So we integrate in smartFB some…
Leggi tutto
Charset encoding in Firebird 3.0, come è noto in un campo di una tabella di tipo varchar o char è possibile definire il tipo di encoding gestito, oppure non specificarlo. Tramite Firebird è possibile convertire il contenuto di tale campo da un charset ad un’altro semplicemente con l’istruzione SQL “cast”. Facciamo un esempio, nella mia…
Leggi tutto
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…
Leggi tutto
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> |
In questo Agosto Embarcadero annuncia la nuova versione del noto database relazione Interbase : Interbase 2019. Interbase è molto utilizzato dagli sviluppatori Delphi dato che in ambito multi piattaforma (iOS,Android,Windows,Mac OSX, Linux) credo sia l’unico database relazionale distribuibile anche su piattaforme iOS / Android, le versioni di interbase per la distribuzione in ambito mobile sono…
Leggi tutto
Synaptica has always adopted Firebird as its main database environment for the realization of many solutions from embedded iot products to Web solutions with thousands of daily accesses. Firebird proved to be a great tool, flexible and easy to manage. For this reason we could not miss the appointment to meet the creators (Dmitry…
Leggi tutto
