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@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
---
_______________________________________________
Blueonyx mailing list
Blueonyx@mail.blueonyx.it
http://mail.blueonyx.it/mailman/listinfo/blueonyx
