Re: Tech-talk Digest, Vol 17, Issue 351

["Lee L. Yang via Tech-talk" <tech-talk at aps.anl.gov>]

Re: has anyone used ADPICam in a docker

Yes, I tried various methods to elevate permission when running:

docker run ...

No help.

I believe the problem is inside the PICAM's driver. But I don't know what it is.

I'm hoping to hear a success story from anyone with a real camera (with docker set up).

On Thu, Jun 29, 2023 at 4:54 AM <tech-talk-request at aps.anl.gov> wrote:

Send Tech-talk mailing list submissions to
        tech-talk at aps.anl.gov

To subscribe or unsubscribe via the World Wide Web, visit
        https://mailman.aps.anl.gov/mailman/listinfo/tech-talk
or, via email, send a message with subject or body 'help' to
        tech-talk-request at aps.anl.gov

You can reach the person managing the list at
        tech-talk-owner at aps.anl.gov

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Tech-talk digest..."


Today's Topics:

   1. has anyone used ADPICam in a docker? (Lee L. Yang)
   2. Re: has anyone used ADPICam in a docker? (Florian Feldbauer)
   3. Senior Controls Engineer Position at Sigray (Ernesto Paiser)
   4. Re: Question about fetching history data from MySQL by using
      phoebus (neu lzf)
   5. RE: Question about fetching history data from MySQL by using
      phoebus (CAOUEN Loic)


----------------------------------------------------------------------

Message: 1
Date: Wed, 28 Jun 2023 11:49:20 -0700
From: "Lee L. Yang" <llyang at lbl.gov>
To: tech-talk at aps.anl.gov
Subject: has anyone used ADPICam in a docker?
Message-ID:
        <CAK2Sj0_O-7_mUVWNoCkpQfEgH8WEc5qUA9CzyuyYYEy2CdW=HQ at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

I'm trying to run the following IOC:
https://github.com/areaDetector/ADPICam
in a docker image.
The IOC runs fine outside of docker, on ubuntu 22.04.
But when I start the same IOC, the camera can not be found.
The communication to the camera is via USB port.
The camera model is Princeton Instruments, MTE3, CCD camera.

--
Lee Yang
Lawrence Berkeley National Lab
1 Cyclotron Road,  M/S 15R0217
Berkeley, California 97320
office:(510)486-7320
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.aps.anl.gov/pipermail/tech-talk/attachments/20230628/f40e8360/attachment.html>

------------------------------

Message: 2
Date: Wed, 28 Jun 2023 20:52:37 +0200
From: Florian Feldbauer <florian at ep1.ruhr-uni-bochum.de>
To: tech-talk at aps.anl.gov
Subject: Re: has anyone used ADPICam in a docker?
Message-ID:
        <728b2c92-1af6-2923-9e4f-e1d343d77bc7 at ep1.ruhr-uni-bochum.de>
Content-Type: text/plain; charset="utf-8"; Format="flowed"

did you give the container access to the device?
you can do this with either `--device <path/to/device/on/host>` or as
volume `-v <path/to/device/on/host>`

Am 28.06.2023 um 20:49 schrieb Lee L. Yang via Tech-talk:
> I'm trying to run the following IOC:
> https://github.com/areaDetector/ADPICam
> in a docker image.
> The IOC runs fine outside of docker, on ubuntu 22.04.
> But when I start the same IOC, the camera can not be found.
> The communication to the camera is via USB port.
> The camera model is Princeton Instruments, MTE3, CCD camera.
>
> --
> Lee Yang
> Lawrence Berkeley National Lab
> 1 Cyclotron Road,? M/S 15R0217
> Berkeley, California 97320
> office:(510)486-7320
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.aps.anl.gov/pipermail/tech-talk/attachments/20230628/88228cad/attachment.html>

------------------------------

Message: 3
Date: Wed, 28 Jun 2023 18:39:59 -0700
From: Ernesto Paiser <epaiser at sigray.com>
To: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Subject: Senior Controls Engineer Position at Sigray
Message-ID: <58967823-02c6-f3c3-6a28-7a06a4ff5003 at sigray.com>
Content-Type: text/plain; charset="UTF-8"; format=flowed

Dear all,
Sigray, Inc. has an opening position for a Senior Controls Engineer.

