Search Results (Searched for: mysql)
- o462
- o462
02 Feb 2025 20:37 - 02 Feb 2025 20:37
About PLC and synchronization (+introduction) was created by o462
About PLC and synchronization (+introduction)
Category: General LinuxCNC Questions
Hello everyone,
As it's my first message here, let me first introduce myself.
Feel free to skip this part
So... I'm a 40+ years old electronics engineer. I'm currently self-employed, and in long term partnership with a French CNC/3D-printer vendor. I'm using Linux since kernel 2.4.18 (~20+ years), and currently using Linux exclusively.
Most of the time, I develop custom solutions to specific problems, that includes board design, firmware development, computer software, web interfaces... I also worked on few CNC-based 3D printers. (few keywords for the curious: PIC, AVR, C, C++, python, MySQL, php)
I'm quite familiar with Beckhoff and Bosch-Rexroth, as these are the most common in my area (there's Siemens too, but Siemens being Siemens, I just can't...).
======
Read this as a quite general discussion about PLC synchronization, I'm currently working on a project to eject and replace any closed-source Windows-based software for CNCs (i.e. no more TwinCAT and IndraWorks, for runtime and development), and my feelings are telling me that I can easily replace existing PLC tasks (that are synchronized) with some python script (that won't be synchronized). Note, you may also think of C as a replacement for python, it's not the point here.
I'm planning to use python as a base to write PLC programs, but as I see it, it won't be synchronized with servo-thread.
Does anyone has any arguments on the critical conditions that any PLC program running has to be synchronized with servo-thread, or the opposite ?
As far as I'm concerned, I don't see anything that has any real impact of both the servo-thread and PLC task are not synchronized (read it as: I has no side-effect for the servo-task to get an action from the PLC on next cycle), but I may miss some cases.
Ofc, I don't talk about critical procedures like homing or emergency stop. I'm talking about procedures like, let's say T3 M6, this has no obligation to be synchronized, so having a python task that run independently is fine, as long as it has the correct checks and waits, and acknowledge the procedure after everything is done.
As it's my first message here, let me first introduce myself.
Feel free to skip this part
So... I'm a 40+ years old electronics engineer. I'm currently self-employed, and in long term partnership with a French CNC/3D-printer vendor. I'm using Linux since kernel 2.4.18 (~20+ years), and currently using Linux exclusively.
Most of the time, I develop custom solutions to specific problems, that includes board design, firmware development, computer software, web interfaces... I also worked on few CNC-based 3D printers. (few keywords for the curious: PIC, AVR, C, C++, python, MySQL, php)
I'm quite familiar with Beckhoff and Bosch-Rexroth, as these are the most common in my area (there's Siemens too, but Siemens being Siemens, I just can't...).
======
Read this as a quite general discussion about PLC synchronization, I'm currently working on a project to eject and replace any closed-source Windows-based software for CNCs (i.e. no more TwinCAT and IndraWorks, for runtime and development), and my feelings are telling me that I can easily replace existing PLC tasks (that are synchronized) with some python script (that won't be synchronized). Note, you may also think of C as a replacement for python, it's not the point here.
I'm planning to use python as a base to write PLC programs, but as I see it, it won't be synchronized with servo-thread.
Does anyone has any arguments on the critical conditions that any PLC program running has to be synchronized with servo-thread, or the opposite ?
As far as I'm concerned, I don't see anything that has any real impact of both the servo-thread and PLC task are not synchronized (read it as: I has no side-effect for the servo-task to get an action from the PLC on next cycle), but I may miss some cases.
Ofc, I don't talk about critical procedures like homing or emergency stop. I'm talking about procedures like, let's say T3 M6, this has no obligation to be synchronized, so having a python task that run independently is fine, as long as it has the correct checks and waits, and acknowledge the procedure after everything is done.
- Muecke
18 Jan 2025 17:47
Replied by Muecke on topic Age of the website and forum
Age of the website and forum
Category: Forum Questions
@cornholio: I was more interested in the structures behind it, which I don't know as an outsider.
The Kunena Forum can take over the complete user structure of Joomla with all rights etc., which is quite complex, at least that's how I understood it on the Kunena Forum website.
Of course, you can also create and operate the forum separately from the website (with additional rights management etc.).
That's a silly question, sure. Is the server environment created by yourself?
Or is the server environment managed?
Notes:
1) If we have installed our own server that runs on Ubuntu, the server may need to be updated.
1.1) Ask the person who installed the server!
1.2) Do nothing without a backup!!!
-- when the server is cleared and done --
2) Check which PHP version is installed
2.1) Update if necessary
3) Check which database is installed (probably MySQL, which version)
3.1) Update if necessary
4) Check which domains are available and where they are forwarded to.
4.1) List of all domains with internal/external destination folder
4.2) Check all start folders of the domains ‘.htaccess’ whether redirects exist here www without www https forced etc. ...
5) Check the user administration of the forum to see if it is connected to Joomla.
5.1) If no, much easier, if yes, think again!
6) Create new folder for new forum
7) Install new forum incl. new database etc.
8) Possibly check with the forum manufacturer Kunena whether user data, posts and images from the old forum can be exported/imported to the new forum.
etc.
But the beginning is very important, because this is the basis for everything else and when I look at what @JT has provided us with as a layman, I get the impression that it is not a finished server (which a service provider takes care of), but that the server was set up itself, which then also has to be maintained!
My site is accessible with and without www, but there is only one page.
All visitors who come to my site without WWW are redirected to the WWW page on the server side!
Google and Co. don't want duplicates either and usually remove such things from the INDEX! which would be a great pity!
I have the impression that I have not yet fully understood how the whole thing is structured and that we are talking past each other in the wrong places.
Ich schätze mal, das liegt oft auch am Problem der Begrifflichkeiten und auch sicher an meinem Englisch, was von DeepL kommt
The Kunena Forum can take over the complete user structure of Joomla with all rights etc., which is quite complex, at least that's how I understood it on the Kunena Forum website.
Of course, you can also create and operate the forum separately from the website (with additional rights management etc.).
The current OS
That's a silly question, sure. Is the server environment created by yourself?
Or is the server environment managed?
Notes:
1) If we have installed our own server that runs on Ubuntu, the server may need to be updated.
1.1) Ask the person who installed the server!
1.2) Do nothing without a backup!!!
-- when the server is cleared and done --
2) Check which PHP version is installed
2.1) Update if necessary
3) Check which database is installed (probably MySQL, which version)
3.1) Update if necessary
4) Check which domains are available and where they are forwarded to.
4.1) List of all domains with internal/external destination folder
4.2) Check all start folders of the domains ‘.htaccess’ whether redirects exist here www without www https forced etc. ...
5) Check the user administration of the forum to see if it is connected to Joomla.
5.1) If no, much easier, if yes, think again!
6) Create new folder for new forum
7) Install new forum incl. new database etc.
8) Possibly check with the forum manufacturer Kunena whether user data, posts and images from the old forum can be exported/imported to the new forum.
etc.
But the beginning is very important, because this is the basis for everything else and when I look at what @JT has provided us with as a layman, I get the impression that it is not a finished server (which a service provider takes care of), but that the server was set up itself, which then also has to be maintained!
I hope not!There are 3 active forums at the same time,
..
forum.linuxcnc.org
...
www.forum.linuxcnc.org
...
162.243.45.186
My site is accessible with and without www, but there is only one page.
All visitors who come to my site without WWW are redirected to the WWW page on the server side!
Google and Co. don't want duplicates either and usually remove such things from the INDEX! which would be a great pity!
I have the impression that I have not yet fully understood how the whole thing is structured and that we are talking past each other in the wrong places.
Ich schätze mal, das liegt oft auch am Problem der Begrifflichkeiten und auch sicher an meinem Englisch, was von DeepL kommt
- rodw
17 Oct 2024 11:51
Replied by rodw on topic Age of the website and forum
Age of the website and forum
Category: Forum Questions
- rodw
18 Sep 2023 11:14
- MakerYang
18 Sep 2023 11:01
- spumco
- spumco
19 Dec 2022 00:03
Replied by spumco on topic Installing LinuxCNC 2.10 And Probe Basic on Linux MX 21
Installing LinuxCNC 2.10 And Probe Basic on Linux MX 21
Category: QtPyVCP
- rodw
13 Aug 2022 09:00 - 13 Aug 2022 09:03
- robertspark
- robertspark
26 May 2022 10:25 - 26 May 2022 16:33
Replied by robertspark on topic Robertspark's CNC Setup
Robertspark's CNC Setup
Category: Show Your Stuff
- ftree
- ftree
23 May 2022 15:31 - 23 May 2022 15:32
Replied by ftree on topic RPI4 - Debian / LinuxCNC / EtherCAT / XFCE
RPI4 - Debian / LinuxCNC / EtherCAT / XFCE
Category: Installing LinuxCNC
I have compile deb packages for rpi like so. I pushed the the wheel build var though to debuild with --set-envvar=“VTK_WHEEL_BUILD=ON” as it doesn’t look like Debian enable that
salsa.debian.org/science-team/vtk9/-/raw/master/debian/rules
This at least maintains deb packaging
apt install -y chrpath cmake debhelper-compat default-jdk default-libmysqlclient-dev dh-sequence-python3 doxygen-latex \
ghostscript gnuplot-nox graphviz hdf5-tools dh-sequence-javahelper libalglib-dev javahelper libavcodec-dev \
libavformat-dev libavutil-dev libdigest-md5-perl libdouble-conversion-dev libeigen3-dev libexpat-dev \
libfontconfig1-dev libfreetype6-dev libftgl-dev libgdal-dev libgl1-mesa-dev libgl-dev libgl2ps-dev \
libglew-dev libglu1-mesa-dev libglu-dev libhdf5-openmpi-dev libhpdf-dev libjpeg-dev libjs-mathjax \
libjsoncpp-dev liblz4-dev libmrmpi-dev libnetcdf-cxx-legacy-dev libnetcdf-dev libogg-dev libosmesa6-dev \
libpng-dev libpq-dev libproj-dev libsqlite3-dev libswscale-dev libtbb-dev libtheora-dev \
libtiff-dev libutfcpp-dev libx11-dev libxdmf-dev libxml2-dev libxpm-dev libxt-dev lzma mpi-default-dev \
pkg-config python3-dev python3-matplotlib python3-mpi4py qtbase5-dev libqt5opengl5 \
r-base-core r-base-dev r-base xauth xvfb
git clone https://salsa.debian.org/science-team/vtk9.git
cd vtk9
dch -a "compiled by djsftree"
debuild -i -us -uc -b --set-envvar="VTK_WHEEL_BUILD=ON"
/usr/lib/python3 -m pip install wheel
/usr/lib/python3 setup.py bdist_wheel
/usr/lib/python3 -m pip install dist/vtk-*.whlThis at least maintains deb packaging
- rodw
25 Apr 2022 19:40 - 25 Apr 2022 19:46
Replied by rodw on topic Raspberry Pi 4 - USB not working under LinuxCNC
Raspberry Pi 4 - USB not working under LinuxCNC
Category: Computers and Hardware
- robertspark
- robertspark
18 Feb 2022 20:03
Replied by robertspark on topic Robertspark's CNC Setup
Robertspark's CNC Setup
Category: Show Your Stuff
- Joco
02 Nov 2021 22:05
Replied by Joco on topic MonoKrom - QtPyVCP GUI for PlasmaC and Mill
MonoKrom - QtPyVCP GUI for PlasmaC and Mill
Category: QtPyVCP
Some work being done on the run and config screens. Moving to a process centric view of cut parameters. Backed but a sql backend so this could be local to a single machine using sqllite or it could be referencing a single DB source in a shop with multiple tables that all reference off a master DB (MS-Sql, MySQL, Postgress etc etc).
Also starting to leverage the qtpyvcp framework to expose many of the params as hal pins so they can easily "wired" to the plasmac component. Obviously still WIP as the hole and slot detection areas are placeholders. Although the hole detection is represented in the persistance layer.
Cheers - J.
Also starting to leverage the qtpyvcp framework to expose many of the params as hal pins so they can easily "wired" to the plasmac component. Obviously still WIP as the hole and slot detection areas are placeholders. Although the hole detection is represented in the persistance layer.
Cheers - J.
- Donb9261
16 Jan 2020 11:33
Replied by Donb9261 on topic Question For Kurt or anyone with SQL Experience and HAL
Question For Kurt or anyone with SQL Experience and HAL
Category: QtPyVCP
- Donb9261
14 Jan 2020 22:49
Question For Kurt or anyone with SQL Experience and HAL was created by Donb9261
Question For Kurt or anyone with SQL Experience and HAL
Category: QtPyVCP
- rodw
07 Nov 2018 20:17 - 07 Nov 2018 20:18
Yes, I use SQLite in my example. When I get a bit more data in the system and am certain the database schema is correct, I've written I will raise another thread as its kind of off topic on this one. I've got to define the gasses better as some machines have both cutting gas and shielding gas. I don't really think the data needs to be accessed by a component in C. Its really a user interface thing so setting fields/pins in the GUI in user space should suffice. There was a proposal from Andy quite some time ago to use SQL for tool tables:
wiki.linuxcnc.org/cgi-bin/wiki.pl?ToolDatabase
and somehow, we have a SQL schema in the LinuxCNC repo already.
github.com/LinuxCNC/linuxcnc/blob/master...ql/schema-simple.sql
Replied by rodw on topic Another plasma component...
Another plasma component...
Category: Plasma & Laser
Rod,
SQL is working in Linuxcnc. For making a c component mysql.h is missing, it's not in the include directory, so this takes more time.
We can also use different version's of SQL. lite_version
Maybe the best way is to test a dynamic input set up.
Yes, I use SQLite in my example. When I get a bit more data in the system and am certain the database schema is correct, I've written I will raise another thread as its kind of off topic on this one. I've got to define the gasses better as some machines have both cutting gas and shielding gas. I don't really think the data needs to be accessed by a component in C. Its really a user interface thing so setting fields/pins in the GUI in user space should suffice. There was a proposal from Andy quite some time ago to use SQL for tool tables:
wiki.linuxcnc.org/cgi-bin/wiki.pl?ToolDatabase
and somehow, we have a SQL schema in the LinuxCNC repo already.
github.com/LinuxCNC/linuxcnc/blob/master...ql/schema-simple.sql
Time to create page: 6.797 seconds