[CWB] MySQL did not connect - please try again later!

[Hardie, Andrew]

Hi Simon 

One likely issue is that the default MySQL was "real" MySQL in Debian 8, but from Debian 9 onwards it's MariaDB. so, chances are your upgrade has uninstalled mysql and installed mariadb. You can check this by entering command line mysql and seeing what the prompt says.

More details here: https://mariadb.com/kb/en/library/moving-from-mysql-to-mariadb-in-debian-9/ 

So, my guess is that some aspect of your client configuration is not right for the new DB, and this and is blocking the connection.  This could be either your CQPweb config file, or the php.ini setup for the mysql connection. 

Re connection, the easiest way to test it is to use the settings in your CQPweb config file via the mysql CLI client. With this client, you can vary things to find out what works and what doesn't - then compare that to what PHP / CQPweb have in their settings. 

The most likely problem is with the server address so you can specify that explicitly with --host when invoking mysql (another possible issue is with the socket file: specify that with --socket; see man mysql for more). That should give you decent error messages. 

If that doesn't work, another possibility is that modifications to your former php.ini file have not carried over to the new php.ini file, and that these affect the mariadb connection.

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Simon Meier-Vieracker
Sent: 19 November 2019 19:51
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: [External Sender] [CWB] MySQL did not connect - please try again later!

This email originated from outside of the University. Do not click links or open attachments unless you recognise the sender and know the content is safe.

Hi,

after upgrading my VM-server (https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffussballlinguistik.linguistik.tu-berlin.de&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C7d9311ba1b8843a340a508d76d29e737%7C9c9bcd11977a4e9ca9a0bc734090164a%7C1%7C1%7C637097899065447866&amp;sdata=b%2F446fKdXJ51Y1bzwCMH0Do78Pv4c8Zbs6reKQuD4mI%3D&amp;reserved=0) from Debian 8 to 9, CQPweb shows the following error:

> MySQL did not connect - please try again later!

Does anyone have an idea where I could have a closer look and what I should check to find the source of this error?

Best,
Simon


_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C7d9311ba1b8843a340a508d76d29e737%7C9c9bcd11977a4e9ca9a0bc734090164a%7C1%7C1%7C637097899065457859&amp;sdata=Jd%2F3%2FMp57iB8RAGjkKXFmfmb4Y1M3SkRezxXQ9o9Q2s%3D&amp;reserved=0