Unable to install SQLITE3


#1

Hi,

After hours of trying to install rtMedia ffmpeg with the script installer on an Ubuntu 14.04.2 LTS, am stuck now with the Sqlite3 Node Module.

Here is what I’ve got

 Installing Formidable Node Module... 
formidable@1.0.17 node_modules/formidable
 Installing Connect Node Module... 
connect@3.4.0 node_modules/connect
├── utils-merge@1.0.0
├── parseurl@1.3.0
├── debug@2.2.0 (ms@0.7.1)
└── finalhandler@0.4.0 (escape-html@1.0.2, unpipe@1.0.0, on-finished@2.3.0)
 Installing Sqlite3 Node Module... 
-
> sqlite3@3.0.8 install /root/media-node/node_modules/sqlite3
> node-pre-gyp install --fallback-to-build

sh: 1: node-pre-gyp: Permission denied
npm ERR! Linux 3.13.0-52-generic
npm ERR! argv "node" "/usr/local/bin/npm" "install" "sqlite3"
npm ERR! node v0.10.13
npm ERR! npm  v2.13.0
npm ERR! file sh
npm ERR! code ELIFECYCLE
npm ERR! errno ENOENT
npm ERR! syscall spawn

npm ERR! sqlite3@3.0.8 install: `node-pre-gyp install --fallback-to-build`
npm ERR! spawn ENOENT
npm ERR! 
npm ERR! Failed at the sqlite3@3.0.8 install script 'node-pre-gyp install --fallback-to-build'.
npm ERR! This is most likely a problem with the sqlite3 package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node-pre-gyp install --fallback-to-build
npm ERR! You can get their info via:
npm ERR!     npm owner ls sqlite3
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR!     /root/media-node/npm-debug.

