Wednesday, September 15, 2010

TODO List : Summary of My profile.com

Perl PHP

use short_open_tag = On in php.ini for
DocumentRoot h:/Ethicline/www
ServerName www.ethicline.com


modify the etc/host insert
127.0.0.1 www.ethicline.com

-----------------------
-----------------------------------------------
Authentication, Authorization and Access Control

what is .htaccess file

server side authentication , password file
http://httpd.apache.org/docs/2.0/howto/auth.html

if you want to allow .htaccess , then AllowOverride directive is used.

AllowOverride AuthConfig
htpasswd utility required and put it in like /usr/local/apache/passwd

To create the file, use the htpasswd utility that came with Apache. This will be located in the bin directory of wherever you installed Apache. To create

the file, type:

htpasswd -c /usr/local/apache/passwd/passwords rbowen

htpasswd will ask you for the password, and then ask you to type it again to confirm it:

# htpasswd -c /usr/local/apache/passwd/passwords rbowen
New password: mypassword
Re-type new password: mypassword
Adding password for user rbowen
------------------------------------------------


javascript Jquery,YUI
populate dynamically select box options.
browser information like , version, "noscript" tag, os currently installed.
how to include javascript in page.
select box properties.
create new node
update the value
apply class runtime i.e. change css runtime
handling json object
accordion implementation
fish eye component implementation
ajax implementation , update only the specific div by ajax on page
submodal box
toggling the checkboxes
use the data table grid
drag and drop method
check the browser and browser information.
preview image effect
embed pdf and flash file

AJAX:
methods
variables





css
how to attach css
what are identifiers.
what is difference in _ and * while applying the patch
float
clear
tableless structure

linux
shell scripting
how to set cron job
svn commnds to checkout
svn command to checkin
svn commadn to export at certain revision number
svn commit
how to make branches from trunk

current running processes
Copy to remote machine:
scp -i .ssh/id_rsa cybage@test.pulsemgr.com:/home/cybage
compress the file on linux
tar -cvzf permuto_admin_app.tar.gz permuto
extract/uncompress the file on linux
tar -xvzf /home/cybage/permuto_admin_app.tar.gz
provide the permission to apache
sudo chown apache permuto




Wordpress blog
how to setup the wordpress blog

SEO:
what is robot.txt
what is pinging , tools for pinging
what is cloaking
what are the keywords
what is social bookmarking
what is tag
what is spider
what is google analytics
how does the stat counter works
tips to increase the site ranks


Basic requirement for the facebook application
Setup Word press blog
setup the normal corporate site using joomla
setup e-commerce site
setup E-learning site
setup CMS
create site using cakephp
Setup vbulletin


vi editor:

replace


projects:
1. Permuto

--------------------------------------------------------------------------------------------------------------------------------------------------------
Host changes
--------------------------------------------------------------------------------------------------------------------------------------------------------

Windows -> run -> drivers ->

Go to etc/hosts and put in eg:

184.73.211.91 test.pulsemgr.com

--------------------------------------------------------------------------------------------------------------------------------------------------------
SSH/SCP/SVN commands
--------------------------------------------------------------------------------------------------------------------------------------------------------
1. When things get bad
ssh root@test.pulsemgr.com "shutdown -r 0"

2. Login to the remote server
ssh -i .ssh/id_rsa_pmt stg2.pulsemgr.com
ssh -i .ssh/id_rsa_pmt 184.73.211.91

3. copy to the remote
scp -i .ssh/id_rsa_pmt stg2.pulsemgr.com:

4. copy from the remote
scp -i /root/.ssh/id_rsa_pmt -r test.pulsemgr.com:/home/test2/build/ /home/karand/perl

5. apache server commands
/etc/init.d/httpd start
/etc/init.d/httpd stop
/etc/init.d/httpd restart

6. Svn export
svn export --force --username=vishalr --password=cybag_4321 https://permuto.svn.cvsdude.com/permuto/branches/4.0.0-QA/src/portal /home/test/src/portal
svn export --force --username=vishalr --password=cybag_4321 https://permuto.svn.cvsdude.com/permuto/branches/4.0.0-QA/src/portal/application/reports/

/usr/local/permuto/apps/application/
svn export --force --username=vishalr --password=cybag_4321 https://permuto.svn.cvsdude.com/permuto/trunk/src/bam_db/db/ /home/test/bam_upgrades/

--------------------------------------------------------------------------------------------------------------------------------------------------------
Linux Commands
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. for splitting large file
split -b 1440k my_big_file

to combine file again
cat xaa xab Xac> my_big_file


