.... အားလံုးအတြက္ မဟုတ္ခဲ့ရင္ေတာင္ တစ္စံုတစ္ရာ တစ္စံုတစ္ေယာက္အတြက္ ေႏြးေထြးတဲ့ ေကာင္းကင္ငယ္ေလး ျဖစ္ပါရေစ ....
Showing posts with label apache. Show all posts
Showing posts with label apache. Show all posts

Tuesday, January 1, 2013

Temporary failure in name resolution: mod_unique_id: unable to find IPv4 address of "YOURDOMAIN"


ဒီလိုမ်ိဲဳးျဖစ္တာကိုတစ္ခါတစ္ရံၾကံဳရမွာပါ

[XXX@XXXXX ~]# tail  /var/log/httpd/error_log -F
Configuration Failed
[Wed Jan 02 13:48:55 2013] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Jan 02 13:48:55 2013] [alert] (EAI 3)Temporary failure in name resolution: mod_unique_id: unable to find IPv4 address of "YOURDOMAIN"
Configuration Failed
[Wed Jan 02 13:48:56 2013] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Jan 02 13:48:56 2013] [alert] (EAI 3)Temporary failure in name resolution: mod_unique_id: unable to find IPv4 address of "YOURDOMAIN"
Configuration Failed
[Wed Jan 02 13:49:23 2013] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Jan 02 13:49:23 2013] [alert] (EAI 3)Temporary failure in name resolution: mod_unique_id: unable to find IPv4 address of "YOURDOMAIN"
Configuration Failed

အရင္ဆံုး ေအာက္က ကြန္မန္းနဲ႔ ဘာေပးလည္းဆိုတာၾကည့္လိုက္ပါ
# hostname
ျပီးရင္ ဒီေနရာမွာသြားစစ္ျပီး မရွိေသးရင္ထည့္ေပးလိုက္ပါ
#cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
11.22.33.44 YOURHOSTNAME WWW.YOURHOSTNAME

ခုလိုမ်ိဳးေပါ့ .. အဲဒါျပိးရင္ေတာ့
# /etc/init.d/httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                              [  OK  ]

အားလ့ုးအဆင္ေျပပါေစ

Friday, December 14, 2012

Sql-Database Import to phpMyadmin fix error -> maximun limit && Script timeout passed, if you want to finish import, please resubmit same file and import will resume

ဒီတစ္ခါကေတာ့ ကၽြန္ေတာ္တို႔ phpMyadmin  မွာ database-Sqlကို import လုပ္တဲ့အခါ upload limit ကိုေက်ာ္သြားနိုင္ေလာက္တဲ့ MB အထိျဖစ္ေနလို႔ ခြင့္မျပဳနုိင္တဲ့ Error ေလးပါ . ကၽြန္ေတာ္တင္ခ်င္တာက 200MB ဗ်ာ .. ဒါေပမယ့္ သူ႔ Default သက္မွတ္ထားတာက 2MB ထဲဗ် .... အဲ့ဒါကို ျပင္ေပးနိုင္မွ အဆင္ေျပမွာပါ . ကဲျပင္ၾကည့္ရေအာင္ .. Apahce ရဲ႕ php.ini ဖိုင္က ဒီေနရာေလးေတြမွာ ျပင္မယ္ ..

