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> > > > > > > > >> > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > >
