Help! Session Initialization Failed!

Topic:	Help! Session Initialization Failed!
quiklilo71 Freshman Posts: 40 Posted: 24.Aug 2003 - 05:45	First off, I know this is a fairly common problem judging by the amount of forum coverage, I've searched and have a mozilla browser filled with tabs on possible solutions: http://forums.postnu…itialisation+failed http://forums.postnu…itialisation+failed http://forums.postnu…itialisation+failed http://forums.postnu…itialisation+failed The solutions I've found have not worked so far.... To list a few... I am running PHP 4.3.1, MySQL 3.23.54, phpMyAdmin 2.4.0 and PN 7.2.3 on a clarkconnect (Redhat Linux 7.1) box ... I realize PN is now at 7.2.6 but don't know if upgrading correct my problem, I'm getting an error when I attemp to change the nuke_session_info table type from MYISAM to ISAM ... Raliegh has helped me out of many a nightmare... please help again! Inforpro, you helped me at the beginning to, almost a year ago... come on folks!
Infopro Professional Posts: 2122 Posted: 24.Aug 2003 - 07:36	Well we're here to help. I am of course going to suggest you upgrade as the version you are using is less secure. I have had this error myself 4 times now since I put up my very first PostNuke site long ago. Those times I did have it happen, I ran repair from phpMyAdmin and it fixed it every time. I also run optimize all tables weekly. -- Friends rock, bullshit walks
quiklilo71 Freshman Posts: 40 Posted: 24.Aug 2003 - 07:46	How do you run repair from phpMyAdmin? Upgrading PN... what's involved? Thanks for your support Infopro, good hearing from you again.
Infopro Professional Posts: 2122 Posted: 24.Aug 2003 - 08:32	Good to see you too. :) Not all of these options will be on your version of phpMyAdmin I don't think, you might want to upgrade that as well. http://mswebdesign.com/fun/repairtables.gif Click select all, then pick it from that drop down list. There are a few tuts in the tutorials and solutions forum here that help to explain upgrading. Here is one of those threads by a guy I know.. ;) http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&t=5080 Good luck. :wink: -- Friends rock, bullshit walks
quiklilo71 Freshman Posts: 40 Posted: 24.Aug 2003 - 18:00	Thanks infopro, I'm going to download and install the latest phpMyAdmin, repair the DB tables, then go for the latest nuke. The newest phpMyAdmin should make my site viewable again right? Thanks!
quiklilo71 Freshman Posts: 40 Posted: 24.Aug 2003 - 19:02	I have the latest phpMyAdmin running (2.5.3rc2) and ran repair but I still have issues with test.nuke_session_info .... It appears my nuke_session_info.MYD is corrupt. Can I get a replacement?
Infopro Professional Posts: 2122 Posted: 24.Aug 2003 - 20:26	You "could" try this. It's ripped straight from the default Phoenix-0.7.2.6.sql file. (no guarantees though, so backup this first) Code # Table structure for table `nuke_session_info` # # Creation: Jun 15, 2003 at 09:41 # Last update: Jun 15, 2003 at 09:42 # CREATE TABLE `nuke_session_info` ( `pn_sessid` varchar(32) NOT null default '', `pn_ipaddr` varchar(20) NOT null default '', `pn_firstused` int(11) NOT null default '0', `pn_lastused` int(11) NOT null default '0', `pn_uid` int(11) NOT null default '0', `pn_vars` blob, PRIMARY key (`pn_sessid`) ) TYPE=MyISAM; # # Dumping data for table `nuke_session_info` # INSERT INTO `nuke_session_info` VALUES ('8b4b52597d41a32e89783e5103c95a9f', '80.145.92.84', 1055706107, 1055706136, 2, 0x504e535672616e647c693a313237393333323539313b504e53566c616e677c733a333a22656e67223b504e53567569647c693a323b); Go back to phpMyAdmin and click your DB (on left) Look on right for SQL and click. that should open a query window. Paste this in. It should dump the old and load a fresh new one. again, this is just to see if this will fix you, no guarantees. -- Friends rock, bullshit walks
quiklilo71 Freshman Posts: 40 Posted: 25.Aug 2003 - 01:33	I'm not sure if the first posting was viewable....IT WORKED!!!! Thanks a million infopro, you rock!
Infopro Professional Posts: 2122 Posted: 25.Aug 2003 - 02:00	kewl. :) Like I said, the pnCorps are here to help where we can. Glad it worked for you. Good luck with your site. ;) -- Friends rock, bullshit walks
soma1992 Registered User Posts: 1 Posted: 30.Aug 2003 - 21:16	I'm having the same problem as this guy, ("Session initialisation failed" on every page) and I tried what has been suggested before but I can not get it to work. Here's my info: PHP Version 4.3.0 System Linux junker.org 2.4.20 #2 Mon Dec 30 02:04:21 EST 2002 i686 Configure Command './configure' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-wddx' '--enable-discard-path' '--with-mysql' '--with-pgsql' '--with-zlib' '--enable-dbase' '--with-gd' PostNuke Version 0.726 Phoenix I was able to view the index page once, right after I installed, after that, nothing worked. Any ideas? (BTW, I don't have access to the php.ini file)
siridhar Freshman Posts: 23 Posted: 2.Sep 2003 - 21:14	The solution you suggested worked. I found "session initialization failed" on my PostNuke portal, rushed to the forums, did a search for it, found this thread, logged in my phpMyAdmin, dropped that nuke_session_info table and recreated by running the code as a query and its fixed. I am hoping the problem will not repeat. Does any one know if the code infopro posted is a temporary fix or a permanent solution? Keep up the good work, PostNuke team and volunteers!
missflowerpod Freshman Posts: 4 Posted: 3.Sep 2003 - 17:52	I change the table structure to myISAM to ISAM and it works alright.
markwest Moderator Posts: 7720 Posted: 3.Sep 2003 - 18:43	missflowerpod I change the table structure to myISAM to ISAM and it works alright. INNODB definately helps here not sure about ISAM rather than myISAM. -Mark
jsandfort Freshman Posts: 11 Posted: 17.Dec 2003 - 06:11	If you have shell access you can repair the database. This is what I use: mysqlanalyze -p -r database_name
TheWatcher Freshman Posts: 25 Posted: 26.Dec 2003 - 06:56	Another approach to resolve this issue. - Goto your myphpadmin web console. - In your website SQL table, select "nuke_session_info" then "repair table". This will do the trick correcting your session. Best regards, TW -- ----------------------------------------------------------- Hardworking.com - small business and home business owners. -----------------------------------------------------------
giampymc Registered User Posts: 1 Posted: 24.Mar 2004 - 15:49	I have re-create table session_info.... , but when i try to refresh (on my browser) my site, the "session initialization failed " appear. Why???? I have an intranet and I have to try check/uncheck "Intranet mode" on installing PostNuke but not work Please help me! Bye

Topic:

Help! Session Initialization Failed!

quiklilo71

Freshman

Posts: 40

Posted:
24.Aug 2003 - 05:45

First off, I know this is a fairly common problem judging by the amount of forum coverage, I've searched and have a mozilla browser filled with tabs on possible solutions:
http://forums.postnu…itialisation+failed
http://forums.postnu…itialisation+failed
http://forums.postnu…itialisation+failed
http://forums.postnu…itialisation+failed

The solutions I've found have not worked so far....
To list a few... I am running PHP 4.3.1, MySQL 3.23.54, phpMyAdmin 2.4.0 and PN 7.2.3 on a clarkconnect (Redhat Linux 7.1) box ... I realize PN is now at 7.2.6 but don't know if upgrading correct my problem, I'm getting an error when I attemp to change the nuke_session_info table type from MYISAM to ISAM ...

Raliegh has helped me out of many a nightmare... please help again! Inforpro, you helped me at the beginning to, almost a year ago... come on folks!

Infopro

Professional

Posts: 2122

Posted:
24.Aug 2003 - 07:36

Well we're here to help. I am of course going to suggest you upgrade as the version you are using is less secure. I have had this error myself 4 times now since I put up my very first PostNuke site long ago. Those times I did have it happen, I ran repair from phpMyAdmin and it fixed it every time. I also run optimize all tables weekly.

--
Friends rock, bullshit walks

quiklilo71

Freshman

Posts: 40

Posted:
24.Aug 2003 - 07:46

How do you run repair from phpMyAdmin? Upgrading PN... what's involved? Thanks for your support Infopro, good hearing from you again.

Infopro

Professional

Posts: 2122

Posted:
24.Aug 2003 - 08:32

Good to see you too. :)

Not all of these options will be on your version of phpMyAdmin I don't think, you might want to upgrade that as well.
http://mswebdesign.com/fun/repairtables.gif
Click select all, then pick it from that drop down list.

There are a few tuts in the tutorials and solutions forum here that help to explain upgrading. Here is one of those threads by a guy I know.. ;)
http://forums.postnuke.com/index.php?name=PNphpBB2&file=viewtopic&t=5080

Good luck. :wink:

--
Friends rock, bullshit walks

quiklilo71

Freshman

Posts: 40

Posted:
24.Aug 2003 - 18:00

Thanks infopro, I'm going to download and install the latest phpMyAdmin, repair the DB tables, then go for the latest nuke.
The newest phpMyAdmin should make my site viewable again right?
Thanks!

quiklilo71

Freshman

