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

2024-04-24 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 syste

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.) > S

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 not

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 > de

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? -- Gruß

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 dis

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 progra

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 juin

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, wi

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 ap

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*

[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, Susmita/Raj

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
og 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 script

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

2023-11-11 Thread debian-user
at > 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 > > Ac

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_sha2

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
t;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: Your PHP installation appears to be missing the MySQL extension which is required by WordPress at: https://stackoverflo

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 num

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-c

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 u

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&#

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 .s

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 on

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 (< 3.1

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: 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 on

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 descripti

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 f

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.

Re: Order of package updates, mysql vs. kernel

2021-10-11 Thread Vladislav Kurz
don't 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 st

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: Lua doesn't load the MySQL driver

2019-12-06 Thread Mark Allums
On 12/5/19 5:02 AM, Bjoern Schiessle wrote: I tried to move the file /usr/local/share/lua/5.2/DBI.lua away, then the error message changes to: Dec 05 11:57:35 sql error Error in SQL transaction: /usr/share/lua/5.2/DBI.lua:53: Cannot load driver MySQL. Available drivers are: PostgreSQL So

Re: Lua doesn't load the MySQL driver

2019-12-05 Thread Andrei POPESCU
h I recently > > > updated to Buster. Since the update the Prosody server refuses to > > > connect to the MariaDB database. The log shows following error: > > > > > > Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody... > > > Nov 30 22:09:15 sql deb

Re: Lua doesn't load the MySQL driver

2019-12-05 Thread tomas
on a Debian server which I recently > > > updated to Buster. Since the update the Prosody server refuses to > > > connect to the MariaDB database. The log shows following error: > > > > > > Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody... > > > Nov 30 22

Re: Lua doesn't load the MySQL driver

2019-12-05 Thread Bjoern Schiessle
fuses to > > connect to the MariaDB database. The log shows following error: > > > > Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody... > > Nov 30 22:09:15 sql debug Database connection was closed. Will > > reconnect and retry. > > Nov

Re: Lua doesn't load the MySQL driver

2019-12-04 Thread tomas
> Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody... > Nov 30 22:09:15 sql debug Database connection was closed. Will > reconnect and retry. > Nov 30 22:09:15 sql debug Retrying SQL transaction > [function(mod_storage_sql.lua:137)] > Nov 30 22:09:15 sql debug Conne

Lua doesn't load the MySQL driver

2019-12-04 Thread Bjoern Schiessle
Hi, I run the XMPP server Prosody on a Debian server which I recently updated to Buster. Since the update the Prosody server refuses to connect to the MariaDB database. The log shows following error: Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody... Nov 30 22:09:15 sql debug

Re: cannot bring up phpmyadmin in browser, cannot link to mysql

2019-10-06 Thread Joe
ete BS. > > Also reffering to some notes from may be 15y ago does not answer the > question. > > The one which urges to go through the installation steps is a good > one. I would also add that OP should go through the mysql/mariadb > installation notes. > > Most likely

Re: cannot bring up phpmyadmin in browser, cannot link to mysql

2019-10-05 Thread deloptes
e one which urges to go through the installation steps is a good one. I would also add that OP should go through the mysql/mariadb installation notes. Most likely it is due to the fact they want to use phpmyadmin with root access from the web browser, which I think is disabled unless you set passwo

Re: cannot bring up phpmyadmin in browser, cannot link to mysql

2019-10-05 Thread Joe
not been able to link other programs like wordpress to > sql or phpmyadmin to sql. > > DEBIAN 9.04 > > please advise > Two different issues. Is MySQL or MariaDb actually running? I recall there are gotchas with new installations (though of course, not what they wer

Re: cannot bring up phpmyadmin in browser, cannot link to mysql

2019-10-05 Thread Miles Fidelman
On 10/5/19 11:51 AM, Dave wrote: On our old server we used to access phpmyadmin via "oursite.com/phpmyadmin" on the new server we have installed phpmyadmin / php / and sql-server ... we cannot access phpmyadmin. also we have not been able to link other programs like wordpress to sql or phpmy

cannot bring up phpmyadmin in browser, cannot link to mysql

2019-10-05 Thread Dave
On our old server we used to access phpmyadmin via "oursite.com/phpmyadmin" on the new server we have installed phpmyadmin / php / and sql-server ... we cannot access phpmyadmin. also we have not been able to link other programs like wordpress to sql or phpmyadmin to sql. DEBIAN 9.04 please a

Character set & BLOBS on MySQL

2018-11-07 Thread Andrew Wood
I am in the process of moving some tables from MySQL 5.1 on Squeeze to MariaDB 10.1 on Buster. One of the tables stores binary data (either a PDF or JPEG) as a LONGBLOB. The code that reads & writes to the table is PHP and hasnt changed other than having the url of the database server alt

Re: A tutorial for MySql installation

2018-08-02 Thread Richard Owlett
of the world. Unless you have specialized needs it doesn't matter which of the MySQL forks you use. WordPress only uses general MySQL functionality, so use whatever's in the repo. For debian there's now default-mysql-server which is a metapackage picking up MariaDB. The debi

Re: A tutorial for MySql installation

2018-08-02 Thread der.hans
Am 02. Aug, 2018 schwätzte Richard Owlett so: At the end you say this is for WordPress, that pre-answers some of the questions I was going to bring up :). Unless you have specialized needs it doesn't matter which of the MySQL forks you use. WordPress only uses general MySQL functionalit

Re: A tutorial for MySql installation

2018-08-02 Thread Richard Owlett
repositories, You're preaching to the choir. I've already mentioned 3 times that I want what is in the repository ;} unless you have a known need for a specific release. The usual repos normally have multiple releases of MariaDB/MySQL on them. It tries to be too many things for too m

Re: A tutorial for MySql installation

2018-08-02 Thread Richard Owlett
On 08/02/2018 10:08 AM, to...@tuxteam.de wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Aug 02, 2018 at 09:10:12AM -0500, Richard Owlett wrote: On 08/02/2018 08:27 AM, to...@tuxteam.de wrote: [...] It was pointed out that MySql would be more suitable. I don't under

Re: A tutorial for MySql installation

2018-08-02 Thread Nicholas Geovanis
eed for a specific release. The usual repos normally have multiple releases of MariaDB/MySQL on them. > It tries to be too many things for too many people MariaDB/MySQL are today DBMS's of commercial depth and quality. That wasn't always the case. One whole lot of Earth's comme

Re: A tutorial for MySql installation

2018-08-02 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Aug 02, 2018 at 09:10:12AM -0500, Richard Owlett wrote: > On 08/02/2018 08:27 AM, to...@tuxteam.de wrote: [...] > >>It was pointed out that MySql would be more suitable. > > > >I don't understand this statement.

Re: A tutorial for MySql installation

2018-08-02 Thread Richard Owlett
being on a network server. The MariaDB server *is* conceptually a network server, as is the MySQL server (but see below). It was pointed out that MySql would be more suitable. I don't understand this statement... Nor did I :/ During my reading before attempting to install MariaDB it was

Re: A tutorial for MySql installation

2018-08-02 Thread Richard Owlett
r *is* conceptually a network server, as is the MySQL server (but see below). It was pointed out that MySql would be more suitable. I don't understand this statement... Nor did I :/ During my reading before attempting to install MariaDB it was either an enhanced MySql or a renamin

Re: A tutorial for MySql installation

2018-08-02 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Aug 02, 2018 at 08:20:08AM -0500, Richard Owlett wrote: > Some time ago failed to install MariaDB. I hadn't realized it was > tightly aimed at being on a network server. The MariaDB server *is* conceptually a network server, as i

A tutorial for MySql installation

2018-08-02 Thread Richard Owlett
Some time ago failed to install MariaDB. I hadn't realized it was tightly aimed at being on a network server. It was pointed out that MySql would be more suitable. I attempted to install it. It failed due to reasons I don't recall. I suspect that part of the problem was I was att

Re: mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-11 Thread Mark Fletcher
On Sat, Nov 11, 2017 at 11:23:37AM +0200, Tapio Lehtonen wrote: > Mark Fletcher kirjoitti 11.11.2017 klo 08:44: > > > > I'm not sure I'd expect that much newer a mysqldump client to work on > > that much older a server. And the mysql - mariadb divide won't

Re: mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-11 Thread Tapio Lehtonen
T. I did not see >>> error messages in logs. >>> >>> root@ispc6:~# mysqldump -cCQ --triggers --routines --quote-names >>> --hex-blob -h -p'password' alfamat_db >>> -- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu >>> (x8

Re: mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-10 Thread Mark Fletcher
pc6:~# mysqldump -cCQ --triggers --routines --quote-names > > --hex-blob -h -p'password' alfamat_db > > -- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu > > (x86_64) > > -- I'm not sure I'd expect that much newer a mysqldump clien

mysqldump from mysql 5.1.73 to mariadb 10.1.26 imports no data

2017-11-10 Thread Tapio Lehtonen
, just some SET lines. Example below with usernames and passwords edited out. This command was run on the TARGET. I did not see error messages in logs. root@ispc6:~# mysqldump -cCQ --triggers --routines --quote-names --hex-blob -h -p'password' alfamat_db -- MySQL dump 10.16  Distrib 10.1.

[Mysql] Performance problem after database drop

2017-06-26 Thread kc atgb
Hi all, I have a strange situation with one of our database servers. After a table purge , we can see a performance degradation for the same jobs. What do the job do, write data to two tables. The first one is purged from entries after 2 months. The second one, is never purged so we had do to it

witch is better for setting options to mysql (5.7.18) ...

2017-06-05 Thread DutchGigalo
witch is better for setting options to mysql, use //etc/mysql/mysql.conf.d/mysqld.cnf/ or / /etc/mysql/my.cnf/ thanks... -- View this message in context: http://debian.2.n7.nabble.com/witch-is-better-for-setting-options-to-mysql-5-7-18-tp4126439.html Sent from the Debian User mailing

Re: zabbix-server-mysql

2017-05-31 Thread Gareth de Vaux
On Mon 2017-05-29 (18:23), Gareth de Vaux wrote: > Hi all, I'm trying to install zabbix-server-mysql on Stretch but when I > get to the configuration over the web stage there's no database type > option for MySQL, only PostgreSQL. I assume this's because zabbix-server-

zabbix-server-mysql

2017-05-29 Thread Gareth de Vaux
Hi all, I'm trying to install zabbix-server-mysql on Stretch but when I get to the configuration over the web stage there's no database type option for MySQL, only PostgreSQL. I assume this's because zabbix-server-mysql pulls in MariaDB rather than MySQL. How do I get zabbix to use 'MySQL'?

Re: how to force mysql to use the name of my machine instead of localhost

2017-04-16 Thread Joe
On Sun, 16 Apr 2017 20:45:56 +0100 Joe wrote: > On Sun, 16 Apr 2017 10:17:53 +0100 > Abdelkader Belahcene wrote: > > > *Thanks for reply and links* > > > > > > *But I am sure, the problem is in mysql.* > > *Look at this: * > > > > *my count

Re: how to force mysql to use the name of my machine instead of localhost

2017-04-16 Thread Joe
On Sun, 16 Apr 2017 10:17:53 +0100 Abdelkader Belahcene wrote: > *Thanks for reply and links* > > > *But I am sure, the problem is in mysql.* > *Look at this: * > > *my count is lite@lite* > *and hostname gives * > *lite@lite:/opt/lampp$ hostname* > *lit

Re: Re: how to force mysql to use the name of my machine instead of localhost

2017-04-16 Thread deloptes
Abdelkader Belahcene wrote: > *Thanks for reply and links* > > > *But I am sure, the problem is in mysql.* > *Look at this: * > > *my count is lite@lite* > *and hostname gives * > *lite@lite:/opt/lampp$ hostname* > *lite.umbb.dz <http://lite.umbb.dz>*

Re: Re: how to force mysql to use the name of my machine instead of localhost

2017-04-16 Thread Abdelkader Belahcene
*Thanks for reply and links* *But I am sure, the problem is in mysql.* *Look at this: * *my count is lite@lite* *and hostname gives * *lite@lite:/opt/lampp$ hostname* *lite.umbb.dz <http://lite.umbb.dz>* *bin/mysql* *ERROR 1045 (28000): Acces s denied for user 'lite'@&#

Re: Re: how to force mysql to use the name of my machine instead of localhost

2017-04-11 Thread deloptes
Abdelkader Belahcene wrote: > thanks a lot for any idea This has nothing to do with mysql or debian, but with wordpress. Please refer the manual or subscribe to the wordpress list. Perhaps someone else here may help you, but it would be OT IMO. regards

Re: how to force mysql to use the name of my machine instead of localhost

2017-04-11 Thread Richard Owlett
in DB, localhost I tore the name of my machine like bela.enst.dz, the connetion w'll be done with this name and the problem is then solved I used xampp to install apache, mysql and php. But the problem is the same when I installed each element alone ( apache2, php, mysql) when I used t

Re: Re: how to force mysql to use the name of my machine instead of localhost

2017-04-11 Thread Abdelkader Belahcene
like bela.enst.dz, the connetion w'll be done with this name and the problem is then solved I used xampp to install apache, mysql and php. But the problem is the same when I installed each element alone ( apache2, php, mysql) when I used the command : localhost -f , I got the correct name tmp$ h

Re: how to force mysql to use the name of my machine instead of localhost

2017-04-10 Thread Joe
On Mon, 10 Apr 2017 07:51:56 +0100 Abdelkader Belahcene wrote: > My machine has another name than localhost like lite.bela.umbb, > when I install mysql, it always takes the the localhost as the name > of the machine. this yields in a problem for me, when I use for > example wor

how to force mysql to use the name of my machine instead of localhost

2017-04-09 Thread Abdelkader Belahcene
My machine has another name than localhost like lite.bela.umbb, when I install mysql, it always takes the the localhost as the name of the machine. this yields in a problem for me, when I use for example wordpress and I want a remote connection. because the localhost stored in DB is irrelevant

Re: Followed https://wiki.debian.org/WordPress got mysql error, syntax Error 1064

2016-12-04 Thread Nate Homier
A ha, line numbers! Toggle line numbers 1 CREATE DATABASE wordpress; 2 GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER 3 ON wordpress.* 4 TO wordpress@localhost 5 IDENTIFIED BY 'NaTe1973J15!'; 6 FLUSH PRIVILEGES; ​ Now that is very obvious once you know it. I thought the phr

Re: Followed https://wiki.debian.org/WordPress got mysql error, syntax Error 1064

2016-12-04 Thread Kushal Kumaran
Nate Homier writes: > I followed the Debian wiki for Wordpress. I got to the part about > > cat ~/wp.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf > > And boom, error! > > Error is; 1064 (42000) at line 1: > > you have an error in your SQL syntax > >

Re: Followed https://wiki.debian.org/WordPress got mysql error, syntax Error 1064

2016-12-04 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Dec 03, 2016 at 11:46:16PM -0700, Nate Homier wrote: > I followed the Debian wiki for Wordpress. I got to the part about > > cat ~/wp.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf Can you show us the file "wp.sql&

Followed https://wiki.debian.org/WordPress got mysql error, syntax Error 1064

2016-12-03 Thread Nate Homier
I followed the Debian wiki for Wordpress. I got to the part about cat ~/wp.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf And boom, error! Error is; 1064 (42000) at line 1: you have an error in your SQL syntax 1 CREATE DATABASE wordpress' at line 1 I am running latest versi

Re: Mysql failed

2016-11-17 Thread Cindy-Sue Causey
On 11/16/16, Tony van der Hoff wrote: > Hi, > > I've just discovered that MySQL on my jessie desktop box has died > unexpectedly. I'm pretty sure it was working 3/4 days ago. > > #### > tony@tony-lx:~$ mysql -p > E

Re: Mysql failed

2016-11-16 Thread Tony van der Hoff
On 16/11/16 16:10, Joe wrote: On 16/11/2016 15:48, Tony van der Hoff wrote: The following packages have unmet dependencies: mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.50-0+deb8u1) but it is not going to be installed PreDepends: mysql-common (>= 5.5.50-0+

Re: Mysql failed

2016-11-16 Thread Joe
On 16/11/2016 15:48, Tony van der Hoff wrote: The following packages have unmet dependencies: mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.50-0+deb8u1) but it is not going to be installed PreDepends: mysql-common (>= 5.5.50-0+deb8u1) but it is not going

Mysql failed

2016-11-16 Thread Tony van der Hoff
Hi, I've just discovered that MySQL on my jessie desktop box has died unexpectedly. I'm pretty sure it was working 3/4 days ago. tony@tony-lx:~$ mysql -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server

  1   2   3   4   5   6   7   8   9   10   >