LISTSERV mailing list manager LISTSERV 16.5

Help for QSERV-L Archives


QSERV-L Archives

QSERV-L Archives


QSERV-L@LISTSERV.SLAC.STANFORD.EDU


View:

Message:

[

First

|

Previous

|

Next

|

Last

]

By Topic:

[

First

|

Previous

|

Next

|

Last

]

By Author:

[

First

|

Previous

|

Next

|

Last

]

Font:

Proportional Font

LISTSERV Archives

LISTSERV Archives

QSERV-L Home

QSERV-L Home

QSERV-L  December 2016

QSERV-L December 2016

Subject:

Re: accessing db in qserv remotely

From:

"Thukral, Vaikunth" <[log in to unmask]>

Reply-To:

General discussion for qserv (LSST prototype baseline catalog)

Date:

Wed, 7 Dec 2016 22:52:01 +0000

Content-Type:

text/plain

Parts/Attachments:

Parts/Attachments

text/plain (1 lines)

Hi Marcus,

Fritz shared with us the logs you sent and we believe it may be because the cmsd service did not start up. To be certain, could you also send us the cmsd logs (usually called “cmsd.log” and “cmsd_<date>.log” if rolled over) from both the czar and the worker instances? Also, what kind of instance are you running - 1 czar and 1 worker on 2 separate machines or on 1 machine?

Thanks,
-Vaikunth

> On Dec 2, 2016, at 11:09 AM, Fritz Mueller <[log in to unmask]> wrote:
> 
> Hi Marcus,
> 
> I think the log files would would need to be examined for clues.  If you tgz them up shoot them to me in an email, we’d happy to take a look?
> 
> 	—FritzM.
> 
>> On Dec 2, 2016, at 2:52 AM, Marcus Ebert <[log in to unmask]> wrote:
>> 
>> Hi,
>> 
>> We were trying out qserv installations since a while here in Edinburgh and have now an own database loaded into it (UKIDSS, ~4TB).
>> That worked fine in the end(we tried so far just a single node installation to get familar with it and while the other machines for the test bed gets installed). On the machine where qserv runs, we can connect as qsmaster using mysql.sock and do queries on the database tables, including select queries.
>> 
>> However, connecting through port 4040 shows some problems. We can connect, list available databases, select the a database, show the tables and columns of a table, but "select" queries just hang. It's also the same on the local qserv machine if not going through the socket but specifiying local host name and port 4040, as well as remotely from another machine.
>> 
>> Does anyone kow what else needs to be changed in the qserv configuration to have this working? I already looked to the grant permissions for qsmaster, but these seem to be the same when connecting on localhost through socket and through port 4040. (also changing these for remote access doesn't change anything)
>> 
>> 
>> 
>> Cheers,
>> Marcus
>> 
>> -- 
>> The University of Edinburgh is a charitable body, registered in
>> Scotland, with registration number SC005336.
>> 
>> ########################################################################
>> Use REPLY-ALL to reply to list
>> 
>> To unsubscribe from the QSERV-L list, click the following link:
>> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1
> 
> ########################################################################
> Use REPLY-ALL to reply to list
> 
> To unsubscribe from the QSERV-L list, click the following link:
> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1


########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1

Top of Message | Previous Page | Permalink

Advanced Options


Options

Log In

Log In

Get Password

Get Password


Search Archives

Search Archives


Subscribe or Unsubscribe

Subscribe or Unsubscribe


Archives

March 2018
February 2018
January 2018
December 2017
August 2017
December 2016
November 2016
October 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
February 2014
January 2014
December 2013
November 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2013
April 2013
March 2013
February 2013
January 2013
December 2012

ATOM RSS1 RSS2



LISTSERV.SLAC.STANFORD.EDU

Secured by F-Secure Anti-Virus CataList Email List Search Powered by the LISTSERV Email List Manager

Privacy Notice, Security Notice and Terms of Use