From: Kimberly <kim...@gm...> - 2019-08-09 16:03:30
|
I am setting up a new server and decided to also install Virtualmin as I have to let additional people on the server. When the new virtual server was created, I got the following error message: Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, x509_subject) values ('localhost', 'username', '', '', '', '') failed : The target table user of the INSERT is not insertable-into at ../web-lib-funcs.pl line 1476. What do I need to do to correct this? |
From: Kimberly <kim...@gm...> - 2019-08-09 21:50:45
|
It is also not creating the database for the virtual server; I have checked and double checked the server template. All looks good to me. On 09/08/2019 12:03, Kimberly wrote: > I am setting up a new server and decided to also install Virtualmin as I > have to let additional people on the server. When the new virtual > server was created, I got the following error message: > > Creating MySQL login .. > .. MySQL database failed! : mysql::execute_sql_logged failed : SQL > insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, > x509_subject) values ('localhost', 'username', '', '', '', '') failed : > The target table user of the INSERT is not insertable-into at > ../web-lib-funcs.pl line 1476. > > What do I need to do to correct this? > > > > - > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list |
From: Kimberly <kim...@gm...> - 2019-08-09 23:10:46
|
OK, I see where this is a bug in virtualmin; a fix is being worked on. Thanks guys for all your hard work on making webmin/virualmin the best server control panel out there. I really mean this, I have tried just about all of them and I keep staying with webmin/virualmin. On 09/08/2019 17:50, Kimberly wrote: > It is also not creating the database for the virtual server; I have > checked and double checked the server template. All looks good to me. > > > On 09/08/2019 12:03, Kimberly wrote: >> I am setting up a new server and decided to also install Virtualmin as I >> have to let additional people on the server. When the new virtual >> server was created, I got the following error message: >> >> Creating MySQL login .. >> .. MySQL database failed! : mysql::execute_sql_logged failed : SQL >> insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, >> x509_subject) values ('localhost', 'username', '', '', '', '') failed : >> The target table user of the INSERT is not insertable-into at >> ../web-lib-funcs.pl line 1476. >> >> What do I need to do to correct this? >> >> >> >> - >> Forwarded by the Webmin mailing list at >> web...@li... >> To remove yourself from this list, go to >> http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > > > - > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list |
From: Kimberly <kim...@gm...> - 2019-08-10 16:57:06
|
I don't want to downgrade MariaDB version. As far as the virtual server is concerned, is there any problem with me creating the database manually logged in as the root user and assigning the virtual server user to the database setting proper permissions? I am guessing that if the virtual server is removed that the database will stay behind but that is OK. I am also guessing that the database will never show up in the virtual server panel. On 09/08/2019 17:50, Kimberly wrote: > > On 09/08/2019 12:03, Kimberly wrote: >> I am setting up a new server and decided to also install Virtualmin as I >> have to let additional people on the server. When the new virtual >> server was created, I got the following error message: >> >> Creating MySQL login .. >> .. MySQL database failed! : mysql::execute_sql_logged failed : SQL >> insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, >> x509_subject) values ('localhost', 'username', '', '', '', '') failed : >> The target table user of the INSERT is not insertable-into at >> ../web-lib-funcs.pl line 1476. >> >> What do I need to do to correct this? >> >> >> >> - >> Forwarded by the Webmin mailing list at >> web...@li... >> To remove yourself from this list, go to >> http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > > > - > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list |
From: Jamie C. <jca...@we...> - 2019-08-10 23:55:10
|
Hi Kimberly, You could try applying this patch : https://github.com/virtualmin/virtualmin-gpl/commit/b414d655de88675fa2cb715ec81875df2ffaa537 Then restart Webmin, and re-try the domain creation. By the way, which Linux distribution and version are you running there? On 10/Aug/2019 09:56 Kimberly <kim...@gm...> wrote .. > I don't want to downgrade MariaDB version. As far as the virtual server > is concerned, is there any problem with me creating the database > manually logged in as the root user and assigning the virtual server > user to the database setting proper permissions? I am guessing that if > the virtual server is removed that the database will stay behind but > that is OK. I am also guessing that the database will never show up in > the virtual server panel. > > > On 09/08/2019 17:50, Kimberly wrote: > > > > On 09/08/2019 12:03, Kimberly wrote: > >> I am setting up a new server and decided to also install Virtualmin as I > >> have to let additional people on the server. When the new virtual > >> server was created, I got the following error message: > >> > >> Creating MySQL login .. > >> .. MySQL database failed! : mysql::execute_sql_logged failed : SQL > >> insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, > >> x509_subject) values ('localhost', 'username', '', '', '', '') failed : > >> The target table user of the INSERT is not insertable-into at > >> ../web-lib-funcs.pl line 1476. > >> > >> What do I need to do to correct this? > >> > >> > >> > >> - > >> Forwarded by the Webmin mailing list at > >> web...@li... > >> To remove yourself from this list, go to > >> http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > > > > > > > > - > > Forwarded by the Webmin mailing list at > > web...@li... > > To remove yourself from this list, go to > > http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > > > - > Forwarded by the Webmin mailing list at web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list |