{"action":"created","issue":{"url":"https://api.github.com/repos/numtel/meteor-mysql/issues/6","labels_url":"https://api.github.com/repos/numtel/meteor-mysql/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/numtel/meteor-mysql/issues/6/comments","events_url":"https://api.github.com/repos/numtel/meteor-mysql/issues/6/events","html_url":"https://github.com/numtel/meteor-mysql/issues/6","id":57974172,"number":6,"title":"Getting The Following Errors with mysql","user":{"login":"Topol","id":1155909,"avatar_url":"https://avatars.githubusercontent.com/u/1155909?v=3","gravatar_id":"","url":"https://api.github.com/users/Topol","html_url":"https://github.com/Topol","followers_url":"https://api.github.com/users/Topol/followers","following_url":"https://api.github.com/users/Topol/following{/other_user}","gists_url":"https://api.github.com/users/Topol/gists{/gist_id}","starred_url":"https://api.github.com/users/Topol/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Topol/subscriptions","organizations_url":"https://api.github.com/users/Topol/orgs","repos_url":"https://api.github.com/users/Topol/repos","events_url":"https://api.github.com/users/Topol/events{/privacy}","received_events_url":"https://api.github.com/users/Topol/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":18,"created_at":"2015-02-17T20:03:54Z","updated_at":"2015-11-15T10:35:43Z","closed_at":null,"body":"```\r\nI20150218-01:33:02.258(5.5)? ** You've set up some data subscriptions with Meteor.publish(), but\r\nI20150218-01:33:02.260(5.5)? ** you still have autopublish turned on. Because autopublish is still\r\nI20150218-01:33:02.260(5.5)? ** on, your Meteor.publish() calls won't have much effect. All data\r\nI20150218-01:33:02.260(5.5)? ** will still be sent to all clients.\r\nI20150218-01:33:02.260(5.5)? **\r\nI20150218-01:33:02.260(5.5)? ** Turn off autopublish by removing the autopublish package:\r\nI20150218-01:33:02.261(5.5)? **\r\nI20150218-01:33:02.261(5.5)? **   $ meteor remove autopublish\r\nI20150218-01:33:02.261(5.5)? **\r\nI20150218-01:33:02.261(5.5)? ** .. and make sure you have Meteor.publish() and Meteor.subscribe() calls\r\nI20150218-01:33:02.261(5.5)? ** for each collection that you want clients to see.\r\nI20150218-01:33:02.261(5.5)? \r\nW20150218-01:33:02.383(5.5)? (STDERR) \r\nW20150218-01:33:02.383(5.5)? (STDERR) /private/var/folders/jk/jf0vd73n24n6yfv0cn1v12c00000gn/T/meteor-test-run1mbn73v/.meteor/local/isopacks/numtel_mysql/npm/node_modules/mysql/lib/protocol/Parser.js:82\r\nW20150218-01:33:02.383(5.5)? (STDERR)         throw err;\r\nW20150218-01:33:02.383(5.5)? (STDERR)               ^\r\nW20150218-01:33:02.383(5.5)? (STDERR) Error: ER_NO_BINARY_LOGGING: You are not using binary logging\r\n```"},"comment":{"url":"https://api.github.com/repos/numtel/meteor-mysql/issues/comments/156800743","html_url":"https://github.com/numtel/meteor-mysql/issues/6#issuecomment-156800743","issue_url":"https://api.github.com/repos/numtel/meteor-mysql/issues/6","id":156800743,"user":{"login":"Topol","id":1155909,"avatar_url":"https://avatars.githubusercontent.com/u/1155909?v=3","gravatar_id":"","url":"https://api.github.com/users/Topol","html_url":"https://github.com/Topol","followers_url":"https://api.github.com/users/Topol/followers","following_url":"https://api.github.com/users/Topol/following{/other_user}","gists_url":"https://api.github.com/users/Topol/gists{/gist_id}","starred_url":"https://api.github.com/users/Topol/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Topol/subscriptions","organizations_url":"https://api.github.com/users/Topol/orgs","repos_url":"https://api.github.com/users/Topol/repos","events_url":"https://api.github.com/users/Topol/events{/privacy}","received_events_url":"https://api.github.com/users/Topol/received_events","type":"User","site_admin":false},"created_at":"2015-11-15T10:35:43Z","updated_at":"2015-11-15T10:35:43Z","body":"Dear Ben\n\nI am trying to use your code inside the meteor server from a different\ncode. I can run your Leaderboard example but while deploying the same code\ninside the server module I have to do these steps.  var LiveMysql =\nNpm.require('mysql-live-select'); otherwise it does not recognize it.\n\nAlso I am getting the following error. Do you think I am doing something\nwrong.\n\nTypeError: string is not a function\n\nW20151115-03:21:19.056(-7)? (STDERR)     at Handshake._callback\n(/var/mobnode/node_modules/mysql-live-select/lib/LiveMysql.js:31:34)\n\n\nThe code is the following.\n\n var LiveMysql = Npm.require('mysql-live-select');\n\n  var MysqlSubscription = Npm.require('mysql-live-select');\n\n  players = new MysqlSubscription('allPlayers');\n\n  myScore = new MysqlSubscription('playerScore', 'Maxwell');\n\n\nvar liveDb = new LiveMysql({\n\n    host: 'localhost',\n\n    // Port 3407 as specified in leaderboard.mysql.json\n\n    // If using external MySQL server, the default port is 3306\n\n    port: 3306,\n\n    user: 'root',\n\n    password: '****',\n\n    database: 'leaderboard'\n\n  });\n\n\n  var closeAndExit = function() {\n\n    liveDb.end();\n\n    process.exit();\n\n  };\n\n  // Close connections on hot code push\n\n  process.on('SIGTERM', closeAndExit);\n\n  // Close connections on exit (ctrl + c)\n\n  process.on('SIGINT', closeAndExit);\n\nOn Thu, Nov 12, 2015 at 8:48 PM, Arindam Bhattacharjee <\ntopol.daiict@gmail.com> wrote:\n\n> Nevermind it was a centos issue, fixed it\n>\n> On Thu, Nov 12, 2015 at 7:45 PM, Arindam Bhattacharjee <\n> topol.daiict@gmail.com> wrote:\n>\n>> I am getting the following error:\n>>\n>> [ERROR] Fatal error: Please read \"Security\" section of the manual to find\n>> out how to run mysqld as root!\n>>\n>> But I am running the meteor command in root.\n>>\n>> On Thu, Nov 12, 2015 at 7:02 PM, Arindam Bhattacharjee <\n>> topol.daiict@gmail.com> wrote:\n>>\n>>> Dear Ben\n>>>\n>>> I tried doing this step in centos OS. Does it not work on centos OS.\n>>>\n>>> On Tue, Apr 21, 2015 at 8:45 AM, Ben Green <notifications@github.com>\n>>> wrote:\n>>>\n>>>> Ok, I have come up with a package that integrates the MySQL server\n>>>> directly into Meteor making it very easy to get set up using this package.\n>>>> The binary log configuration is already in place, just set a port and\n>>>> you'll have a MySQL server that starts and stops with your Meteor app.\n>>>>\n>>>> https://github.com/numtel/meteor-mysql-server\n>>>>\n>>>> [image: easy-mysql]\n>>>> <https://cloud.githubusercontent.com/assets/518698/7245069/eeaa4d34-e799-11e4-9620-7687683913f4.png>\n>>>>\n>>>> —\n>>>> Reply to this email directly or view it on GitHub\n>>>> <https://github.com/numtel/meteor-mysql/issues/6#issuecomment-94625483>\n>>>> .\n>>>>\n>>>\n>>>\n>>\n>\n"}}