Job description
Sigray is a manufacturer of high-end x-ray scientific equipment with
systems installed around the world. At Sigray, we actively seek to
foster an environment of respect and inclusion; we?re excited to work
with people from a wide range of backgrounds. Sigray is growing quickly,
so this is an opportunity with major growth potential.

Controls Engineers at Sigray collaborate with our Software Engineers,
Systems Engineers and Design team. They contribute to our control system
by debugging, maintaining, and improving our hardware.

The ideal candidate should have:
- Experience with Bash scripting
- Experience controlling and troubleshooting motors and encoders.
- Experience controlling and troubleshooting cameras and/or detectors
- Experience controlling and troubleshooting sensors (optical, pressure,
temperature, etc)
- Experience connecting devices to a computer via ethernet and usb and
configuring the network.
- Interest in building, maintaining and improve quality standards
- Comfort working in a collaborative environment
- Interest in working at a diverse and inclusive workplace

Requirements: BS or MS in a computational field (eg. electronics,
mechanical engineering, information technology, computer science) or
equivalent experience. At least 4 years of experience working with
device control in a professional setting.

Additional appreciated abilities of interest to the team are:
- Experience with Dockers
- Knowledge of EPICS
- Experience with vacuum technology, solid state detectors, gigE
cameras, and PLCs
- Experience with X-ray sources

--
Ernesto Paiser - Senior Controls Engineer
Sigray, Inc.
5750 Imhoff Dr, Concord, CA 94520
United States
epaiser at sigray.com <mailto:epaiser at sigray.com>
+1-650-503-3410
----


--



This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error, please notify the
system manager. This message contains confidential information and is
intended only for the individual named. If you are not the named addressee,
you should not disseminate, distribute or copy this email. Please notify
the sender immediately by email if you have received this email by mistake
and delete this email from your system. If you are not the intended
recipient, you are notified that disclosing, copying, distributing or
taking any action in reliance on the contents of this information is
strictly prohibited


------------------------------

Message: 4
Date: Thu, 29 Jun 2023 03:10:15 +0000
From: neu lzf <lzfneu at live.com>
To: "Kasemir, Kay" <kasemirk at ornl.gov>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Subject: Re: Question about fetching history data from MySQL by using
        phoebus
Message-ID:
        <OSZP286MB1774A5FA8545A7CDFC8DC29EAD25A at OSZP286MB1774.JPNP286.PROD.OUTLOOK.COM>

Content-Type: text/plain; charset="windows-1252"

Hi Kay,

Thanks for your reply.

I try to use binary SNS version of Phoebus and I checked the product/lib folder and found that the file mysql-connector-java-8.0.30.jar is present.

However, both problems are still exists when I run "sh phoebus.sh":

  1.  the connection issue: Cannot connect to jdbc://mysql://192.168.1.230/archive as root

  2.  Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive

The user name "root" and password are the same as CSS, which is successful to connect to MySQL.

The rdb channel archiver I used is for CSS version: archive-engine-4.5.0-linux.gtk.x86_64.zip<https://controlssoftware.sns.ornl.gov/css_rcp/nightly/archive-engine-4.5.0-linux.gtk.x86.zip> and archive-config-4.5.0-linux.gtk.x86_64.zip<https://controlssoftware.sns.ornl.gov/css_rcp/nightly/archive-config-4.5.0-linux.gtk.x86_64.zip>

