This Help forum is for issues relates to the latest release (1.0). For issues related to beta or svn version please use their own Help forum.
When requesting help please provide as much information as possible. Explain what version of webtrees, PHP and MYSQL you are using. If possible provide a URL to your site so we can see the problem first-hand.
Tip: Think about putting these details in your signature, so it appears in the footer of ALL your messages
  • Page:
  • 1

TOPIC:

Cannot Log In 10 years 2 months ago #1

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
I have a small home server running Debian, PHP 5.3.2, MySQL 5.1.49 running behind a Cherokee web server. I have an operational PGV 4.2.3 configuration running well. This environment has been running fine for around a year now. However various sites have convinced me to shift to webtrees and so I would give it a try.

The setup wizard runs and the database is set up. I get to the Log In screen. Any attempt to do anything from this screen returns me to the log in screen. I can attempt to log in using the username password combination but am returned to the log in screen.

On checking the database tables I see the user set up on the wt_user table and the wt_log table shows the log in attempt as successful. However the gedcom_id in the table shows NULL and there is no entry in the user_gedcom_setting. Clearly there is no GEDCOM set up and I cannot get into the administration screens to set it up. Surely the initial doesn't need a GEDCOM to get operational? The installation topic suggests "So, after installation, you will be directed to the GEDCOM (family tree) administration page, where you will need to select one of the following options." but that is not the case for me.

What have I done wrong and where should I go from here?

Please Log in or Create an account to join the conversation.

Re: Cannot Log In 10 years 2 months ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
Most genealogy pages won't work until you have created/loaded your first GEDCOM file.

So, until this is done, most pages will redirect to the "manage gedcoms pages".

1) What happens if you try to visit the page editgedcoms.php directly? (Type this into the URL in your web browser).

2) Did you run the PGV->webtrees wizard? If so, you'll need to log in with an administrator username/password from your PGV system.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Re: Cannot Log In 10 years 2 months ago #3

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
Thanks for the speedy reply.

1) It kicks me back to the Log In screen

2) As I understand it the PGV to webtrees wizard isn't available until after successful log in

As further information I also maintain another small server, which I use for some development; same environment but behind an Apache web server. I installed webtrees on this environment and it started as expected. Configured properly then allowed log in to the GEDCOM administration screen. I guess this tells me the issue is with the Cherokee web server so I'll have a look at that configuration. Why webtrees it would be much different to PGV is beyond me at the moment.

Please Log in or Create an account to join the conversation.

Re: Cannot Log In 10 years 2 months ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
<< It kicks me back to the Log In screen>>

This may be a dumb question, but does it say "incorrect password" ?

There are two reasons for being sent back to the login screen.

1) you are not logged in (!)
2) you are logged in, but as a regular user, not an administrator.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Re: Cannot Log In 10 years 2 months ago #5

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
Thanks

No it's not dumb. I have tried it with incorrect user and it gives me the incorrect password screen addition. The attempt is logged in the log table so all appears as it should be.

When I try with correct username/password combo it logs the access correctly in the log table but does not move me to the application screens. It returns me to the login screen again. Bizarre.

When I press the button for either new user of new password it serves up the initial log in screen. For example at the moment it I http://webserver/webtrees I now get this screen:
http://webserver/webtrees/login.php?url=editgedcoms.php showing the Log In screen. If I log in, the log in is recorded correctly in the correct database table as successful but the same screen is returned:
http://webserver/webtrees/login.php?url=editgedcoms.php
and I am back at the start.

I am suspecting that it has something to do with the web server not parsing the page correctly and processing the php accurately but I'll need more time to look.

Please Log in or Create an account to join the conversation.

Re: Cannot Log In 10 years 2 months ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
Your desciption sounds like the account does not have administrator rights. This would be the "canadmin" entry in the wt_user_setting table. It should be 1.

Have you tried deleting all the tables, deleting the file /data/config.ini.php and running the setup again?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Re: Cannot Log In 10 years 2 months ago #7

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
Yes

The setting in the user_setting table for canadmin is 1.

I have reinstalled a couple of times but will try again tomorrow. Thanks for help so far. Interestingly I have noticed that the data schema for my two installations (one a debian/cherokee combo the other XP/Apache) are different slightly. I'll reinstall both environments tomorrow to see whether it was a set up issue or whether the app changes the schema during runtime.

Please Log in or Create an account to join the conversation.

Re: Cannot Log In; Cherokee Server 10 years 2 months ago #8

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
Ok I have re-installed on both servers.

On PC/Apache the install sets up 32 tables in the MySQL database and the User Table has the correct user. The User Settings table has 7 rows. When install complete the app moves into log in then through to uploading the GEDCOM - no problems. At this point the MySQL database now has 34 tables and the User Setting table now has a row added for each user called "sessiontime"

On Debian/Cherokee the install continues correctly and the app sets up 32 tables in the database, the User table has the correct user with admin setting on and there are 7 rows in the user setting table. The app moves to Log In and stalls. Checking the database the database shows log in occured however the user setting table still only has 7 rows with no sessiontime. The app does not move through to GEDCOM upload.

Checking the error log for the server there is this:
[26/02/2011 17:32:29.438] (error) handler_fcgi.c:118 - PHP Fatal error: Class 'WT_DB' not found in /var/www/webtrees/includes/session.php(285) : runtime-created function on line 0

This seems to suggest the sessiontime is not being set and there is an issue with the session.php. I'll need to check this later but would appreciate any guidance. PS trying to fool it by inserting sessiontime with a value into the user setting table doesn't work.

Please Log in or Create an account to join the conversation.

Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

Re: Cannot Log In; Cherokee Server 10 years 2 months ago #9

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
There are known issues with PHP/APC (a PHP cache/accelerator)

In the WIKI, there is an FAQ entry for "After installation, the login page gives an error that it cannot find wt_db".

Try following the instructions there to disable (part of) APC.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Re: Cannot Log In; Cherokee Server 10 years 2 months ago #10

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
Ok. Had a look and tried the solutions mentioned in the FAQ. Cherokee doesn't use a .htaccess file but has another mechanism to set up virtual servers and trying to create exception for Db access in the virtual server hasn't yet worked for me. Have also tried to mod the php.ini file as suggested in the FAQ regarding setting filters in the APC but no effect either.

I'll need to do a bit more research as I am now in the out of my depth area and I'll come back to the issue in a while. don't sweat it.

Thanks for the help

Please Log in or Create an account to join the conversation.

Re: Cannot Log In; Cherokee Server 10 years 2 months ago #11

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 14515
<<Have also tried to mod the php.ini file as suggested in the FAQ regarding setting filters in the APC but no effect either.>>

1) On most systems, you must restart the web-server process (apache, etc.) for the new php.ini to take effect.

2) The next version of webtres (due tomorrow) has some changes which may help with these APC problems.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Re: Cannot Log In; Cherokee Server 10 years 2 months ago #12

  • Doug
  • Doug's Avatar Topic Author
  • Visitor
  • Visitor
Yes same for Cherokee but no go. I did notice some changes to the php structure between PGV and webtrees particularly in the login.php series of apps but I am not strong in php to know whether this has a major effect.

See what happens with next release.

Been playing with the XP/Apache version and I like the changes. I find the stories tab particularly useful to my readers as I was including "stories" under a wiki structure using mediawiki. Good for contributions but not efficient for log-in etc.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum