6/06/2014

Error: Package: google-chrome-stable-XXXXXXX.x86_64 (google-chrome) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

When you install chrome on centos, you may require to install : libstdc++.so.6(GLIBCXX_3.4.15)(64bit).









The error may be like:
Error: Package: google-chrome-stable-35.0.1916.114-1.x86_64 (google-chrome)
           Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)

Now you may try to install chromium compiled for centos.


1. Download
    wget http://people.centos.org/hughesjr/chromium/6/x86_64/RPMS/chromium-31.0.1650.63-2.el6.x86_64.rpm

2.install
   rpm -ivh chromium-31.0.1650.63-2.el6.x86_64.rpm




Now you may use chrome on your centos.

6/05/2014

MYSQL Unix time stamp conversion

When you want to convert the time stamp on mysql, please use the following code

1. time stamp to time
select FROM_UNIXTIME(1425933810);
+---------------------------+
| FROM_UNIXTIME(1425933810) |
+---------------------------+
| 2015-03-10 05:43:30       |
+---------------------------+
1 row in set (0.00 sec)

2. time to time stamp

select UNIX_TIMESTAMP('2015-11-06 10:10:10');
+---------------------------------------+
| UNIX_TIMESTAMP('2015-11-06 10:10:10') |
+---------------------------------------+
|                            1446772210 |
+---------------------------------------+
1 row in set (0.00 sec)

5/13/2014

configure SVN server

Install
 # yum install mod_dav_svn subversion

Configure Apache
  #vi /etc/httpd/conf/httpd.conf

  LoadModule dav_module modules/mod_dav.so

Configure subversion
 # vi /etc/httpd/cond.d/subversion.conf


LoadModule dav_svn_module     /usr/lib/httpd/modules/mod_dav_svn.so
LoadModule authz_svn_module   /usr/lib/httpd/modules/mod_authz_svn.so
...

   DAV svn
   SVNParentPath /home/svn
< Location /repos>
   DAV svn
   SVNParentPath /home/svn
#
#   # Limit write permission to list of valid users.
#   < LimitExcept GET PROPFIND OPTIONS REPORT>
#      # Require SSL connection for password protection.
#      # SSLRequireSSL
#
#      AuthType Basic
#      AuthName "Authorization Realm"
#      AuthUserFile /path/to/passwdfile
#      Require valid-user

#
#       
#     Order Deny,Allow
#        Deny from all
#      Allow from 192.168.  

#
#  < /LimitExcept>
< /Location>  

 

Create repos
# mkdir /home/svn
# svnadmin create /home/svn/Test
# chown -R apache:apache /home/svn/Test

Restart the apache
 # service httpd reload

Note:
SVNPath: for single svn project
SVNParentPath: for multiple svn project
If you use  SVNParentPath, you should access sub-svn from the browser, or you will get
------------------------------------------------------------

Forbidden

You don't have permission to access /repos on this server.
--------------------------------------------------------------------------------------
You should access them by http://localhost/repos/sub-svn


p.s.
Create basic auth
htpasswd -c /path/to/passwdfile svn-admin

IP permisison   
       Order Deny,Allow
        Deny from all
        Allow from 192.168.10.126