Error on Create New User: Field 'salt' doesn't have a default value

[q2amarket]

When I tried to create user with store_salt to FALSE it is giving below error

$config['salt_length'] = 10;
$config['store_salt']  = FALSE;

Here is the error

Error Number: 1364

Field 'salt' doesn't have a default value

INSERT INTO `users` (`first_name`, `last_name`, `company`, `phone`, `username`, `password`, `email`, `ip_address`, `created_on`, `last_login`, `active`) VALUES ('xxx', 'yyy', 'zzz', '466', 'xxx.yyy', '', 'xxx@yyy.com', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0�', 1385641604, 1385641604, 1)

Filename: C:\xampp\htdocs\atlas-dev\system\database\DB_driver.php

Line Number: 330

When I tried with store_sal to TRUE it is not giving error but than it is not considering the password correct and user cannot login.

Can you help to resolve this?

[benedmunds]

Add a default value of null to the salt field in the DB.

-Ben Edmunds

On Nov 28, 2013, at 4:41 AM, Q2A Market notifications@github.com wrote:

When I tried to create user with store_salt to FALSE it is giving below
error

$config['salt_length'] = 10;$config['store_salt'] = FALSE;

Here is the error

Error Number: 1364
Field 'salt' doesn't have a default value
INSERT INTO users (first_name, last_name, company, phone,
username, password, email, ip_address, created_on,
last_login, active) VALUES ('xxx', 'yyy', 'zzz', '466', 'xxx.yyy',
'', 'xxx@yyy.com', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 1385641604,
1385641604, 1)
Filename: C:\xampp\htdocs\atlas-dev\system\database\DB_driver.php
Line Number: 330

When I tried with store_sal to TRUE it is not giving error but than it is
not considering the password correct and user cannot login.

Can you help to resolve this?

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522
.

[q2amarket]

Thanks for reply,

Could you please specify in which file I should look for the salt field for the DB?

[benedmunds]

Actually in your DB Schema. So use your favorite GUI or the command line to
set a default value for that column.

-Ben Edmunds

On Nov 28, 2013, at 9:05 PM, Q2A Market notifications@github.com wrote:

Thanks for reply,

Could you please specify in which file I should look for the salt field for
the DB?

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29497017
.

[q2amarket]

Oh so should I consider it as a bug? By the way if I want to use salt and make it to True in config than why it is not considering any password?

I may be asking very basic question but still trying to understand the system you have written. I won't mind to use salt as far as it works well.

[benedmunds]

Ok that's fine. Set it to true and then copy the password from the comment
in the config file to your db for the admin user. The salt changes the way
the password on hashed so you'll need to update it.

-Ben Edmunds

On Nov 28, 2013, at 9:29 PM, Q2A Market notifications@github.com wrote:

Oh so should I consider it as a bug? By the way if I want to use salt and
make it to True in config than why it is not considering any password?

I may be asking very basic question but still trying to understand the
system you have written. I won't mind to use salt as far as it works well.

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29497503
.

[q2amarket]

Thanks for the quick response,

I have already tried that before posting here.

When I set store_salt to TRUE and updated password fbaa5e216d163a02ae630ab1a43372635dd374c0 in admin password field but than not able to login.

Note: I have tried updating password without selecting any function like sha1 al well as by selecting sha1 but none of them works.

[benedmunds]

Ah sorry I missed that you updated the password. Please ensure that the
salt is still there in the db as well.

-Ben Edmunds

On Nov 28, 2013, at 9:37 PM, Q2A Market notifications@github.com wrote:

Thanks for the quick response,

I have already tried that before posting here.

When I set store_salt to TRUE and updated password
fbaa5e216d163a02ae630ab1a43372635dd374c0 in admin password field but than
not able to login.

Note: I have tried updating password without selecting any function like
sha1 al well as by selecting sha1 but none of them works.

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29497662
.

[q2amarket]

Yeah salt value is there in db. Please refer this image http://s28.postimg.org/cpleard4t/image.jpg

[benedmunds]

Did you change the username or email? If so try setting it back to admin
and try again.

-Ben Edmunds

On Nov 28, 2013, at 9:42 PM, Q2A Market notifications@github.com wrote:

Yeah salt value is there in db. Please refer this image
http://s28.postimg.org/cpleard4t/image.jpg

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29497761
.

[q2amarket]

Actually I made changes directly to the migration file so that should not be a problem. What basically I have done combined first name and last name with dot so it will become first.last where default is with the space.

I have set identification with the username instead of email. Can that creates a problem?

[q2amarket]

Here is the code what I Have updated controllers/auth.php line #415

$username = strtolower($this->input->post('first_name')) . '.' . strtolower($this->input->post('last_name'));

This allows me to login with the store_salt to FALSE but than again not able to create new users

[benedmunds]

Do you need username login? I usually recommend using email login.

If you're going to use username you should allow the user to enter it
usually

-Ben Edmunds

On Nov 28, 2013, at 10:00 PM, Q2A Market notifications@github.com wrote:

Here is the code what I Have updated controllers/auth.php line
#415#415

$username = strtolower($this->input->post('first_name')) . '.' .
strtolower($this->input->post('last_name'));

This allows me to login with the store_salt to FALSE but than again not
able to create new users

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29498125
.

[benedmunds]

Yea likely there is an inconsistently with your changes.

How did you change the login view and method?

-Ben Edmunds

On Nov 28, 2013, at 9:57 PM, Q2A Market notifications@github.com wrote:

Actually I made changes directly to the migration file so that should not
be a problem. What basically I have done combined first name and last name
with dot so it will become first.last where default is with the space.

I have set identification with the username instead of email. Can that
creates a problem?

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29498054
.

[q2amarket]

Yes actually the system I am building is for internal use only and we may use only username instead of email. But if you prefer and suggest email than I may switch that to email.

---

I am using Bootstrap3 so wrap your code to their HTML. Basically I didn't changed anything but only added HTML wrapper and some class to the form_xxx() fields.

[benedmunds]

Well it's not that you need that, I'm just trying to figure out what broke
it. Can you send me your controller and a db dump and I'll try it when I
get a chance.

Email me, ben.edmunds@gmail.com

-Ben Edmunds

On Nov 28, 2013, at 10:07 PM, Q2A Market notifications@github.com wrote:

Yes actually the system I am building is for internal use only and we may
use only username instead of email. But if you prefer and suggest email

than I may switch that to email.

I am using Bootstrap3 so wrap your code to their HTML. Basically I didn't
changed anything but only added HTML wrapper and some class to the
form_xxx() fields.

—
Reply to this email directly or view it on
GitHubhttps://github.com//issues/522#issuecomment-29498264
.

[q2amarket]

Okay will send you all files by end of the day today.. you please have a look the matter. Thanks a lot

[q2amarket]

Resolved..Just changed password and works fine.

[LChaiya]

Hello I'm chaiya. I'm new Ion auth user.

I 'm facing with password field get 0 when create new user.

Could anyone help me?

[benedmunds]

Post your Ion Auth config file please.

[LChaiya]

Thank you to Mr. Ben for your fast reply

HERE is my config file:

ion_auth->is_max_login_attempts_exceeded(). | The controller should check this function and act | appropriately. If this variable set to 0, there is no maximum. */ $config['site_title'] = "MYsite.com"; // Site Title, example.com $config['admin_email'] = "loeur.chaiya@gmail.com"; // Admin Email, admin@example.com $config['default_group'] = 'members'; // Default group, use name $config['admin_group'] = 'admin'; // Default administrators group, use name $config['identity'] = 'email'; // A database column which is used to login with $config['min_password_length'] = 8; // Minimum Required Length of Password $config['max_password_length'] = 20; // Maximum Allowed Length of Password $config['email_activation'] = TRUE; // Email Activation for registration $config['manual_activation'] = FALSE; // Manual Activation for registration $config['remember_users'] = TRUE; // Allow users to be remembered and enable auto-login $config['user_expire'] = 86500; // How long to remember the user (seconds). Set to zero for no expiration $config['user_extend_on_login'] = FALSE; // Extend the users cookies every time they auto-login $config['track_login_attempts'] = FALSE; // Track the number of failed login attempts for each user or ip. $config['track_login_ip_address'] = TRUE; // Track login attempts by IP Address, if FALSE will track based on identity. (Default: TRUE) $config['maximum_login_attempts'] = 3; // The maximum number of failed login attempts. $config['lockout_time'] = 600; // The number of seconds to lockout an account due to exceeded attempts $config['forgot_password_expiration'] = 0; // The number of milliseconds after which a forgot password request will expire. If set to 0, forgot password requests will not expire. /* | ------------------------------------------------------------------------- | Email options. | ------------------------------------------------------------------------- | email_config: | 'file' = Use the default CI config or use from a config file | array = Manually set your email config settings _/ $config['use_ci_email'] = TRUE; // Send Email using the builtin CI email class, if false it will return the code and the identity $config['email_config'] = array( 'protocol'=>'smtp', 'smtp_host'=>'ssl://smtp.googlemail.com', //(SMTP server) 'smtp_port'=>'465', //(SMTP port) 'smtp_timeout'=>'30', 'smtp_user'=>'abc@gmail.com', //(user@gmail.com) 'smtp_pass'=>'_*********', // (gmail password) 'mailtype' => 'html', 'charset' => 'utf-8', 'newline' => "\r\n", ); /* | ------------------------------------------------------------------------- | Email templates. | ------------------------------------------------------------------------- | Folder where email templates are stored. | Default: auth/ */ $config['email_templates'] = 'auth/email/'; /* | ------------------------------------------------------------------------- | Activate Account Email Template | ------------------------------------------------------------------------- | Default: activate.tpl.php */ $config['email_activate'] = 'activate.tpl.php'; /* | ------------------------------------------------------------------------- | Forgot Password Email Template | ------------------------------------------------------------------------- | Default: forgot_password.tpl.php */ $config['email_forgot_password'] = 'forgot_password.tpl.php'; /* | ------------------------------------------------------------------------- | Forgot Password Complete Email Template | ------------------------------------------------------------------------- | Default: new_password.tpl.php */ $config['email_forgot_password_complete'] = 'new_password.tpl.php'; /* | ------------------------------------------------------------------------- | Salt options | ------------------------------------------------------------------------- | salt_length Default: 10 | | store_salt: Should the salt be stored in the database? | This will change your password encryption algorithm, | default password, 'password', changes to | fbaa5e216d163a02ae630ab1a43372635dd374c0 with default salt. */ $config['salt_length'] = 10; $config['store_salt'] = TRUE; /* | ------------------------------------------------------------------------- | Message Delimiters. | ------------------------------------------------------------------------- */ $config['delimiters_source'] = 'config'; // "config" = use the settings defined here, "form_validation" = use the settings defined in CI's form validation library $config['message_start_delimiter'] = '

'; // Message start delimiter $config['message_end_delimiter'] = '

'; // Message end delimiter $config['error_start_delimiter'] = '

'; // Error mesage start delimiter $config['error_end_delimiter'] = '

'; // Error mesage end delimiter /\* End of file ion_auth.php _/ /_ Location: ./application/config/ion_auth.php */

[benedmunds]

It's because your PHP install doesn't support BCrypt. Try updating you PHP version to at least PHP 5.3.7

[LChaiya]

Thank you Mr. Ben,

Could you provide me the way how to update PHP version please?

[benedmunds]

Depends on your server.

Are you running locally? If so what OS?

Did you install PHP yourself or using a tool like WAMP or MAMP?

[LChaiya]

I use Window 7 and Wamp tool.
Thank you
Chaiya

[benedmunds]

It's been years since I've used WAMP but there should be a way to select a PHP version there.

This looks like it would work: http://sourceforge.net/projects/wampserver/files/WampServer%202/WampServer%202.2/wampserver2.2e/wampserver2.2e-php5.3.13-httpd2.2.22-mysql5.5.24-32b.exe/download

[robertlagrant]

Lol Ben you're like the nicest guy in the world!

@LChaiya download the latest WAMP and install it.

[LChaiya]

@ben Thank you for trying to help me.
@robertlagrant you have good idea.

Thank you.

[benedmunds]

Haha thanks @robertlagrant. I try

[LChaiya]

Is there any solution behind install new WAMP?

[benedmunds]

1. Download exe from http://sourceforge.net/projects/wampserver/files/WampServer%202/WampServer%202.2/wampserver2.2e/wampserver2.2e-php5.3.13-httpd2.2.22-mysql5.5.24-32b.exe/download
2. Double click exe
3. Setup

[LChaiya]

OK thank you Ben,

But If I would like to use my old WAMP. What should I do Ben?
Do you have any Ideas?

Once again Thank you!.

[benedmunds]

In config/ion_auth.php set

$config['hash_method']    = 'sha1';

then update the "password" field the "admin" record in your "users" table in your database to

1283592850bc9a3e833d3f93ba181a1a8b3af67a

This query should do it for you

UPDATE users SET password="1283592850bc9a3e833d3f93ba181a1a8b3af67a" WHERE username="administrator";

[LChaiya]

Many thank to Ben,
Let me try on it.

Cheer!

[LChaiya]

Ben ! It work fine :).

I can create new user and password field get right value.

Thank you.

On Thu, Mar 27, 2014 at 8:05 AM, Ben Edmunds notifications@github.comwrote:

In config/ion_auth.php set

$config['hash_method'] = 'sha1';

then update the "password" field the "admin" record in your "users" table
in your database to

12835921283592

This query should do it for you

UPDATE users SET password="1283592850bc9a3e833d3f93ba181a1a8b3af67a" WHERE
username="administrator";

Reply to this email directly or view it on GitHubhttps://github.com//issues/522#issuecomment-38759087
.

[davidstanley01]

If you're still having trouble, the Geek Squad at Best Buy can help. They're good at installing and upgrading software. Pretty knowledgable about softwares too.

[LChaiya]

Hello

But when I Login with new account why the page show like this

"You must be an administrator to view this page."?

Could anyone explain me about this message?

On Thu, Mar 27, 2014 at 9:53 PM, David Stanley notifications@github.comwrote:

If you're still having trouble, the Geek Squad at Best Buy can help.
They're good at installing and upgrading software. Pretty knowledgable
about softwares too.

Reply to this email directly or view it on GitHubhttps://github.com//issues/522#issuecomment-38812852
.

[benedmunds]

Edit the example controller (controllers/auth.php) to fit your needs.