Announcement

Collapse
No announcement yet.

phpMyAdmin - Error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • dirtydex
    started a topic phpMyAdmin - Error

    phpMyAdmin - Error

    I haven't made any changes to InterWorx and have just let the updates auto install. But yesterday when I tried to login to phpMyAdmin (for the first time since July) via NodeWorx and SiteWorx I keep getting the following "phpMyAdmin - Error" "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser."

    • I've tried different browsers - still the same error.
    • The PHP pages that use sessions are working okay.
    • The database used by the PHP pages are still working okay.
    • I've checked the logs and they don't to have anything in them relating to this.


    Details:
    CentOS 7
    interworx-phpmyadmin version 4.0.10.17
    InterWorx CP v5.1.34

    I haven't made any changes so I can only assume it was an update that has caused this to happen. Apologies if this has already been covered off somewhere else but I did try a search but couldn't find any topic with this issue. Any help is appreciated.

  • bestellen
    replied
    The following resolved the issue for me:
    /usr/local/interworx/lib/phpMyAdmin3/sessions

    Leave a comment:


  • d2d4j
    replied
    Hi gewootnit

    Many thanks

    I forwarded this thread to Iw, so it's kept in mind but as I understand it now, this is a hard issue for them to track down, as it is inconsistent and cannot be replicated on every install

    Patience I think is needed and as it is easy to correct, should not present any real issue

    Many thanks

    John

    Leave a comment:


  • gewoonit
    replied
    Hi d2d4j,

    Creating this folder..
    /usr/local/interworx/lib/phpMyAdmin3/sessions
    drwx--x--x 2 iworx-pma iworx-pma 4096 Nov 12 20:58
    ...solved the problem.

    The problem exist still in the installer.

    Gewoon IT - Mart Dirks

    Leave a comment:


  • d2d4j
    replied
    Hi gewoonif

    Many thanks and I've forward the thread to IW

    Just so I'm clear, does the workaround in this post work for you, so your just posting to let know the installer has not been corrrcted

    Many thanks

    John

    Leave a comment:


  • gewoonit
    replied
    This problem still exists! Latest available version (5.1.50-1292), clean install.

    Gewoon IT - Mart Dirks

    Leave a comment:


  • dss
    replied
    After creating sessions folder with the correct permissions everything is working fine! InterWorx DB is also visible.

    Leave a comment:


  • d2d4j
    replied
    Hi dss

    I hope your well

    Please could I ask if the above resolves it for you and if you can see the iworx db shown as well as localhost

    Many thanks

    John

    Leave a comment:


  • dss
    replied
    This problem still exists! Latest available version (5.1.41-1262), clean install.

    Leave a comment:


  • d2d4j
    replied
    Hi keiro
    Glad it resolved for you
    The permissions for session folder I believe should be
    /usr/local/interworx/lib/phpMyAdmin3/sessions
    drwx--x--x 2 iworx-pma iworx-pma 4096 Nov 12 20:58
    chmod 0711 /usr/local/interworx/lib/phpMyAdmin3/sessions
    Many thanks
    John

    Leave a comment:


  • Keiro
    replied
    Originally posted by dirtydex View Post
    You are an absolute star! Thank you for all your help :)

    The following resolved the issue for me:
    /usr/local/interworx/lib/phpMyAdmin3/sessions

    The sessions folder didn't exist. I created a new sessions folder within /usr/local/interworx/lib/phpMyAdmin3/ and used the same permissions as the other folders within /usr/local/interworx/lib/phpMyAdmin3/ e.g. js folder. As soon as I created this and logged out of InterWorx CP and logged back in I was able to access phpMyAdmin.
    I got bit by this error today... the server's on InterWorx-CP v5.1.41, though. Incidentally, what was the chmod permissions you used? I'm for some reason having a major case of the stupids right now.

    Edit: I wanted to note that doing this resolved the issue for me as well.

    Leave a comment:


  • dirtydex
    replied
    You are an absolute star! Thank you for all your help :)

    The following resolved the issue for me:
    /usr/local/interworx/lib/phpMyAdmin3/sessions

    The sessions folder didn't exist. I created a new sessions folder within /usr/local/interworx/lib/phpMyAdmin3/ and used the same permissions as the other folders within /usr/local/interworx/lib/phpMyAdmin3/ e.g. js folder. As soon as I created this and logged out of InterWorx CP and logged back in I was able to access phpMyAdmin.

    Leave a comment:


  • d2d4j
    replied
    Hi Dirtydex
    Many thanks, and sorry, I am about to finish for the night.
    I had a quick look at your PM, and confirm it shows the same on my browser, had to create a test database though, or it would not show anything anyway.
    Please can you check and delete as need - I tried quickly on a test server, and deleting the sessions did not break anything on our test server, but once deleted, you will need to log out of nodeworx, refresh and log back in again. This then creates the session for phpmyadmin, when accessing phpmyadmin.
    I do believe it is connected with a setting, which may have changed, and please remember, IW runs its own PHP/Mysql/services which are seperate to apache, so I am thinking any changes you have made, were to apache php.ini and not IW php.ini.
    The location of myphpadmin maybe different on your centos 7, as I tested tonight using a centos 6 server, but same versions of IW, phpmyadmin etc...
    I hope that helps, and if it still fails, I would open a support ticket with IW, those guys rock, and please can you delete the test account you setup.
    Many thanks
    John
    Sessions to delete
    /usr/local/interworx/lib/phpMyAdmin3/sessions
    /usr/local/interworx/var/session
    PHP to check (/usr/local/interworx/etc/php.ini)
    Handler used to store/retrieve data.
    session.save_handler = files
    session.save_path = /home/interworx/var/session
    session.use_cookies = 1

    session.use_only_cookies = 1
    session.name = PHPSESSID
    session.cookie_path = /
    perms to check
    /usr/local/interworx/var/session
    drwx------. 2 iworx iworx 12288 Nov 12 21:06
    /usr/local/interworx/lib/phpMyAdmin3/sessions
    drwx--x--x 2 iworx-pma iworx-pma 4096 Nov 12 20:58

    Leave a comment:


  • dirtydex
    replied
    Does it do the same if you try private browsing - Yes
    Have you cleared your browser cache and cookies in full - Yes
    Have you cleared you /tmp folder on server - I haven't tried this. What I did instead was change the directory in the php.ini for session.save_path to a new folder named "temp" with 777 and it did the same thing.
    In your php.ini, is you session set to files and not memcache, and you have not set session secure I think it's called - session.save_handler = files
    Is it possible to pm me a login to nodeworx or siteworx account, which is a test site only - Will PM you :)
    What are your permissions on your /tmp and var/tmp and also on ~iworx/tmp
    drwxrwxrwt. = var/tmp
    drwx------ = ~iworx/tmp
    drwxrwxrwt. = /tmp

    Leave a comment:


  • d2d4j
    replied
    Hi dirtydex

    Does it do the same if you try private browsing

    Have you cleared your browser cache and cookies in full

    Have you cleared you /tmp folder on server

    In your php.ini, is you session set to files and not memcache, and you have not set session secure I think it's called

    Is it possible to pm me a login to nodeworx or siteworx account, which is a test site only

    What are your permissions on your /tmp and var/tmp and also on ~iworx/tmp

    Many thanks

    John

    Leave a comment:

Working...
X