thank you for all of you're recommendations and directions
On Tue, Apr 29, 2014 at 11:41 PM, Yehuda Katz <yeh...@ymkatz.net> wrote: > If you are already using PHP sessions, then there is no need for > mod_session. > PHP supports changing the session store: > session_set_save_handler<http://www.php.net/session_set_save_handler> > For an example solution, see http://phpsecurity.org/code/ch08-2 > > - Y > > > On Tue, Apr 29, 2014 at 1:05 AM, Билгүүн Ө <bilguu...@statebank.mn> wrote: > >> First, thank you for response. >> >> I’m apologize for about the asking question on comment section. >> >> And I try to store php session in MySQL then configure Load Balancing. If >> I can’t store session in DB, I think our server will get single point of >> failure. We have a many php websites and these all using php session. >> >> Is there any module that possible to sync php sessions. >> >> >> >> *From:* Yehuda Katz [mailto:yeh...@ymkatz.net] >> *Sent:* Tuesday, April 29, 2014 12:27 PM >> *To:* users@httpd.apache.org >> *Subject:* Re: [users@httpd] Question >> >> >> >> mod_session_dbd and php $_SESSION have nothing to do with each other and >> php has its own session management system. >> >> >> >> If you can better explain what you are trying to do, someone might be >> able to give you a recommendation for whether to use mod_session or php >> session. >> >> >> >> Also, the Comments section on the Apache manual >> pages<http://httpd.apache.org/docs/trunk/mod/mod_session_dbd.html#comments_section>is >> NOT for asking questions like this. Please don't do it again. >> >> >> >> - Y >> >> >> >> On Tue, Apr 29, 2014 at 12:14 AM, Билгүүн Ө <bilguu...@statebank.mn> >> wrote: >> >> *From:* Билгүүн Ө [mailto:bilguu...@statebank.mn] >> *Sent:* Tuesday, April 29, 2014 12:03 PM >> *To:* 'users-...@httpd.apache.org' >> *Subject:* Question >> >> >> >> Dear everyone >> >> I'm trying to use mo_session_db, but i cant. I'm using mysql-14.14, >> apache-2.4.9 and php-5.5.11. >> >> I create database named session_db, and table named SESSION which created >> by query CREATE TABLE SESSION ( id VARCHAR(32) NOT NULL COMMENT 'Stores the >> Session ID', access INT(10) UNSIGNED NOT NULL, data TEXT, PRIMARY KEY >> (`id`) ) ENGINE=INNODB ROW_FORMAT=DEFAULT; >> >> My mod_session_dbd.conf is: >> >> Session On >> >> SessionDBDCookieName session path=/ >> >> SessionDBDCookieRemove Off >> >> SessionDBDPerUser On >> >> SessionDBDDeleteLabel deletesession >> >> SessionDBDInsertLabel insertsession >> >> SessionDBDSelectLabel selectsession >> >> SessionDBDUpdateLabel updatesession >> >> DBDriver mysql >> >> DBDParams "host=<ip address x.x.x.x/localhost>, port=3306, user=root, >> password=<password>, dbname=session_db" >> >> DBDExptime 300 >> >> DBDPrepareSQL "delete from SESSION where id = %s" deletesession >> >> DBDPrepareSQL "update SESSION set data = %s, access = %lld, id = %s where >> id = %s" updatesession >> >> DBDPrepareSQL "insert into SESSION (id, access, data) values (%s, %lld, >> %s)" insertsession >> >> DBDPrepareSQL "select data from SESSION where id = %s and (access = 0 or >> access > %lld)" selectsession >> >> DBDPrepareSQL "delete from SESSION where access != 0 and access < %lld" >> cleansession >> >> >> >> I tested by store the session but it could not store in sql. My test >> pages are: >> >> >> >> #index.html >> >> <form action="session.php" method="get"> >> >> Value:<input type="text" name="view"/> >> >> <input type="submit" value="Submit"/> >> >> </form> >> >> >> >> #session.php >> >> session_start(); >> >> if(isset($_GET['view'])) >> >> { $_SESSION['view'] = $_GET['view']; >> >> echo "Saved in SESSION<br/>"; >> >> echo "<a href=link.php>Link</a><br/>"; >> >> echo "<a href=index.html>Back</a>"; >> >> } >> >> else >> >> { echo "Could not save in SESSION<br/>"; >> >> echo "<a href=index.html>Back</a>"; >> >> } >> >> #link.php >> >> session_start(); >> >> if(isset($_SESSION['view'])) >> >> { echo"Session: ". $_SESSION['view']."<br/>"; >> >> echo "<a href=clear.php>Clear cookie</a><br/>"; >> >> } >> >> else >> >> { echo "There is no cookie<br/>"; } >> >> >> >> #clear.php >> >> session_start(); >> >> if(isset($_SESSION['view'])) >> >> { unset($_SESSION['view']); >> >> echo "cookie cleared<br/><br/>"; >> >> } >> >> else{ echo "there has not been saved cookie<br/>"; } >> >> >> >> Is there any problem in my config or testing pages. Sorry for my bad >> english >> >> >> >> [image: line] >> >> Хүндэтгэсэн >> >> Ө.Билгүүн >> >> Системийн администратор >> >> МТ Системийн хэлтэс >> >> >> >> Мэйл хаяг | bilguu...@sbank.mn; bilguu...@statebank.mn >> >> Вэб хуудас | www.statebank.mn >> >> >> >> [image: state-logo] >> >> *Танд санхүүгийн үйлчилгээг эрсдэлгүй хүргэнэ.* >> >> >> >> >> > >
