I think the error may be in your POST request: Try:
curl -i -X POST http://localhost:7070/events.json\?accessKey\=$my-access-key \ -H "Content-Type: application/json" \ -d '{ "event" : "$set", "entityType" : "user", "entityId" : "u0" }' Replacing your "-" with a "$", where $my-access-key is a variable for the access key for one of your apps. Fifty On Tue, Jan 31, 2017 at 7:07 PM, Chan Lee <[email protected]> wrote: > That is strange. The event table should have been created when you run > `pio app new MyApp`. > > Could you try re-creating your app with `pio app new MyApp2 --verbose`, > and check that table "pio_event_<your_app_id>" has been created? > > On Tue, Jan 31, 2017 at 2:12 PM, Saarthak Chandra < > [email protected]> wrote: > >> I'm using postgresql >> I created the db called pio..using the created pio command... >> >> Not sure why the event table is not being created when I send the post >> request though .... >> >> On 31 Jan 2017 17:10, "Tom Chan" <[email protected]> wrote: >> >>> I don't have an answer from the top of my head, hope someone can chime >>> in and help. >>> >>> To help others debugging this, which database are you using (PostgreSQL, >>> MySQL or elasticsearch)? >>> >>> Tom >>> >>> On Tue, Jan 31, 2017 at 1:47 PM, Saarthak Chandra < >>> [email protected]> wrote: >>> >>>> Hi, >>>> >>>> I did create a new app, and used the access key when doing a post to >>>> the event server. >>>> When i run pio app list, I do see the app that I created here >>>> >>>> [INFO] [App$] MpApp | 1 | -my-access-key | (all) >>>> >>>> >>>> Post request I made from my terminal : >>>> >>>> curl -i -X POST http://localhost:7070/events.j >>>> son\?accessKey\=-my-access-key \ >>>> >>>> -H "Content-Type: application/json" \ >>>> >>>> -d '{ >>>> >>>> "event" : "$set", >>>> >>>> "entityType" : "user", >>>> >>>> "entityId" : "u0" >>>> >>>> }' >>>> >>>> >>>> Response I get : >>>> >>>> HTTP/1.1 500 Internal Server Error >>>> >>>> Server: spray-can/1.3.3 >>>> >>>> Date: Tue, 31 Jan 2017 21:46:24 GMT >>>> >>>> Content-Type: application/json; charset=UTF-8 >>>> >>>> Content-Length: 76 >>>> >>>> >>>> {"message":"ERROR: relation \"pio_event_1\" does not exist\n Position: >>>> 20"}*%* >>>> >>>> On a side note : I also checked to see that the event server was up : >>>> localhost:7070 : Shows the JSON {"status":"alive"} >>>> >>>> >>>> >>>> On Tue, Jan 31, 2017 at 4:39 PM, Tom Chan <[email protected]> >>>> wrote: >>>> >>>>> As a quick check, did you do >>>>> >>>>> pio app new MyApp1 >>>>> >>>>> and what's the output when you run >>>>> >>>>> pio app list >>>>> >>>>> ? and what's the POST request you're trying that returned error 500? >>>>> >>>>> Tom >>>>> >>>>> On Tue, Jan 31, 2017 at 12:48 PM, Saarthak Chandra < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I am currently using Postgresql , as my storage repo for event data. >>>>>> >>>>>> However, when i do a POST using curl, to the event server at >>>>>> 'localhost:7070', I get a Http 500 error saying : >>>>>> >>>>>> {"message":"ERROR: relation \"pio_event_1\" does not exist\n >>>>>> Position: 20"} >>>>>> Shouldn't the table/relation be created automatically, and then the >>>>>> data I posted be inserted ?? >>>>>> >>>>>> I was following along the tutorials here : >>>>>> http://predictionio.incubator.apache.org/templates/javaeco >>>>>> mmercerecommendation/quickstart/ >>>>>> >>>>>> Thanks for your help !! >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Saarthak Chandra , >>>> Masters in Computer Science, >>>> Cornell University. >>>> >>> >>> >
