Skip to content

Chris' Laboratory

chrislee.kr – Personal blog as bookshelves

Menu
  • Home
  • Github
  • Contact Me
Menu

Category: Databases

MongoDB exception in initAndListen: old lock file, terminating

Posted on 30/04/202130/04/2021 by Chris Lee

Reference: https://github.com/docker-library/mongo/issues/62#issuecomment-568308941 Error Message: Fix for docker-compose.yml:

Continue reading

Node.js + MongoDB RESTful API Boilerplate

Posted on 13/03/202029/08/2020 by Chris Lee

Github: https://github.com/chrisleekr/nodejs-mongodb-api-boilerplate This is a sample project that I followed the tutorial Build Node.js RESTful APIs in 10 Minutes written by Olatunde Garuba. How to start $ docker-compose up -d $ docker logs -f api This command will build Node.js API and launch docker container mongo and mongo-express Endpoints Node.js API Method URL Sample Data GET http://localhost:3000/tasks POST http://localhost:3000/tasks {“name”:”Fix…

Continue reading

[PHP+MySQL] 간단한 카카오 i 오픈빌더 챗봇 만들기 (Kakao i Open Builder)

Posted on 29/03/201929/08/2020 by Chris Lee

카카오 i 오픈빌더 (Kakao i Open Builder)를 이용한 플러스 친구 챗봇 (PHP + MySQL) 백엔드 프로젝트 이 프로젝트는 샘플 테스트용으로 카카오톡 플러스 친구 챗봇을 구현하기 위해 만들어졌습니다. 이 프로젝트는 아주 기본 기능만을 구현하였습니다. Production 환경에서는 사용하기에 부족함이 많으니 참고용으로만 사용하시기 바랍니다. 테스트 커뮤니티 챗봇: http://pf.kakao.com/_vAKtj Backend API: https://kakao.chrislee.kr Backend 소스코드: https://github.com/chrisleekr/kakao-plusfriend-bot-backend 개발 환경 PHP 7.2…

Continue reading

Vagrant MySQL Master-Slave Replication

Posted on 22/08/201629/08/2020 by Chris Lee

Vagrant MySQL Master-Slave Replication Source Repo: https://github.com/chrisleekr/vagrant-mysql-master-slave-replication Vagrantfile to spin up MySQL Master-Slave replication with persistent data storage Note: This project is created for just practice. Not suitable for production use. Prerequisites Vagrant 1.8.1+: http://www.vagrantup.com/ VirtualBox: https://www.virtualbox.org/ Usage $ git clone https://github.com/chrisleekr/vagrant-mysql-master-slave-replication.git $ cd vagrant-mysql-master-slave-replication $ vagrant up After vagrant machines are running, you can connect…

Continue reading

MS SQL Express 2012 Installation Error – No room is available to display rows

Posted on 29/12/2014 by Chris Lee

Environments Mac 10.10 Parallels Desktop 9 Windows 7 Issue & Solutions When I try to install MS SQL Express 2012, the installer shows an error like “No room is available to display rows”. The reason was screen resolution in Mac retina display. Open Parallels Desktop -> Virtual Machine -> Configure -> Hardware -> Video -> Change…

Continue reading

Sample XAMPP MySql my.ini Fast Performance

Posted on 23/09/201429/08/2020 by Chris Lee

Only use in local test MySQL. # Example MySQL config file for large systems. # # This is for a large system with memory = 512M where the system runs mainly # MySQL. # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You…

Continue reading

EnvironmentError: mysql_config not found

Posted on 09/05/201429/08/2020 by Chris Lee

I am using Mac OS X 10.9, MAMP 1.9 (MySQL 5.1.44), Python 2.7.5. Got this error when I change database configuration in settings.py. I felt this issue can make me painful, so I start logging what happened and how I fixed. Do not follow below steps. Just go straightly bottom of article and read last…

Continue reading

VPS – Apache & MySQL Performance Tuning

Posted on 13/03/201429/08/2020 by Chris Lee

Apache 1. Open/Create /var/www/vhosts/{hostname}/conf/vhosts.conf 2. Add oradjust below code KeepAlive On MaxKeepAliveRequests 29 KeepAliveTimeout 15 3. Copy to make backup of apache configuration # cp -p /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.YYYY-MM-DD.bak 4. Execute below shell script one by one # ramCount=`awk ‘match($0,/vmguar/) {print $4}’ /proc/user_beancounters` # ramBase=-16 && for ((;ramCount>1;ramBase++)); do ramCount=$((ramCount/2)); done # perl -0 -p -i…

Continue reading

MongoDB Library for Codeigniter

Posted on 15/08/201215/08/2012 by Chris Lee

Codeigniter MongoDB Library Reference & Download: https://github.com/alexbilbie/codeigniter-mongodb-library/tree/v2 Using with CodeIgniter: Add the file Mongo_db.php to your /application/libraries folder. Add the file mongodb.php to your /application/config folder. Update the config file.

Continue reading

MongoDB PHP extension for MAMP in Mac OS X

Posted on 15/08/201215/08/2012 by Chris Lee

The command ‘pecl’ in MAMP dos not work; therefore, it requires to download pre-complied PHP extensions from https://github.com/mongodb/mongo-php-driver/downloads Open php.ini and add below code [code]extension=mongo.so[/code] Reference: http://www.php.net/manual/en/mongo.installation.php#mongo.installation.osx

Continue reading

A script to change all tables and fields to the utf-8-bin collation in MYSQL

Posted on 13/12/201029/08/2020 by Chris Lee

A script to change all tables and fields to the utf-8-bin collation in MYSQL (This article is from http://stackoverflow.com/questions/105572/a-script-to-change-all-tables-and-fields-to-the-utf-8-bin-collation-in-mysql)   <?php set_time_limit(0); function MysqlError() { if (mysql_errno()) { echo “<b>Mysql Error: ” . mysql_error() . “</b>\n”; } } $username = “root”; $password = “”; $db = “database”; $host = “localhost”; $target_charset = “utf8”; $target_collate =…

Continue reading

Categories

  • Databases (11)
    • MongoDB (4)
    • MS-SQL (1)
    • MySQL (6)
  • E-Commerce (8)
    • Magento (8)
  • Finance (2)
  • Frameworks (84)
    • Adobe Flex (1)
    • Angular (ngx) (3)
    • Codeigniter (6)
    • CSS (5)
    • Django (2)
    • Javascript (13)
    • Node.js (6)
    • PHP (17)
    • React Native (4)
    • React.js (1)
    • Sencha Touch (4)
    • Terraform (1)
    • Vue.js (1)
    • WordPress (4)
    • Yii2 (3)
  • General Documents (15)
  • Marketing (3)
  • Mobile Development (33)
    • Android (20)
    • iPhone (13)
  • Platforms (21)
    • Arduino (2)
    • Docker (5)
    • Google App Engine (5)
    • Raspberry Pi (5)
    • Samsung Smart TV (4)
  • Security (17)
  • Server (30)
    • Linux (12)
  • Tools (14)
    • SVN (7)
  • Uncategorized (2)

Search

Recent Posts

  • Taint all resources in the one module
  • Alpine – Plugin caching_sha2_password could not be loaded
  • npm link with peerDependencies
  • How to setup Gitlab runner with KVM enabled
  • Failed to transform bcprov-jdk15on-1.68.jar

Recent Comments

  • Obayed on Binance Auto Trading Bot – Buy low/Sell high with stop loss limit/Trade multiple coins
  • Ari on How to install memcache.so/memcached.so for MAMP Pro (Mac)
  • Mida ali on Binance Auto Trading Bot – Buy low/Sell high with stop loss limit/Trade multiple coins
  • Chris Lee on How to install memcache.so/memcached.so for MAMP Pro (Mac)
  • Chris Lee on Setting Up A VPN Server On OSX 10.6

Tags

1 ajax amazon android android-addpart browser chrislee-kr codeigniter codeigniter-tcpdf com-apple-net-racoon CSS CSS history hack delpaigmail-com entity-addpart-double exception-printing-is-disabled-by-default-for-security-reasons ext-plugins-listpagingplugin ext-plugins-listpagingplugin-example f iphone javascript jquery-defaultchecked jquery-samsung-smart-tv listpagingplugin mac magento-exception-printing-is-disabled-by-default-for-security-reasons magento-sample-data-exception-printing-is-disabled-by-default-for-security-reasons nu-vot null-core-errors-confignotfound-config-mk9engine-ini php samsung-smart-tv-jquery samsung-smart-tv-sdk-ajax samsung-smart-tv-sdk-jquery samsung-tv-sdk samsung-tv-sdk-jquery samsung tv sencha-smart-tv sencha-touch-list-paging smart-tv-jquery sqlite subversion svn tcedook tcpdf-codeigniter uilinebreakmodecharacterwrap-is-deprecated unknown-column-link-area

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2023 Chris' Laboratory | Powered by Minimalist Blog WordPress Theme
 

Loading Comments...