2. link
ln -s


3. search replace strings globally across file
%s///g


4. search string
/search string


5. find files
find
-name


6. display file information

ls -lrth

l -> Shows you huge amounts of information (permissions, owners, size, and when last modified.)
r -> Force printing of non-printable characters in file names as the character question mark (?).
t -> Shows you the files in modification time.
h -> Nearest biggest file size.


7. Processes
ps -ef | grep


8. System details
cat /proc/cpuinfo
cat /proc/meminfo


9. Kill process
kill -9

--------------------------------------------------------------------------------------------------------------------------------------------------------
vim Shortcuts
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. show line number
:set number

2. undo
u

3. redo
ctrl+r

4. cut line
dd

5. cut from cursor to end of line
d$

6. cut from cursor to beg of line
d0

7. copy line
yy

8. copy n lines to end of file
nyy

9. copy to end of file
yG

--------------------------------------------------------------------------------------------------------------------------------------------------------
Samba Server
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. chmod -R 777

2. Then in /etc/samba/smb.conf at the bottom add

[library]
path = /usr/local/permuto/apps/shared/perl/
guest ok = yes
read only = no
public = yes

3. /etc/init.d/smb restart

--------------------------------------------------------------------------------------------------------------------------------------------------------
Compress/Decompress files
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. bunzip
bzip2 filename.txt -> will give filename.txt.bz2
bunzip2 filename.txt.bz2 -> will give filename.txt

2. zip
zip squash.zip file1 file2 file3
unzip squash.zip

--------------------------------------------------------------------------------------------------------------------------------------------------------
MySQL
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. Managing ibdata
innodb_file_per_table helps in disk space management, since DROP TABLE really removes the .ibd file, and frees the disk space to the operating system. As

you know, ibdata files never shrink.

2. Restart
/etc/init.d/mysqld restart

--------------------------------------------------------------------------------------------------------------------------------------------------------
Perl
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. Check if perl module is installed

perl -MNet::SSH::Per l -e 1

if not installed it cries else nothing


what are the special variables:
$_ , \$, @_, @INC,

what is anonymous hash and regular hash?

how to print arrays/hash elements
how to get the array of keys from hash ( keys(%hash) )

What is xss.

Tuesday, June 15, 2010

linux misc

1. Wamp server-
"ERROR - Show plugins"
cookie issue faced during the wamp server 2.0 mysql.

2.What is logrotate
- logrotate is designed to ease administration of systems that generate large numbers of log files. It allows automatic rotation, compression, removal, and mailing of log files. Each log file may be handled daily, weekly, monthly, or when it grows too large.
it runs as daily cron job.

"/var/log/httpd/access.log" /var/log/httpd/error.log {
rotate 5
mail www@my.org
size=100k
sharedscripts
postrotate
/sbin/killall -HUP httpd
endscript
}

3.On linux ntsysv command is used to show the run startup programs.
4.Host file on linux is "/etc/hosts"
- you can mention the domain name here and this domain then will be used to virtual host in httpd.conf file
5. The ^M character is identified by vi -b filename
6. linux svn export command
svn export --force --username=suchitb --password=cybag_4321 https://permuto.svn.cvsdude.com/permuto/trunk/tools /home/test/tools

7.exporting the enviroment variable
export DEV_HOME=/home/test
8.copy file to test box
scp -i .ssh/id_rsa cybage@test.pulsemgr.com:/home/cybage

9.ssh -i .ssh/id_rsa cybage@test.pulsemgr.com

10.tar command on linux
tar -cvzf permuto_admin_app.tar.gz permuto
11. Assign permissions to the apache
chown apache permuto
12. execute sql on command console
execute mysql -uroot < permuto_admin.sql

13. yum install php-mysql
14. /etc/init.d/httpd start
15./etc/httpd/conf/httpd.conf
16.mysqldump -uroot -ppassword permuto > permuto_09Apr09.sql
17.chmod a+w permuto
18.top command is used to show the running services on linux .
19.error regarding "Permissions 0655 for '/root/.ssh/id_rsa' are too open."
-solution is "chmod 0600 .id_rsa" ssh stopped complaining and I could ssh w/o entering a password. Happy ending.

MYSQL:
20.To get the mysql database size use
select SUM(data_length)/1024 from information_schema.tables where table_schema = 'permuto';
MYSQL:
21
1.mysqldump -h DBSERVER -u DBUSER -p DBNAME > DBNAME.sql
22. mysql dump exclude tables from database.
2.mysqldump -uroot --databases permuto --ignore-table=permuto.ad_templates --ignore-table=permuto.tab_menu >v.sql

