Hi Siddarth Thanks for the reply. I also addressed mysql jdbc connection issues in RHEL 6 per https://unix.stackexchange.com/questions/145416/mysql-jdbc-connection-issues-in-rhel-6
I see no error at the eagle-server.log any more as I used to get (java.net.UnknownHostException: server.eagle.apache.org). However GUI fails to load. (http://101-02-08-node1.internal.bigtdata.io:9090/ does not load) 1) [root@101-02-08-node1 tmp]# cat /etc/hosts 127.0.0.1 server.eagle.apache.org localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 2) [root@101-02-08-node1 tmp]# mysql -u root -p -hlocalhost Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 40 Server version: 5.6.38 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. grant all privileges on . to root; 3) Edit /etc/my.cnf file The last exception was promising. It says connection refused rather than saying something like not able to resolve the hostname. So, I thought something should be changed in the /etc/my.cnf file and I added the below lines to the file. port=3306 bind-address=0.0.0.0 Tushar Shah [email protected] +1 732 673 0210 cell On 2019/03/01 03:30:28, Sidharth Kumar <[email protected]> wrote: > Hi Tushar, > > You can verify mysql connectivity using below command > #mysql -u<username> -p -hlocalhost > > Generally mysql server bind to 0.0.0.0 so local host will work but prefer > to always use hostname of your server and if you do not have DNS > configured make entry in /etc/hosts for same. > > Warm Regards > > Sidharth Kumar | Mob: +91 8197 555 599| Skype: itzsidharth > > On Fri, 1 Mar, 2019, 2:54 AM [email protected], <[email protected]> > wrote: > > > Hi Jay > > (believe Jayesh Senjaliya ) > > I changed my eagle.conf and changed all references of the > > server.eagle.apache.org to loca lhost > > So at the Eagle Metadata Store Configuration, I changed the > > definition from > > connection = "jdbc:mysql://server.eagle.apache.org:3306/eagle" > > to : connection = "jdbc:mysql://localhost:3306/eagle" > > However. I have same issue with that GUI does not load. At the > > server.log I see > > ERROR [2019-02-28 00:00:05,349] > > org.apache.eagle.metadata.store.jdbc.JDBCMetadataMetadataStoreServiceImpl: > > Error to query batch: SELECT * FROM applications a INNER JOIN sites s on > > a.siteid = s.siteid > > ! java.net.UnknownHostException: server.eagle.apache.org > > Seems error referring to server.eagle.apache.org is coming from the > > code . I do not ssee ant reference to server.eagle.apache.org at the > > code . > > eagle-core/eagle-metadata/eagle-metadata-jdbc/src/main/java/org/apache/eagle/metadata/store/jdbc/JDBCMetadataMetadataStoreServiceImpl.java > > > > > > wonder if there is a way I can test my jdbc:mysql connection form > > command line ? > > I modified my .etc/hosts to add server.eagle.apache.org > > 127.0.0.1 server.eagle.apache.org localhost localhost.localdomain > > localhost4 localhost4.localdomain4 > > Following is my eagle.conf. > > > > # --------------------------------------------- > > # Eagle Metadata Store Configuration > > ## changed #connection = "jdbc:mysql://server.eagle.apache.org:3306/eagle" > > # --------------------------------------------- > > metadata { > > ##store = org.apache.eagle.metadata.service.memory.MemoryMetadataStore > > store = org.apache.eagle.metadata.store.jdbc.JDBCMetadataStore > > jdbc { > > username = "root" > > password = "" > > driverClassName = com.mysql.jdbc.Driver > > database = "eagle" > > connection = "jdbc:mysql://localhost:3306/eagle" > > } > > } > > > > > > On 2019/02/28 06:05:57, Jay Sen <[email protected]> wrote: > > > Hi Tushar, > > > > > > looks like you havent configured the mysql and other properties properly. > > > > > > can u share the config? make sure you have lcoalhost for mysql connection > > > instead of server.eagle.apache.org. > > > > > > Thanks > > > Jay > > > > > > > > > > > > On Wed, Feb 27, 2019 at 10:00 PM SHAH, TUSHAR <[email protected]> wrote: > > > > > > > Hi Hao Chen,,Apache Eagele project managers > > > > > > > > > > > > > > > > I would like to follow up on the following issue . I have attached the > > > > word document describe how installed. > > > > > > > > > > > > > > > > The key issue is after starting the Eagle, the Eagle Dashboard/GUI does > > > > not load at the browser at the defined port ( 9090 by default). > > > > > > > > At the same node (8080) the Ambari and Hortonworks services work > > fine. > > > > > > > > > > > > > > > > I have added the snapshot of the browser using the development tool > > > > showing that many URL request failed because of code generating > > invalid > > > > RLS > > > > > > > > > > > > > > > > At the log I see error related to JDBC connection > > > > > > > > > > > > > > > > ERROR [2019-02-28 05:23:31,482] > > > > > > org.apache.eagle.metadata.store.jdbc.JDBCMetadataMetadataStoreServiceImpl: > > > > Error to query batch: SELECT * FROM applications a INNER JOIN sites s > > on > > > > a.siteid = s.siteid > > > > > > > > ! java.net.UnknownHostException: server.eagle.apache.org: Name or > > service > > > > not known > > > > > > > > > > > > > > > > ! java.net.UnknownHostException: server.eagle.apache.org: Name or > > service > > > > not known > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > Tushar Shah > > > > > > > > 732 420 2139 W > > > > > > > > > > > > > > > > > > > > > > > > *From:* SHAH, TUSHAR > > > > *Sent:* Thursday, February 21, 2019 10:44 AM > > > > *To:* '[email protected]' <[email protected]> > > > > *Subject:* Re: Apache Eagle unable to start > > > > > > > > > > > > > > > > Reference : https://lists.apache.org/[email protected] > > > > > > > > > > > > > > > > Hi Hao Chen. > > > > > > > > > > > > > > > > Backround: This is what I did: > > > > > > > > I am following the instructions here. > > > > > > > > > > > > > > > > https://eagle.apache.org/docs/latest/getting-started/#deployment > > > > > > > > I downloaded Eagle version 0.5 souce code from here at > > > > http://101-02-08-node1.internal.bigtdata.io:8080/#/login > > > > > > > > > > > > > > > > https://github.com/apache/eagle.git to my Ambari Linux server > > node > > > > running A cluster. > > > > > > > > > > > > > > > > I compiled the code successfully using “mvn clean *install* > > –DskipTests” > > > > > > > > > > > > > > > > After build the source code, and a tar.gz package is enerated under > > > > eagle-server-assembly/target as per > > > > https://eagle.apache.org/docs/latest/getting-started/#deployment > > > > > > > > > > > > > > > > I successfully serve the Eagle > > > > > > > > ./bin/eagle-server.sh start > > > > > > > > > > > > > > > > http://101-02-08-node1.internal.bigtdata.io:9090/ > > > > > > > > > > > > > > > > When I check the eagle server , It says in “loading” mode forever. The > > > > full GUI does not het loaded. > > > > > > > > *I have also attached the server log from in the text file * > > > > > > > > > > > > > > /root/eagle/eagle-assembly/target/eagle-0.5.1-SNAPSHOT-bin/eagle-0.5.1-SNAPSHOT/log > > > > > > > > > > > > > > > > I essentially do not see in log any error except repeats of “NFO > > > > [2019-02-21 15:20:49,462] > > > > org.apache.eagle.alert.coordinator.trigger.DynamicPolicyLoader: No > > policy > > > > (totally 0) changed since last round > > > > > > > > “ > > > > > > > > > > > > > > > > > > > > > > > > Thankyou very much / > > > > > > > > > > > > > > > > Tushar Shha > > > > > > > > Big Data Software Engineer > > > > > > > > AT&T > > > > > > > > 732 420 2139 > > > > > > > > On 2019/02/13 01:11:23, Hao Chen <[email protected]> wrote: > > > > > > > > > Hi SHA TUSHAR,> > > > > > > > > > > > > > > > > > > Could you please provide more details about the errors to fail to > > start> > > > > > > > > > eagle?> > > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks & Regards,> > > > > > > > > > > > > > > > > > > Hao Chen> > > > > > > > > > > > > > > > > > > On Wed, Feb 13, 2019 at 6:50 AM SHAH, TUSHAR <[email protected]> wrote:> > > > > > > > > > > > > > > > > > > > Hi> > > > > > > > > > > I am trying POC ( Proof of concept) for the Apache Eagle at > > AT&T.> > > > > > > > > > >> > > > > > > > > > > At my test cluster I am running Hadoop 2.6 with Ambrai and other> > > > > > > > > > > components of the Hadoop Eco system, having the required > > > > pre-requisites per> > > > > > > > > > > https://eagle.apache.org/docs/latest/getting-started/#quick-start > > > > or> > > > > > > > > > > https://eagle.apache.org/docs/latest/getting-started/#deployment> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > > [root@103-01-18-node1 tushar]# git clone> > > > > > > > > > > https://github.com/apache/eagle.git> > > > > > > > > > >> > > > > > > > > > > I installed it but it does not start the eagle though ./ > > > > eagle-server.sh> > > > > > > > > > > start> > > > > > > > > > >> > > > > > > > > > > Can you give me some hint or help ?> > > > > > > > > > > Thanks> > > > > > > > > > > Tushar Shha> > > > > > > > > > > Big Dat Software Eng,> > > > > > > > > > > AT&T> > > > > > > > > > > 732 420 2139> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > > > > > > > > > > > >
