Yes following is the response of pio status sudo PredictionIO-0.10.0-incubating/bin/pio status [INFO] [Console$] Inspecting PredictionIO... [INFO] [Console$] PredictionIO 0.10.0-incubating is installed at /home/ekbana-php/Downloads/apache-predictionio-0.10.0-incubating/PredictionIO-0.10.0-incubating [INFO] [Console$] Inspecting Apache Spark... [INFO] [Console$] Apache Spark is installed at /home/ekbana-php/Downloads/apache-predictionio-0.10.0-incubating/PredictionIO-0.10.0-incubating/vendors/spark-1.5.1-bin-hadoop2.6 [INFO] [Console$] Apache Spark 1.5.1 detected (meets minimum requirement of 1.3.0) [INFO] [Console$] Inspecting storage backend connections... [INFO] [Storage$] Verifying Meta Data Backend (Source: PGSQL)... [ERROR] [Console$] Unable to connect to all storage backends successfully. The following shows the error message from the storage backend. [ERROR] [Console$] FATAL: password authentication failed for user "pio" (org.postgresql.util.PSQLException) [ERROR] [Console$] Dumping configuration of initialized storage backend sources. Please make sure they are correct. [ERROR] [Console$] Source Name: PGSQL; Type: jdbc; Configuration: URL -> jdbc:postgresql://localhost/pio, PASSWORD -> pio, TYPE -> jdbc, USERNAME -> pio
Which says that postgresql authentication failed. Ok I'm trying to go for postgresql this time instead of mysql, I don't wanna lose much time fighting with this two sql. I can use any of them, it just need to work. Thanks On Thu, Mar 23, 2017 at 11:00 PM, Marius Rabenarivo < [email protected]> wrote: > How do you start the services? > > The is a script named pio-start-all in $PIO_HOME/bin to do it you can > check it to see what you have to start before using pio commands. > > Try doing pio status to check if all required services are running > properly. > > 2017-03-23 21:04 GMT+04:00 Vaghawan Ojha <[email protected]>: > >> Yes that's what I wanted to do, but couldn't come out to configure it. No >> matter how much I change in the pio-env.sh.template, when I start the event >> server it always pops up with the posgresql error of authentication. >> >> I even tried with posgresql and it shows the same things. Party something >> to do with my dumbness I guess. >> >> Thank you very much Marius. >> >> On Thu, Mar 23, 2017 at 10:39 PM, Marius Rabenarivo < >> [email protected]> wrote: >> >>> You can use MySQL as event store but you need ElasticSearch to store the >>> model metadata and index used by UR Engine. >>> >>> 2017-03-23 20:25 GMT+04:00 Vaghawan Ojha <[email protected]>: >>> >>>> But I wanted to use mysql as default. Should I switch it? I can do >>>> that, but I was just wondering since the documentation says that I could >>>> use mysql. >>>> >>>> On Thu, Mar 23, 2017 at 10:03 PM, Marius Rabenarivo < >>>> [email protected]> wrote: >>>> >>>>> I think pio-start-all start PostgreSQL by default >>>>> >>>>> 2017-03-23 20:16 GMT+04:00 Vaghawan Ojha <[email protected]>: >>>>> >>>>>> Hi, >>>>>> >>>>>> Yes I did that but still I get the same output, it's weird. >>>>>> >>>>>> Thanks >>>>>> >>>>>> On Thu, Mar 23, 2017 at 10:00 PM, Marius Rabenarivo < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> You have to change this section >>>>>>> >>>>>>> # Default is to use PostgreSQL >>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_NAME=pio_meta >>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_SOURCE=PGSQL >>>>>>> >>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_NAME=pio_event >>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_SOURCE=PGSQL >>>>>>> >>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_NAME=pio_model >>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_SOURCE=PGSQL >>>>>>> >>>>>>> Put MYSQL in place of PGSQL >>>>>>> >>>>>>> 2017-03-23 20:07 GMT+04:00 Vaghawan Ojha <[email protected]>: >>>>>>> >>>>>>>> Hi, Thank you! >>>>>>>> >>>>>>>> I came into further more confusion here, actually I installed >>>>>>>> prediction IO version 0.10.0 from here http://predictionio.incub >>>>>>>> ator.apache.org/install/install-sourcecode/ and have been >>>>>>>> fighting to configure mysql as a storage in my local linux machine. >>>>>>>> >>>>>>>> But I see there is a different documentation of installing in >>>>>>>> actionml website, I'm not sure for which I would have to go. Currently >>>>>>>> there is no "pio-env.sh". file inside conf folder however there >>>>>>>> is pio-env.sh.template file. I commented the pgsql section and >>>>>>>> uncommented >>>>>>>> the mysql section with the username and password, but whenever I do . >>>>>>>> sudo >>>>>>>> PredictionIO-0.10.0-incubating/bin/pio eventserver there seems to >>>>>>>> be an error that says that authentication failed with pgsql, however I >>>>>>>> don't want to use pgsql. >>>>>>>> >>>>>>>> # Storage Repositories >>>>>>>> >>>>>>>> # Default is to use PostgreSQL >>>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_NAME=pio_meta >>>>>>>> PIO_STORAGE_REPOSITORIES_METADATA_SOURCE=PGSQL >>>>>>>> >>>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_NAME=pio_event >>>>>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_SOURCE=PGSQL >>>>>>>> >>>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_NAME=pio_model >>>>>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_SOURCE=PGSQL >>>>>>>> >>>>>>>> # Storage Data Sources >>>>>>>> >>>>>>>> # PostgreSQL Default Settings >>>>>>>> # Please change "pio" to your database name in >>>>>>>> PIO_STORAGE_SOURCES_PGSQL_URL >>>>>>>> # Please change PIO_STORAGE_SOURCES_PGSQL_USERNAME and >>>>>>>> # PIO_STORAGE_SOURCES_PGSQL_PASSWORD accordingly >>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_TYPE=jdbc >>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_URL=jdbc:postgresql://localhost/pio >>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_USERNAME=pio >>>>>>>> #PIO_STORAGE_SOURCES_PGSQL_PASSWORD=pio >>>>>>>> >>>>>>>> # MySQL Example >>>>>>>> PIO_STORAGE_SOURCES_MYSQL_TYPE=jdbc >>>>>>>> PIO_STORAGE_SOURCES_MYSQL_URL=jdbc:mysql://localhost/pio >>>>>>>> PIO_STORAGE_SOURCES_MYSQL_USERNAME=root >>>>>>>> PIO_STORAGE_SOURCES_MYSQL_PASSWORD=root >>>>>>>> >>>>>>>> >>>>>>>> This is how the pio-env.sh.template looks like. And again when I >>>>>>>> visited the actionml site, it suggests that I do have to have >>>>>>>> ELASTICSEARCH. but prediction.io site doesn't tells us the same. >>>>>>>> Which one should I follow and where would I find the current working >>>>>>>> version of installation guide. I actually wanaa use prediction.io >>>>>>>> in my production shortly after I implemented in local. >>>>>>>> >>>>>>>> Please help me, thank you very much for your help, I appreciate it >>>>>>>> so much. >>>>>>>> Vaghawan >>>>>>>> >>>>>>>> >>>>>>>> On Thu, Mar 23, 2017 at 9:27 PM, Pat Ferrel <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Since PIO has moved to Apache, the namespace of PIO code changed >>>>>>>>> and so all templates need to be updated. None of the ones in >>>>>>>>> https://github.com/PredictionIO/ >>>>>>>>> <https://github.com/PredictionIO/template-scala-parallel-universal-recommendation> >>>>>>>>> will >>>>>>>>> work with Apache PIO. For the upgraded UR see: >>>>>>>>> https://github.com/actionml/universal-recommender Docs for the UR >>>>>>>>> are here: http://actionml.com/docs/ur >>>>>>>>> >>>>>>>>> Also look on the Template gallery page here for a description of >>>>>>>>> template status. Some have not been moved to the new namespace and >>>>>>>>> converted to run with PIO but this is pretty easy to do yourself. >>>>>>>>> http://predictionio.incubator.apache.org/gallery/template-gallery/ >>>>>>>>> >>>>>>>>> user_id, product_id and purchase_date is all you need to use any >>>>>>>>> recommender. If you plan to gather other events in the future, use >>>>>>>>> the UR. >>>>>>>>> As far as item or user based recommendations, the UR will give either >>>>>>>>> based >>>>>>>>> on the query with the same data and model, as some others will do. >>>>>>>>> The UR >>>>>>>>> allows you to mix both types in a single query, which may be useful >>>>>>>>> with >>>>>>>>> small amounts of individual user data. >>>>>>>>> >>>>>>>>> Also the accepted wisdom about this it to put item-based recs on >>>>>>>>> item detail pages, and user-based recs elsewhere, when you don’t have >>>>>>>>> an >>>>>>>>> item to base recs on, or in another placement on any page. >>>>>>>>> >>>>>>>>> You can have many different placements of recs in any page by >>>>>>>>> changing the queries. This is how Netflix gets rows and rows of >>>>>>>>> specialized >>>>>>>>> recs for different things all based on the same data. The UR queries >>>>>>>>> are >>>>>>>>> quite flexible. >>>>>>>>> >>>>>>>>> >>>>>>>>> On Mar 23, 2017, at 7:08 AM, Vaghawan Ojha <[email protected]> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I've been trying to deploy a recommendation system using >>>>>>>>> https://github.com/PredictionIO/template-scala-paralle >>>>>>>>> l-universal-recommendation. >>>>>>>>> >>>>>>>>> I've purchase history of user something like this: >>>>>>>>> user_id, product_id and purchase_date, so I will be using user_id >>>>>>>>> and product_id to determine the recommendation. I'm not sure if I >>>>>>>>> would be >>>>>>>>> able to customize the default even parameter. >>>>>>>>> >>>>>>>>> Do you have any suggestions like which template would be more >>>>>>>>> suitable for my problem. I don't have data like rating or view state, >>>>>>>>> I >>>>>>>>> only have data about user and product they purchased. I need >>>>>>>>> something like >>>>>>>>> item based similarity as well as user based item similarity. >>>>>>>>> >>>>>>>>> Any help would be great >>>>>>>>> >>>>>>>>> Thank you >>>>>>>>> Vaghawan >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
