<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
<span style="background-color: rgba(255, 255, 255, 0);">Hi Andrew, </span>
<div><span style="background-color: rgba(255, 255, 255, 0);"><br>
</span></div>
<div><span style="background-color: rgba(255, 255, 255, 0);">For unknown reasons I did not receive your response. However, we fixed the problem, or to be precise: my colleague fixed it for me. I don't know exactly what he did, but now it works. </span></div>
<div><span style="background-color: rgba(255, 255, 255, 0);"><br>
</span></div>
<div><span style="background-color: rgba(255, 255, 255, 0);">Best, Simon</span></div>
<br>
<div id="AppleMailSignature" dir="ltr">---
<div>Von meinen Smartphone gesendet </div>
<div><br>
<div><span style="font-size: 13pt;"><br>
</span></div>
</div>
</div>
<div dir="ltr"><br>
Am 19.11.2019 um 21:54 schrieb Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>>:<br>
<br>
</div>
<blockquote type="cite">
<div dir="ltr"><span>Hi Simon </span><br>
<span></span><br>
<span>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.</span><br>
<span></span><br>
<span>More details here: <a href="https://mariadb.com/kb/en/library/moving-from-mysql-to-mariadb-in-debian-9/">
https://mariadb.com/kb/en/library/moving-from-mysql-to-mariadb-in-debian-9/</a> </span>
<br>
<span></span><br>
<span>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.
</span><br>
<span></span><br>
<span>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. </span><br>
<span></span><br>
<span>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. </span><br>
<span></span><br>
<span>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.</span><br>
<span></span><br>
<span>best</span><br>
<span></span><br>
<span>Andrew.</span><br>
<span></span><br>
<span>-----Original Message-----</span><br>
<span>From: <a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a>> On Behalf Of Simon Meier-Vieracker</span><br>
<span>Sent: 19 November 2019 19:51</span><br>
<span>To: Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a>></span><br>
<span>Subject: [External Sender] [CWB] MySQL did not connect - please try again later!</span><br>
<span></span><br>
<span>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.</span><br>
<span></span><br>
<span>Hi,</span><br>
<span></span><br>
<span>after upgrading my VM-server (<a href="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">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</a>)
from Debian 8 to 9, CQPweb shows the following error:</span><br>
<span></span><br>
<blockquote type="cite"><span>MySQL did not connect - please try again later!</span><br>
</blockquote>
<span></span><br>
<span>Does anyone have an idea where I could have a closer look and what I should check to find the source of this error?</span><br>
<span></span><br>
<span>Best,</span><br>
<span>Simon</span><br>
<span></span><br>
<span></span><br>
<span>_______________________________________________</span><br>
<span>CWB mailing list</span><br>
<span><a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a></span><br>
<span><a href="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">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</a></span><br>
<span>_______________________________________________</span><br>
<span>CWB mailing list</span><br>
<span><a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a></span><br>
<span><a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a></span><br>
</div>
</blockquote>
</body>
</html>