Unable to install SQLITE3

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... 
[email protected] node_modules/formidable
 Installing Connect Node Module... 
[email protected] node_modules/connect
├── [email protected]
├── [email protected]
├── [email protected] ([email protected])
└── [email protected] ([email protected], [email protected], [email protected])
 Installing Sqlite3 Node Module... 
-
> [email protected] 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! [email protected] install: `node-pre-gyp install --fallback-to-build`
npm ERR! spawn ENOENT
npm ERR! 
npm ERR! Failed at the [email protected] 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 [email protected]
1447 info linkStuff [email protected]
1448 silly linkStuff [email protected] has /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules as its parent node_modules
1449 verbose linkBins [email protected]
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 [email protected]
1452 verbose rebuildBundles [email protected]
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 [email protected]
1456 info postinstall [email protected]
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 [email protected]
1460 info linkStuff [email protected]
1461 silly linkStuff [email protected] has /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules as its parent node_modules
1462 verbose linkBins [email protected]
1463 verbose linkMans [email protected]
1464 verbose rebuildBundles [email protected]
1465 verbose rebuildBundles [ 'block-stream', 'fstream', 'inherits' ]
1466 info install [email protected]
1467 info postinstall [email protected]
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 [email protected]
1471 info linkStuff [email protected]
1472 silly linkStuff [email protected] has /root/media-node/node_modules/sqlite3/node_modules/node-pre-gyp/node_modules as its parent node_modules
1473 verbose linkBins [email protected]
1474 verbose linkMans [email protected]
1475 verbose rebuildBundles [email protected]
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 [email protected]
1478 info postinstall [email protected]
1479 info install [email protected]
1480 info postinstall [email protected]
1481 info install [email protected]
1482 verbose unsafe-perm in lifecycle false
1483 info [email protected] 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: [email protected] 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 [email protected]
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 [email protected] install: `node-pre-gyp install --fallback-to-build`
1496 error spawn ENOENT
1497 error Failed at the [email protected] 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 [email protected]
1501 info uninstall [email protected]
1502 verbose unbuild rmStuff [email protected] from /root/media-node/node_modules
1503 info postuninstall [email protected]
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:

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

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)

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 ?

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

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: