| 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
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.
(06-14-2018, 06:15 PM)skunkbad Wrote: 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. (06-14-2018, 06:15 PM)skunkbad Wrote: 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 (06-14-2018, 06:15 PM)skunkbad Wrote: 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. (06-19-2018, 03:34 AM)kageja Wrote:(06-14-2018, 06:15 PM)skunkbad Wrote: SQLite? Community Auth support is limited to MySQL only. 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? |
| Welcome Guest, Not a member yet? Register Sign In |
