LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-21-2016, 11:55 AM   #1
grant.baxter
LQ Newbie
 
Registered: Jun 2016
Posts: 1

Rep: Reputation: Disabled
Webmin database issue


Hello,

Sorry if someone has already asked this however i have looked high and low. Anyway, i am running Webmin on Ubuntu server and continuously experiencing issues with the MySQL database.

Everything is installed and I did get it working after i had fixed it ( lost the fix ) so basically when ever i try to create a new database user i receive the below error, I know it has something to do with the SSL Cipher. Can anyone help????

P.S. treat me a s a newbe as i know very little, but enough to figure things out

Failed to save user : SQL insert into user (host, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, authentication_string) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) failed : Column 'ssl_type' cannot be null
 
Old 06-21-2016, 06:35 PM   #2
urbanwks
Member
 
Registered: Sep 2003
Distribution: Slackware64-Current, FreeBSD 12.1, Alpine 5.4, Manjaro 19, Alpine on WSL [Win10]
Posts: 194

Rep: Reputation: 213Reputation: 213Reputation: 213
Since the values that are being inserted are listed as "?", I'm assuming that there's a script somewhere that is populating those values. The value for the field "ssl_type" is being passed as NULL, and the schema for the table "user" does not allow for NULL values. You need to specify a non-null value for this field.

I also count 2 more "?"s than there are fields in the query; that could cause a problem (unless I'm counting wrong).
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Webmin Backup Issue athomas Linux - Software 1 10-26-2010 01:56 AM
webmin issue, poss security issue bejiita Slackware 3 11-03-2004 07:07 AM
Quota / Webmin Issue lunardreamr Fedora 0 10-31-2004 02:33 PM
Webmin MySQL trouble reading database apache363 Linux - Software 2 04-28-2004 04:28 PM
Webmin theme issue guyk Linux - Software 2 04-14-2004 05:49 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:16 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration