Love Coding

MySQL error 1093 You can't specify target table

2012-01-16T18:51:00.000+07:00

SQL: Before google DELETE FROM category WHERE id IN ( SELECT c.id as id FROM category c LEFT JOIN category_translation t ON c.id = t.id GROUP BY c.id HAVING COUNT(t.lang) = 0) ); --> error After google DELETE FROM category WHERE id IN ( SELECT id FROM ( SELECT c.id as id FROM category c LEFT JOIN category_translation t ON c.id = t.id GROUP BY c.id HAVING COUNT(t.lang) = 0) ) tblId

Test Soap Server with cURL command

2012-01-14T20:28:00.001+07:00

Linux cd /root/huypv vim soap-request.xml (Don't know how to create soap request content: try use SoapUI) <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetWeather xmlns="http://www.webserviceX.NET"> <CityName>

try catch finnaly in java

2012-01-14T00:26:00.000+07:00

Do you know that: try { System.out.println("First"); return true; // still call code statement in finnaly block before return! } catch (Exception e) { System.out.println("Exception"); }finnaly { System.out.println("Second, then return!!!"); }

PHP get first and last day of week

2012-01-10T23:25:00.000+07:00

Mon Tue Wed Thu Fri Sat Sun <!--?php $str = date('Y-m-d'); $iStr = strtotime($str); $n = date('N', $iStr);#Mon = 1, Sun = 7 $d1 = $n - 1; $d2 = 7 - $n; # monday in week $mon = date('Y-m-d', strtotime("-$d1 days", $iStr)); # sunday in week $sun = date('Y-m-d', strtotime("+$d2 days", $iStr)); var_dump($mon, $sun);

Config gossip (private)

2012-01-06T17:43:00.000+07:00

[root@localhost huypv]# find . -iname "*.cfg" | xargs grep 10.72.87.37 [root@localhost huypv]# find . -iname "*.conf" | xargs grep 10.72.87.37 Cấu hình phân tải cho gossip thì phải có IP và port. Lấy thông tin IP và port từ initialHosts ở các file agent.cfg

My note for I18N Symfony Doctrine

2012-01-06T17:39:00.000+07:00

Truy cập vào URL1 -> xác định được id -> Article -> có ArtitlceTranslation tương ứng với culture hiện tại không -> xác định được category_id -> category_id -> có CategoryTranslation tương ứng với culture hiện tại không Khi bài viết không có bản dịch ở ngôn ngữ L1 thì tên bài viết sẽ được lấy mặc định theo ngôn ngữ sf_default_culture (en) sfContext::getInstance()->getUser()->setCulture('

Symfony Application Change default culture

2012-01-05T19:01:00.000+07:00

apps/frontend/config/settings.yml all: .settings: defaut_culture: vi Article (I18N: name, body) In action: $article = ArticleTable::getInstance()->find(1987); if ($article !== false) { $this->getUser()->setCulture($unknownLang); $name = $article->getName(); # will return $vietnameseName (I am using Diem CMF; check function getI18nFallback in file dmDoctrineRecord.php) $

symfony form setDefault for choice

2012-01-05T18:52:00.002+07:00

$gender = array(0 => 'Female', 1 => 'Male'); $this->widgetSchema['gender'] = new sfWidgetFormChoice(array('choices' => $gender)) ; $this->setDefault('gender', 1);

scp, ssh and rsync without prompting for password

2012-01-04T00:20:00.002+07:00

#On my pc (local) ssh-keygen -t rsa cd scp .ssh/id_rsa.pub root@server:/root/ #On my server cd /root cat id_rsa.pub >>/root/.ssh/authorized_keys chmod 700 /root/.ssh/authorized_keys vim /etc/ssh/sshd_config --> Config: PermitRootLogin yes /etc/init.d/sshd restart #On my pc ssh root@server --> enjoy # Bonus rsync command with include rsync -e ssh -arv --delete --include="/uploads/" --include

Ping public IP fail

2012-01-04T00:01:00.000+07:00

Server with 2 ethernet card: eth0 - private ip:10.72.134.34 eth1 - public ip: 123.72.134.34 ping 123.72.134.35 ok ping 123.72.134.34 Request timed out Check default gateway (10.72.134.33 should be replaced by 123.72.134.33, example) Change by route command: ?

Command route slow

2012-01-03T23:52:00.001+07:00

# Server 1: 10.72.13.34, run route very fast route # Server 2: 10.72.13.35, run route very slow route compare file contents: /etc/resolver.conf

HAProxy forward IP for each request

2012-01-03T23:49:00.000+07:00

HAProxy 1.4 #/etc/haproxy.cfg option http-server-close option forwardfor Haproxy 1.4 introduced a new mode with "option http-server-close". It still closed the connection to the server but maintains keep-alive towards the client if possible and used. On most setups, you probably want to use that as it helps with latency on the single high-latency part of your connection (between Haproxy and

Build MySQL 5.5 from source

2011-12-27T23:18:00.002+07:00

#yum install cmake #yum install gcc-c++ #yum install bison # Preconfiguration setup groupadd mysql useradd -r -g mysql mysql # Beginning of source-build specific instructions tar zxvf mysql-5.5.18.tar.gz cd mysql-5.5.18 cmake . make make install # End of source-build specific instructions # Postinstallation setup cd /usr/local/mysql chown -R mysql . chgrp -R mysql . scripts/mysql_install_db --

Cấp phát IP

2011-12-23T23:26:00.001+07:00

10.85.133.32/27 Subnest Mask: 255.255.255.224 IP có thể dùng: 10.85.133.33 đến 10.85.133.62 (bỏ 32; 63) http://www.subnet-calculator.com/cidr.php Ở router, thay vì 8 câu lệnh: # Khi request (ping, HTTP...) từ router tới IP 66.100.50.1; 66.100.50.2; ...; 66.100.50.31 hãy sử dụng gateway 194.1.1.1 ip route 66.100.50.0 255.255.255.224 194.1.1.1 # Khi request (ping, HTTP...) từ router tới IP

Centos Configure NFS on Linux

2011-12-22T21:58:00.002+07:00

# Data storage server: /home/nfs/storage # IP: 10.10.10.87 vim /etc/exports /home/nfs/storage 10.10.10.0/24(rw,sync) ==> export /home/nfs/storage directory for network 10.10.10.0 with netmask 255.255.255.0 with read write permissions and synchronized mode. /etc/init.d/nfs restart # Config ip tables # vim /etc/sysconfig/iptables-config -A RH-Firewall-1-INPUT -p tcp -m state --state NEW -m tcp

Symfony Doctrine connect to Oracle

2011-12-21T21:26:00.002+07:00

# NOT TEST! all: opacstat: class: sfDoctrineDatabase param: dsn: 'oracle:dbname=//server_address:1521/SID' username: xxx password: xxxx

Symfony Get current route name

2011-12-16T21:20:00.000+07:00

$routing = sfContext::getInstance()->getRouting();$rule = $routing->getCurrentRouteName();#'@' . $rule

Symfony Default filter

2011-12-16T21:18:00.000+07:00

You can add in myclassGeneratorConfiguration class that is in myproject/apps/backend/modules/mymodule/lib folder a method to set filter defaults: public function getFilterDefaults() { return array('groups' => array('text' => 'news')); }

Linux command developer enter

2011-12-14T00:31:00.000+07:00

# Tìm tất cả các file có đuôi là conf, nội dung file có chứa xâu '192.168.1.3' find . -iname '*conf' | xargs grep '192.168.1.3' # Nén thư mục cd /var/www/html/ zip -r huypv.net.zip huypv.net # Giải nén thư mục cd /var/www/html/ unzip huypv.net.zip # Giải nén ra một thư mục xác định unzip huypv.net.zip -d /srv/www/html # cd /srv/www/html/huypv.net # VIM # Về đầu file: gg # Tới cuối file: G

symfony backend routing link to frontend

2011-12-09T23:51:00.000+07:00

http://www.symfony-project.org/cookbook/1_2/en/cross-application-links // apps/backend/config/backendConfiguration.class.php class backendConfiguration extends sfApplicationConfiguration { protected $frontendRouting = null; public function generateFrontendUrl($name, $parameters = array()) { return 'http://frontend.example.com'.$this->getFrontendRouting()->generate($name, $parameters

Perfomance - Config Apache, MySQL

2011-11-11T22:31:00.001+07:00

Config Apache MaxClients - MySQL MaxConnections - Example Total RAM System usage Free RAM 1 Apache & MySQL MaxClients - Apache MaxConnections - MySQL

MySQL - select is very slow

2011-11-11T21:36:00.000+07:00

column msisdn - VARCHAR(14) SELECT * FROM sv.subscriber WHERE msisdn='84975292582'; # 6s EXPLAIN SELECT * FROM sv.subscriber WHERE msisdn='84975292582'; => type = ALL, rows = 2000475 # Create index ALTER TABLE `sv`.`subscriber` ADD INDEX `idx_msisdn`(`msisdn`); EXPLAIN SELECT * FROM sv.subscriber WHERE msisdn='84975292582'; => type = REF, key=idx_msisdn, rows = 1 SELECT * FROM sv.subscriber

MySQL max int

2011-11-11T21:35:00.000+07:00

from MySQL: The maximum value of an integer SELECT ~0 as max_bigint_unsigned , ~0 >> 32 AS max_int_unsigned , ~0 >> 40 AS max_mediumint_unsigned , ~0 >> 48 AS max_smallint_unsigned , ~0 >> 56 AS max_tinyint_unsigned , ~0 >> 1 AS max_bigint_signed , ~0 >> 33 AS max_int_signed , ~0 >> 41 AS max_mediumint_signed , ~0 >> 49 AS max_smallint_signed , ~0 >>

Lighttpd - Install Mod-h264-Streaming

2011-11-04T21:08:00.000+07:00

http://www.wowtutorial.org/linux-servers/how-install-mod-h264-streaming-lighttpd-web-server-332.html

cURL - Use socks 5 as proxy

2011-11-04T18:05:00.000+07:00

Command line: D:\curl\curl.exe --socks5-hostname 127.0.0.1:1080 http://client.huypv.net/uploads/contents/1388/songoku/face.bin -o face.bin PHP code: $cUrl = curl_init(); curl_setopt($cUrl, CURLOPT_URL, $url); curl_setopt($cUrl, CURLOPT_RETURNTRANSFER, 1); $proxy = '127.0.0.1:1080'; curl_setopt($cUrl, CURLOPT_PROXY, $proxy); curl_setopt($cUrl, CURLOPT_PROXYTYPE, CURLPROXY_SOCKS5); #curl_setopt($