Skip to content

Instantly share code, notes, and snippets.

View simonqian's full-sized avatar

simonqian simonqian

1 follower · 0 following
View GitHub Profile
@simonqian
simonqian / gist:a4e3b3e3386aa339ea5502aceef97aaf
Created October 24, 2017 04:35
fix-macos-used-cannot-open-file
xattr -c ./*
@simonqian
simonqian / mysql.server-start-creating-InnoDB-error.md
Last active June 12, 2017 03:41

error info (vi /usr/local/var/mysql/bogon.err):

...
4608 170612 11:36:00 mysqld_safe mysqld from pid file /usr/local/var/mysql/bogon.pid ended
4609 170612 11:36:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
4610 170612 11:36:10 [Note] /usr/local/Cellar/mariadb/10.0.19/bin/mysqld (mysqld 10.0.19-MariaDB) starting as process 48851 ...
4611 170612 11:36:10 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
4612 170612 11:36:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages
4613 170612 11:36:10 [Note] InnoDB: The InnoDB memory heap is disabled
4614 170612 11:36:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
@simonqian
simonqian / gem-install-mysql2-error.md
Created June 1, 2017 07:19

error info:

➜  hh (hh_api) ✗ gem install mysql2
Fetching: mysql2-0.4.6.gem (100%)
Building native extensions.  This could take a while...
ERROR:  Error installing mysql2:
	ERROR: Failed to build gem native extension.

    current directory: /Users/simonqian/.rvm/gems/ruby-2.2.2@rails4/gems/mysql2-0.4.6/ext/mysql2
/Users/simonqian/.rvm/rubies/ruby-2.2.2/bin/ruby -r ./siteconf20170601-29418-1uit6cw.rb extconf.rb
@simonqian
simonqian / base64_to_file.rb
Created April 14, 2017 09:15
base64 to file in rails
module Base64ToFile
extend ActiveSupport::Concern
def base64_to_file(base64_data, filename=nil)
return base64_data unless base64_data.is_a? String
start_regex = /data:image\/[a-z]{3,4};base64,/
filename ||= SecureRandom.hex
regex_result = start_regex.match(base64_data)
@simonqian
simonqian / SSL-certificate-verify-failure.md
Last active April 11, 2017 01:43
SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed

error info:

SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed

resolve:

  1. show cert status:
➜  hh (develop-hh) ✔ rvm osx-ssl-certs status all
Certificates for /etc/openssl/cert.pem: Up to date.
@simonqian
simonqian / gem-error-installing-libv8.md
Last active August 9, 2020 12:31

error info:

➜  hh (develop-hh) ✔ gem install libv8 -v '3.16.14.11'
Building native extensions.  This could take a while...
ERROR:  Error installing libv8:
	ERROR: Failed to build gem native extension.

    current directory: /Users/simonqian/.rvm/gems/ruby-2.2.2/gems/libv8-3.16.14.11/ext/libv8
/Users/simonqian/.rvm/rubies/ruby-2.2.2/bin/ruby -r ./siteconf20170410-48026-19k49a7.rb extconf.rb
creating Makefile
@simonqian
simonqian / mysql-init-user-and-database.md
Last active April 11, 2017 07:07
  1. create database:
  create database cellar;
  1. create user:
  create user cellar;
  1. grant privileges:
@simonqian
simonqian / caddy-certificate-acme-error-400.md
Last active April 6, 2017 08:28

error info:

Activating privacy features...2017/04/06 07:54:36 [[your domain]] failed to get certificate: acme: Error 400 - urn:acme:error:connection - Failed to connect to [your ip]:443 for TLS-SNI-01 challenge
Error Detail:
	Validation for [your domain]:443
	Resolved to:
		[your ip]
	Used: [your ip]
@simonqian
simonqian / spring-mvc-ajax-post-json-request-not-working
Created March 30, 2017 07:21
resolve:
add `<mvc:annotation-driven/>` to applicationContext-mvc.xml
@simonqian
simonqian / node-sass-error-no-such-file-or-directory.md
Last active May 27, 2017 06:56

------------------------------------------------------------error------------------------------------------------------------

➜ app (master) ✗ npm run dev

app@1.0.0 dev /Users/simonqian/Work/ohmy411/app NODE_ENV=development PORT=3000 node index.js

fs.js:914 return binding.readdir(pathModule._makeLong(path), options.encoding); ^