Community Auth Database Problem

Hello everyone,

at since, i try to install community_auth into the codeigniter fw.

i follow instruction and i setup the database and create it.

But I take an error like this:
Wher is the mistake  ?

My Best Regards,

Error:

---

A PHP Error was encountered
Severity: Warning
Message: date(): Invalid date.timezone value 'UTC', we selected the timezone 'UTC' for now.
Filename: models/Auth_model.php
Line Number: 225
Backtrace:
File: /www/application/third_party/community_auth/models/Auth_model.php
Line: 225
Function: date
File: /www/application/third_party/community_auth/libraries/Authentication.php
Line: 413
Function: clear_expired_holds
File: /www/application/third_party/community_auth/core/Auth_Controller.php
Line: 489
Function: current_hold_status
File: /www/application/controllers/Examples.php
Line: 297
Function: setup_login_form
File: /www/index.php
Line: 292
Function: require_once

Fatal error: date(): Timezone database is corrupt - this should *never* happen! in /www/application/third_party/community_auth/models/Auth_model.php on line 225
A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /www/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 564
Backtrace:
A PHP Error was encountered
Severity: Error
Message: date(): Timezone database is corrupt - this should *never* happen!
Filename: models/Auth_model.php
Line Number: 225
Backtrace:

---

You need to configure PHP with a timezone. This is not really a Community Auth issue. Similar issue: https://github.com/yiisoft/yii/issues/542

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3

Hello Skubkbad,

Many thx for your replying,
I sloved this problem,

But another problem find me !

i create a database sqlite,
the codeigniter succesfully connected the db,
The db has include username or necceseaty table and filed,
but I can not connect correctly,

Many times it said
Login Error #1/5: Invalid Username, Email Address, or Password.

Username, email address and password are all case sensitive.

---------------------------------------------------------------------
The debug out:

DEBUG - 2000-01-01 17:01:38 --> UTF-8 Support Disabled
DEBUG - 2000-01-01 17:01:38 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2000-01-01 17:01:38 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:01:38 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:01:38 --> Session class already loaded. Second attempt ignored.
DEBUG - 2000-01-01 17:01:38 --> Encryption: Auto-configured driver 'mcrypt'.
DEBUG - 2000-01-01 17:01:38 -->
string = onur.gursoy
password = 1234
form_token = 67701c2a
token_jar = ["67701c2a"]
DEBUG - 2000-01-01 17:01:38 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:01:38 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:01:38 --> Compatibility (mbstring): iconv_strlen() is not available, falling b.
DEBUG - 2000-01-01 17:01:38 -->
LOGIN ATTEMPT DID NOT PASS FORM VALIDATION
DEBUG - 2000-01-01 17:01:38 --> Total execution time: 0.3016

DEBUG - 2000-01-01 17:06:33 --> UTF-8 Support Disabled
DEBUG - 2000-01-01 17:06:33 --> Global POST, GET and COOKIE data sanitized
DEBUG - 2000-01-01 17:06:33 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:06:33 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:06:33 --> Session class already loaded. Second attempt ignored.
DEBUG - 2000-01-01 17:06:33 --> Encryption: Auto-configured driver 'mcrypt'.
DEBUG - 2000-01-01 17:06:33 -->
string = skunkbot
password = $2y$10$a6639f1e4a44dce876837u9ziBnVJqwQZ10Sq8vCFc9qKwxKzuNGK
form_token = 755a5106
token_jar = ["755a5106"]
DEBUG - 2000-01-01 17:06:33 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:06:33 --> Config file loaded: /www/application/third_party/community_auth/confp
DEBUG - 2000-01-01 17:06:33 --> Compatibility (mbstring): iconv_strlen() is not available, falling b.
DEBUG - 2000-01-01 17:06:34 -->
user is banned = no
password in database = $2y$10$a6639f1e4a44dce876837u9ziBnVJqwQZ10Sq8vCFc9qKwxKzuNGK
supplied password match =
required level or role = 1
auth level in database = 1
auth level equivalant role = customer
DEBUG - 2000-01-01 17:06:34 --> Total execution time: 1.1015
---------------------------------------------------------------------

SQLite? Community Auth support is limited to MySQL only.

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3

SQLite? Community Auth support is limited to MySQL only.

But something is ok ? Community auth connected the DB very well , getting the token uname role level and DB password, it seems couldn't match between input pass and DB pass

Anyway , now u Said only MySQL DB supported by community auth.
Ok I will install MySQL server , after that it's work ?

There is one something?
I want to access another page only login. I'm not login , I want to can't zee another page ? But I see.

Thanks,
My Best Regards.

SQLite? Community Auth support is limited to MySQL only.

Meanwhile, I notice something,
The debug out says me :
supplied password match = 

I think , tho could be 1.
Why ?

Another something:
Compatibility (mbstring): iconv_strlen() is not available, falling b.
This is an error ?

Thanks,
My best regards 

SQLite? Community Auth support is limited to MySQL only.

Hello skunkbad,

I notice one thing at login()->_user_confirmed->check_passwd func. in  application/third_party/community_auth/libraries/Authentication.php

it said if php version is 5.5 use password_verify
otherwise use crypt

but i have php5.4, and i changed it check password method.
I used password_verify and ther is no problem.

Now i use community_auth library bvery well with sqlite db and php5.4

My Best Regards.
Onur.

SQLite? Community Auth support is limited to MySQL only.

Hello skunkbad,

I notice one thing at login()->_user_confirmed->check_passwd func. in  application/third_party/community_auth/libraries/Authentication.php

it said if php version is 5.5 use password_verify
otherwise use crypt

but i have php5.4, and i changed it check password method.
I used password_verify and ther is no problem.

Now i use community_auth library bvery well with sqlite db and php5.4

My Best Regards.
Onur.

Thanks for the note. Soon there will no longer be support for older 5.x versions of PHP, so this won't  be an issue anymore.

May I ask why you use the old 5.4?

Also, it would be a good thing to share how you set up Community Auth to use sqlite. Maybe a blog post or video?

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3