Hmmm - maybe the link i posted wasn't meant for this problem.
I can not logon to my site. It is probably not an SQLthing (or is it) :o)
Of course I can remember some of the other users passwords, but that will not help me :o/
Jesper
Denmark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes - I tried that
Unfortunately i haven't set this part up.
I will do it as soon as I get in.
What is my next step? - do I have to backup the whole lot externally (can it be done?). and the start over again?
I only have three users and I will easily could set them up again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Jesper:
An easy solution, since you only need to set up a few users, is to simply delete the "pgv_users" table from the database. If you don't know how to do that, please post back here.
After having done that, you need to edit the "config.php" file to set the $CONFIGURED variable to "false".
Now, when you launch PhpGedView, you'll be taken to the Install routine, where you need to confirm all options by clicking the "next" button as needed. When you get to the Setup Admin page, you can fill in the details of the Admin account.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I solved it. I found a person who had tried the same.
He told me what to do with the program phpAdmin which was on my ISP' site.
Found the admin password. Encrypted it. Voila.
Thankyou for your concern and help.
Jesper
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I also have lost the Admin password - tried a fix to change the email but it still presumably goes to my defunct email address.
is there anyone who I can pay to do this work? My original web programmer is no longer available and I wish to revive the project without manually inputting all the data.
I have one working Guest login. Happy to use Cisco Webex to login together.
Thanks David
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I also have lost the Admin password - tried a fix to change the email but it still presumably goes to my defunct email address.
is there anyone who I can pay to do this work? My original web programmer is no longer available and I wish to revive the project without manually inputting all the data.
I have one working Guest login. Happy to use Cisco Webex to login together.
Thanks David
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I also have lost the Admin password - tried a fix to change the email
but it still presumably goes to my defunct email address.
is there anyone who I can pay to do this work? My original web
programmer is no longer available and I wish to revive the project
without manually inputting all the data.
I have one working Guest login. Happy to use Cisco Webex to login together.
Thanks David
I can't help with the MySQL setup, although it should be possible to
'clone' the password between accounts. I have a version running on
Firebird and tools to play with things like account management.
BUT, the source for the material is stored a text in the .GED file in
your Index folder. You can take that and save it ... along with any
media files ... and load them into any family tree program that handles
gedcom format. So worse case one just reinstalls phpgedview and reload
the .GED file
I can help further if you are still stuck ... just send a private message.
Hello David:
I tried to respond to this post earlier today, but couldn't log in to SourceForge. I couldn't even report the Login problem to Sourceforge because in order to report a problem with a page (it caused a 500 server error), you have to login! Stupid design.
The solution to your problem is relatively easy, and the path you take depends on whether you want to preserve existing users or not. I'm assuming that you're running PhpGedView version 4.2.4 or higher. The database tables and fields mentioned below apply to PGV version 4.2.4 and later. You should actually be using the "SVN" version of PhpGedView.
If you can't find the SVN version, you can download and copy the 4.3.0 version to your server, and then contact me to get a ZIP file containing everything that's changed from 4.3.0 to the current SVN. If necessary, I can also supply a complete ZIP file of the SVN version. e-mail: gkroll (at) keldine (dot) ca
Download the file "config.php" to your local PC
Inspect that downloaded file (it's just a text file) to find the database credentials. They should be right at the top of the file.
If you want to blow away all existing users and start sort-of from scratch, change the $CONFIGURED line near the bottom of the file from "true" to "false", and then FTP that changed file back to the server. BE SURE TO SAVE THE MODIFIED config.php FILE IN ASCII BEFORE YOU UPLOAD IT.
Use a tool such as phpMyAdmin to modify the database tables.
PhpMyAdmin requires you to supply the database login credentials when you start.
If you want to blow away all existing users (so that you can do a partial re-installation), delete the pgv_users, pgv_user_comments, pgv_gedcom_setting and pgv_user_setting tables, leaving everything else alone.
If you just want to recover the Admin password, you'll need to look at the pgv_user_setting table. Entries in this pgv_user_setting table are matched by user_id (should actually be called user_number) to the to the login user_name in the pgv_users table.
The recovery e-mail address is found in the pgv_user_setting table. The column you need to look at is called setting_name and the value is email, with the actual e-mail address being found in the corresponding setting_value column. You also need be sure that you're looking at the correct user number in the user_id column. For the first (admin) user, this is probably 1. Verify the canadmin setting. For the Admin, this should be Y .
If you want to give Admin rights to another userid for whom you know the password , just go through the same routine, but change the corresponding canadmin setting to Y .
If you've blown away the pgv_users and pgv_user_setting tables and also uploaded a revised config.php file where the line $CONFIGURED is set to false, PGV will go through a partial from-scratch install. You'll be asked to define the Admin userid and password, and then the program will discover all of the existing tables and configuration settings.
NOTE you said that you had tried changing the e-mail address in the database, but this didn't work. You probably looked at a defunct database table. During the upgrade from 4.2.3 to 4.2.4, the database structures changed. The user information was split from a single table into the two separate tables, with the numeric user_id tying everything together. The update procedure did not delete the old table because the old table was needed if you had to restart the upgrade,
Last edit: Gerry Kroll 2018-06-01
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I did it again :o/
I forgot my password. I've searched this forum and I found this
https://sourceforge.net/forum/forum.php?thread_id=2223048&forum_id=185166
I would like to delete the admin and get the possibility to create a new admin - option.
But i am not very good at this.
Could someone please take my hand and lead me the right way?
Jesper Frehr
Denmark
Hmmm - maybe the link i posted wasn't meant for this problem.
I can not logon to my site. It is probably not an SQLthing (or is it) :o)
Of course I can remember some of the other users passwords, but that will not help me :o/
Jesper
Denmark
Can you access SQL directly (e.g. with phpMyAdmin or a command line) ?
Copy a known password from one user's account to the admin accout.
Is the passwords hidden in the SQL-thing??
How do I get in there?
When I try to reach the phpmyadmin page i get an 404 error.
Im am new to this
I can see that phpmyadmin is a program that has to be run on my site
I will try to upload it now.
Is this the only way to do it?
It sounds a bit complicated :o)
PS - I guess you have tried/failed to use the "mail forgotten password" option?
Yes - I tried that
Unfortunately i haven't set this part up.
I will do it as soon as I get in.
What is my next step? - do I have to backup the whole lot externally (can it be done?). and the start over again?
I only have three users and I will easily could set them up again.
You culd try these instructions form the WIKI:
http://wiki.phpgedview.net/en/index.php?title=FAQ:Error_Messages#Lost_password_to_PhpGedView
Jesper:
An easy solution, since you only need to set up a few users, is to simply delete the "pgv_users" table from the database. If you don't know how to do that, please post back here.
After having done that, you need to edit the "config.php" file to set the $CONFIGURED variable to "false".
Now, when you launch PhpGedView, you'll be taken to the Install routine, where you need to confirm all options by clicking the "next" button as needed. When you get to the Setup Admin page, you can fill in the details of the Admin account.
Hi everybody
I solved it. I found a person who had tried the same.
He told me what to do with the program phpAdmin which was on my ISP' site.
Found the admin password. Encrypted it. Voila.
Thankyou for your concern and help.
Jesper
I also have lost the Admin password - tried a fix to change the email but it still presumably goes to my defunct email address.
is there anyone who I can pay to do this work? My original web programmer is no longer available and I wish to revive the project without manually inputting all the data.
I have one working Guest login. Happy to use Cisco Webex to login together.
Thanks David
I also have lost the Admin password - tried a fix to change the email but it still presumably goes to my defunct email address.
is there anyone who I can pay to do this work? My original web programmer is no longer available and I wish to revive the project without manually inputting all the data.
I have one working Guest login. Happy to use Cisco Webex to login together.
Thanks David
On 01/06/18 10:42, David Latter wrote:
I can't help with the MySQL setup, although it should be possible to
'clone' the password between accounts. I have a version running on
Firebird and tools to play with things like account management.
BUT, the source for the material is stored a text in the .GED file in
your Index folder. You can take that and save it ... along with any
media files ... and load them into any family tree program that handles
gedcom format. So worse case one just reinstalls phpgedview and reload
the .GED file
I can help further if you are still stuck ... just send a private message.
--
Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Hello David:
I tried to respond to this post earlier today, but couldn't log in to SourceForge. I couldn't even report the Login problem to Sourceforge because in order to report a problem with a page (it caused a 500 server error), you have to login! Stupid design.
The solution to your problem is relatively easy, and the path you take depends on whether you want to preserve existing users or not. I'm assuming that you're running PhpGedView version 4.2.4 or higher. The database tables and fields mentioned below apply to PGV version 4.2.4 and later. You should actually be using the "SVN" version of PhpGedView.
If you can't find the SVN version, you can download and copy the 4.3.0 version to your server, and then contact me to get a ZIP file containing everything that's changed from 4.3.0 to the current SVN. If necessary, I can also supply a complete ZIP file of the SVN version. e-mail: gkroll (at) keldine (dot) ca
Use a tool such as phpMyAdmin to modify the database tables.
If you've blown away the pgv_users and pgv_user_setting tables and also uploaded a revised config.php file where the line $CONFIGURED is set to false, PGV will go through a partial from-scratch install. You'll be asked to define the Admin userid and password, and then the program will discover all of the existing tables and configuration settings.
NOTE you said that you had tried changing the e-mail address in the database, but this didn't work. You probably looked at a defunct database table. During the upgrade from 4.2.3 to 4.2.4, the database structures changed. The user information was split from a single table into the two separate tables, with the numeric user_id tying everything together. The update procedure did not delete the old table because the old table was needed if you had to restart the upgrade,
Last edit: Gerry Kroll 2018-06-01