Posts: 40

Posted:
24.Aug 2003 - 19:02

I have the latest phpMyAdmin running (2.5.3rc2) and ran repair but I still have issues with test.nuke_session_info .... It appears my nuke_session_info.MYD is corrupt. Can I get a replacement?

Infopro

Professional

Posts: 2122

Posted:
24.Aug 2003 - 20:26

You "could" try this. It's ripped straight from the default Phoenix-0.7.2.6.sql file.
(no guarantees though, so backup this first)

Code

# Table structure for table `nuke_session_info`
#
# Creation: Jun 15, 2003 at 09:41 
# Last update: Jun 15, 2003 at 09:42 
#

CREATE TABLE `nuke_session_info` (
  `pn_sessid` varchar(32) NOT null default '',
  `pn_ipaddr` varchar(20) NOT null default '',
  `pn_firstused` int(11) NOT null default '0',
  `pn_lastused` int(11) NOT null default '0',
  `pn_uid` int(11) NOT null default '0',
  `pn_vars` blob,
  PRIMARY key  (`pn_sessid`)
) TYPE=MyISAM;

#
# Dumping data for table `nuke_session_info`
#

INSERT INTO `nuke_session_info` VALUES ('8b4b52597d41a32e89783e5103c95a9f', '80.145.92.84', 1055706107, 1055706136, 2, 0x504e535672616e647c693a313237393333323539313b504e53566c616e677c733a333a22656e67223b504e53567569647c693a323b);

Go back to phpMyAdmin and click your DB (on left) Look on right for SQL and click. that should open a query window. Paste this in.
It should dump the old and load a fresh new one.
**again, this is just to see if this will fix you, no guarantees.**

--
Friends rock, bullshit walks

quiklilo71

Freshman

Posts: 40

Posted:
25.Aug 2003 - 01:33

I'm not sure if the first posting was viewable....IT WORKED!!!!

Thanks a million infopro, you rock!

Infopro

Professional

Posts: 2122

Posted:
25.Aug 2003 - 02:00

kewl. :)

Like I said, the pnCorps are here to help where we can. Glad it worked for you. Good luck with your site. ;)

--
Friends rock, bullshit walks

soma1992
avatar

Registered User

Posts: 1

Posted:
30.Aug 2003 - 21:16

I'm having the same problem as this guy, ("Session initialisation failed" on every page) and I tried what has been suggested before but I can not get it to work.

Here's my info:

PHP Version 4.3.0

System Linux junker.org 2.4.20 #2 Mon Dec 30 02:04:21 EST 2002 i686

Configure Command './configure' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-wddx' '--enable-discard-path' '--with-mysql' '--with-pgsql' '--with-zlib' '--enable-dbase' '--with-gd'

PostNuke Version 0.726 Phoenix

I was able to view the index page once, right after I installed, after that, nothing worked.

Any ideas? (BTW, I don't have access to the php.ini file)

siridhar
avatar

Freshman

Posts: 23

Posted:
2.Sep 2003 - 21:14

The solution you suggested worked.

I found "session initialization failed" on my PostNuke portal, rushed to the forums, did a search for it, found this thread, logged in my phpMyAdmin, dropped that nuke_session_info table and recreated by running the code as a query and its fixed.

I am hoping the problem will not repeat. Does any one know if the code infopro posted is a temporary fix or a permanent solution?

Keep up the good work, PostNuke team and volunteers!

missflowerpod
avatar

Freshman

Posts: 4

Posted:
3.Sep 2003 - 17:52

I change the table structure to myISAM to ISAM and it works alright.

markwest

Moderator

Posts: 7720

Posted:
3.Sep 2003 - 18:43

missflowerpod

I change the table structure to myISAM to ISAM and it works alright.

INNODB definately helps here not sure about ISAM rather than myISAM.

-Mark

jsandfort
avatar

Freshman

Posts: 11

Posted:
17.Dec 2003 - 06:11

If you have shell access you can repair the database. This is what I use:

mysqlanalyze -p -r database_name

TheWatcher
avatar

Freshman

Posts: 25

Posted:
26.Dec 2003 - 06:56

Another approach to resolve this issue.

- Goto your myphpadmin web console.
- In your website SQL table, select "nuke_session_info" then "repair table".

This will do the trick correcting your session.

Best regards,
TW

--
-----------------------------------------------------------
Hardworking.com - small business and home business owners.
-----------------------------------------------------------

giampymc
avatar

Registered User

Posts: 1

Posted:
24.Mar 2004 - 15:49

I have re-create table session_info.... , but when i try to refresh (on my browser) my site, the "session initialization failed " appear.
Why????
I have an intranet and I have to try check/uncheck "Intranet mode" on installing PostNuke but not work
Please help me!
Bye