23. for multiple rows in one record
SELECT city,
-> GROUP_CONCAT(DISTINCT first_name
-> ORDER BY city DESC SEPARATOR ' ')
-> FROM employee
-> GROUP BY city;

SELECT city,
-> GROUP_CONCAT(first_name)
-> FROM employee
-> GROUP BY city;

24. To change the db location to other drive
create db in mysql
move the /var/lib/mysql dbname to another location
change the permission to 755
change the owner ship to mysql:mysql (chown -R mysql:mysql permuto)
25 LInux:
df -h >>>>gives file system used space
du -h >> current folders size

26. Command to find large files on linux box
COMMAND -> find / -type f -size +1000000k -exec ls -lh {} \; | awk '{ print$NF ": " $5 }'
will give list of files like -> /usr/local/mysql/data/ibdata1: 23G

Monday, December 8, 2008

Linux commnads , rpm ,search

linux apache basics
http://www.alwanza.com/howto/linux/apache.html

Search command

find / -type f -name httpd

Apache installed on:

/usr/local/apache

http://hostlibrary.com/installing_apache_mysql_php_on_linux

apache2 and php5 (Mod_) :Installation:

http://dan.drydog.com/apache2php.html



"chcon libphp5.so -t shlib_t" changed to "chcon -t texrel_shlib_t libphp5.so" works

Installation Procedure:
http://www.php.net/manual/en/install.unix.php

which arhitecture belongs to your linux:i386 or x86_64
rpm -qa --qf "%{n}-%{arch}\n"


package details:
rpm -qi mysql

which package install with its details...
rpm -qa --qf "%{n}-%{v}-%{r}.%{arch}\n" | less


mysql runnig or not:
ps aux | grep [m]ysqld.

::::::::::::::::::::::::::
file transfer from window to linux
pscp ./php-5.2.5.tar.gz root@172.16.3.22:/usr/local/

from linux to linux

Where is php.ini defuault location in linux?

/etc/php.ini
/usr/local/lib/php.ini

How to Improve the site rank

1. Use Google Adwords to search for a general niche from a portal like website
2. Select a niche with Moderate Search and High Advertiser Competition
3. User Wordtracker to get search volumes for keywords
4. Use Google to find out competition for the keywords. Focus on low competition keywords (less than 10,000 competing results)
5. Build a blog(with your adsense codes) to get number 1 position in Search Engines

SEO --IM

http://search.msn.com/docs/submit.aspx?FORM=WSUT
http://www.dmoz.org/add.html
http://www.2createawebsite.com/traffic/search-engine-traffic.html
https://siteexplorer.search.yahoo.com/submit
http://www.2createawebsite.com/traffic/search-engine-traffic.html
http://www.2createawebsite.com/traffic/index.html


top bookmarking site
http://3spots.blogspot.com/2006/04/social-bookmark-tools-to-view-search.html
http://www.socialize-it.com/index.php?url=$URL&tag=$tag

http://www.ebizmba.com/articles/social30.html


backflip.com
bibsonomy.org
blinklist.com
blogmarks.net
faves.com
buddymarks.com
connectedy.com
de.lirio.us
del.icio.us
diigo.com
excites.com
feedmelinks.com
folkd.com
furl.net
google.com
linkagogo.com
linkroll.com
ma.gnolia.com
markaboo.com
mister-wong.com
mister-wong.cn
mister-wong.de
mister-wong.es
mister-wong.fr
mister-wong.ru
my.xilinus.com
myweb2.search.yahoo.com
netvouz.com
scuttle.org
scuttleplus.org
simpy.com
taggly.com

Sunday, December 7, 2008

Imp LInks

http://www.youtube.com/watch?v=Hb3-Qg9JjKw---------squidoo
http://www.youtube.com/results?search_query=affiliate&search=tag -------------affiliate

elite

http://www.youtube.com/watch?v=fLJskZNEIDY&mode=related&search=squidoo%20lens%20money%20affiliate%20marketing%20plr%20monetize%20monetizing%20tiffany%20dow [http://www.youtube.com/watch?v=fLJskZNEIDY]
http://www.youtube.com/watch?v=vyTkfIIdhf4

http://www.youtube.com/watch?v=J5WoejuePpk&mode=related&search=squidoo%20lens%20money%20affiliate%20marketing%20plr%20monetize%20monetizing%20tiffany%20dow


Perl FAQs:----------------------------------
http://en.allexperts.com/q/Perl-CGI-1045/
--------------------------------------------