Unable To Install Sqlite3 Node Module :( 

Here the errors wrote in the npm-debug :

1445 info build /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/semver
1446 info preinstall semver@4.3.3
1447 info linkStuff semver@4.3.3
1448 silly linkStuff semver@4.3.3 has /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules as its parent node_modules
1449 verbose linkBins semver@4.3.3
1450 verbose link bins [ { semver: './bin/semver' },
1450 verbose link bins   '/root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/.bin',
1450 verbose link bins   false ]
1451 verbose linkMans semver@4.3.3
1452 verbose rebuildBundles semver@4.3.3
1453 silly gentlyRm /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/.bin/semver is being purged
1454 verbose gentlyRm don't care about contents; nuking /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/.bin/semver
1455 info install semver@4.3.3
1456 info postinstall semver@4.3.3
1457 verbose rebuild bundle /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/tar
1458 info build /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/tar
1459 info preinstall tar@2.1.0
1460 info linkStuff tar@2.1.0
1461 silly linkStuff tar@2.1.0 has /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules as its parent node_modules
1462 verbose linkBins tar@2.1.0
1463 verbose linkMans tar@2.1.0
1464 verbose rebuildBundles tar@2.1.0
1465 verbose rebuildBundles [ 'block-stream', 'fstream', 'inherits' ]
1466 info install tar@2.1.0
1467 info postinstall tar@2.1.0
1468 verbose rebuild bundle /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/tar-pack
1469 info build /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules/tar-pack
1470 info preinstall tar-pack@2.0.0
1471 info linkStuff tar-pack@2.0.0
1472 silly linkStuff tar-pack@2.0.0 has /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules as its parent node_modules
1473 verbose linkBins tar-pack@2.0.0
1474 verbose linkMans tar-pack@2.0.0
1475 verbose rebuildBundles tar-pack@2.0.0
1476 verbose rebuildBundles [ 'debug',
1476 verbose rebuildBundles   'fstream',
1476 verbose rebuildBundles   'fstream-ignore',
1476 verbose rebuildBundles   'graceful-fs',
1476 verbose rebuildBundles   'once',
1476 verbose rebuildBundles   'readable-stream',
1476 verbose rebuildBundles   'rimraf',
1476 verbose rebuildBundles   'tar',
1476 verbose rebuildBundles   'uid-number' ]
1477 info install tar-pack@2.0.0
1478 info postinstall tar-pack@2.0.0
1479 info install node-pre-gyp@0.6.7
1480 info postinstall node-pre-gyp@0.6.7
1481 info install sqlite3@3.0.8
1482 verbose unsafe-perm in lifecycle false
1483 info sqlite3@3.0.8 Failed to exec install script
1484 verbose unlock done using /home/spotmedias/.npm/_locks/sqlite3-7c6e6a9888ccd13e.lock for /root/media-node/node_modules/sqlite3
1485 verbose stack Error: sqlite3@3.0.8 install: `node-pre-gyp install --fallback-to-build`
1485 verbose stack spawn ENOENT
1485 verbose stack     at ChildProcess.<anonymous> (/usr/local/lib/node_modules/npm/lib/utils/spawn.js:17:16)
1485 verbose stack     at ChildProcess.EventEmitter.emit (events.js:98:17)
1485 verbose stack     at maybeClose (child_process.js:735:16)
1485 verbose stack     at Process.ChildProcess._handle.onexit (child_process.js:802:5)
1486 verbose pkgid sqlite3@3.0.8
1487 verbose cwd /root/media-node
1488 error Linux 3.13.0-52-generic
1489 error argv "node" "/usr/local/bin/npm" "install" "sqlite3"
1490 error node v0.10.13
1491 error npm  v2.13.0
1492 error file sh
1493 error code ELIFECYCLE
1494 error errno ENOENT
1495 error syscall spawn
1496 error sqlite3@3.0.8 install: `node-pre-gyp install --fallback-to-build`
1496 error spawn ENOENT
1497 error Failed at the sqlite3@3.0.8 install script 'node-pre-gyp install --fallback-to-build'.
1497 error This is most likely a problem with the sqlite3 package,
1497 error not with npm itself.
1497 error Tell the author that this fails on your system:
1497 error     node-pre-gyp install --fallback-to-build
1497 error You can get their info via:
1497 error     npm owner ls sqlite3
1497 error There is likely additional logging output above.
1498 verbose exit [ 1, true ]
1499 verbose unbuild node_modules/sqlite3
1500 info preuninstall sqlite3@3.0.8
1501 info uninstall sqlite3@3.0.8
1502 verbose unbuild rmStuff sqlite3@3.0.8 from /root/media-node/node_modules
1503 info postuninstall sqlite3@3.0.8
1504 silly gentlyRm /root/media-node/node_modules/sqlite3 is being purged from base /root/media-node
1505 verbose gentlyRm don't care about contents; nuking /root/media-node/node_modules/sqlite3
1506 silly vacuum-fs purging /root/media-node/node_modules/sqlite3
1507 silly vacuum-fs quitting because other entries in /root/media-node/node_modules

Hope someone will be able to explain how to deal with this problem and give me a tip how to continue to run the end of the script wiithout loosing 2 more hours to start-it over.

Thanks for you help :slight_smile:


#2

So good to find so much help in here ! :smiley:

I found a way to install Sqlite3 by replacing

curl -sL https://npmjs.org/install.sh | sudo sh

with

sudo curl -k -L https://npmjs.org/install.sh | sudo sh

In the install script (ubuntu.sh)

But now I still have error at the end of the script installation

Cloning into 'media-node'...
remote: Counting objects: 1228, done.
remote: Total 1228 (delta 0), reused 0 (delta 0), pack-reused 1228
Receiving objects: 100% (1228/1228), 414.09 KiB | 0 bytes/s, done.
Resolving deltas: 100% (424/424), done.
Checking connectivity... done.
‘media-node/ffmpeg_server.js’ -> ‘/root/media-node/ffmpeg_server.js’
‘media-node/install.sh’ -> ‘/root/media-node/install.sh’
‘media-node/package.json’ -> ‘/root/media-node/package.json’
‘media-node/README.md’ -> ‘/root/media-node/README.md’
‘media-node/setup’ -> ‘/root/media-node/setup’
‘media-node/setup/ubuntu.sh’ -> ‘/root/media-node/setup/ubuntu.sh’
‘media-node/setup/check.sh’ -> ‘/root/media-node/setup/check.sh’
‘media-node/setup/update.sh’ -> ‘/root/media-node/setup/update.sh’
‘media-node/setup/redhat.sh’ -> ‘/root/media-node/setup/redhat.sh’
‘media-node/setup/debian.sh’ -> ‘/root/media-node/setup/debian.sh’
‘media-node/setup/redhat5.sh’ -> ‘/root/media-node/setup/redhat5.sh’
‘media-node/.git’ -> ‘/root/media-node/.git’
‘media-node/.git/info’ -> ‘/root/media-node/.git/info’
‘media-node/.git/info/exclude’ -> ‘/root/media-node/.git/info/exclude’
‘media-node/.git/branches’ -> ‘/root/media-node/.git/branches’
‘media-node/.git/config’ -> ‘/root/media-node/.git/config’
‘media-node/.git/logs’ -> ‘/root/media-node/.git/logs’
‘media-node/.git/logs/HEAD’ -> ‘/root/media-node/.git/logs/HEAD’
‘media-node/.git/logs/refs’ -> ‘/root/media-node/.git/logs/refs’
‘media-node/.git/logs/refs/remotes’ -> ‘/root/media-node/.git/logs/refs/remotes’
‘media-node/.git/logs/refs/remotes/origin’ -> ‘/root/media-node/.git/logs/refs/remotes/origin’
‘media-node/.git/logs/refs/remotes/origin/HEAD’ -> ‘/root/media-node/.git/logs/refs/remotes/origin/HEAD’
‘media-node/.git/logs/refs/heads’ -> ‘/root/media-node/.git/logs/refs/heads’
‘media-node/.git/logs/refs/heads/master’ -> ‘/root/media-node/.git/logs/refs/heads/master’
‘media-node/.git/packed-refs’ -> ‘/root/media-node/.git/packed-refs’
‘media-node/.git/HEAD’ -> ‘/root/media-node/.git/HEAD’
‘media-node/.git/refs’ -> ‘/root/media-node/.git/refs’
‘media-node/.git/refs/tags’ -> ‘/root/media-node/.git/refs/tags’
‘media-node/.git/refs/remotes’ -> ‘/root/media-node/.git/refs/remotes’
‘media-node/.git/refs/remotes/origin’ -> ‘/root/media-node/.git/refs/remotes/origin’
‘media-node/.git/refs/remotes/origin/HEAD’ -> ‘/root/media-node/.git/refs/remotes/origin/HEAD’
‘media-node/.git/refs/heads’ -> ‘/root/media-node/.git/refs/heads’
‘media-node/.git/refs/heads/master’ -> ‘/root/media-node/.git/refs/heads/master’
‘media-node/.git/objects’ -> ‘/root/media-node/.git/objects’
‘media-node/.git/objects/info’ -> ‘/root/media-node/.git/objects/info’
‘media-node/.git/objects/pack’ -> ‘/root/media-node/.git/objects/pack’
‘media-node/.git/objects/pack/pack-328df686c9cb13dccf38e257b95f5aae3076cc5a.pack’ -> ‘/root/media-node/.git/objects/pack/pack-328df686c9cb13dccf38e257b95f5aae3076cc5a.pack’
‘media-node/.git/objects/pack/pack-328df686c9cb13dccf38e257b95f5aae3076cc5a.idx’ -> ‘/root/media-node/.git/objects/pack/pack-328df686c9cb13dccf38e257b95f5aae3076cc5a.idx’
‘media-node/.git/index’ -> ‘/root/media-node/.git/index’
‘media-node/.git/description’ -> ‘/root/media-node/.git/description’
‘media-node/.git/hooks’ -> ‘/root/media-node/.git/hooks’
‘media-node/.git/hooks/applypatch-msg.sample’ -> ‘/root/media-node/.git/hooks/applypatch-msg.sample’
‘media-node/.git/hooks/pre-rebase.sample’ -> ‘/root/media-node/.git/hooks/pre-rebase.sample’
‘media-node/.git/hooks/pre-commit.sample’ -> ‘/root/media-node/.git/hooks/pre-commit.sample’
‘media-node/.git/hooks/pre-applypatch.sample’ -> ‘/root/media-node/.git/hooks/pre-applypatch.sample’
‘media-node/.git/hooks/post-update.sample’ -> ‘/root/media-node/.git/hooks/post-update.sample’
‘media-node/.git/hooks/prepare-commit-msg.sample’ -> ‘/root/media-node/.git/hooks/prepare-commit-msg.sample’
‘media-node/.git/hooks/update.sample’ -> ‘/root/media-node/.git/hooks/update.sample’
‘media-node/.git/hooks/commit-msg.sample’ -> ‘/root/media-node/.git/hooks/commit-msg.sample’
‘media-node/.git/hooks/pre-push.sample’ -> ‘/root/media-node/.git/hooks/pre-push.sample’
spotmedias@ns:~$ 
spotmedias@ns:~$ 
spotmedias@ns:~$ TypeError: Object function createServer() {
  function app(req, res, next){ app.handle(req, res, next); }
  merge(app, proto);
  merge(app, EventEmitter.prototype);
  app.route = '/';
  app.stack = [];
  return app;
} has no method 'static'
    at Object.<anonymous> (/root/media-node/ffmpeg_server.js:383:24)
    at Module._compile (module.js:456:26)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Function.Module.runMain (module.js:497:10)
    at startup (node.js:119:16)
    at node.js:901:3
Error: SQLITE_ERROR: duplicate column name: duration
Error: SQLITE_ERROR: duplicate column name: thumbs

Maybe a miracle, someone could help me ! :wink:

Thanks


#3

Those two errors are no problem. You can safely ignore them. Installing the script can be a pain in the ass depending on your system configuration. Best thing I did was run through the installer script line by line one at a time, instead of running it as a script. Then, any errors I see can be googled, fixed, and then keep on to the next line till its done.

Ben (Just a guy, not an official support person here)


#4

Hi Ben,

thank you for your answer.

Ok about the 2 line about duplicate column but just before there is “TypeError: Object function createServer()…”

In my case nothing work right now.

About the line by line from the install script, am so newbie with ssh command that I am not sure what to copy/paste exactly so I ran the script till error that I had to find a solution. So it took me a looooong time to resolve all, till the end and now I’ve got most of the installation done but nothing work. :frowning:

I don’t understand how rtcamp can sell a software without an good installer… maybe because they just want us to buy there installation service I guess. In my case it’s to make some tests to see if it’s working and am exhausted to waist so much time on something that I bought and has to work.

Did you installed it on ubuntu also without problem ?


#5

I didn’t install it on unbuntu, I installed on CentOS. rtCamp will be able to help you with this, have you filled out a support ticket in wp-admin->rtMedia->Support? The web forums here are slower for replies, it’s just the community help forum, not their fast premium support…

Cheers

Ben


#6

I had earlier an exchange with the support about the installer script which is not correct for Ubuntu. They will make an update.

Thanks for your help Ben. :slight_smile:


#7