I have no idea what the problem is and I wonder if I should change my rdb channel archiver version from for CSS to for phoebus (https://controlssoftware.sns.ornl.gov/css_phoebus/nightly/) : archive-engine.zip.

Is that the issue?

Thanks you very much in advance.

________________________________
From: Kasemir, Kay <kasemirk at ornl.gov>
Sent: 28 June 2023 13:09
To: neu lzf <lzfneu at live.com>; tech-talk at aps.anl.gov <tech-talk at aps.anl.gov>
Subject: Re: Question about fetching history data from MySQL by using phoebus


> org.csstudio.trends.databrowser3/urls=jdbc:mysql://192.168.1.230/archive

> org.csstudio.trends.databrowser3/archives=jdbc:mysql://192.168.1.230/archive

> ?

> Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive



If there was a connection issue, you?d see an error like



        Cannot connect to jdbc:mysql://192.168.1.230/archive



?No suitable driver found?  suggests that your product simply doesn?t include the MySQL library.

In your_product/lib, there should be a file mysql-connector-java-8.0.30.jar

Is that not present?

Try a binary like the one from https://controlssoftware.sns.ornl.gov/css_phoebus/ which should include it.



-Kay








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.aps.anl.gov/pipermail/tech-talk/attachments/20230629/f8adfc77/attachment.html>

------------------------------

Message: 5
Date: Thu, 29 Jun 2023 11:53:47 +0000
From: CAOUEN Loic <loic.caouen at cea.fr>
To: neu lzf <lzfneu at live.com>
Cc: "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov>
Subject: RE: Question about fetching history data from MySQL by using
        phoebus
Message-ID: <ec9c8c7a6dae405fbd5b607e1a16a449 at cea.fr>
Content-Type: text/plain; charset="iso-8859-1"

I can see you're using a "LAN IP" (192.168.1.230)
Does it mean Phoebus and Mysql are not on the same server ?
If it's the case, did you grant the privileges in mysql ?
You must allow the connection from the server where your phoebus runs.

GRANT ALL PRIVILEGES ON *.* TO 'root'@'your_phoebus_server_ip' IDENTIFIED BY 'your_root_password'

Regards


De : Tech-talk <tech-talk-bounces at aps.anl.gov> De la part de neu lzf via Tech-talk
Envoy? : jeudi 29 juin 2023 05:10
? : Kasemir, Kay <kasemirk at ornl.gov>
Cc : tech-talk at aps.anl.gov
Objet : Re: Question about fetching history data from MySQL by using phoebus

Hi Kay,

Thanks for your reply.

I try to use binary SNS version of Phoebus and I checked the product/lib folder and found that the file mysql-connector-java-8.0.30.jar is present.

However, both problems are still exists when I run "sh phoebus.sh":

  1.  the connection issue: Cannot connect to jdbc://mysql://192.168.1.230/archive as root


  1.  Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive
The user name "root" and password are the same as CSS, which is successful to connect to MySQL.

The rdb channel archiver I used is for CSS version: archive-engine-4.5.0-linux.gtk.x86_64.zip<https://controlssoftware.sns.ornl.gov/css_rcp/nightly/archive-engine-4.5.0-linux.gtk.x86.zip> and archive-config-4.5.0-linux.gtk.x86_64.zip<https://controlssoftware.sns.ornl.gov/css_rcp/nightly/archive-config-4.5.0-linux.gtk.x86_64.zip>

I have no idea what the problem is and I wonder if I should change my rdb channel archiver version from for CSS to for phoebus (https://controlssoftware.sns.ornl.gov/css_phoebus/nightly/) : archive-engine.zip.

Is that the issue?

Thanks you very much in advance.

________________________________
From: Kasemir, Kay <kasemirk at ornl.gov<mailto:kasemirk at ornl.gov>>
Sent: 28 June 2023 13:09
To: neu lzf <lzfneu at live.com<mailto:lzfneu at live.com>>; tech-talk at aps.anl.gov<mailto:tech-talk at aps.anl.gov> <tech-talk at aps.anl.gov<mailto:tech-talk at aps.anl.gov>>
Subject: Re: Question about fetching history data from MySQL by using phoebus


> org.csstudio.trends.databrowser3/urls=jdbc:mysql://192.168.1.230/archive

> org.csstudio.trends.databrowser3/archives=jdbc:mysql://192.168.1.230/archive

> ...

> Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.230/archive



If there was a connection issue, you'd see an error like



        Cannot connect to jdbc:mysql://192.168.1.230/archive



"No suitable driver found"  suggests that your product simply doesn't include the MySQL library.

In your_product/lib, there should be a file mysql-connector-java-8.0.30.jar

Is that not present?

Try a binary like the one from https://controlssoftware.sns.ornl.gov/css_phoebus/ which should include it.



-Kay








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.aps.anl.gov/pipermail/tech-talk/attachments/20230629/d81b3d07/attachment.html>

------------------------------

Subject: Digest Footer

_______________________________________________
Tech-talk mailing list Tech-talk at aps.anl.gov
https://mailman.aps.anl.gov/mailman/listinfo/tech-talk


------------------------------

End of Tech-talk Digest, Vol 17, Issue 351
******************************************

--

Lee Yang
Lawrence Berkeley National Lab
1 Cyclotron Road,  M/S 15R0217
Berkeley, California 97320
office:(510)486-7320