[BlueOnyx:22437] Re: new RoundCube version
Meaulnes Legler @ MailList
bluelist at waveweb.ch
Sat Oct 13 00:35:52 -05 2018
hi Dirk, thanks for the instructions!
unfortunately, the database named in config.inc.php doesn't exist in the personal profile phpMyAdmin, not even in the server's phpMyAdmin...
$config['db_dsnw'] = 'mysql://nwa_2ECOMKARcX4p:NWBbiLxXsNEHbcdO@127.0.0.1/nwa_xUF15UKWqakQ';
this means user:password at host/database, 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.
Other working RoundCubes with version 1.2.4. have also database names in their config.inc.php, but none of them appear in phpMyAdmin.
Then I found out that I noted how to access MySQL from the command line: mysql -u root -p
With MariaDB [(none)]> show databases I get a much longer list of databases and — look there — the nwa_xUF15UKWqakQ database is listed!
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)]>
But that's about it in my knowledge of MySQL... How do I access and change the value of the alias field in the users table?
Thank you and best regards
Meaulnes Legler
On 11.10.18 15:37, Dirk Estenfeld wrote:
>
> Hello Meaulnes,
>
> here is the way to correct it.
> Check the config/config.inc.php file in the roundcube installation.
> Look for the line $config['db_dsnw'] =
> At the end of the line you will find the database name: nwa_whatever
>
> Now you login to Blueonyx backend as admin and go to personal profile -> programs -> phpmyadmin (use “open in new window” link)
> Open Tab databases in the top and click on the name of the database you did find in config/config.inc.php
> Look for table users and klick structure.
> Click checkbox before alias and select edit under tables.
> Now set standard to NULL and save.
> That’s it. Now you can login again.
>
> Best regards,
>
> Dirk
>
> ---
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20181013/6c403be5/attachment.html>
More information about the Blueonyx
mailing list