[Halld] JInventory
Serguei Pozdniakov
sergpozd at jlab.org
Fri Mar 27 14:32:27 EDT 2015
Hi Manuel,
Of cause you can try to do the full size upload to the test Database:
SP_JInventory.
But, prior to make the final upload to the real Hall-D JInventory Database,
I think, all appropriate Hall-D staff and interested in it people should
be informed
about this huge upload of completely new kind of items.
How about to make a presentation on some of Hall-D meetings?
Best regards, Serguei P.
P.S. I'm just a contractor. And decision about so huge update should be
done by
responsible Hall-D staff man.
On 3/27/15 12:28 PM, Manuel Lara wrote:
> I've showed people at IU the db and they seem pleased with it. Early
> next week I will try to upload the full 2800 cell FCAL.
>
> On Tue, Mar 24, 2015 at 5:22 PM, Serguei Pozdniakov <sergpozd at jlab.org
> <mailto:sergpozd at jlab.org>> wrote:
>
> Fixed.
> I removed symbol (') from room's short name.
> It is impossible to use (') here. It goes to SQL query and ruins
> SQL syntax.
>
>
>
>
> On 3/24/15 4:47 PM, Manuel Lara wrote:
>> I'm playing with the db and when I try to change the location of
>> a base from the survey table to Pauls Workshop I get the
>> following error:
>>
>> Query failed: You have an error in your SQL syntax; check the
>> manual that corresponds to your MariaDB server version for the
>> right syntax to use near 's Worshop (1680) > Comment: Test. Send
>> to Paul ' , ITM_PurchaseReq = '', IT' at line 1
>>
>> On Tue, Mar 24, 2015 at 1:42 PM, Serguei Pozdniakov
>> <sergpozd at jlab.org <mailto:sergpozd at jlab.org>> wrote:
>>
>> I'm in my office.
>>
>>
>> On 3/24/15 1:39 PM, Manuel Lara wrote:
>>> Will you be in your office today? I've been playing with the
>>> db and moving bases around and it seems to be working great.
>>> I would like to add IU and some rooms at IU to the db like
>>> we discussed.
>>>
>>> The rooms associated with IU are be:
>>> SW 262
>>> Paul's Shop
>>>
>>> On Thu, Mar 19, 2015 at 11:05 PM, Manuel Lara
>>> <manlara at umail.iu.edu <mailto:manlara at umail.iu.edu>> wrote:
>>>
>>> Thanks, I fixed fixed the BFM for the detector
>>>
>>> On Thu, Mar 19, 2015 at 9:51 PM, Serguei Pozdniakov
>>> <sergpozd at jlab.org <mailto:sergpozd at jlab.org>> wrote:
>>>
>>> DB cleaned up.
>>> Could you fix BFM for Detector. From my point of
>>> view it should be:
>>> IU - FCAL Detector - N/A
>>> Regards, S.P.
>>>
>>>
>>>
>>> On 03/19/2015 05:00 PM, Manuel Lara wrote:
>>>
>>> Could you reset the db. I made some duplicate
>>> entries for the bases that I can't delete
>>>
>>> On Thu, Mar 19, 2015 at 1:24 PM, Serguei
>>> Pozdniakov <sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>>
>>> wrote:
>>>
>>> I'm in my office and planning to be here
>>> till 5 p.m.
>>> Call me 5464.
>>> Serguei P.
>>>
>>>
>>>
>>> On 03/19/2015 12:25 PM, Manuel Lara wrote:
>>>
>>> Hi Serguei,
>>>
>>> Will you be around later today or
>>> tomorrow? I would really like to get the
>>> database stuff
>>> situated
>>> so people back at IU could start using it.
>>>
>>> On Sun, Mar 1, 2015 at 12:53 PM, Serguei
>>> Pozdniakov <sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>>>
>>> wrote:
>>>
>>> Hi Manuel,
>>>
>>> Let's talk about FCAL hierarchy on
>>> Monday.
>>> We have to modify formats for all
>>> yours new items.
>>>
>>> Regards, Serguei P.
>>>
>>>
>>>
>>>
>>>
>>> On 2/27/15 8:38 AM, Manuel Lara wrote:
>>>
>>> Hi Serguei,
>>>
>>> Here's a quick look at the hierarchy of the FCAL
>>>
>>> HallD => D2 => X_Y => Base or PMT,
>>> Base => Can, Base => SockBoard, Base =>
>>> TranBoard, Base => CommBoard, Base => MultBoard
>>>
>>> I am playing with the database
>>> and seeing what happens If I move a Base to the
>>> survey table.
>>> What I would like is that all the children of
>>> Base would also be moved to the
>>> survey table but
>>> when I try with
>>> https://halldweb1.jlab.org/SP___JInventory/htdocs/editItem.__php?id=1699
>>>
>>> <https://halldweb1.jlab.org/SP_JInventory/htdocs/editItem.php?id=1699>
>>> I get an error:
>>>
>>> *Location Error: Unknown Format*
>>> * For more information send
>>> mail to Serguei Pozdniakov : sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>>*
>>> *
>>> *
>>> Is this because this function is somehow broken
>>> in the test database?
>>> In the production db will all the children of
>>> Base move with Base?
>>>
>>> On Wed, Feb 25, 2015 at 11:49 AM, Serguei
>>> Pozdniakov <sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>>> wrote:
>>>
>>> Yes, I should be around, maybe not all day in
>>> my office,
>>> but just call me 5464 before you come in.
>>> Serguei P.
>>>
>>>
>>>
>>>
>>>
>>> On 2/25/15 11:11 AM, Manuel Lara wrote:
>>>
>>> Will you be available sometime tomorrow?
>>> I can go over what I have.
>>>
>>> On Wed, Feb 25, 2015 at 10:35 AM, Serguei
>>> Pozdniakov <sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>
>>> <mailto:sergpozd at jlab.org
>>> <mailto:sergpozd at jlab.org>>>> wrote:
>>>
>>> Hi Manuel,
>>>
>>> It seems that Marty did a copy of our
>>> databases before I granted you as
>>> a user.
>>> I gave you access again, but this
>>> time without password.
>>> You can set new password for yourself
>>> by typing:
>>>
>>> mysql> SET PASSWORD = PASSWORD('blablabla');
>>>
>>> Both halldweb1 and halldweb are
>>> working now for:
>>>
>>> jlab> mysql -h halldweb -D SP_JInventory -u manlara
>>>
>>>
>>> Regards, Serguei P.
>>>
>>> P.S. Before you will populate all
>>> your thousands item
>>> can you inform me about final
>>> structure of FCAL items in DB?
>>>
>>>
>>>
>>>
>>>
>>> On 02/25/2015 08:51 AM, Manuel Lara
>>> wrote:
>>>
>>>
>>> Hi Serguei,
>>>
>>> I am trying to log into
>>> SP_JInventory but I get the following error:
>>>
>>> ifarm1401> mysql -h halldweb1 -D SP_JInventory -p
>>> Enter password:
>>> ERROR 1045 (28000): Access denied for user
>>> 'manlara'@'ifarm1401.jlab.org
>>> <http://ifarm1401.jlab.org>
>>> <http://ifarm1401.jlab.org>
>>> <http://ifarm1401.jlab.org>
>>> <http://ifarm1401.jlab.org>' (using password: YES)
>>>
>>> Maybe I lost permission to the database after
>>> the upgrade
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mailman.jlab.org/pipermail/halld/attachments/20150327/0be6eede/attachment-0001.html
More information about the Halld
mailing list