Oh ya, I fixed but with the same thing in my hand it still search for PGSQL.
On Thu, Mar 23, 2017 at 11:51 PM, Ambuj Sharma <[email protected]> wrote: > check your pio-env.sh. Every configuration is copied twice > > > Thanks and Regards > Ambuj Sharma > Sunrise may late, But Morning is sure..... > Team ML > Betaout > > On Thu, Mar 23, 2017 at 11:26 PM, Vaghawan Ojha <[email protected]> > wrote: > >> Still got the same unfortunately: >> >> this is pio status >> >> ionIO-0.10.0-incubating/bin/pio status >> [INFO] [Console$] Inspecting PredictionIO... >> [INFO] [Console$] PredictionIO 0.10.0-incubating is installed at >> /var/www/apache-predictionio-0.10.0-incubating/PredictionIO- >> 0.10.0-incubating >> [INFO] [Console$] Inspecting Apache Spark... >> [INFO] [Console$] Apache Spark is installed at >> /var/www/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 >> >> and I've attacted the pio-env.sh. Any help? >> >> On Thu, Mar 23, 2017 at 11:37 PM, Ambuj Sharma <[email protected]> >> wrote: >> >>> copy pio-env.sh.template to pio-env.sh. >>> >>> >>> Thanks and Regards >>> Ambuj Sharma >>> Sunrise may late, But Morning is sure..... >>> Team ML >>> Betaout >>> >>> On Thu, Mar 23, 2017 at 11:13 PM, Vaghawan Ojha <[email protected]> >>> wrote: >>> >>>> There is no file called pio-env.sh however there is >>>> pio-env.sh.template. Are they the same? >>>> >>>> On Thu, Mar 23, 2017 at 11:11 PM, Marius Rabenarivo < >>>> [email protected]> wrote: >>>> >>>>> # Default is to use PostgreSQL >>>>> PIO_STORAGE_REPOSITORIES_METADATA_NAME=pio_meta >>>>> PIO_STORAGE_REPOSITORIES_METADATA_SOURCE=MYSQL >>>>> >>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_NAME=pio_event >>>>> PIO_STORAGE_REPOSITORIES_EVENTDATA_SOURCE=MYSQL >>>>> >>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_NAME=pio_model >>>>> PIO_STORAGE_REPOSITORIES_MODELDATA_SOURCE=MYSQL >>>>> >>>>> >>>>> 2017-03-23 21:24 GMT+04:00 Marius Rabenarivo < >>>>> [email protected]>: >>>>> >>>>>> You have to change the config in pio-env.sh to use MYSQL instead of >>>>>> PGSQL >>>>>> >>>>>> In the pasted response above I can read Verifying Meta Data Backend >>>>>> (Source: PGSQL)... >>>>>> >>>>>> 2017-03-23 21:19 GMT+04:00 Vaghawan Ojha <[email protected]>: >>>>>> >>>>>>> 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-incuba >>>>>>> ting/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-incuba >>>>>>> ting/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.incubator.apache.org/install/instal >>>>>>>>>>>>>>> l-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/p >>>>>>>>>>>>>>> io >>>>>>>>>>>>>>> #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 >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
pio-env.sh
Description: Bourne shell script
