Zikula: A Flexible Open Source Content Management System
home | forum | contact us

Dizkus

Goto page: 1 - 2 [+1]

Bottom
Help! Session Initialization Failed!
  • Posted: 24.08.2003, 05:45
     
    quiklilo71
    rank:
    Freshman Freshman
    registered:
     November 2002
    Status:
    offline
    last visit:
    03.01.04
    Posts:
    40
    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!
  • Posted: 24.08.2003, 07:36
     
    Infopro
    rank:
    Professional Professional
    registered:
     December 1969
    Status:
    offline
    last visit:
    17.06.04
    Posts:
    2122
    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
  • Posted: 24.08.2003, 07:46
     
    quiklilo71
    rank:
    Freshman Freshman
    registered:
     November 2002
    Status:
    offline
    last visit:
    03.01.04
    Posts:
    40
    How do you run repair from phpMyAdmin? Upgrading PN... what's involved? Thanks for your support Infopro, good hearing from you again.
  • Posted: 24.08.2003, 08:32
     
    Infopro
    rank:
    Professional Professional
    registered:
     December 1969
    Status:
    offline
    last visit:
    17.06.04
    Posts:
    2122
    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
  • Posted: 24.08.2003, 18:00
     
    quiklilo71
    rank:
    Freshman Freshman
    registered:
     November 2002
    Status:
    offline
    last visit:
    03.01.04
    Posts:
    40
    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!
  • Posted: 24.08.2003, 19:02
     
    quiklilo71
    rank:
    Freshman Freshman
    registered:
     November 2002
    Status:
    offline
    last visit:
    03.01.04
    Posts:
    40
    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?
  • Posted: 24.08.2003, 20:26
     
    Infopro
    rank:
    Professional Professional
    registered:
     December 1969
    Status:
    offline
    last visit:
    17.06.04
    Posts:
    2122
    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
  • Posted: 25.08.2003, 01:33
     
    quiklilo71
    rank:
    Freshman Freshman
    registered:
     November 2002
    Status:
    offline
    last visit:
    03.01.04
    Posts:
    40
    I'm not sure if the first posting was viewable....IT WORKED!!!!

    Thanks a million infopro, you rock!
  • Posted: 25.08.2003, 02:00
     
    Infopro
    rank:
    Professional Professional
    registered:
     December 1969
    Status:
    offline
    last visit:
    17.06.04
    Posts:
    2122
    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
  • Posted: 30.08.2003, 21:16
     
    soma1992
    rank:
    Registered User Registered User
    registered:
     August 2003
    Status:
    offline
    last visit:
    30.08.03
    Posts:
    1
    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)
  • Posted: 02.09.2003, 21:14
     
    siridhar
    rank:
    Freshman Freshman
    registered:
     April 2003
    Status:
    offline
    last visit:
    29.01.04
    Posts:
    23
    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!
  • Posted: 03.09.2003, 17:52
     
    missflowerpod
    rank:
    Freshman Freshman
    registered:
     March 2003
    Status:
    offline
    last visit:
    08.10.03
    Posts:
    4
    I change the table structure to myISAM to ISAM and it works alright.
  • Posted: 03.09.2003, 18:43
     
    rank:
    Moderator Moderator
    registered:
     March 2002
    Status:
    offline
    last visit:
    26.08.08
    Posts:
    7720

    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
  • Posted: 17.12.2003, 06:11
     
    jsandfort
    rank:
    Freshman Freshman
    registered:
     April 2003
    Status:
    offline
    last visit:
    16.10.05
    Posts:
    11
    If you have shell access you can repair the database. This is what I use:

    mysqlanalyze -p -r database_name
  • Posted: 26.12.2003, 06:56
     
    TheWatcher
    rank:
    Freshman Freshman
    registered:
     March 2002
    Status:
    offline
    last visit:
    20.09.05
    Posts:
    25
    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.
    -----------------------------------------------------------

Goto page: 1 - 2 [+1]

Extensions Moderation

Main Menu

Extensions Database

Documentation

Development

Login

Donate to Zikula