I made an app which basically logs certain activity. Now I need to connect this mongoDB with external tools but I cant connect to port 3001. Making telnet to this port shows nothing and firewall is down.
Ps. If anyone knows free / gpl ODBC driver for mongo would be great!
Ok, as I understand I have to set somehow disable / set to server ip mongodb option bind_ip setting. How to do that?
Are you talking about accessing a local Meteor based mongo instance, or a remote one? If you want to access a local one you just need to supply the local mongo URL to your mongo client. You can get the local mongo URL by running:
meteor mongo --url
Let’s say you wanted to connect to this instance using the mongo CLI tool - you would run:
If you’re talking about accessing a remote mongo instance however, then we’ll need more details. How is your remote mongo instance setup - are you using a 3rd party mongo provider, are you using a mongo instance created via something like mup, etc.
I’m not talking about local instance. I’m not going to bother you with the details but to be precise I need to access MongoDB remotely with MS Excel or Access - dont ask. But robomongo will do right now I guess
Yikes - I promise I won’t ask; I don’t want to wake up in the middle of the night screaming!
Oh, I’m going to ask … are you going to use MongoDB Connector for BI or some other solution?
Awesome architecture - love it!
It sounds like you don’t actually need to access Mongo from Excel, but you need Excel from Meteor?
Which is doable with the npm exceljs module. Although I’m not saying it will be easy!
Yes, maybe they dont need the reporting in real time, maybe a user can get daily “updates” from app. I’ll have to check it
I’m thinking that Meteor reacts to a change in Mongo and updates the spreadsheet immediately.
Yes but some has to download the spreadsheet to the “local computer” where the production planning spreadsheet is.
If you need to connect to external mongoDB instance which was created by Meteor.js you need to change ip binding, look: http://stackoverflow.com/questions/20618035/unable-to-access-meteor-mongodb-running-on-vm-from-the-host-using-the-ip-address
You can do it manually by edit meteor file or from console:
cd ~ && sed -i '0,/127.0.0.1/s//0.0.0.0/' .meteor/packages/meteor-tool/.22.214.171.124yhl3g++os.linux.x86_64+web.browser+web.cordova/mt-os.linux.x86_64/tools/runners/run-mongo.js
Remember that you can have another meteor-tool version
I wish you well: it’s an interesting project to tackle, ripe for bringing up to date, and Meteor is a good way to attack it.
I’m wondering if future workflows will involve printing out the SMS, taking a photo of it on a wooden table and then sending it on via E-Mail so it can be run through an OCR program or something.
That would be truly awesome , but it seems @imapi has already removed the SMS component:
I was just about to add to the humour of this by mentioning this would only be possible in this project if Excel could be used to handle the OCR … until I did a search and found out this is actually possible … suddenly nothing is funny anymore …
It’s certainly worthy of an article for the The Daily WTF.
That’s where the idea with the wooden table came from, by the way.