I am actually struggling with this error on our centos server all day, this is how I fixed it. I could not recover everything from my commandline history but this is what I could find out. Hope it will be helpful. I am sure while cleaning up my server for production it will be helpful to me. So cheers!
All this started with this error message on my centos server:
npm-2 Unhandled rejection SequelizeDatabaseError: You need JSON-C for ST_GeomFromGeoJSON npm-2 at Query.formatError (/home/centos/jobcue.com/node_modules/sequelize/lib/dialects/postgres/query.js:357:14) npm-2 at null. (/home/centos/jobcue.com/node_modules/sequelize/lib/dialects/postgres/query.js:88:19) npm-2 at emitOne (events.js:77:13) npm-2 at emit (events.js:169:7) npm-2 at Query.handleError (/home/centos/jobcue.com/node_modules/pg/lib/query.js:108:8) npm-2 at null. (/home/centos/jobcue.com/node_modules/pg/lib/client.js:171:26) npm-2 at emitOne (events.js:77:13) npm-2 at emit (events.js:169:7) npm-2 at Socket. (/home/centos/jobcue.com/node_modules/pg/lib/connection.js:109:12) npm-2 at emitOne (events.js:77:13) npm-2 at Socket.emit (events.js:169:7) npm-2 at readableAddChunk (_stream_readable.js:153:18) npm-2 at Socket.Readable.push (_stream_readable.js:111:10) npm-2 at TCP.onread (net.js:531:20)
When I tried to install json-c on server it was like:
sudo yum install json-c Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: centos.eecs.wsu.edu * epel: s3-mirror-us-west-2.fedoraproject.org * extras: linux.mirrors.es.net * updates: mirror.raystedman.net Package json-c-0.11-4.el7_0.x86_64 already installed and latest version Nothing to do
Then I started panicing. Tried 5-6 hours long yum battles and figure out a solution that would look like following:
Install some dependencies at first:
yum install geos-devel.x86_64 yum install proj-devel.x86_64 yum install gdal-devel.x86_64 yum install libxml2-devel.x86_64 yum install json-c-devel.x86_64 yum install postgresql92-devel sudo yum install postgresql-server sudo yum install geos geos-devel
wget http://download.osgeo.org/proj/proj-4.8.0.tar.gz gzip -d proj-4.8.0.tar.gz tar -xvf proj-4.8.0.tar cd proj-4.8.0 ./configure make sudo make install
I needed to install gdal:
installing gdal: sudo rpm -Uvh http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm sudo yum install -y gdal ./configure make make install
Obviously I needed to install json c:
sudo yum install json-c-devel
I needed to know where it is located:
rpm -ql json-c json-c-devel
for me it was at:
/usr/include/*
Now it is time to built our postgis like this:
wget http://download.osgeo.org/postgis/source/postgis-2.2.1.tar.gz tar xvzf postgis-2.2.1.tar.gz cd postgis-2.2.1 ./configure --with-jsonc=/usr/include make make install sudo make install
