1. Install wordpress from bluehost interface
2. Install the farsi patch from wp-persian.com
3. edit the wp-config-sample.php and remove the below:
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
Sunday, November 09, 2008
Sunday, October 05, 2008
mysql change database charset to unicode
SELECT concat('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as stmt
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'database_name'
ORDER BY 1
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'database_name'
ORDER BY 1
Friday, October 03, 2008
OLAT email problem
once you could not send emails and came accross this:
DEBUG: setDebug: JavaMail version 1.3
DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,gnu.mail.providers.smtp.SMTPTransport,nferrier@tapsellferrier.co.uk]
java.lang.NoSuchMethodException: gnu.mail.providers.smtp.SMTPTransport.(javax.mail.Session, javax.mail.URLName)
you should install java mail components, I installed:
geronimo-javamail-1.3.1-api-1.1-4jpp
sun-mail-1.4-3jpp
classpathx-mail-1.1.1-4jpp.2
And the problem was solved.
DEBUG: setDebug: JavaMail version 1.3
DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,gnu.mail.providers.smtp.SMTPTransport,nferrier@tapsellferrier.co.uk]
java.lang.NoSuchMethodException: gnu.mail.providers.smtp.SMTPTransport.
you should install java mail components, I installed:
geronimo-javamail-1.3.1-api-1.1-4jpp
sun-mail-1.4-3jpp
classpathx-mail-1.1.1-4jpp.2
And the problem was solved.
Tuesday, September 23, 2008
jdk installation
when installing jdk depenging on the version for JRE to work correctly as well
java-sun-compat
has to be installed too.
for example for jdk-6u6-linux-i586.rpm to work along with tomcat you need to install java-1.6.0-sun-compat-1.6.0.06-1jpp.i586.rpm as well, otherwise tomcat and the applications that need jre 1.5 upwards will not work.
java-sun-compat
has to be installed too.
for example for jdk-6u6-linux-i586.rpm to work along with tomcat you need to install java-1.6.0-sun-compat-1.6.0.06-1jpp.i586.rpm as well, otherwise tomcat and the applications that need jre 1.5 upwards will not work.
Friday, September 05, 2008
Strange Linux PPTP problem
When using Linux PPTP service web pages fail to load completely [freeze] (aka common PPTP MTU problem) all one has to do is to:
> cat /etc/ppp/ip-up.local
#!/bin/bash
/sbin/ifconfig $1 mtu 1400
> cat /etc/ppp/ip-up.local
#!/bin/bash
/sbin/ifconfig $1 mtu 1400
Thursday, September 04, 2008
Tor problem
When Tor can not connect the first thing you do is to check the date/time of your machine!
Friday, August 01, 2008
Jalali Date - Javascript
Jalali date in java script as active desktop element
it can be downloaded from:
http://sites.google.com/site/alisade/Home/fdate.zip?attredirects=0
it can be downloaded from:
http://sites.google.com/site/alisade/Home/fdate.zip?attredirects=0
Sunday, July 06, 2008
a simple bash prompt PS1
export PS1="\[\e[32;1m\]\d \t\[\e[36;1m\]\n\u@\h\n\[\e[31;1m\]\w > \[\e[0m\]"
Thursday, June 12, 2008
openvpn config parameter seems compulsory
Although I used to do openvpn TLS without the "tls-auth ta.key 0" directive for years, now it looks like it has become compulsory, otherwise handshake will not occcur completely although the first
TLS: Initial packet from xxx.xx.xx.xx:1194, sid=42fb5c72 1f286ab1
is exchanged with no problems
TLS: Initial packet from xxx.xx.xx.xx:1194, sid=42fb5c72 1f286ab1
is exchanged with no problems
Saturday, June 07, 2008
linux disable single user mode
do not try to disable the single user mode instead use a grub password.
Monday, May 19, 2008
Join a computer to windows 2003 domain
When joining a computer to a windows 2003 box remember to add the .com at the end of the domain name otherwise the dns will not find the SRV record of the domain name
Monday, March 31, 2008
free totally legal Nastaliq font by http://www.scict.ir/
http://www.box.net/shared/bh9ioqs2ss originally from http://www.scict.ir/
Sunday, March 16, 2008
command line download accelerator for windows
AXEL is a command line accelerator for the *nix, I have compiled it under cygwin and have put it here:
http://www.box.net/shared/avraot95w8
Enjoy!
http://www.box.net/shared/avraot95w8
Enjoy!
Saturday, March 15, 2008
Tuesday, March 11, 2008
red hat root login in telnet,...
edit /etc/pam.d/login and /etc/pam.d/remote and
comment out
auth required pam_securetty.so
comment out
auth required pam_securetty.so
Monday, March 03, 2008
crontab does not accept
crontab does not accept commands with `command to execute` within command line
Saturday, March 01, 2008
Wednesday, February 27, 2008
Error: Can't open Display
although you do an xhost + still you cannot do an xclock so:
on the machine connecting to the other do a
vi /etc/X11/gdm/gdm.com
DisallowTCP=false
** REMEMBER to check iptables
on the machine connecting to the other do a
vi /etc/X11/gdm/gdm.com
DisallowTCP=false
** REMEMBER to check iptables
Tuesday, February 26, 2008
Sunday, February 24, 2008
Oracle Move from one computer/directory to another
1. Edit and replace paths in
/etc/oratab
/etc/rc.d/rc5.d/S99zzoracle_orasid
/etc/rc.d/init.d/orastop_orasid
/etc/rc.d/init.d/listener_orasid
/etc/rc.d/init.d/orastart_orasid
/etc/rc.d/rc6.d/K10zzoracle_orasid
/etc/rc.d/rc0.d/K10zzoracle_orasid
/etc/rc.d/rc3.d/S99zzoracle_orasid
/etc/rc.d/rc1.d/K10zzoracle_orasid
/etc/oraInst.loc
2. Edit and replace paths in
listener.ora tnsnames.ora
3. login as sys as sysdba (listener must be on and database mounted)
create pfile='/apps/oracle/OraHome1/dbs/initorasid.ora' from spfile='/apps/oracle/OraHome1/dbs/spfileorasid.ora'
4. Edit /apps/oracle/OraHome1/dbs/initorasid.ora and change paths
5. Now do the reverse
create spfile='/apps/oracle/OraHome1/dbs/spfileorasid.ora' from pfile='/apps/oracle/OraHome1/dbs/initorasid.ora'
6. The last step is to alter internal files names:
alter database rename file '/home/gf_admin/oradata/gftt/control01.ctl' to '/apps/gf_admin/oradata/gftt/control01.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/control02.ctl' to '/apps/gf_admin/oradata/gftt/control02.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/control03.ctl' to '/apps/gf_admin/oradata/gftt/control03.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/redo01.log' to '/apps/gf_admin/oradata/gftt/redo01.log';
alter database rename file '/home/gf_admin/oradata/gftt/redo02.log' to '/apps/gf_admin/oradata/gftt/redo02.log';
alter database rename file '/home/gf_admin/oradata/gftt/redo03.log' to '/apps/gf_admin/oradata/gftt/redo03.log';
alter database rename file '/home/gf_admin/oradata/gftt/system.dbf' to '/apps/gf_admin/oradata/gftt/system.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/temp.dbf' to '/apps/gf_admin/oradata/gftt/temp.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/tsdata.dbf' to '/apps/gf_admin/oradata/gftt/tsdata.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/tsindex.dbf' to '/apps/gf_admin/oradata/gftt/tsindex.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/undotbs.dbf' to '/apps/gf_admin/oradata/gftt/undotbs.dbf';
/etc/oratab
/etc/rc.d/rc5.d/S99zzoracle_orasid
/etc/rc.d/init.d/orastop_orasid
/etc/rc.d/init.d/listener_orasid
/etc/rc.d/init.d/orastart_orasid
/etc/rc.d/rc6.d/K10zzoracle_orasid
/etc/rc.d/rc0.d/K10zzoracle_orasid
/etc/rc.d/rc3.d/S99zzoracle_orasid
/etc/rc.d/rc1.d/K10zzoracle_orasid
/etc/oraInst.loc
2. Edit and replace paths in
listener.ora tnsnames.ora
3. login as sys as sysdba (listener must be on and database mounted)
create pfile='/apps/oracle/OraHome1/dbs/initorasid.ora' from spfile='/apps/oracle/OraHome1/dbs/spfileorasid.ora'
4. Edit /apps/oracle/OraHome1/dbs/initorasid.ora and change paths
5. Now do the reverse
create spfile='/apps/oracle/OraHome1/dbs/spfileorasid.ora' from pfile='/apps/oracle/OraHome1/dbs/initorasid.ora'
6. The last step is to alter internal files names:
alter database rename file '/home/gf_admin/oradata/gftt/control01.ctl' to '/apps/gf_admin/oradata/gftt/control01.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/control02.ctl' to '/apps/gf_admin/oradata/gftt/control02.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/control03.ctl' to '/apps/gf_admin/oradata/gftt/control03.ctl';
alter database rename file '/home/gf_admin/oradata/gftt/redo01.log' to '/apps/gf_admin/oradata/gftt/redo01.log';
alter database rename file '/home/gf_admin/oradata/gftt/redo02.log' to '/apps/gf_admin/oradata/gftt/redo02.log';
alter database rename file '/home/gf_admin/oradata/gftt/redo03.log' to '/apps/gf_admin/oradata/gftt/redo03.log';
alter database rename file '/home/gf_admin/oradata/gftt/system.dbf' to '/apps/gf_admin/oradata/gftt/system.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/temp.dbf' to '/apps/gf_admin/oradata/gftt/temp.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/tsdata.dbf' to '/apps/gf_admin/oradata/gftt/tsdata.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/tsindex.dbf' to '/apps/gf_admin/oradata/gftt/tsindex.dbf';
alter database rename file '/home/gf_admin/oradata/gftt/undotbs.dbf' to '/apps/gf_admin/oradata/gftt/undotbs.dbf';
Subscribe to:
Posts (Atom)