Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming DB_Session not working! CI 2.0.2
DB_Session not working! CI 2.0.2
  • El Forum
    Guest
  •  
#1
06-03-2011, 06:41 PM

[eluser]Asiansexynine[/eluser]
DB Session not working for me no any session adding to database table..

file: application/config/database.php
Code:
$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '1111';
$db['default']['database'] = 'main';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

database session table
Code:
CREATE TABLE IF NOT EXISTS  `sessions` (
session_id varchar(40) DEFAULT '0' NOT NULL,
ip_address varchar(16) DEFAULT '0' NOT NULL,
user_agent varchar(50) NOT NULL,
last_activity int(10) unsigned DEFAULT 0 NOT NULL,
user_data text DEFAULT '' NOT NULL,
PRIMARY KEY (session_id)
);

file: application/config/config.php
Code:
$config['sess_cookie_name']        = 'gsession';
$config['sess_expiration']        = 7200;
$config['sess_expire_on_close']    = TRUE;
$config['sess_encrypt_cookie']    = FALSE;
$config['sess_use_database']    = TRUE;
$config['sess_table_name']        = 'sessions';
$config['sess_match_ip']        = FALSE;
$config['sess_match_useragent']    = TRUE;
$config['sess_time_to_update']    = 300;

Not add session to database session table. how to fixed?
  • El Forum
    Guest
  •  
#2
06-05-2011, 03:23 AM

[eluser]toopay[/eluser]
Did the session works without using database?
  • El Forum
    Guest
  •  
#3
06-05-2011, 05:20 AM

[eluser]InsiteFX[/eluser]
For one the session databse table is incorrect there has been a change to it but the documentation has not been updated!
Code:
-- --------------------------------------------------------------

--
-- Table structure for CodeIgniter ci_sessions.
--

DROP TABLE IF EXISTS `ci_sessions`;

CREATE TABLE IF NOT EXISTS  `ci_sessions` (
  `session_id`    varchar(40)           DEFAULT '0' NOT NULL,
  `ip_address`    varchar(16)           DEFAULT '0' NOT NULL,
  `user_agent`    varchar(120)                      NOT NULL,
  `last_activity` int(10)      unsigned DEFAULT 0   NOT NULL,
  `user_data`     text,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- -------------------------------------------------------------
--  `user_data` text,       COMMENT - maximum length of 65535 characters.
--  `user_data` mediumtext, COMMENT - maximum length of 16777215 characters.
--  `user_data` longtext,   COMMENT - maximum length of 4294967295 characters.

InsiteFX
  • El Forum
    Guest
  •  
#4
06-05-2011, 07:48 AM

[eluser]Asiansexynine[/eluser]
[quote author="InsiteFX" date="1307290831"]For one the session databse table is incorrect there has been a change to it but the documentation has not been updated!
Code:
-- --------------------------------------------------------------

--
-- Table structure for CodeIgniter ci_sessions.
--

DROP TABLE IF EXISTS `ci_sessions`;

CREATE TABLE IF NOT EXISTS  `ci_sessions` (
  `session_id`    varchar(40)           DEFAULT '0' NOT NULL,
  `ip_address`    varchar(16)           DEFAULT '0' NOT NULL,
  `user_agent`    varchar(120)                      NOT NULL,
  `last_activity` int(10)      unsigned DEFAULT 0   NOT NULL,
  `user_data`     text,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

-- -------------------------------------------------------------
--  `user_data` text,       COMMENT - maximum length of 65535 characters.
--  `user_data` mediumtext, COMMENT - maximum length of 16777215 characters.
--  `user_data` longtext,   COMMENT - maximum length of 4294967295 characters.

InsiteFX[/quote]


I am change to

file: application/config/database.php
Code:
$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'main';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

database session table
Code:
CREATE TABLE IF NOT EXISTS  `ci_sessions` (
  `session_id`    varchar(40)           DEFAULT '0' NOT NULL,
  `ip_address`    varchar(16)           DEFAULT '0' NOT NULL,
  `user_agent`    varchar(120)                      NOT NULL,
  `last_activity` int(10)      unsigned DEFAULT 0   NOT NULL,
  `user_data`     text,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

file: application/config/config.php
Code:
$config['sess_cookie_name']        = 'gsession';
$config['sess_expiration']        = 7200;
$config['sess_expire_on_close']    = TRUE;
$config['sess_encrypt_cookie']    = FALSE;
$config['sess_use_database']    = TRUE;
$config['sess_table_name']        = 'ci_sessions';
$config['sess_match_ip']        = FALSE;
$config['sess_match_useragent']    = TRUE;
$config['sess_time_to_update']    = 300;

Still not work for me.. Anyone was test DB session and working?
  • El Forum
    Guest
  •  
#5
06-05-2011, 08:56 AM

[eluser]toopay[/eluser]
Did the session works without using database?
  • El Forum
    Guest
  •  
#6
06-05-2011, 09:23 AM

[eluser]Asiansexynine[/eluser]
[quote author="toopay" date="1307303819"]Did the session works without using database?[/quote]

I am checking session.save_path C:\xampp\tmp where session store. and my CI2 not store session in C:\xampp\tmp

what happen with session on CI2 where to save session on CI2? I don't understand

CI session are working on 1.7.2 the version that use before
  • El Forum
    Guest
  •  
#7
06-05-2011, 03:35 PM

[eluser]InsiteFX[/eluser]
Did you load the session library?

InsiteFX
  • El Forum
    Guest
  •  
#8
06-06-2011, 08:39 AM

[eluser]Asiansexynine[/eluser]
[quote author="InsiteFX" date="1307327735"]Did you load the session library?

InsiteFX[/quote]

By CI 1.7 do not load the session library.. but work well.. by setting config file.. with CI2 must load the session library? I don't know that.. how to do? and what's files to adding?
  • El Forum
    Guest
  •  
#9
06-06-2011, 09:17 AM

[eluser]WanWizard[/eluser]
CI doesn't load anything by default. Either add it to the config/autoload list, or load it manually in your controller.
  • El Forum
    Guest
  •  
#10
06-06-2011, 10:49 AM

[eluser]Asiansexynine[/eluser]
I am try to set $autoload['libraries'] = array('session'); in application/config/autoload.php

set config
Code:
$config['sess_cookie_name']        = 'ci_session';
$config['sess_expiration']        = 7200;
$config['sess_expire_on_close']    = TRUE;
$config['sess_encrypt_cookie']    = FALSE;
$config['sess_use_database']    = FALSE;
$config['sess_table_name']        = 'ci_sessions';
$config['sess_match_ip']        = FALSE;
$config['sess_match_useragent']    = TRUE;
$config['sess_time_to_update']    = 300;

add code to view.. to check if session work.
Code:
<?php
$session_id = $this->session->userdata('session_id');

echo 'Session ID = ' . $session_id;
?>

Now session_id were generate for my website.. but where session files store?
in phpinfo() show me that session.save_path = C:\xampp\tmp

OK.. take a look at C:\xampp\tmp but no session files generate there..
where is my session files? how to set session.save_path on CI2?




Theme © iAndrew 2016 - Forum software by © MyBB