Category: Root

SSL & Serverzertifikat Debian Package Solaris Package remove all lines from the file d.dat: perl -p -i.bak -e ’s#^\*X-something.*\n$##g’ d.dat perl -p -n -i.bak -e ’s/^\*X-pol.*\n$//g’ file.in perl -p -n -i.bak -e ’s/\r\n/\n/’ file.in awk ‘{print $3}’ $filename installing a new module: – perl Makefile.PL or perl Makefile.PL PREFIX=/my/perl_directory make make test …

Perl, PHP and mySQL Read more »

debugger for hash variable require Data::Dumper; print STDERR “Line ” . __LINE__ . “, File: ” . __FILE__ . “\n” . Data::Dumper->new([$columns, \@fields],[qw(columns fields)])->Indent(1)->Useqq(1)->Dump; require Data::Dumper; print STDERR “Line” . __LINE__ . “, File: ” . __FILE__ . Data::Dumper->new([$applConfigHash],[qw(columns)])->Indent(1)->Useqq(1)->Dump; Cached queries with bind variables. Here an Example: my %attr = ( PrintError …

debugger for hash variable Read more »

An introduction to building a Web Service: A Web service consists of a network-accessible service with a formal description of how to connect to and use the service. The language for formal description of a Web service is XML and through a family of XML interfaces (like SOAP, UDDI and WSDL) will …

Web service Read more »

The best ways to run all files from a folder in SqlPLus Create a file and store all of the file names from the folder: ls -l > list.sql Edit and set @ before each file name vi list.sql 1,$s/^/@/ sqlpus ich/foo@mydb @list.sql Convert latin1 to UTF-8 in MySQL $ mysqldump -h …

Linux commands Read more »

Tora with Oracle on debian(Ubuntu) Oracle on debian Added this server is in your apt sources list. # sudo vi /etc/apt/source.list deb http://oss.oracle.com/debian unstable main non-free # wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add – # sudo apt-get install oracle-xe-client oracle-xe-universal # sudo /etc/init.d/oracle-xe configure export LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:$LD_LIBRARY_PATH export TNS_ADMIN=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/ export PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/ export …

Tora with Oracle Read more »

The best ways to run all files from a folder in SqlPLus Create a file and store all of the file names from the folder: ls -l > list.sql Edit and set @ before each file name vi list.sql 1,$s/^/@/ sqlpus ich/foo@mydb @list.sql SPOOL Command SPOOL FILENAME:  Store query results in file …

Oracle & SQLPlus Read more »