upload_max_filesize=2M
post_max_size=2M
memory_limit=128M (လိုအပ္မွ ဒီလစ္မစ္ကိုေျပာင္းပါ ကၽြန္ေတာ္ကေတာ့ မေျပာင္းဘူး ( ^ _^ )

အခုလိုမ်ိဳးေျပာင္းေပးလိုက္မယ္ ..

upload_max_filesize=300M
post_max_size=300M
memory_limit=910M

ျပီးရင္ လုပ္ေနက်အတိုင္း
/etc/init.d/mysqld restart OR service mysqld restart
/etc/init.d/httpd restart OR service httpd restart ေပါ့ဗ်ာ ..

ေအာ္ ေနာ္ကတစ္ခုရွိေသးတယ္ဗ် .. ကၽြန္ေတာ္တို ခုလို import လုပ္္တဲ့အခါမွာ အခ်ိန္ဆိုတာပါေသးတယ္ဗ် .. သူက upload time limit လို႔ပဲေျပာရမလားမသိဘူး ..ခုလို 200MB ေလာက္ ထည့္တဲ့အခါက်ေတာ့ အခ်ိန္က အနည္းဆံုး ၈ မိနစ္ေလာက္သြားၾကာတယ္ဆိုေတာ့ လက္မခံေတာ့ဘူး ဆာဗာက . အဲဒီအခ်ိန္

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

ဒီလို Error mesage ေလးေပးတတ္ပါတယ္ ..စိတ္မပူပါနဲ႔ အဲဒါလည္းရွင္းၾကည့္ၾကမယ္ ..ေအာက္မွာပါ ..
php.ini ထဲက ဒီအခ်ိန္ေလးကိုျပင္မယ္ ..
max_execution_time=6000

ျပီးေတာ့ phpMyAdmin ရဲ႕ config.default.php (phpMyAdmin\libraries\config.default.php) ထဲက ဒီအခ်ိန္ကန္႔သက္ခ်က္ကိုလည္းျပင္ေပးမယ္

$cfg['ExecTimeLimit'] = 300 -- ကို
$cfg['ExecTimeLimit'] = 0 (0 ဆိုတာကေတာ့ No Limit ) ကိုေျပာတာပါ

ေအာက္ကလိုေလးျဖစ္သြားမွာေပါ့

/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 0;

ျပီးရင္ လုပ္ေနက်အတိုင္း

/etc/init.d/httpd restart OR service httpd restart
/etc/init.d/mysqld restart OR service mysqld restart ေပါ့ဗ်ာ ..
ဒီေနရာမွာ sql ကိုပါ restart  လုပ္ေပးရမယ္ေနာ္ .. သူ႔ကိုျပင္ထားတာဆိုေတာ့ .. အားလံုးအဆင္ေျပပါေစ

Monday, November 26, 2012

No space left on device: Couldn't create accept lock (/etc/httpd/logs/accept.lock.xxxx) Error in apache {start/stop/restart}

တစ္ခါဗ်ာ ..ကၽြန္ေတာ္တို႔ ေအာက္ကလိုမ်ိဳးအဲယာေတြ ေျပာျပိးေတာ ့ရန္းေနတဲ့ Apache က ရပ္လိုမရေတာ့ဘူး .. အဲဒီအခါမ်ိုးဆိုရင္ လြယ္ပါတယ္ .. ေအာက္ကလိုမ်ိဳးတစ္ေၾကာင္းတည္းေသာ ကြန္းမန္႔ေလးနဲ႔ အဆင္ေျပနိုင္ၾကပါေစ .. (ခုမွ လြယ္တာ ..ျဖစ္တုန္းက ဘာမွန္းကိုမသိလို ရြာပ်က္ေနတယ္ ((^ _ ^))
======================= ။ ==============================
tail -f /var/log/httpd/error_log
[Sat Nov 24 21:21:16 2012] [notice] Digest: done
[Sat Nov 24 21:21:16 2012] [warn] mod_wsgi: Compiled for Python/2.6.2.
[Sat Nov 24 21:21:16 2012] [warn] mod_wsgi: Runtime using Python/2.6.6.
[Sat Nov 24 21:21:16 2012] [emerg] (28)No space left on device: Couldn't create accept lock (/etc/httpd/logs/accept.lock.22001) (5)
[Sat Nov 24 21:21:59 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Nov 24 21:21:59 2012] [notice] Digest: generating secret for digest authentication ...
[Sat Nov 24 21:21:59 2012] [notice] Digest: done
[Sat Nov 24 21:21:59 2012] [warn] mod_wsgi: Compiled for Python/2.6.2.
[Sat Nov 24 21:21:59 2012] [warn] mod_wsgi: Runtime using Python/2.6.6.
[Sat Nov 24 21:21:59 2012] [emerg] (28)No space left on device: Couldn't create accept lock (/etc/httpd/logs/accept.lock.22017) (5)
=================== This Error ============================

ဒီကြန္မန္းေလးကေတာ့ အေျဖကိုေကာင္းေအာင္ျပင္ေပးမွာပါ  --->>

ipcs -s | grep apache | awk ' { print $2 } ' | xargs ipcrm sem

Sunday, August 26, 2012

MySql Master to Master Replication on CentOS


ဒါကေတာ့ sql replication ကို master to master လုပ္မွာျဖစ္ပါတယ္ . နမူနာအေနနဲ႔ ဆာဗာ ၁ နဲ႔ ၂ ဆိုျပီး စမ္းလုပ္ၾကည့္ရေအာင္

Master 1 IP Address : 172.168.0.1
Master 2 IP Address: 172.168.0.2
Database to replicate: db1, db2, and db3

ဒီနမူနာကို စမ္းမယ္သူအေနနဲ႔ လိုအပ္တဲ့ SQL ကိုသြင္းျပီးသားျဖစ္ေနေလာက္မွာပါ .. မရွိေသးရင္လည္းသြင္းလိုက္ျပီး ပါတ္စ္၀ါဒ့္တစ္ခါတည္းသက္မွတ္ေပးလိုက္ပါ ..

#yum install mysql mysql-server
#mysqladmin -u root password new_mysql_password

ေအာက္ကအဆင့္ေတြကေတာ့ ဆာဗာ ၂ ခုလံုးမွာ လုပ္မွာပါ .. ဆာဗာ ၁ ဆိုရင္ ဆာဗာ ၁ မွာ သံုးမယ့္ ကြန္မန္းလိုင္းေတြျဖစ္ျပီး ဆာဗာ ၂ ဆိုရင္ေတာ့  ၂ေအာက္မွာသံုးမွာပါ ..
ပထမဆံုးအေနနဲ႔ ဆာဗာ ၂ ခုလံုးရဲ႕ /var/log ေအာက္မွာ mysql ကိုတည္ေဆာက္ေပးျပီး owner ကိုလည္း mysql ဆိုျပီး ခ်ိန္းေပးထားလိုက္ပါ

#mkdir /var/log/mysql
#chown apache:apache /var/log/mysql

ွခု ဆာဗာ ၁ ကေနစရေအာင္
sql ထဲ၀င္မယ္ ျပီးရင္ေအာက္ကအတိုင္းဆက္သြားလိုက္မယ္ ကြန္မန္႔ေတြ ဖတ္ရင္ သံုးရင္းနားလည္လိမ့္မယ္ထင္လို႔ တစ္ခုခ်င္းမရွင္းေတာ့ပါဘူး .. လိုအပ္ရင္ေတာ့ ျပန္ေမးလို႔ရပါတယ္ .. ( ^_^ )..
#mysql -u root -p
Enter Password:
mysql> CREATE USER 'slave_user'@'172.168.0.2' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'172.168.0.2' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;

ဆာဗာ ၂ မွာလည္း အလားတူပဲသက္မွတ္ပါ့မယ္ ..

#mysql -u root -p
Enter Password:
mysql> CREATE USER 'slave_user'@'172.168.0.1' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'172.168.0.1' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;

ဒါဆိုရင္ မာစတာအတြက္ လိုအပ္တာေတြျပင္ျပီးပါျပိ ခု SLAVE အတြက္ လုပ္ပါ့မယ္ .. အဲဒါမတိုင္ခင္ sql config အရင္လုပ္ပါမယ္ . လုပ္မယ့္ ေနရာကေတာ့ /etc/my.cnf ဆိုတဲ့ configuration မွာပါ ..

ဆာဗာ ၁ ရဲ႕ /etc/my.cnf မွာေအာက္ကအတို္င္းထည့္ေပးမယ္.

server-id = 1
master-host =172.168.0.2
master-user = slave_user
master-password = password
master-connect-retry = 60
slave-net-timeout = 60
replicate-do-db = db1
replicate-do-db = db2
replicate-do-db = db3

log-bin = /var/log/mysql/mysql-bin.log
log-bin-index = /var/log/mysql/master-log-bin.index
binlog-do-db = db1
binlog-do-db = db2
binlog-do-db = db3

relay-log = /var/lib/mysqld-relay-bin
relay-log = /var/lib/mysql/slave-relay.log
relay-log-index = /var/lib/mysql/slave-relay-log.index

ဒီေအာက္ကေတာ့ ဆာဗာ ၂ ရဲ႕ /etc/my.cnf  အထဲမွာ ထည့္မွာပါ

Tuesday, August 14, 2012

Apache http.config ဖိုင္အားျပင္ဆင္ၾကည့္ျခင္း


http.config
http apache ကိုစတင္ျပီအလုပ္လုပ္ေတာ့မယ္ဆိုရင္ 
/etc/init.d/httpd restart|start|stop|status

သူနဲ႔ပတ္သက္တဲ့ အဲယာေတြ လိုအပ္ခ်က္ေတြကိုၾကည့္မယ္ဆိုရင္
tail /var/log/http/error_log
tail /var/log/http/access_log

မိမိဘယ္အိုင္ပီကိုသံုးျပီး အြန္မလည္းဆိုတာကိုေျပာင္းရန္
Listen 80 သာထားရန္

ServerAdmin မိမိအက္ဒမင္လုပ္မည့္နာမည္ေျပာင္းရန္

ServerName  ေျပာင္းရန္
ServerName www.xxxxx.com.mm:80

မိမိဘယ္အရာကိုသံုးေနတယ္ဆိုတာကို မေဖၚျပနိုင္ေစရန္အတြက္
#ServerTAken OS
ServerTokens Prod
ServerSignature off

အမ်ားဆံုးလက္ခံနိုင္မည့္ ေတာင္းခံႏိုင္မူ
MaxKeepAliveRequests 100 Or 1000 (ၾကိဳက္ႏွစ္သက္ရာ)

http enter step ပတ္စ္၀ါဒ့္ခံထားရန္အတြက္
<Directory "/var/www/html"> ေအာက္တြင္ ေအာက္ပါအတိုင္းထည့္
Authtype Basic
AuthName "Authentication Required"
AuthUserFile "/var/www/.htpasswd"
Require valid-user
ျပီးရင္ /var/www ေအာက္မွာ touch htpasswd ဆိုျပီးေဆာက္ပါ.ျပီးရင္

Sunday, August 12, 2012

Not Found The request UR/XXX was not found on this server ျပဳလုပ္ရန္

မိမိ Site တြင္ မရွိသည့္အေၾကာင္းအရာကို xxxx.com.mm/XXX ရွာေဖြျပိး၀င္လာလွ်င္


့Not Found
The request UR/XXX was not found on this server
ဆိုျပိး မိမိဆိုက္တြင္ေပၚေစခ်င္လွ်င္
ErrorDocument မ်ားတြင္ ရွာေဖြျပီး ကြန္မန္႔ကိုျဖဳတ္ေပးရန္

#    ErrorDocument 400 /error/HTTP_BAD_REQUEST.html.var
#    ErrorDocument 401 /error/HTTP_UNAUTHORIZED.html.var
#    ErrorDocument 403 /error/HTTP_FORBIDDEN.html.var
#    ErrorDocument 404 /error/HTTP_NOT_FOUND.html.var
#    ErrorDocument 405 /error/HTTP_METHOD_NOT_ALLOWED.html.var
#    ErrorDocument 408 /error/HTTP_REQUEST_TIME_OUT.html.var
#    ErrorDocument 410 /error/HTTP_GONE.html.var
#    ErrorDocument 411 /error/HTTP_LENGTH_REQUIRED.html.var
#    ErrorDocument 412 /error/HTTP_PRECONDITION_FAILED.html.var
#    ErrorDocument 413 /error/HTTP_REQUEST_ENTITY_TOO_LARGE.html.var
#    ErrorDocument 414 /error/HTTP_REQUEST_URI_TOO_LARGE.html.var
#    ErrorDocument 415 /error/HTTP_UNSUPPORTED_MEDIA_TYPE.html.var
#    ErrorDocument 500 /error/HTTP_INTERNAL_SERVER_ERROR.html.var
#    ErrorDocument 501 /error/HTTP_NOT_IMPLEMENTED.html.var


Saturday, July 28, 2012

Infinited loopback error IN JOOMLA WITH APACHE


APACHE AND JOOMLA မွာ Infinited loopbak error in JError ဒီလိုမ်ိုးအဲယာတက္ျပီး sitepages ကုိေခာ္မရျဖစ္ေနတတ္ပါတယ္.
အဲဒီအခါမ်ိုးဆိုရင္ သက္ဆိုင္ရာ /var/www/html ေအာက္က admin & site page dir ေတြကို permission & owner change pay lite par

chmod 755 /your's site dir/configuration.php 
chown apache:apache /your's site dir/configuration.php

ျပီးရင္ ျပန္ေခာ္ျကည့္ပါ ..  http://Yor's site/ ...
အဆင္ေျပနုိင္ျကပါေစ.