Re: Debian, Postfix, Dovecot, MySQL, and argon2 password hashing scheme?

2024-04-25 Thread Marco Moock
Am 25.04.2024 schrieb David Mehler : > Since changing systems to Debian 12.5 I can't send, though checking > the password with a manual login to Dovecot works fine. Sending mails is SMTP and therefore postfix on your machine. It can use PAM for auth. Do you use PAM?

Debian, Postfix, Dovecot, MySQL, and argon2 password hashing scheme?

2024-04-24 Thread David Mehler
Hello, I have a quick question. Can Debian, and/or it's Postfix/Dovecot/MySQL/MariaDB packages support the argon2 password hashing scheme? I had a previously-working e-mail setup on a *BSD system, utilizing the argon2ID scheme with Dovecot, Postfix, and MySQL. Since changing systems

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-29 Thread Greg Wooledge
On Fri, Mar 29, 2024 at 11:49:06AM +0100, Bernard wrote: > Hi to Everyone, > > The text quoted below has already been sent to the list, 2-3 days ago, > someone had replied to it (but the message has been lost, I no longer see it > on the list. I had replied again, which reply disappeared too.) >

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-29 Thread Bernard
Hi to Everyone, The text quoted below has already been sent to the list, 2-3 days ago, someone had replied to it (but the message has been lost, I no longer see it on the list. I had replied again, which reply disappeared too.) So, I want to say again that the errors shown in the text below (S

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-28 Thread Greg Wooledge
On Thu, Mar 28, 2024 at 10:36:01AM +0100, Bernard wrote: > But I've found more problems, concerning $_REQUEST, $_GET... > > The old way that I used 11 yrs ago no longer works : > > $nom = S_GET [‘nom’] ; > > no longer operates with php 7.4. This code is simply ignored. S_REQUEST, > $_POST do

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-28 Thread Bernard
Yes, this list (exactly the same here) shows that mysqli.so is loaded. In any case, as said before, this function does operate as I have checked. But I've found more problems, concerning $_REQUEST, $_GET... The old way that I used 11 yrs ago no longer works : $nom = S_GET [‘nom’] ; no longer

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread Jeffrey Walton
On Tue, Mar 26, 2024 at 1:17 PM Marco Moock wrote: > > Am 26.03.2024 um 10:33:59 Uhr schrieb Bernard: > > > I have the two // in the displayed error messages. However the file > > is where it should be, without double // > > The this seems to be a bug because if it searches for //file it will >

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread David Wright
On Tue 26 Mar 2024 at 09:43:37 (-0400), Cindy Sue Causey wrote: > On Tue, Mar 26, 2024 at 6:04 AM Bernard wrote: [ … ] > > $ php -m | grep mysqli > > > > "If the MySQLi extension is enabled, we’ll see mysqli in the output. > > Otherwise, the output will be empty." > > > > php -m grep mysqli > >

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread Marco Moock
Am 26.03.2024 um 10:33:59 Uhr schrieb Bernard: > I have the two // in the displayed error messages. However the file > is where it should be, without double // The this seems to be a bug because if it searches for //file it will definitely not find it. Can you use strace to verify that? --

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread Cindy Sue Causey
On Tue, Mar 26, 2024 at 6:04 AM Bernard wrote: > > I have progressed a little in my trials. > > mysqli.so still shows the previously described problems, and I thought that > this was responsible of the fact that mysqli functions were apparently > discarded in the test programs I wrote. > > I

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread Bernard
I have progressed a little in my trials. mysqli.so still shows the previously described problems, and I thought that this was responsible of the fact that mysqli functions were apparently discarded in the test programs I wrote. I discovered that this was due to errors I made in the php

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread Bernard
ls -Al /usr/lib/php/20190902 total 7732 -rw-r--r-- 1 root root   34920  9 juin   2023 calendar.so -rw-r--r-- 1 root root   14440  9 juin   2023 ctype.so -rw-r--r-- 1 root root   92264  9 juin   2023 exif.so -rw-r--r-- 1 root root  161896  9 juin   2023 ffi.so -rw-r--r-- 1 root root 5744752  9

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-26 Thread Bernard
On 24/03/2024 20:02, Marco Moock wrote: Am Sun, 24 Mar 2024 19:51:05 +0100 schrieb Bernard : '//usr/lib/php/20190902/mysqli.so' Is that really the path in the message? The 2 // must not be there. I have the two // in the displayed error messages. However the file is where it should be,

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-24 Thread Jeffrey Walton
On Sun, Mar 24, 2024 at 5:57 PM Bernard wrote: > > Hi to Everyone ! > > PHP Warning: PHP Startup: Unable to load dynamic library > '//usr/lib/php/20190902/mysqli.so' However, the file is there... not human > readable as expected and mysqli_connect doesn't operate. Please provide the output of

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-24 Thread Geert Stappers
On Sun, Mar 24, 2024 at 07:51:05PM +0100, Bernard wrote: > *PHP Warning: PHP Startup: Unable to load dynamic library > '//usr/lib/php/20190902/mysqli.so' |$ apt-file search mysqli.so |php8.2-mysql: /usr/lib/php/20220829/mysqli.so |$ So on my system, trixie, I would do `sudo apt install

Re: Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-24 Thread Marco Moock
Am Sun, 24 Mar 2024 19:51:05 +0100 schrieb Bernard : > '//usr/lib/php/20190902/mysqli.so' Is that really the path in the message? The 2 // must not be there.

Debian 11 PHP 7.4 – Mysql 8 - Can’t get Mysqli_connect to work

2024-03-24 Thread Bernard
Hi to Everyone ! *PHP Warning: PHP Startup: Unable to load dynamic library '//usr/lib/php/20190902/mysqli.so' * *However, the file is there... not human readable as expected* *and mysqli_connect doesn't operate.* *Thanks in advance for your help* *Bernard*

Re: MySQL Workbench

2023-11-18 Thread Carlos Villiere
¡¡Mil perdones!! Este es link que no indique en mi post anterior [1] https://packages.debian.org/sid/mysql-workbench Nuevamente Muchas Gracias!! Saludos Carlos El sáb, 18 nov 2023 a las 15:22, Carlos Villiere () escribió: > ¡¡Hola Comunidad!! > > Agradezco a todos las sugerencias q

Re: MySQL Workbench

2023-11-18 Thread Carlos Villiere
¡¡Hola Comunidad!! Agradezco a todos las sugerencias que me han dado, me resultaron muy útiles. Luego de intentar instalar MySQL Workbench, a base de prueba y error lo he logrado. Para resumir, instale el repo ATP de MySQL, posteriormente baje del paquete mysql-workbench-community_8.0.20

Re: MySQL Workbench

2023-11-17 Thread Camaleón
El 2023-11-16 a las 17:22 -0300, Carlos Villiere escribió: > ¡¡Hola Comunidad Debian!! > > Estoy tratando de instalar mysql-workbench-community_8.0.34 en miPc Debian > desde un paquete .deb obtenido de la Web Page de MySQL, pero los únicos > para Sistemas Debian son &g

Re: MySQL Workbench

2023-11-16 Thread N4ch0
On Thu Nov 16, 2023 at 5:22 PM -03, Carlos Villiere wrote: > ¡¡Hola Comunidad Debian!! > > Estoy tratando de instalar mysql-workbench-community_8.0.34 en miPc Debian > desde un paquete .deb obtenido de la Web Page de MySQL, pero los únicos > para Sistemas Debian son &g

Re: MySQL Workbench

2023-11-16 Thread Robert J. Briones C.
El jue, 16 nov 2023 a las 22:16, Carlos Villiere () escribió: > > ¡¡Hola Comunidad Debian!! > > Estoy tratando de instalar mysql-workbench-community_8.0.34 en miPc Debian > desde un paquete .deb obtenido de la Web Page de MySQL, pero los únicos > para Sistemas Debian son

MySQL Workbench

2023-11-16 Thread Carlos Villiere
¡¡Hola Comunidad Debian!! Estoy tratando de instalar mysql-workbench-community_8.0.34 en miPc Debian desde un paquete .deb obtenido de la Web Page de MySQL, pero los únicos para Sistemas Debian son mysql-workbench-community_8.0.34-1ubuntu23.04_amd64 y mysql-workbench-community_8.0.34

[SOLVED] Uninstalling unwanted PHP and mariadb packages [WAS Re: How could the missing MySQL extension required by WordPress be installed?]

2023-11-11 Thread Susmita/Rajib
lient-10.5 Following my practice of safety, I kept a note of the packages I had installed, as recorded in my first post of this thread, at: https://lists.debian.org/debian-user/2023/11/msg00384.html as follows: [quote] The nearest that are available in Debian Bullseye : default-mysql-server default-mysql-s

Uninstalling unwanted PHP and mariadb packages [WAS Re: How could the missing MySQL extension required by WordPress be installed?]

2023-11-11 Thread Susmita/Rajib
From: "Andrew M.A. Cater" Date: Sat, 11 Nov 2023 16:39:01 + Message-id: <[] zu-ujrqewxkor...@einval.com> In-reply-to: <[] CAEG4cZXquvxryjdFLCgHBiteyx8mFm=e+kjcusxnhhj0+zp...@mail.gmail.com>, https://lists.debian.org/debian-user/2023/11/msg00415.html On Sun, 12 Nov 2023 at 07:42,

Uninstalling unwanted PHP and mariadb packages [WAS Re: How could the missing MySQL extension required by WordPress be installed?]

2023-11-11 Thread Andrew M.A. Cater
has a Log file for the installed packages yesterday: > > > > Commit Log for Fri Nov 10 21:04:10 2023 > > Upgraded the following packages: > mariadb-common (1:10.5.18-0+deb11u1) to 1:10.5.21-0+deb11u1 > > Installed the following packages: > default-mysql-server (1.0.7) > ga

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-11 Thread Andy Smith
Hello, On Fri, Nov 10, 2023 at 09:51:41PM +0530, Susmita/Rajib wrote: > Dear illustrious leaders and the senior members, Debian-user ML, Did you want any assistance from people who aren't illustrious leaders and senior members? Thanks, Andy -- https://bitfolk.com/ -- No-nonsense VPS hosting

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-11 Thread Susmita/Rajib
Upgraded the following packages: mariadb-common (1:10.5.18-0+deb11u1) to 1:10.5.21-0+deb11u1 Installed the following packages: default-mysql-server (1.0.7) galera-4 (26.4.11-0+deb11u1) libcgi-fast-perl (1:2.15-1) libcgi-pm-perl (4.51-1) libconfig-inifiles-perl (3.03-1) libdbd-mariadb-perl (1.21-3

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-11 Thread Susmita/Rajib
Two messages from debian-user-howorth-org-uk (1) From: debian-u...@howorth.org.uk Date: Sat, 11 Nov 2023 11:10:22 + Message-id: <[] 2023111022.58bb3...@acer-suse.lan> On Sat, 11 Nov 2023 at 17:09, Susmita/Rajib wrote: > > Marco wrote: > > Am 11.11.2023 06:58 schrieb Susmita/Rajib: > >

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-11 Thread debian-user
Marco wrote: > Am 11.11.2023 06:58 schrieb Susmita/Rajib: > > > mysqli > > > > MysqlI Support => enabled > > Client API library version => mysqlnd 7.4.33 > > Active Persistent Links => 0 > > Inactive Persistent Links => 0 > > Active Links => 0 > > Can you now try to create your own php

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-11 Thread debian-user
gt; http://ckraju.net/blog/?p=189 > > I received a Firefox-esr notice: > "Your PHP installation appears to be missing the MySQL extension which > is required by WordPress." > > Searching the internet, I reached the Stack Overflow page with the > partial title:

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-11 Thread Susmita/Rajib
From: Marco Date: Sat, 11 Nov 2023 08:37:12 +0100 Message-id: <[] 2023083712.6badf0b7@x40> On Sat, 11 Nov 2023 at 15:31, Susmita/Rajib wrote: > > Am 11.11.2023 06:58 schrieb Susmita/Rajib: > > > mysqli > > > > MysqlI Support => enabled > > Client API library version => mysqlnd 7.4.33 > >

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-10 Thread Marco
Am 11.11.2023 06:58 schrieb Susmita/Rajib: > mysqli > > MysqlI Support => enabled > Client API library version => mysqlnd 7.4.33 > Active Persistent Links => 0 > Inactive Persistent Links => 0 > Active Links => 0 Can you now try to create your own php script that makes use of that to test it?

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-10 Thread Susmita/Rajib
ead buffer size => 32768 Read timeout => 86400 Collecting statistics => Yes Collecting memory statistics => No Tracing => n/a Loaded plugins => mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_pa

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-10 Thread Marco M.
Am 10.11.2023 um 23:48:35 Uhr schrieb Susmita/Rajib: > But the result remains the same. Can you use the php info function to get information about the php stuff that is being loaded?

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-10 Thread Susmita/Rajib
From: "Marco M." Date: Fri, 10 Nov 2023 17:40:56 +0100 Message-id: <[] 20231110174056.3760b...@ryz.home.arpa> [ ... ] > > That is the old Sysvinit method. > Use systemd tools instead > > systemctl status mysql Thank you, Mr. M. Checked. >From supe

Re: How could the missing MySQL extension required by WordPress be installed?

2023-11-10 Thread Marco M.
Am 10.11.2023 um 21:51:41 Uhr schrieb Susmita/Rajib: > I installed them all. Then I tried to follow the instructions: > # sudo /etc/init.d/mysql status > sudo: /etc/init.d/mysql: command not found That is the old Sysvinit method. Use systemd tools instead systemctl status mysql

How could the missing MySQL extension required by WordPress be installed?

2023-11-10 Thread Susmita/Rajib
r PHP installation appears to be missing the MySQL extension which is required by WordPress." Searching the internet, I reached the Stack Overflow page with the partial title: Your PHP installation appears to be missing the MySQL extension which is required by WordPress at: https://stackoverflow.com

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Xavier Drudis Ferran
El Mon, Oct 02, 2023 at 12:45:26PM +0200, Narcis Garcia deia: > > Però el què necessito és poder dissenyar un formulari: Amb etiquetes i > explicacions per a cada camp que emplena l'usuari, limitació del format de > les dades, algun avís o reacció programada, etc. > També dissenyar un informe: Un

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Narcis Garcia
LibreOffice i saber la seva credencial. Si s'han d'instal·lar «extres» això complica les possibilitats d'èxit. No estic segur que el libreoffice sol inclogui totes les extensions necessàries per acedir a MySQL, o a tots els sgbd possibles. MySQL té un client de base de dades gràfic (MySQL Workbench

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Xavier Drudis Ferran
va credencial. > > Si s'han d'instal·lar «extres» això complica les possibilitats d'èxit. > > > > No estic segur que el libreoffice sol inclogui totes les extensions > necessàries per acedir a MySQL, o a tots els sgbd possibles. > > MySQL té un client de base de dades gràf

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Xavier Drudis Ferran
> No estic segur que el libreoffice sol inclogui totes les extensions necessàries per acedir a MySQL, o a tots els sgbd possibles. MySQL té un client de base de dades gràfic (MySQL Workbench), però no tinc clar que un usuari final s'hi trobi molt còmode. Si no aparentment hi ha aplicacions que

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Narcis Garcia
El 13/9/23 a les 21:58, Alex Muntada ha escrit: Hola, Julio i Narcis: Tinc una base de dades remota postgresql i vull que altres usuaris puguin llistar qualsevol informació d'aquesta sense coneixements de SQL. Desconec si és fàcil introduir dades tipus formulari, ja que en principi no ho

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Narcis Garcia
El 13/9/23 a les 9:51, Julio ha escrit: Hola, jo tampoc et puc ajudar amb libreoffice. Però sí et puc comentar el meu cas. Tinc una base de dades remota postgresql i vull que altres usuaris puguin llistar qualsevol informació d'aquesta sense coneixements de SQL. Desconec si és fàcil

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-10-02 Thread Narcis Garcia
El 12/9/23 a les 11:00, Xavier Drudis Ferran ha escrit: Ho sento, no ho he provat ni gens ni gaire això que dius, suposo que no et podré ajudar... El Tue, Sep 12, 2023 at 09:05:56AM +0200, Narcis Garcia deia: Bon dia, Estic intentant crear un document de base de dades amb LibreOffice per a

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-09-13 Thread Alex Muntada
Hola, Julio i Narcis: > Tinc una base de dades remota postgresql i vull que altres > usuaris puguin llistar qualsevol informació d'aquesta sense > coneixements de SQL. Desconec si és fàcil introduir dades tipus > formulari, ja que en principi no ho necessito. > > Vaig trobar dbgate

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-09-13 Thread Julio
Hola, jo tampoc et puc ajudar amb libreoffice. Però sí et puc comentar el meu cas. Tinc una base de dades remota postgresql i vull que altres usuaris puguin llistar qualsevol informació d'aquesta sense coneixements de SQL. Desconec si és fàcil introduir dades tipus formulari, ja que en

Re: (deb-cat) LibreOffice i MariaDB/MySQL

2023-09-12 Thread Xavier Drudis Ferran
Ho sento, no ho he provat ni gens ni gaire això que dius, suposo que no et podré ajudar... El Tue, Sep 12, 2023 at 09:05:56AM +0200, Narcis Garcia deia: > Bon dia, > > Estic intentant crear un document de base de dades amb LibreOffice per a > compartir, connectat a una base de dades del servei

(deb-cat) LibreOffice i MariaDB/MySQL

2023-09-12 Thread Narcis Garcia
Bon dia, Estic intentant crear un document de base de dades amb LibreOffice per a compartir, connectat a una base de dades del servei remot MariaDB. Em trobo que fer-ho mitjançant ODBC requereix algun tipus de configuració a l'entorn operatiu (poc portable), mitjançant JDBC no funciona*

Re: dpkg: error processing package mysql-client

2023-07-20 Thread Andy Smith
Hello, On Thu, Jul 20, 2023 at 08:17:34PM -0400, Greg Wooledge wrote: > On Thu, Jul 20, 2023 at 05:55:12PM -0600, William Torrez Corea wrote: > > Setting up mysql-common (8.0.34-1debian11) ... > > This package did not come from Debian. […] > If your third-party MySQL packag

Re: dpkg: error processing package mysql-client

2023-07-20 Thread Greg Wooledge
On Thu, Jul 20, 2023 at 05:55:12PM -0600, William Torrez Corea wrote: > Setting up mysql-common (8.0.34-1debian11) ... This package did not come from Debian. That's not a Debian version string (*none* of them have that pattern, with the literal word "debian" in between numbers)

dpkg: error processing package mysql-client

2023-07-20 Thread William Torrez Corea
*I try to update, upgrade my operating system but i get the following error:* Setting up mysql-common (8.0.34-1debian11) ... update-alternatives: error: alternative path /etc/mysql/my.cnf.fallback doesn't exist dpkg: error processing package mysql-common (--configure): installed mysql-common

Re: Mysql backup on Google Drive

2022-09-28 Thread Tim Woodall
On Wed, 28 Sep 2022, Remigio wrote: ... The package rclone can do this. unfortunately I can't find Rclone package Furter information? Thanks Wild guess, but lenny probably predates google drive so rclone won't be present unless you can backport. (someone can check the dates but IIRC lenny

Re: Mysql backup on Google Drive

2022-09-28 Thread Махно
Hello. Rclone is in official Debian repo. Just check this https://packages.debian.org/bullseye/rclone 2022-09-28, tr, 14:48 Remigio rašė: > > ... > > The package rclone can do this. > unfortunately I can't find Rclone package > Furter information? > Thanks >

Re: Mysql backup on Google Drive

2022-09-28 Thread Remigio
... > The package rclone can do this. unfortunately I can't find Rclone package Furter information? Thanks

Re: Mysql backup on Google Drive

2022-09-28 Thread Dan Ritter
Remigio wrote: > Hi everyone, > I've been using a mysql database for a long time, that runs on a Debian 5 > Lenny machine. Using "cron" I locally backup it and overwrite every hour, > and I manually backup it every week on a usb pen. > I'm wondering if it's possi

Mysql backup on Google Drive

2022-09-28 Thread Remigio
Hi everyone, I've been using a mysql database for a long time, that runs on a Debian 5 Lenny machine. Using "cron" I locally backup it and overwrite every hour, and I manually backup it every week on a usb pen. I'm wondering if it's possible to automatically send the .sql file created

Re: OT: mysql-workbench alternative

2022-09-25 Thread Gareth Evans
On 24 Sep 2022, at 22:55, Nicholas Geovanis wrote:On Sat, Sep 24, 2022, 2:47 PM Gareth Evans <donots...@fastmail.fm> wrote:Given what looks to be the ongoing absence of mysql-workbench in stable: https://tracker.debian.org/pkg/mysql-workbench Can anyone recommend a free (at least as i

Re: OT: mysql-workbench alternative

2022-09-24 Thread Nicholas Geovanis
On Sat, Sep 24, 2022, 2:47 PM Gareth Evans wrote: > Given what looks to be the ongoing absence of mysql-workbench in stable: > > https://tracker.debian.org/pkg/mysql-workbench > > Can anyone recommend a free (at least as in beer) alternative that creates > ERDs automati

OT: mysql-workbench alternative

2022-09-24 Thread Gareth Evans
Given what looks to be the ongoing absence of mysql-workbench in stable: https://tracker.debian.org/pkg/mysql-workbench Can anyone recommend a free (at least as in beer) alternative that creates ERDs automatically from MariaDB? I tried installing mysql-workbench-community from mysql.com

Re: [HS] MySQL: valeur par défaut [RESOLU]

2022-05-26 Thread Christian Quentin
Cette requête devrait aussi faire le job, je pense : SELECT IF(COUNT(*) > 0, macolonne2, 'ABC') FROM ma_table WHERE macolonne1 = 123 AND macolonne2 IS NOT NULL LIMIT 1 Bonne journée Le mercredi 25 mai 2022 à 08:49 +0200, Olivier a écrit : > Voici la réponse de Dethegeek: > > CREATE

Re: [HS] MySQL: valeur par défaut [RESOLU]

2022-05-25 Thread Olivier
nvoyé depuis mon smartphone Linux Android > > > > Message d'origine > De : Olivier > Date : 24/05/2022 11:13 (GMT+01:00) > À : ML Debian User French > Objet : Re: [HS] MySQL: valeur par défaut [RESOLU] > > Merci à tous pour vos réponses ! > > La r

Re: [HS] MySQL: valeur par défaut [RESOLU]

2022-05-24 Thread Olivier
Merci à tous pour vos réponses ! La réponse de Dethegeek fonctionne parfaitement. Au passage, j'ignorais que MySQL était si susceptible sur l'absence de parenthèses. Le lun. 23 mai 2022 à 22:57, Jean-Michel OLTRA a écrit : > > > Bonjour, > > > Le lundi 23 mai 202

Re: [HS] MySQL: valeur par défaut

2022-05-23 Thread Jean-Michel OLTRA
Bonjour, Le lundi 23 mai 2022, Olivier a écrit... > Exemple: > SELECT IFNULL("ABC", macolonne2) AS foo WHERE macolonne1=123 Peut-être : select coalesce((select macolonne2 from matable where macolonne1=123), 'ABC'); -- jm

[HS] MySQL: valeur par défaut

2022-05-23 Thread Olivier
Hello, Voici une question qui n'a qu'un rapport indirect avec Debian (même si la mise en oeuvre sera faite sur notre OS préféré). Comment avec MySQL, retourner une valeur par défaut, si aucun rang ne correspond, ou un rang correspond mais que la valeur qu'il contient est NULL ? Exemple: SELECT

Re: Installing mysql-workbench on Debian Sid

2022-05-22 Thread Sven Hartge
Valerio wrote: > I need to install mysql-workbench package on debian sid, but i get > problems about missing dependencies. > The following packages have unmet dependencies: > mysql-workbench : Depends: libgdal29 (>= 3.3.0) but it is not > installable Depends: python3 (<

Installing mysql-workbench on Debian Sid

2022-05-20 Thread Valerio
Hi, I need to install mysql-workbench package on debian sid, but i get problems about missing dependencies. The following packages have unmet dependencies: mysql-workbench : Depends: libgdal29 (>= 3.3.0) but it is not installable Depends: python3 (< 3.10) but 3.10.4-1+b1 is to be ins

Re: OFF TOPIC - Problemas com mysql

2022-04-26 Thread Mauricio Neto
Amigos boa noite. Quero agradecer a todos que me auxiliaram para solução do problema. Hélio seu "chute" sobre estar usando dois processos mysql foi fundamental para solucionar o problema. Não estava com dois processos mysql mais configurações apontando para sockets diferentes, um

Re: OFF TOPIC - Problemas com mysql

2022-04-25 Thread Mauricio Neto
Helio boa tarde. Achei interessante seu "chute" mas veja se estou com o raciocino errado: No /etc/mysql/mysql.conf.d/mysqld.cnf /[mysqld]// //pid-file    = /var/run/mysqld/mysqld.pid// //*socket  = /var/run/mysqld/mysqld.sock*// //datadir = /dbase/mysql// /

Re: OFF TOPIC - Problemas com mysql

2022-04-24 Thread Helio Loureiro
Quando você conecta com o client, ele usa o arquivo de socket pra isso. Eu chuto que o problema é que vc tem dois mysqld rodando. Uma via TCP que parece estar certo, mas via socket entra no errado que parece ser um banco zerado (possivelmente a configuração default do MySQL). ./helio On Sat

Re: OFF TOPIC - Problemas com mysql

2022-04-23 Thread Mauricio Neto
Gustavo, bom dia e obrigado pelo retorno É pratica minha  criar um filesystem separado para o database. Então logo após a instalação do mysql, antes da instalação de qualquer aplicativo que vá utilizar o banco, eu para o processo , copio os arquivos para o filesystem que defini para o

Re: OFF TOPIC - Problemas com mysql

2022-04-22 Thread Gustavo Villela Goulart
Opá Mauricio, boa noite! Vc mexeu na conf do mysql? Por default o path do datadir é: /var/lib/mysql Seu datadir esta assim: /dbase/mysql Se vc alterou essa configuração na mão, ou as aplicações que vc esta usando fizeram essa alteração, é o que esta causando o problema. Para vc alterar o

OFF TOPIC - Problemas com mysql

2022-04-22 Thread Mauricio Neto
Amigo boa tarde. Desculpe o off topic já que se trata de um problema de mysql e não Debian mas como nesta comunidade temos conhecedores de tudo relato uma situação muito estranha na esperança que algum dos amigos já tenham visto algo parecido, ou posam indicar um forum mais apropriado

Re: exim4-base dependency on mysql?

2022-03-12 Thread Roberto C . Sánchez
On Sat, Mar 12, 2022 at 11:14:34AM -0800, Kaz Kylheku wrote: > Hi, > > Can someone explain why MySQL/MariaDB detritus gets pulled in when you > install exim4? > > Does exim4 use a database now? > > I thought all the queues and such were just text files. > The

Re: exim4-base dependency on mysql?

2022-03-12 Thread Teemu Likonen
* 2022-03-12 11:14:34-0800, Kaz Kylheku wrote: > Can someone explain why MySQL/MariaDB detritus gets pulled in when you > install exim4? No personal experience about the "heavy" Exim but Debian package exim4-daemon-heavy has dependency on database libraries. Its

Re: exim4-base dependency on mysql?

2022-03-12 Thread Eduardo M KALINOWSKI
On 12/03/2022 16:14, Kaz Kylheku wrote: Hi, Can someone explain why MySQL/MariaDB detritus gets pulled in when you install exim4? Does exim4 use a database now? I thought all the queues and such were just text files. If by 'detritus' you mean libmariadb3, a client library for MariaDB

exim4-base dependency on mysql?

2022-03-12 Thread Kaz Kylheku
Hi, Can someone explain why MySQL/MariaDB detritus gets pulled in when you install exim4? Does exim4 use a database now? I thought all the queues and such were just text files. Thanks.

JOB | DBA MySQL/MariaDB (London and Singapore)

2022-03-02 Thread James Tobin
Hello, I am working with an employer that is looking to hire a permanent DBA (MySQL/MariaDB) for their London and Singapore office Consequently, I had hoped that some members of this mailing list may like to discuss with me further I can be reached using "JamesBTobin (at) Gmail (dot

Re: Order of package updates, mysql vs. kernel

2021-10-11 Thread Vladislav Kurz
think that it is new problem. I have seen this long time before, but just didn't bother to report it. IMHO it is more about the timing of mysql stop, which comes too early (at/ before unpack stage). But there may be some good reason for that. If so then all packages that need to stop their da

Re: Order of package updates, mysql vs. kernel

2021-10-11 Thread Andrei POPESCU
On Lu, 11 oct 21, 10:53:18, Vladislav Kurz wrote: > Hello, > > during the last point release (and some previous updates too) I have noticed > one unpleasant issue: > > If there is mysql (mariadb) and kernel update at the same time, the order of > actions is as fol

Re: Order of package updates, mysql vs. kernel

2021-10-11 Thread Josef Strýček
Dobrý den, minulý týden se mi stalo něco podobného na testinngu, po aktualizaci, včetně jádra na 5.14, se mi nechtěl zkompilovat dkms pro nvidii, proto se domnívám, že za to může nový kernel. S pozdravem Josef Strýček English: Hello, something similar happened to testing last

Order of package updates, mysql vs. kernel

2021-10-11 Thread Vladislav Kurz
Hello, during the last point release (and some previous updates too) I have noticed one unpleasant issue: If there is mysql (mariadb) and kernel update at the same time, the order of actions is as follows: stop mysql compile kernel modules for new kernel (using dkms) create new initrd

Re: Mysql et php5.6 => 7.4

2021-04-17 Thread Jean-Michel OLTRA
Bonjour, Le samedi 17 avril 2021, ajh-valmer a écrit... > $mysqli = new mysqli($servername, $username, $password, "association"); > if ($mysqli->connect_errno) { > echo "Echec lors connexion MySQL : (" . $mysqli->connect_errno . ") " . &

Re: Mysql et php5.6 => 7.4

2021-04-17 Thread ajh-valmer
On Wednesday 14 April 2021 22:09:38 Jean-Michel OLTRA wrote: > Tiens, une doc en français : > https://www.php.net/manual/fr/mysqli.quickstart.connections.php > MariaDB [mysql]> select user, plugin, host from user; > (chez moi, c'est Mar

Re: Mysql 5.7 vers mysql 8 et php5.6 vers 7.4

2021-04-16 Thread Jean-Michel OLTRA
Bonjour, Le vendredi 16 avril 2021, ajh-valmer a écrit... > https://mysqlserverteam.com/upgrading-to-mysql-8.0-here-is-what-you-need-to-know/ > Ça ne migre pas si facilement. Le lien au début de ce texte explique comment faire. Et comment tester la migration. Au pire, avec le d

Re: Mysql 5.7 vers mysql 8 et php5.6 vers 7.4

2021-04-16 Thread ajh-valmer
On Wednesday 14 April 2021 14:06:07 Jean-Michel OLTRA wrote: Voici un lien intéressant sur le sujet, passage vers mysql 8 : https://mysqlserverteam.com/upgrading-to-mysql-8.0-here-is-what-you-need-to-know/ Ça ne migre pas si facilement.

Re: Mysql et php5.6

2021-04-14 Thread Jean-Michel OLTRA
n français : https://www.php.net/manual/fr/mysqli.quickstart.connections.php > > Sinon, tu as également les logs de mysql/mariadb, si tu y as accès. > C'est une base de données MySQL. Ben, c'est un peu pareil. Si il y a un souci de connexion, l'erreur est peut-être mentionnée dedans. I

Re: Mysql et php5.6

2021-04-14 Thread ajh-valmer
On Wednesday 14 April 2021 14:06:07 Jean-Michel OLTRA wrote: > Erreur, ou pas ? Avec connect_errno et connect_error, tu devrais en savoir > un peu plus sur l'erreur de connexion : Ou et comment placer ces scripts ? connect_errno , connect_error > Sinon, tu as également les logs de mysq

Re: Mysql et php5.6

2021-04-14 Thread MERLIN Philippe
Le mercredi 14 avril 2021, 11:31:49 CEST ajh-valmer a écrit : > On Tuesday 13 April 2021 00:06:27 Jean-Michel OLTRA wrote: > > Le lundi 12 avril 2021, ajh-valmer a écrit... > > > > > > > if (!$CNX = mysql_connect($DB_BASE, $DB_USER, $DB_PASS, $DB_SERVER)) > > > > > { > > > > > > La syntaxe

Re: Mysql et php5.6

2021-04-14 Thread Jean-Michel OLTRA
riétés de cet objet classe mysqli ici : https://www.php.net/manual/fr/class.mysqli.php > Mais mysqli me renvoie erreur. Erreur, ou pas ? Avec connect_errno et connect_error, tu devrais en savoir un peu plus sur l'erreur de connexion. Sinon, tu as également les logs de mysql/mariadb, si t

Re: Mysql et php5.6

2021-04-14 Thread ajh-valmer
On Tuesday 13 April 2021 00:06:27 Jean-Michel OLTRA wrote: > Le lundi 12 avril 2021, ajh-valmer a écrit... > > > > if (!$CNX = mysql_connect($DB_BASE, $DB_USER, $DB_PASS, $DB_SERVER)) { > > > La syntaxe ci-dessus n'est pas supprimée en php 5.6. > > Normalement, il devrait accepter les scripts php

Re: Mysql et php5.6

2021-04-12 Thread Jean-Michel OLTRA
Bonjour, Le lundi 12 avril 2021, ajh-valmer a écrit... > > > if (!$CNX = mysql_connect($DB_BASE, $DB_USER, $DB_PASS, $DB_SERVER)) { > La syntaxe ci-dessus n'est pas supprimée en php 5.6. > Normalement, il devrait accepter les scripts php 5 Que mysql_connect existe encore c'est une

Re: Mysql et php5.6

2021-04-12 Thread ajh-valmer
On Monday 12 April 2021 17:45:08 Jean-Michel OLTRA wrote: > Le lundi 12 avril 2021, ajh-valmer a écrit... > > La connexion à la base ne se fait plus, même avec ce code : > > $DB_USER = 'xxx'; > > $DB_PASS = 'xxx'; > > $DB_SERVER = 'localhost'; > > $DB_BASE

Re: Mysql et php5.6

2021-04-12 Thread Jean-Michel OLTRA
Bonjour, Le lundi 12 avril 2021, ajh-valmer a écrit... > La connexion à la base ne se fait plus, même avec ce code : > $DB_USER = 'xxx'; > $DB_PASS = 'xxx'; > $DB_SERVER = 'localhost'; > $DB_BASE = 'xxx'; > // Connection mysql > if (!$CNX = mysql_connect($DB_BAS

Re: Mysql et php5.6

2021-04-12 Thread ajh-valmer
On Monday 12 April 2021 07:16:34 Jean-Michel OLTRA wrote: > Le dimanche 11 avril 2021, ajh-valmer a écrit... > > J'ai upgradé mon serveur Buster. MySQL est passée en version 8. > > Depuis, les scripts PHP 5.6 de mon site ne passent plus : > > "Erreur connexion serveur

Re: Mysql et php5.6

2021-04-11 Thread Jean-Michel OLTRA
Bonjour, Le dimanche 11 avril 2021, ajh-valmer a écrit... > J'ai upgradé mon serveur Buster. MySQL est passée en version 8. > Depuis, les scripts PHP 5.6 de mon site ne passent plus : > "Erreur connexion serveur Mysql : > Erreur de la requête 1.SELECT COUNT(numero) FR

Re: Mysql et php5.6

2021-04-11 Thread ajh-valmer
On Sunday 11 April 2021 21:47:41 Dethegeek wrote: > Vérifie que tu as bien installé et activé le module mysql pour php 7. > Le langage SQL en lui même n'a pas fondamentalement changé. C'est le module php 5.6 qui est activé. Si je mets le module php 7.4, c'est bon nombre de scripts php

Mysql et php5.6

2021-04-11 Thread ajh-valmer
Bonsoir, J'ai upgradé mon serveur Buster. MySQL est passée en version 8. Depuis, les scripts PHP 5.6 de mon site ne passent plus : "Erreur connexion serveur Mysql : Erreur de la requête 1.SELECT COUNT(numero) FROM ..." C'est bien le module php5.6 qui est installé sous Apache2. L

[solved] Re: php7 mysql

2021-04-03 Thread Pierre Meurisse
PHP > > i A php7.3-readline - module readline pour PHP > > i php7.3-xml - module DOM, SimpleXML, WDDX, XML et XSL pour PHP > > Il te manque php7.3-mysql > > > C'est toujours la même chose, le navigateur n'affiche que les > > sources. > > Il te manque libapac

Re: php7 mysql

2021-04-03 Thread Jean-Michel OLTRA
er-side, HTML-embedded scripting language (FPM-CGI binary) > i A php7.3-json - module JSON pour PHP > i A php7.3-opcache - module Zend OpCache pour PHP > i A php7.3-readline - module readline pour PHP > i php7.3-xml - module DOM, SimpleXML, WDDX, XML et XSL pour PHP Il te manque php7

  1   2   3   4   5   6   7   8   9   10   >