Hi Marcus,
It should be part of git history.
Andy
On Fri, 9 Dec 2016, Marcus Ebert wrote:
> Hi Andy,
>
> Yes, the access seems to work now. The version I use is the one I got using
> "RELEASE=qserv_latest" during the install at the beginning of November. From
> the directory structure under Linux64/qserv it seems to be version
> 12.1.rc1-2-gaa0865a.
>
> BTW: Is there somewhere a release history available with changes made between
> versions?
>
>
> Cheers,
> Marcus
>
>
> On Fri, 9 Dec 2016, Andrew Hanushevsky wrote:
>
>> Hi Marcus,
>>
>> Ah, yes. So, the qserv version that you were using wasn't the one that I
>> posted fixes to which caused misleading messages in the log. So, never
>> mind. As long as mono-node worked fine after your changes then all is well.
>>
>> Andy
>>
>> On Fri, 9 Dec 2016, Marcus Ebert wrote:
>>
>>> Hi Andy,
>>>
>>> Yes, it should be configured as a mono-node, at least I have not changed
>>> anything on the default config which I understood is a mono-node config.
>>> To install, I followed the quick-start guide and the integration tests at
>>> the end worked too (and still work).
>>> lsp.cf uses the "all.role server" directive only.
>>>
>>> What finally seems to have made the access working was to add entries for
>>> the new databases to qservw_worker.Dbs
>>>
>>>
>>> Cheers,
>>> Marcus
>>>
>>>
>>> On Thu, 8 Dec 2016, Andrew Hanushevsky wrote:
>>>
>>> > Hi Marcus,
>>> > > If you configured it as a mono-node then you are correct. However, my
>>> > understanding (and what the log appears to show) qserv was configured
>>> as > a clustered system. So, even with one worker you would still need a
>>> > redirector and the associated cmsd processes. So, the big question is >
>>> how was this really configured. That would be answered by what is in the
>>> > qserv-run/etc/lsp.cf configuration file.
>>> > > Andy
>>> > > On Thu, 8 Dec 2016, Marcus Ebert wrote:
>>> > > > Hi Vaikunth,
>>> > > > > Thanks for looking at the logs!
>>> > > I'm running 1 czar and 1 worker on 1 machine. To start up qserv, I >
>>> > used
>>> > > the qserv-start.sh script. On a single machine there doesn't need to
>>> > > be a
>>> > > running cmsd, does it?
>>> > > > > Cheers,
>>> > > Marcus
>>> > > > > On Wed, 7 Dec 2016, Thukral, Vaikunth wrote:
>>> > > > > > 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, wed happy to > > If > > 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, > > can > > > show > > the > > > tables and
>>> columns of a table, but "select" queries just > > the > > > 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 > > the > > > 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
>>> > > > > > > --
>>> > > 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
>>> > > > > >
>>> --
>>> 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
>>>
>>
>>
>>
>
> --
> 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
|