Samba public share

How to configure a Debian based Linux distribution to share a folder with anyone on the network, with read and write access ?
Read more →

Convert PDF to PNG with enough resolution

ImageMagick logoAs ‘man convert’ states :

The convert program is a member of the ImageMagick suite of tools. Use it to convert between image formats as well as resize an image, blur, crop, despeckle, dither, draw on, flip, join, re-sample, and much more.

Read more →

Don’t forget master infos in your MySQL dump

I tried to resync a slave MySQL after it disconnected from the master. But the binary log was already deleted on master, so the only solution was to restore from the last backup. To avoid lock tables on the master and remember the binary log name and position to put them on the slave configuration, there is a tip to take care of all that : the “–master-data” option in mysqldump. Read more →

MySQL import from csv

To import a local CSV file into MySQL, use the syntax below :


LOAD DATA LOW_PRIORITY LOCAL INFILE '/path/tofile.csv'
INTO TABLE database.table
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES
(`field1`,`field2`,...)

MySQL export to csv

To export a mysql results in CSV format, use the syntax below :

SELECT field1, field2, ...
FROM table
WHERE condition
INTO OUTFILE '/tmp/toto.csv'
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
LINES TERMINATED BY '\n' ;

Cheyenne server and POST size limit

By default, in Cheyenne, the header size limit for a post request is 102’400.
If you want to ajust this limit you can define the post-mem-limit parameter in the global context or in a specific webapp.
For example, to double the initial limit in the httpd.cfg, :

...
default [
	root-dir %./www/
	default [%index.html %index.rsp]
	post-mem-limit 408'800
]
...

Boot Linux in text console

Get rid of graphic boot on Linux with a few modifications in grub configuration : Read more →

French Git Log

french git example

Read more →

mysql client : don’t show columns names and grid

Default mysql client behaviour is to show column names and grid when returning results  but how to get rid of this decorations ?  Read more →

Allow invalid date in MySQL

Just in case you absolutely have to insert a date in MySQL that does’nt exist, eg 2014-02-30, you can run MySQL server in a special mode that authorizes such dates :

	mysqld --sql-mode="ALLOW_INVALID_DATES"

MySQL will only check that the month is in the range from 1 to 12 and the day is in the range from 1 to 31.
see Mysql DOC