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