<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style><!--
tt { background-color:#eaeaea; padding:0 4px;}
--></style>
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>hi Dirk, thanks for the instructions!</p>
<p>unfortunately, the database named in <tt>config.inc.php</tt>
doesn't exist in the personal profile phpMyAdmin, not even in the
server's phpMyAdmin...</p>
<p><tt style="">$config['db_dsnw'] = '<a
class="moz-txt-link-abbreviated"
href="mailto:mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ">mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ</a>';</tt></p>
<p>this means <tt>user:password@host/database</tt>, but how do I
access that database? I guess I would have to enter SQL commands
but I have find out how. I deleted the RC installation and
reinstalled it, I get then a new user, pw and database — still
doesn't show up in phpMyAdmin.</p>
<p>Other working RoundCubes with version 1.2.4. have also database
names in their <tt>config.inc.php</tt>, but none of them appear
in phpMyAdmin.</p>
<p>Then I found out that I noted how to access MySQL from the
command line: <tt>mysql -u root -p</tt></p>
<p>With <tt>MariaDB [(none)]> show databases</tt> I get a much
longer list of databases and — look there — the <tt style="">nwa_xUF15UKWqakQ</tt>
database is listed! </p>
<pre style="background-color:#eee; font-size:85%;">MariaDB [(none)]> show tables from nwa_xUF15UKWqakQ
-> ;
+----------------------------+
| Tables_in_nwa_xUF15UKWqakQ |
+----------------------------+
| cache |
| cache_index |
| cache_messages |
| cache_thread |
| contactgroupmembers |
| contactgroups |
| contacts |
| dictionary |
| identities |
| searches |
| session |
| users |
+----------------------------+
12 rows in set (0.00 sec)
MariaDB [(none)]> show table status from nwa_xUF15UKWqakQ;
+---------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+---------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| cache | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| cache_index | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| cache_messages | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| cache_thread | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| contactgroupmembers | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-10-12 22:21:46 | NULL | NULL | latin1_swedish_ci | NULL | | |
| contactgroups | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| contacts | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| dictionary | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| identities | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| searches | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
| session | InnoDB | 10 | Dynamic | 1 | 16384 | 16384 | 0 | 16384 | 0 | NULL | 2018-10-12 22:21:46 | 2018-10-12 22:22:12 | NULL | utf8_general_ci | NULL | | |
| users | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2018-10-12 22:21:46 | NULL | NULL | utf8_general_ci | NULL | | |
+---------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
12 rows in set (0.00 sec)
MariaDB [(none)]></pre>
<p>But that's about it in my knowledge of MySQL... How do I access
and change the value of the <tt>alias</tt> field in the <tt>users</tt>
table?</p>
<p>Thank you and best regards</p>
<p>Meaulnes Legler<br>
</p>
<br>
<div class="moz-cite-prefix">On 11.10.18 15:37, Dirk Estenfeld
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:c1d5a8a804954b1698adb02481ef3407@blackpoint.de">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Consolas;
	panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;
	color:black;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p
	{mso-style-priority:99;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;
	color:black;}
pre
	{mso-style-priority:99;
	mso-style-link:"HTML Vorformatiert Zchn";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";
	color:black;}
tt
	{mso-style-priority:99;
	font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
	{mso-style-name:msonormal;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;
	color:black;}
span.HTMLVorformatiertZchn
	{mso-style-name:"HTML Vorformatiert Zchn";
	mso-style-priority:99;
	mso-style-link:"HTML Vorformatiert";
	font-family:Consolas;
	color:black;}
span.E-MailFormatvorlage22
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hello
Meaulnes,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-GB">here is the way to correct it.<br>
Check the config/config.inc.php file in the roundcube
installation.<br>
Look for the line $config['db_dsnw'] =<br>
At the end of the line you will find the database name:
nwa_whatever<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-GB">Now you login to Blueonyx backend as admin and
go to personal profile -> programs -> phpmyadmin (use
“open in new window” link)<br>
Open Tab databases in the top and click on the name of the
database you did find in config/config.inc.php<br>
Look for table users and klick structure.<br>
Click checkbox before alias and select edit under tables.<br>
Now set standard to NULL and save.<br>
That’s it. Now you can login again.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-GB">Best regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-GB">Dirk<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span
style="font-size:8.0pt;font-family:"Arial",sans-serif;color:gray"><o:p> </o:p>---<br>
</span><br>
</p>
</div>
</div>
</blockquote>
<br>
</body>
</html>