$sudo apt-get install msttcorefonts
$sudo fc-cache -fv
Friday, December 31, 2010
Sunday, December 5, 2010
Ubuntu fix DVDs playing
Some movie DVDs don't play regardless the used player: vlc, mplayer, gxine, movie player, etc. This fixes it:
sudo apt-get install libdvdread4
sudo /usr/share/doc/libdvdread4/install-css.sh
Source for info: https://help.ubuntu.com/community/RestrictedFormats/PlayingDVDs
Error received: "error reading nav packet"
sudo apt-get install libdvdread4
sudo /usr/share/doc/libdvdread4/install-css.sh
Source for info: https://help.ubuntu.com/community/RestrictedFormats/PlayingDVDs
Error received: "error reading nav packet"
Labels:
DVD movies,
linux
Tuesday, November 23, 2010
Howto: Install TRENDnet Wireless Network Card on Ubuntu 10.04 LTS (Lucid Lynx)
Ubuntu Lucid (10.04) - TRENDnet Wireless PCI Adapter
apt-get install ndiswrapper-utils ndisgtk
# install windows drivers (select 32 or 64 bit drivers)
# (*.sys file should also be present near net819xp.inf)
ndiswrapper -i /path/to/drivers/Windows\ 2000/net819xp.inf
# test install
# should output something like:
# net819xp : driver installed
# device (10EC:8190) present
ndiswrapper -l
# bring up ndiswrappwer
sudo modprobe ndiswrappwer
# add ndiswrapper to /etc/modules
# add a new line with text: ndiswrapper
sudo gedit /etc/modules
# configure wireless interface
sudo gedit /etc/network/interfaces
# type the following info (example for WPA or WPA2 encryption):
auto wlan0
iface wlan0 inet dhcp
wpa-ssid wlan_home
wpa-psk xx00-xx00-xx00
# restart networking
sudo /etc/init.d/networking restart
DONE!
apt-get install ndiswrapper-utils ndisgtk
# install windows drivers (select 32 or 64 bit drivers)
# (*.sys file should also be present near net819xp.inf)
ndiswrapper -i /path/to/drivers/Windows\ 2000/net819xp.inf
# test install
# should output something like:
# net819xp : driver installed
# device (10EC:8190) present
ndiswrapper -l
# bring up ndiswrappwer
sudo modprobe ndiswrappwer
# add ndiswrapper to /etc/modules
# add a new line with text: ndiswrapper
sudo gedit /etc/modules
# configure wireless interface
sudo gedit /etc/network/interfaces
# type the following info (example for WPA or WPA2 encryption):
auto wlan0
iface wlan0 inet dhcp
wpa-ssid wlan_home
wpa-psk xx00-xx00-xx00
# restart networking
sudo /etc/init.d/networking restart
DONE!
Wednesday, November 17, 2010
Google IMAP and SMTP client settings
imap.gmail.com 993 SSL/TLS
smtp.gmail.com 587 STARTTLS
smtp.gmail.com 587 STARTTLS
Labels:
internet
Sunday, November 7, 2010
Saturday, November 6, 2010
Romanian political parties statistics
Comparative charts:
PDL, PSD, PNL
PDL - Democratic Liberal Party (en) - Partidul Democrat Liberal (ro)
PSD - Social Democratic Party (en) - Partidul Social Democrat (ro)
PNL - National Liberal Party (en) - Partidul National Liberal (ro)
PDL, PSD, PNL, UDMR, PRM, UNPR
PDL - Democratic Liberal Party (en) - Partidul Democrat Liberal (ro)
PSD - Social Democratic Party (en) - Partidul Social Democrat (ro)
PNL - National Liberal Party (en) - Partidul National Liberal (ro)
UDMR - The Democratic Union of Hungarians in Romania (en) - Uniunea Democrata Maghiara din Romania (ro)
PRM - The Greater Romania Party (en) - Partidul Romania Mare (ro)
UNPR - National Union for the Progress of Romania (en) - Uniunea Nationala pentru Progresul Romaniei (ro)
PDL, PSD, PNL
PDL - Democratic Liberal Party (en) - Partidul Democrat Liberal (ro)
PSD - Social Democratic Party (en) - Partidul Social Democrat (ro)
PNL - National Liberal Party (en) - Partidul National Liberal (ro)
PDL, PSD, PNL, UDMR, PRM, UNPR
PDL - Democratic Liberal Party (en) - Partidul Democrat Liberal (ro)
PSD - Social Democratic Party (en) - Partidul Social Democrat (ro)
PNL - National Liberal Party (en) - Partidul National Liberal (ro)
UDMR - The Democratic Union of Hungarians in Romania (en) - Uniunea Democrata Maghiara din Romania (ro)
PRM - The Greater Romania Party (en) - Partidul Romania Mare (ro)
UNPR - National Union for the Progress of Romania (en) - Uniunea Nationala pentru Progresul Romaniei (ro)
Labels:
servicii,
statistici
How to redirect non-www to www
Howto 301 ( permanent ) redirect non www to www
301 (permanent) redirect all non-www requests to www.
Apache webserver with mod_rewrite enabled; apache.conf or .htaccess file.
This will redirect requests to all pages to www. domain.
301 (permanent) redirect all non-www requests to www.
Apache webserver with mod_rewrite enabled; apache.conf or .htaccess file.
RewriteEngine On
RewriteCond %{HTTP_HOST} ^mydomain.com/? [NC]
RewriteRule ^(.*)$ http://www.mydomain.com/$1 [L,R=301]
RewriteCond %{HTTP_HOST} ^mydomain.com/? [NC]
RewriteRule ^(.*)$ http://www.mydomain.com/$1 [L,R=301]
This will redirect requests to all pages to www. domain.
Friday, November 5, 2010
Javascript email obfuscator
Javascript email obfuscator function:
function obfEm(_a_id, _part1, _part2, _innerHTML, _part3) {
if(document.getElementById(_a_id)) {
var txt1 = _part1;
var txt2 = _part2;
var txt3 = _part3;
var ar_mt1 = ['m', 'a', 'i'];
var ar_mt2 = ['l', 't', 'o'];
var em = new Array();
em[0] = txt1;
em[1] = '@';
em[2] = txt2;
em[3] = '.';
em[4] = txt3;
var ems = em.join('');
var mts = ar_mt1.join('') + ar_mt2.join('');
document.getElementById(_a_id).href = mts + ':' + ems;
document.getElementById(_a_id).innerHTML = _innerHTML.length > 0 ? _innerHTML : ems;
}
}
if(document.getElementById(_a_id)) {
var txt1 = _part1;
var txt2 = _part2;
var txt3 = _part3;
var ar_mt1 = ['m', 'a', 'i'];
var ar_mt2 = ['l', 't', 'o'];
var em = new Array();
em[0] = txt1;
em[1] = '@';
em[2] = txt2;
em[3] = '.';
em[4] = txt3;
var ems = em.join('');
var mts = ar_mt1.join('') + ar_mt2.join('');
document.getElementById(_a_id).href = mts + ':' + ems;
document.getElementById(_a_id).innerHTML = _innerHTML.length > 0 ? _innerHTML : ems;
}
}
Javascript email obfuscator HTML:
<script type="text/javascript">
obfEm('a1', 'contact', 'office-space', 'person-name-optional', 'com')
</script>
<script type="text/javascript">
obfEm('a2', 'contact', 'office-space', '', 'com')
</script>
Tuesday, November 2, 2010
Change blogspot title format for posts
1) Go to Design -> Edit HTML
2) Locate section "<title><data:blog.pageTitle/></title>" and replace it with the following:
This will display the title for post pages like this:
"<data:blog.pageName/> - <data:blog.title/>"
Post 1 title - Main blog title
Choose Preview & Save Template or just Save Template.
2) Locate section "<title><data:blog.pageTitle/></title>" and replace it with the following:
<title>
<b:if cond='data:blog.pageType == "item"'>
<data:blog.pageName/> - <data:blog.title/>
<b:else/>
<data:blog.pageTitle/>
</b:if>
</title>
This will display the title for post pages like this:
"<data:blog.pageName/> - <data:blog.title/>"
Post 1 title - Main blog title
Choose Preview & Save Template or just Save Template.
Labels:
blogspot
MySQL UNIX_TIMESTAMP howto: date and datetime fields operations (common)
MySQL UNIX_TIMESTAMP examples
• set date to current date for all items having dates bigger than 24 hours in the future
• delete all entries older than 30 days (having date smaller than current time minus 30 days)
Both above examples make use of UNIX_TIMESTAMP function.
• set date to current date for all items having dates bigger than 24 hours in the future
UPDATE table_name SET data = now() WHERE UNIX_TIMESTAMP(data) > UNIX_TIMESTAMP() + 24 * 60 * 60;
• delete all entries older than 30 days (having date smaller than current time minus 30 days)
DELETE FROM table_name WHERE UNIX_TIMESTAMP(data) < UNIX_TIMESTAMP() - 30 * 24 * 60 * 60;
Both above examples make use of UNIX_TIMESTAMP function.
Labels:
mysql,
unix_timestamp
"Uniunea Europeana" in presa din Romania
Numar aparitii "Uniunea Europeana" in presa din Romania.
Labels:
servicii,
uniunea europeana
Monday, November 1, 2010
Care sunt tarile europene despre care se vorbeste cel mai des in presa din Romania?
Numar aparitii in presa din Romania
Tarile europene in presa din Romania:
anglia, austria, belgia, bulgaria, cipru, cehia, danemarca
estonia, finlanda, franta, germania, grecia, irlanda, italia
letonia, lituania, luxembourg, malta, olanda, polonia, portugalia
slovacia, slovenia, spania, suedia, ungaria
Alte tari din Uniunea Europeana:
PIIGS
Diverse: franta, germania, austria, polonia, finlanda, norvegia, suedia
Tarile europene in presa din Romania:
anglia, austria, belgia, bulgaria, cipru, cehia, danemarca
estonia, finlanda, franta, germania, grecia, irlanda, italia
letonia, lituania, luxembourg, malta, olanda, polonia, portugalia
slovacia, slovenia, spania, suedia, ungaria
Alte tari din Uniunea Europeana:
PIIGS
Diverse: franta, germania, austria, polonia, finlanda, norvegia, suedia
Labels:
servicii,
uniunea europeana
Friday, October 22, 2010
Wednesday, October 20, 2010
Monitorizarea presei
Sursa De Stiri ofera posibilitatea consultarii stirilor din cele mai importante ziare romanesti intr-un format usor de folosit.
In plus, un serviciu foarte util pentru persoanele interesate de anumite subiecte, oferit in mod gratuit, este serviciul de monitorizare stiri, care presupune:
- crearea de cuvinte cheie pe baza carora sunt selectate articolele pentru a fi citite
- notificarea pe e-mail la aparitia de noi articole care contin cuvintele cheie alese; alegerea orelor din zi la care se doreste primirea mesajelor e-mail
Mai multe detalii despre monitorizare stiri: monitorizarea presei.
Evolutii, grafice comparative, numar aparitii termeni in presa.
In plus, un serviciu foarte util pentru persoanele interesate de anumite subiecte, oferit in mod gratuit, este serviciul de monitorizare stiri, care presupune:
- crearea de cuvinte cheie pe baza carora sunt selectate articolele pentru a fi citite
- notificarea pe e-mail la aparitia de noi articole care contin cuvintele cheie alese; alegerea orelor din zi la care se doreste primirea mesajelor e-mail
Mai multe detalii despre monitorizare stiri: monitorizarea presei.
Evolutii, grafice comparative, numar aparitii termeni in presa.
Labels:
servicii
Sunday, August 8, 2010
Ubuntu Firefox 3.6 HtmlValidator extension - Fixed!
Ubuntu 10.04 LTS (Lucid), Firefox 3.6.3, HTMLVALIDATOR extension - howto
1) Download & install HTML Validator extension:
http://users.skynet.be/mgueury/mozilla/download.html
2) Install libstdc++5
http://packages.ubuntu.com/jaunty/i386/libstdc++5/download
3) Link tidy to the library
4) Restart firefox (stop it, wait 10 seconds, start it)
1) Download & install HTML Validator extension:
http://users.skynet.be/mgueury/mozilla/download.html
2) Install libstdc++5
http://packages.ubuntu.com/jaunty/i386/libstdc++5/download
3) Link tidy to the library
cd ~/.mozilla/firefox/
find . -name libnstidy.so
#go to that directory:
cd directory_of_libnstidy.so
# create symbolic link to libstdc++5
ln -s /usr/lib/libstdc++.so.5 libstdc++.so.5
4) Restart firefox (stop it, wait 10 seconds, start it)
Labels:
firefox,
htmlvalidator,
linux,
ubuntu
Thursday, August 5, 2010
Official Google Blog: Update on Google Wave
Official Google Blog: Update on Google Wave: "there will be other waves"
Wednesday, August 4, 2010
Shell parallelization - Shell solution for running same process or different processes in parallel
Multiple instances of same job, in parallel.
Example 1:
#!/bin/bash
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
...
Example 2:
#!/bin/bash
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
...
# wait for all secvential started processes to finish
wait
# do other stuff ...
email-results.sh
Example 3:
#!/bin/bash
secvential-job1.sh &
secvential-job2.sh &
secvential-job2.sh &
secvential-job3.sh &
...
# wait for all secvential started processes to finish
wait
# do other stuff ...
compute-full-report.sh
email-results.sh
Example 1:
#!/bin/bash
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
...
Example 2:
#!/bin/bash
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
secvential-job.sh &
...
# wait for all secvential started processes to finish
wait
# do other stuff ...
email-results.sh
Example 3:
#!/bin/bash
secvential-job1.sh &
secvential-job2.sh &
secvential-job2.sh &
secvential-job3.sh &
...
# wait for all secvential started processes to finish
wait
# do other stuff ...
compute-full-report.sh
email-results.sh
Labels:
linux,
shell scripting
Simple cron locking system
Run cron jobs safely, using locking. Cron lock prevents running a cronjob if the first one didn't finished running (prevents cron overlaps).
2 files are used:
- cron-job1.sh
- cron-job1.lock
Contents of cron-job1.lock will be:
- free - if it's free, cron-job1.sh is NOT running
- locked - if cron-job1.sh is running
Locking script (cron-job1.sh):
#!/bin/bash
lock_file="cron-job1.lock"
lock_content=`cat $lock_file`
if [[ "$lock_content" == "free" ]] ; then
echo "locked" > $lock_file
# do stuff here:
cd /some-dir
php compute-things.php
php email-results.php
echo "free" > $lock_file
else
echo "script already running, file $lock_file is not free"
fi
2 files are used:
- cron-job1.sh
- cron-job1.lock
Contents of cron-job1.lock will be:
- free - if it's free, cron-job1.sh is NOT running
- locked - if cron-job1.sh is running
Locking script (cron-job1.sh):
#!/bin/bash
lock_file="cron-job1.lock"
lock_content=`cat $lock_file`
if [[ "$lock_content" == "free" ]] ; then
echo "locked" > $lock_file
# do stuff here:
cd /some-dir
php compute-things.php
php email-results.php
echo "free" > $lock_file
else
echo "script already running, file $lock_file is not free"
fi
Labels:
linux,
php,
shell scripting
Tuesday, August 3, 2010
Recursively change directory and file permissions
Recursive php script that updates directories and files permissions.
Directory permissions: 755
File permissions: 644
File update-permissions.php:
ini_set('display_errors', 1);
$dir = '/home/user/folder';
update_perms($dir);
function update_perms($dir, $_dir_perms = '755', $_file_perms = '644') {
echo "\n" . $dir . '...';
if(is_dir($dir)) {
shell_exec("chmod $_dir_perms $dir");
echo 'dir update';
$files = scandir($dir);
unset($files[0]);
unset($files[1]);
#print_r($files);exit;
foreach($files as $file) {
update_perms($dir . '/' . $file);
}
} elseif(is_file($dir)) {
shell_exec("chmod $_file_perms $dir");
echo 'file update';
}
}
Directory permissions: 755
File permissions: 644
File update-permissions.php:
ini_set('display_errors', 1);
$dir = '/home/user/folder';
update_perms($dir);
function update_perms($dir, $_dir_perms = '755', $_file_perms = '644') {
echo "\n" . $dir . '...';
if(is_dir($dir)) {
shell_exec("chmod $_dir_perms $dir");
echo 'dir update';
$files = scandir($dir);
unset($files[0]);
unset($files[1]);
#print_r($files);exit;
foreach($files as $file) {
update_perms($dir . '/' . $file);
}
} elseif(is_file($dir)) {
shell_exec("chmod $_file_perms $dir");
echo 'file update';
}
}
Evolutia salariului minim in Romania, 2000 - 2010
Salariul minim in Romania: 600 lei (brut) - ianuarie 2010.
Evolutia salariului minim in perioada 2000 - 2010 si hotararile de guvern care i-au modificat valoarea:
Evolutia salariului minim in perioada 2000 - 2010 si hotararile de guvern care i-au modificat valoarea:
![]() |
Salariul minim in Romania - istoric 2000 - 2010 |
Labels:
economie
Servicii contorizare trafic in Romania, Iulie 2010
Servicii contorizare trafic Iulie 2010
124.757 domenii analizate.
124.757 domenii analizate.
- Trafic.ro - 28.380 domenii
- Google Analytics - 27.397 domenii
- SATI - 395 domenii
Labels:
internet,
servicii,
statistici
Inregistrare domenii – top firme inregistrare domenii
Inregistrare domenii:
- cauti o statistica a firmelor de inregistrare domenii din Romania?
- doresti sa inregistrezi un domeniu nou?
InfoDomenii ofera informatii despre firmele de inregistrare domenii folosite in Romania: firme inregistrare domenii.
- cauti o statistica a firmelor de inregistrare domenii din Romania?
- doresti sa inregistrezi un domeniu nou?
InfoDomenii ofera informatii despre firmele de inregistrare domenii folosite in Romania: firme inregistrare domenii.
Labels:
internet,
servicii,
statistici
SursaDeStiri.ro – toate stirile in acelasi loc
O aplicatie online, cu frecventa de actualizare ridicata, activa 24 de ore din 24: www.sursadestiri.ro. “Sursa de stiri” ofera toate stirile din cele mai importante ziare, intr-un mod unitar, organizate pe categorii. Pentru a fi informat si la curent cu cele mai noi evenimente, foloseste acest site.
Harta publicitatii online din Romania
Un serviciu nou, de calitate: Harta publicitatii online in Romania.
Analize pe seturi mari de date, informatii utile despre agentiile de publicitate din Romania si despre sistemele de contorizare trafic folosite de site-urile romanesti.
Analize pe seturi mari de date, informatii utile despre agentiile de publicitate din Romania si despre sistemele de contorizare trafic folosite de site-urile romanesti.
Labels:
internet,
servicii,
statistici
Monday, August 2, 2010
EveryDNS a fost preluat de DynDNS
David Ulevitch, fondatorul EveryDNS (2001), a vandut EveryDNS catre Dyn Inc., care detine DynDNS. EveryDNS administra gratuit aproximativ 400.000 de domenii, domenii care vor trece in administrarea DynDNS. Tranzitia domeniilor se va face fara intreruperea serviciilor. Serviciile vor ramane gratuite in continuare, insa nu se stie pentru cat timp. Sistemul de plata pentru DynDNS momentan constituie in efectuarea unei donatii, in schimbul careia se primeste administrare gratuita life-time pentru acel domeniu.
Client RDS Business – review servicii internet si telefonie
La RDS, orice persoana, fizica sau juridica, poate beneficia de un abonament business. Oferta o primesti pe mail de obicei, dupa ce soliciti acest lucru la relatii cu clientii / dep. comercial, whatever.
Ce primesti in plus:
- portul 25 deblocat – deci poti tine un mail server la tine
- 3 adrese ip statice
- viteza minima garantata
De mentionat ca vitezele maxime sunt mai mici decat la abonamentele fiber link normale, dar sunt garantate.
Si acum despre cum functioneaza aceste servicii:
- daca ai depasit data scadenta a facturii, serviciul e taiat automat; mergi sa platesti si se reactiveaza (tot automat) in max 24 de ore
- in general in caz de avarie a echipamentelor rds (switch, media-convertor), e f. recomandat sa faci o sesizare imediat la Rel. Clienti si problema se rezolva in 24-48 de ore
- in cazuri exceptionale (am patit eu asta), avariile echipamentelor sunt rezolvate intr-un timp f. mare, de 1-2 saptamani; in aceasta situatie, oricate sesizari si reveniri faci, nu se schimba nimic, efectiv oamenii aia nu fac NIMIC; te zbati degeaba. Solutia de urgentare este contacterea unui reprezentant comercial (cel cu care ai semnat contractul) si amenintarea cu rezilierea, etc. In toate interactiunile cu angajatii RDS este f. recomandat sa fii f. ager si pe faza, ei au un talent deosebit de a se eschiva si de a te duce cu vorba pentru a scapa de tine.
- daca nu functioneaza internetul timp de 2 saptamani sa zicem, tot nu esti indreptatit conform contractului sa renunti la serviciile lor. In contract se precizeaza ceva de genul ca timp de 3 luni daca nu functioneaza internetul mai mult de 30 zile, abia atunci, tu, clientul, poti renunta la serviciile lor. De asemenea, daca vrei reziliere, trebuie sa notifici cu 60 de zile inainte acest lucru.
Pe scurt, RCS-RDS, este o firma care ofera servicii de internet f. bune la nivel de tara/orase si efectiv are cea mai buna oferta de net. Si ieftin si f. bun!! DAR, DE RETINUT, nu se merita sa faci un abonament business la ei. Pur si simplu nu-ti garanteaza up-time-ul necesar si se poarta total neprofesionist…
Pentru net pentru acasa, sunt f. ok, insa daca vrei mai mult, sa faci un hosting, sa tii niste servere, si te gandesti la un abonament business la RDS, nu e alegerea cea mai fericita.
Am patit-o cu ei si efectiv “mi-au mancat sanatatea”. Am sunat de mi-a venit rau la ei… pe banii mei, normal…
Si inca o faza “clasica”: cand depui o sesizare, intrebarea clasica a operatorului “dobitoc” este: “cand sunteti in locatie pentru a trimite o echipa pe teren?”. Si tu-i zici: “bai, inteligentule, defectiunea e pe scara, am precizat asta de la inceput, de ce trebuie eu sa fiu in locatie?”. Iar, el, vadit surprins de acest raspuns, revine cu aceeasi intrebare: “cand sunteti in locatie pentru ca trebuie sa completez aici formularul”. Deci, … ma abtin… astia sunt oamenii de acolo.
Ce primesti in plus:
- portul 25 deblocat – deci poti tine un mail server la tine
- 3 adrese ip statice
- viteza minima garantata
De mentionat ca vitezele maxime sunt mai mici decat la abonamentele fiber link normale, dar sunt garantate.
Si acum despre cum functioneaza aceste servicii:
- daca ai depasit data scadenta a facturii, serviciul e taiat automat; mergi sa platesti si se reactiveaza (tot automat) in max 24 de ore
- in general in caz de avarie a echipamentelor rds (switch, media-convertor), e f. recomandat sa faci o sesizare imediat la Rel. Clienti si problema se rezolva in 24-48 de ore
- in cazuri exceptionale (am patit eu asta), avariile echipamentelor sunt rezolvate intr-un timp f. mare, de 1-2 saptamani; in aceasta situatie, oricate sesizari si reveniri faci, nu se schimba nimic, efectiv oamenii aia nu fac NIMIC; te zbati degeaba. Solutia de urgentare este contacterea unui reprezentant comercial (cel cu care ai semnat contractul) si amenintarea cu rezilierea, etc. In toate interactiunile cu angajatii RDS este f. recomandat sa fii f. ager si pe faza, ei au un talent deosebit de a se eschiva si de a te duce cu vorba pentru a scapa de tine.
- daca nu functioneaza internetul timp de 2 saptamani sa zicem, tot nu esti indreptatit conform contractului sa renunti la serviciile lor. In contract se precizeaza ceva de genul ca timp de 3 luni daca nu functioneaza internetul mai mult de 30 zile, abia atunci, tu, clientul, poti renunta la serviciile lor. De asemenea, daca vrei reziliere, trebuie sa notifici cu 60 de zile inainte acest lucru.
Pe scurt, RCS-RDS, este o firma care ofera servicii de internet f. bune la nivel de tara/orase si efectiv are cea mai buna oferta de net. Si ieftin si f. bun!! DAR, DE RETINUT, nu se merita sa faci un abonament business la ei. Pur si simplu nu-ti garanteaza up-time-ul necesar si se poarta total neprofesionist…
Pentru net pentru acasa, sunt f. ok, insa daca vrei mai mult, sa faci un hosting, sa tii niste servere, si te gandesti la un abonament business la RDS, nu e alegerea cea mai fericita.
Am patit-o cu ei si efectiv “mi-au mancat sanatatea”. Am sunat de mi-a venit rau la ei… pe banii mei, normal…
Si inca o faza “clasica”: cand depui o sesizare, intrebarea clasica a operatorului “dobitoc” este: “cand sunteti in locatie pentru a trimite o echipa pe teren?”. Si tu-i zici: “bai, inteligentule, defectiunea e pe scara, am precizat asta de la inceput, de ce trebuie eu sa fiu in locatie?”. Iar, el, vadit surprins de acest raspuns, revine cu aceeasi intrebare: “cand sunteti in locatie pentru ca trebuie sa completez aici formularul”. Deci, … ma abtin… astia sunt oamenii de acolo.
Mysql export SQL Server compatible
Export Mysql – SQL Server:
mysqldump --compatible=mssql dbname > dump.sql
Ubuntu O2 prepaid internet stick – Ubuntu 10.04 LTS
Ubuntu 10.04 LTS O2 Qualcomm 3G icon howto.
O2 prepaid internet stick.
O2 prepaid internet stick.
Install usb_modeswitch and comgt (comgt is necessary if the stick has a sim with PIN code)
sudo apt-get install usb-modeswitch comgt
Create new file
sudo mcedit /etc/usb_modeswitch.d/1e0e\:f000
with content:
#-----------------------
# Option iCON 210
#
#
# Contributor: wahlm
#
DefaultVendor= 0x1e0e
DefaultProduct= 0xf000
TargetVendor= 0x1e0e
TargetProduct= 0x9000
TargetClass= 0xff
MessageEndpoint=0x1
MessageContent="55534243689d528100000000000006bd000000020000000000000000000000"
ResponseEndpoint=0x1
#------------------------------
Insert the stick
Check device id
lsusb
Create new ppp connection (Choose CHAP authentication, name it o2-prepaid)
sudo pppconfig
Create connect script (./o2-prepaid-stick-connect):
#!/bin/bash
sudo usb_modeswitch -c /etc/usb_modeswitch.d/1e0e\:f000
sudo modprobe usbserial vendor=0x1e0e product=0x9000
sudo comgt -d /dev/ttyUSB2
sudo pon o2-prepaid
Run script:
$ sudo ./o2-prepaid-stick-connect
Looking for target devices ...
Found devices in target mode or class (1)
Looking for default devices ...
No default device found. Is it connected? Bye.
Enter PIN number: ****
Waiting for Registration..(120 sec max).
Registered on Home network: "o2 - de",2
Signal Quality: 15,99
Done! It works!
Backup linux server - Rsync Backup - solutie backup
Solutie de backup folosind rsync. Rsync backup tutorial complet.
Avem 2 masini: client, server. Pe client dorim sa avem o copie fidela a unor directoare de pe server.
Este necesar sa fie deschise in paralel 2 shell-uri pe ambele masini, pentru a rula comenzile intercalat.
In comenzile de mai jos cuvintele “server” si “client” se pot inlocui cu numele masinilor pentru o utilizare mai usoara.
client:
server:
client:
# — copiem rsync-server-key.pub pe server (securizat, folosind scp):
server:
case "$SSH_ORIGINAL_COMMAND" in
*\&*)
echo "Rejected"
;;
*\(*)
echo "Rejected"
;;
*\{*)
echo "Rejected"
;;
*\;*)
echo "Rejected"
;;
*\<*)
echo "Rejected"
;;
*\`*)
echo "Rejected"
;;
*\|*)
echo "Rejected"
;;
rsync\ --server*)
$SSH_ORIGINAL_COMMAND
;;
*)
echo "Rejected"
;;
esac
# — validate-rsync permite doar rularea comenzilor rsync pentru sesiunea deschisa de pe client
# — adaugam ca prefix ip-ul clientului, pentru a permite conexiuni doar de pe client:
client:
# — Comanda de backup:
Avem 2 masini: client, server. Pe client dorim sa avem o copie fidela a unor directoare de pe server.
Este necesar sa fie deschise in paralel 2 shell-uri pe ambele masini, pentru a rula comenzile intercalat.
In comenzile de mai jos cuvintele “server” si “client” se pot inlocui cu numele masinilor pentru o utilizare mai usoara.
client:
su -
cd /root
mkdir rsync-server
cd rsync-server
ssh-keygen -t dsa -b 1024 -f rsync-server-key
server:
su -
cd /home
mkdir rsyncclient
useradd -d /home/rsyncclient rsyncclient
chown -R rsyncclient rsyncclient
client:
# — copiem rsync-server-key.pub pe server (securizat, folosind scp):
scp rsync-server-key.pub root@server:/root/
server:
mv /root/rsync-server-key.pub /home/rsyncclient
cd /home/rsyncclient
mkdir .ssh
chmod 700 .ssh
mv rsync-server-key.pub .ssh/
cd .ssh
touch authorized_keys
chmod 600 authorized_keys
cat rsync-server-key.pub >> authorized_keys
cd ..
mcedit validate-rsync
#!/bin/sh
case "$SSH_ORIGINAL_COMMAND" in
*\&*)
echo "Rejected"
;;
*\(*)
echo "Rejected"
;;
*\{*)
echo "Rejected"
;;
*\;*)
echo "Rejected"
;;
*\<*)
echo "Rejected"
;;
*\`*)
echo "Rejected"
;;
*\|*)
echo "Rejected"
;;
rsync\ --server*)
$SSH_ORIGINAL_COMMAND
;;
*)
echo "Rejected"
;;
esac
chmod +x validate-rsync
chmod 700 validate-rsync
# — validate-rsync permite doar rularea comenzilor rsync pentru sesiunea deschisa de pe client
chown -R rsyncclient /home/rsyncclient
mcedit .ssh/authorized_keys
# — adaugam ca prefix ip-ul clientului, pentru a permite conexiuni doar de pe client:
from="ip_client",command="/home/rsyncclient/validate-rsync" ssh-dss ....
client:
# — Comanda de backup:
rsync -az -e "ssh -i /root/rsync-server/rsync-server-key" rsyncclient@server:/DIRECTORY_TO_BACKUP /BACKUP-STORE-CLIENT/
Labels:
linux
Cron: disable mail sending
Cron keeps sending messages and a huge list forms.
In order to disable cron sending mail messages:
In order to disable cron sending mail messages:
edit /etc/crontab and add or modify: MAILTO=""
Labels:
linux
Export useri si privilegii mysql
Trebuie exportate inregistrarile care ne intereseaza din db mysql, tabelele: user, tables_priv, db.
Query-urile rezultate (insert) se ruleaza pe serverul destinatie. Apoi, FLUSH PRIVILEGES.
Query-urile rezultate (insert) se ruleaza pe serverul destinatie. Apoi, FLUSH PRIVILEGES.
Labels:
mysql
Dump multiple databases from console - mysqldump
mysqldump -u root -p --create-options --databases dbname1 dbname2 > dbs.sql
Use
--create-options
to have “create database” statements. Do not use this option if databases already exists.Simply dump all databases:
mysqldump -u root -p --create-options -A > dbs.sql
Import them:
mysql -u root -p < dbs.sql
Ubuntu 10.04 LTS – install from usb stick - windows tutorial
Howto install Ubuntu 10.04 LTS from usb stick.
Create usb stick image from Windows:
1) Get Ubuntu Ubuntu 10.04 LTS
2) Download UNetbootin
3) Run UNetbootin and select source (ubuntu image) and destination (usb drive)
4) Restart and boot from usb
Create usb stick image from Windows:
1) Get Ubuntu Ubuntu 10.04 LTS
2) Download UNetbootin
3) Run UNetbootin and select source (ubuntu image) and destination (usb drive)
4) Restart and boot from usb
Labels:
linux
Perl, Cpan Install Google Page Rank
install:
gpr2.pl file content:
usage:
cpan
install WWW::Google::PageRank
install LWP::UserAgent
install URI::Escape
gpr2.pl file content:
#!/usr/bin/perl
use WWW::Google::PageRank;
my $domain = $ARGV[0];
my $pr = WWW::Google::PageRank->new;
print "PR: ", scalar($pr->get("http://$domain")), "\n";
usage:
./gpr2.pl domain_name
Labels:
google page rank,
linux
Defragmentarea pe linux nu este necesara
Procesul de defragmentare, atat de necesar pe windows, nu are nici o aplicabilitate pe linux datorita modului in care sistemul de fisiere de pe linux functioneaza. Pe windows, sistemul de fisiere stocheaza informatiile secvential pe hard-disk. In cazul in care un fisier este editat si isi mareste dimensiunea, spre exemplu, dupa editare, informatia nou adugata este stocata pe hard-disk intr-o locatie diferita. Astfel, fisierul este fragmentat. Pe linux, sistemul de fisiere este diferit, continutul fisierelor fiind stocat unitar (nefragmentat) in zone diferite ale hard-diskului.
windows
linux
Din reprezentarile de mai sus se poate observa cu usurinta – chiar si in situatia in care mai este suficient de mult spatiu liber pe hard-disk – ca fragmentarea fisierelor are o rata de aparitie mult mai mare in cazul windows (exemplu: modificare dimensiune fisier in urma editarii).
Presupunem ca editam fisierul 1, adaugand mai multe informatii in el. Rezulta:
windows
linux
Windows – fisier 1 = fragmentat
Linux – fisier 2 = nefragmentat
Pentru a continua aprofundarea subiectului:
http://geekblog.oneandoneis2.org/index.php/2008/11/13/fighting-fragmentation-on-linux
windows
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000|CONTINUTFISIER1||CONTINUTFISIER2||CONTINUTFISIER3|000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
linux
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
0000|CONTINUTFISIER1|000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000|CONTINUTFISIER2|000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000|CONTINUTFISIER3|0000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
Din reprezentarile de mai sus se poate observa cu usurinta – chiar si in situatia in care mai este suficient de mult spatiu liber pe hard-disk – ca fragmentarea fisierelor are o rata de aparitie mult mai mare in cazul windows (exemplu: modificare dimensiune fisier in urma editarii).
Presupunem ca editam fisierul 1, adaugand mai multe informatii in el. Rezulta:
windows
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000|CONTINUTFISIER1_PART1||CONTINUTFISIER2||CONTINUTFISIER3||CONTINUT
FISIER1_PART2|0000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
linux
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
0000|CONTINUTFISIER1_EDITAT|00000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000|CONTINUTFISIER2|000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000|CONTINUTFISIER3|0000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000
Windows – fisier 1 = fragmentat
Linux – fisier 2 = nefragmentat
Pentru a continua aprofundarea subiectului:
http://geekblog.oneandoneis2.org/index.php/2008/11/13/fighting-fragmentation-on-linux
Labels:
linux
Monitorizare server linux - Munin
Munin – solutie monitorizare server linux, setup f.f. rapid, rapoarte generate in cateva minute. Db-ul folosit e rdd, nimic de setat in plus, e f.f. rapid.
Install & Setup (debian)
su -
apt-get install munin munin-node
mcedit /etc/munin/munin.conf (update htmldir /var/www/...web_path.../munin)
mkdir /var/www/...web_path.../munin
chown munin:munin /var/www/...web_path.../munin
/etc/init.d/munin-node restart
Extra
Protect: /var/www/…web_path…/munin
mcedit /var/www/...web_path.../munin/.htaccess
AuthType Basic
AuthName "Members Only"
AuthUserFile /var/www/www.example.com/.htpasswd
require valid-user
htpasswd -c /var/www/...web_path.../munin/.htpasswd munin-admin-user
Edit apache.conf .. create new virtual host, etc
Install & Setup (debian)
su -
apt-get install munin munin-node
mcedit /etc/munin/munin.conf (update htmldir /var/www/...web_path.../munin)
mkdir /var/www/...web_path.../munin
chown munin:munin /var/www/...web_path.../munin
/etc/init.d/munin-node restart
Extra
Protect: /var/www/…web_path…/munin
mcedit /var/www/...web_path.../munin/.htaccess
AuthType Basic
AuthName "Members Only"
AuthUserFile /var/www/www.example.com/.htpasswd
require valid-user
htpasswd -c /var/www/...web_path.../munin/.htpasswd munin-admin-user
Edit apache.conf .. create new virtual host, etc
Labels:
linux
Change bash color - Schimbat culoare bash
edit ~/.bashrc
export PS1=’\e[0;31m[\u@\h:\w]\$ ‘
* Black 0;30
* Dark Gray 1;30
* Blue 0;34
* Light Blue 1;34
* Green 0;32
* Light Green 1;32
* Cyan 0;36
* Light Cyan 1;36
* Red 0;31
* Light Red 1;31
* Purple 0;35
* Light Purple 1;35
* Brown 0;33
* Yellow 1;33
* Light Gray 0;37
* White 1;37
export PS1=’\e[0;31m[\u@\h:\w]\$ ‘
* Black 0;30
* Dark Gray 1;30
* Blue 0;34
* Light Blue 1;34
* Green 0;32
* Light Green 1;32
* Cyan 0;36
* Light Cyan 1;36
* Red 0;31
* Light Red 1;31
* Purple 0;35
* Light Purple 1;35
* Brown 0;33
* Yellow 1;33
* Light Gray 0;37
* White 1;37
Labels:
linux
Linux remote desktop command / tool
rdesktop 192.168.103.174
rdesktop 192.168.101.154
rdesktop 192.168.102.124
rdesktop 192.168.101.154
rdesktop 192.168.102.124
Labels:
linux
Mount from network, using sshfs
sudo apt-get install fuse-utils sshfs
sudo modprobe fuse
sudo modprobe fuse
sshfs -o uid=`id -u`,gid=`id -g`,idmap=user,nonempty,workaround=rename user@host:/home/user/files /mnt/remote_files_mounted_here
Labels:
linux
Subscribe to:
Posts (Atom)