Install LAMP on Ubuntu 16.04

sudo apt install apache2

sudo a2ensite example.conf

sudo a2dissite 000-default.conf

sudo a2enmod  rewrite

sudo chown -R user:user /var/www

sudo service apache2 reload


sudo apt install mysql-server

mysql -u root -p

 CREATE USER 'user'@'%' IDENTIFIED BY 'password';

 GRANT ALL PRIVILEGES ON *.* TO 'user'@'%';

sudo vim /etc/mysql/mysql.conf/mysqld.cnf

 # bind-address          = 127.0.0.1

mysql -u root -p < mysqldump.sql

sudo systemctl restart mysql

sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql

color palette for st (suckless simple terminal) config.h

/* Terminal colors (16 first used in escape sequence) */
static const char *colorname[] = {

/* 8 normal colors */
[0] = "#2b2b2b", /* black   */
[1] = "#da4939", /* red     */
[2] = "#a5c261", /* green   */
[4] = "#6d9cbe", /* blue    */
[5] = "#b6b3eb", /* magenta */
[6] = "#519f50", /* cyan    */
[7] = "#e6e1dc", /* white   */

/* 8 bright colors */
[8]  = "#5a647e", /* black   */
[9]  = "#da4939", /* red     */
[10] = "#a5c261", /* green   */
[11] = "#ffc66d", /* yellow  */
[12] = "#6d9cbe", /* blue    */
[13] = "#b6b3eb", /* magenta */
[14] = "#519f50", /* cyan    */
[15] = "#f9f7f3", /* white   */

/* special colors */
[256] = "#2b2b2b", /* background */
[257] = "#e6e1dc", /* foreground */
};

/*
* Default colors (colorname index)
* foreground, background, cursor
*/
unsigned int defaultfg = 257;
unsigned int defaultbg = 256;
static unsigned int defaultcs = 257;
static unsigned int defaultrcs = 256;

/*
* Colors used, when the specific fg == defaultfg. So in reverse mode this
* will reverse too. Another logic would only make the simple feature too
* complex.
*/
static unsigned int defaultitalic = 7;
static unsigned int defaultunderline = 7;

Building st (suckless simple terminal) on Debian 9

# install pre-requisites
sudo apt-get -y install libx11-dev libxft-dev libxext-dev

# clone latest stterm
cd
git clone git://git.suckless.org/st

# install
cd st
sudo make clean install

# command for st: stterm
# open maximized with this hack: stterm -g 300x300
sudo ln -s /usr/local/bin/st /usr/bin/stterm

Coldfusion - Railo : INSTALL and CALL : Java - Jar - MP3File

wget http://downloads.sourceforge.net/project/javamp3.berlios/java_mp3-0.4-src.zip?r=&ts=1343927979&use_mirror=iweb

unzip java_mp3-0.4-src.zip

mv java_mp3.jar /opt/railo/lib

/opt/railo/railo_ctl restart



 <CFDIRECTORY  ACTION="LIST" DIRECTORY="#GetDirectoryFromPath(ExpandPath("*.*"))#MP3L" FILTER="*.mp3" SORT="name ASC" NAME="main">
 19
 20
 21 <CFOUTPUT QUERY="main">
 22
 23 <cfif len(name) GT 8>
 ..

 39
 40
 41 <cfset MP3File = createObject('java', 'de.vdheide.mp3.MP3File').init('/home/frank/rothkamm/ROTHKAMM/MP3L/#name#')>
 42 #name# - #MP3File.getBitrate()# - #MP3File.Length()#
 43
 44 <cfif MP3File.getLength() GTE 4>
 45
 46 <CFQUERY NAME="new" DATASOURCE="rothkamm">
 47 UPDATE    PART
 48 SET       length = #MP3File.getLength()#
 49 WHERE     ID = #left(name,4)#
 50
 51 </CFQUERY>
 52
 53 </cfif>
 54
 ..

 62
 63 <br />
 64
 65
 66
 67
 68 </cfif>
 69
 70
 71
 72 </CFOUTPUT>

find a file and rename it

find -iname  *mega* -exec mv {} Rothkamm-Megablast.mp3 \;

MSSQL to MySQL migration kit - use unicode

Advanced >> ConnectionString

jdbc:jtds:sqlserver://[IPaddress]:1433/[database_name];user=sa;password=[password];useUnicode=true;domain= 

jdbc:mysql://[IPaddress]:3306/?user=[username]&password=[password]&useServerPrepStmts=false&useUnicode=true 

random shuffle of lines in a text file

cat conplaylist.txt | perl -MList::Util=shuffle -e 'print shuffle();' > conplaylist_shuffle.txt

or 

cat conplaylist.txt | sort -R > conplaylist_shuffle

MSSQL TOP 1 mysql LIMIT 0,1

MSSQL:

SELECT TOP 1 Name, Released, label
FROM Album
WHERE  Released > #DateFormat(album.Released,'YYYY-MM-DD')# AND Released <= #DateFormat(now(),'YYYY-MM-DD')# AND (label like '%Flux%' OR label like '%Monochrome%' OR label like '%baskaru%')
ORDER BY Released ASC

mysql:

SELECT Name, Released, label
FROM Album
WHERE  Released > #DateFormat(album.Released,'YYYY-MM-DD')# AND Released <= #DateFormat(now(),'YYYY-MM-DD')# AND (label like '%Flux%' OR label like '%Monochrome%' OR label like '%baskaru%')
ORDER BY Released ASC LIMIT 0,1

rename files : UPPER CASE to lower case

ls | while read file; do mv $file `echo $file | sed 's/.*/\L&/'`; done;

but does not work for file names with white space(s) in them.


replace all white spaces with underscore in any [filename.ext]:

for i in `find . -name '* *' | tr ' ' '~'`; do mv "$(echo $i| tr '~' ' ')" "$(echo $i | tr '~' '_')"; done

xrdp | Free software downloads at SourceForge.net - Google Chrome

http://sourceforge.net/projects/xrdp/

Import CSV file directly into MySQL | a Tech-Recipes Tutorial - Google Chrome

http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/

Shell Script To Get Data Center Information, IP Owner, City and Country From Domain Name - Google Chrome

http://bash.cyberciti.biz/monitoring/get-data-center-information-from-domain-name/

m4a to mp3

#!/bin/bash
#
# Convert m4a to mp3

if [ -n "$1" ]; then

  for i in $1/*.m4a
  do
    faad -o "$i.wav" "$i"
    dest=`echo "$i.wav"|sed -e 's/m4a.wav$/mp3/'`
    lame -h -b 128 "$i.wav" "$dest"
    rm "$i.wav"
    rm "$i#
  done

else
  echo "Usage: m4a2mp3 [directory_containing_m4a_files]"
fi


chmod +x m4a2mp3
mv m4a2mp3 /usr/local/bin

m4a3mp3  [directory] > /dev/null 2>&1 &

mv -t /MP3/ *.mp3
mv  */*/*.mp3  /MP3/

find -name \*.mp3 -print > conplaylist.txt

wc -l conplaylist.txt



sudo yum install perl-Image-ExifTool.noarch 

exiftool -AudioBitrate [File].mp3

ps -eF


sudo vim /opt/railo/lib/railo-server/context/railo-server.xml


 data-source 
 ... class="org.gjt.mm.mysql.Driver" 
 ... dsn="jdbc:mysql://{host}:{port}/{database}?zeroDateTimeBehavior=convertToNull"
 ... /


sudo /opt/railo/railo_ctl restart
sudo service httpd restart