Well, it's been a learning experience every step of the way. I've installed MySQL, recompiled PHP to include PDO/MySql, etc. I get to step 8 of the installation wizard and when I select upload a Gedcom, I get a message: :
Well, I've set the permissions on the index directory and all content to 777. Also have the owner set as www:www. Also set the ownere of the the PhpGedView directory to www:www.
Deleted the database and started again - went through the configuration to Step 8 again.
To create the database, I simply did "Create Database phpgedview" and did a Grant command to give a all permissions to the database to the user I set up to have access (which is the name I put in the configuration screen for the database).
Feels like I'm missing something simple here.
Any further advice you can provide, please?
Thanks, Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
One more thing, all of the files in the phpgedview directory have owner set to root:wheel since I imported them when logged in as the root user. Does this matter?
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can't stop - one more thing… the mySql user I set up doesn't have a password so I left that blank. I did a query on the tables in the phpgedview database, and the tables were created.
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Another strange thing: I can't put in the url …./phpgedview and get the wizard screens to come up again. However, I can do "back" over and over to get it come up again. When I do that I get a message in red on the administrator setup screen that "passwords must be at least 6 characters" and it shows the administrator that I already set up (which has a password of more than 6 characters).
It is possible that my not putting a password on the user in mysql who has access to the DB that it's causing residual errors like this one?
Thanks to anyone who can help me, please.
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
> I can't put in the url …./phpgedview
> and get the wizard screens to come up
> again
That is because you only get redirected to the wizard on first install.
> passwords must be at least 6
> characters
This applies to pplication (PGV) user accounts. PGV doesn't have any restrictions on your database connection password. The fact that tables ahve been created suggests this is not an issue.
I know nothing of safari, or what might cause it to display the "cannot open page" error. Have you tried a different browser.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, I've used both Safari and IE. By deleting the database and restarting install, I can restart the wizard. Somewhere it is saving where the installation wizard picks back up when I start the install.php wizard - only way I could force it to start over was to delete and recreate the database.
I noticed that the PHP status (I created a test.php with the line:
<?php phpinfo() ?>
that the mysql socket is set to /var/mysql/mysql.sock, even though I changed the default to /tmp/mysql.sock in the /etc/php.ini file. Not understanding why, I went ahead and copied /tmp/mysql.sock over to /var/mysql/mysql.sock. Thought that might help even though I wasn't getting an error message about the database not being accessed.
Can anyone think of anything else to check? I'm definitely a novice here and am a loss as to what to check next.
Thanks, Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are you sure you've changed the correct php.ini ?
You can see which one is in use using the phpinfo output you've already generated.
Note that you have to stop & start Apache to get the change you've made actually to be noticed.
As you're apparently using a Mac Mini as the server, which route did you use to get Apache, php and MySQL installed? And which versions?
On my iMac (using MacPorts for Apache2, MySQL and php) the htdocs and phpGedView directories and files are generally set to root:admin and 644 / 755 as appropriate for files / directories. I haven't needed to change these. Just the config.php and ./index and ./index/* before running the installation. (I generate thumbnails for images beforehand).
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I changed the php.ini file in the /etc directory (so /etc/php.ini).
I checked the table count and there are no rows in the tables - although the tables were created.
Does it matter what database user id I use? I began to use "root" and get no errors.
I am using a Mac Mini. Apache and PHP were already installed. I downloaded MySQL from www.mysql.com and followed the install instructions there. The most difficult thing was installing PDO/MySQL in PHP - followed instructions I found on the internet and it seemed to work (see the test output below).
Since the tables are created, but a record is not put in each, does that point for a further explanation.
You can see the PHP installation information at my server via this url:
www.schmidtfamilynews.com/phpgedview/test.php
What else might I try?
Thanks for your continuing help here.
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Not totally sure but you might need to enable these php extensions too
calendar
gd
mhash
mcrypt
In the MySQL section, my phpinfo says
Client API version mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $
whereas yours has
Client API version 5.0.82
in fact you don't a mysqlnd section either. I'm running php 5.3.1 though and that might be the difference between me and you.
Same API difference for the PDO_mysql section.
You shouldn't need to use the root MySQL user, but if that does work, then it presumably means that there is something awry with the user you were using up til then. Please use some (strong) passwords though!
It'll interesting to see if your phpGedView installation sends email messages when you do get it installed.
(You can't be that much of a novice if you've already recompiled php :-) )
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In the index subdirectory, the original .htaccess and index.php files are there. In addition it now contains lang_settings.php, lang_settings.php.old, and pgv-201001.log.
Started looking at the process to re-install PHP and looks over my head on first glance, so hoping to avoid.
With this data, where might I look next to find the problem?
Thanks for hanging in there with me and offering your advice!
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
added user ….
config.php updated by …
lang_settings.php updated
config.php updated by ….
etc., etc., many lines duplicated due to my many tries to get the Step 8 Items to work.
Back to square one? Am I just not going to get this to work?
By the way, I did have it working successfully with previous version of PVG (pre need for PDO), lost my hard drive, and started over from scratch - started with a fresh install of Leopard. Assume that's a good thing, but at least was successful once before earler version of PVG.
Am I at the end of diagnosis? Any additional leads I can pursue? None of the Step 8 items work - not specific to loading GEDCOMs, trying to do user admin all give the same message like "…. can't open the page "http://mac-min/phpgedview/login.php?url=install.php" type of message. Now I can't even get the wizard back up without deleting the DB and creating it again.
Back to square one. Does the fact that I can't even enter the install wizard again without deleting the DB first point to a new place to investigate?
Thanks again for attempts to help me!
Steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I did wonder why your phpinfo page had all the "funny stuff" at the top of the output page …
_from http://www.entropy.ch/software/macosx/php/_
Why do I get stuff like {\rtf1\mac\ansicpg10000\cocoartf100 on every page?
You probably used TextEdit to edit your .php file. Don’t do that as it inserts lots of RTF formatting code into your HTML and PHP code, which is what you’re seeing.
Do yourself a big favor and get BBEdit or TextWrangler!
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well, it's been a learning experience every step of the way. I've installed MySQL, recompiled PHP to include PDO/MySql, etc. I get to step 8 of the installation wizard and when I select upload a Gedcom, I get a message: :
Safari can’t open the page “http://mac-mini/phpgedview/editconfig_gedcom.php?source=upload_form”
I'm at a loss on what to do next. Any suggestions or help would be greatly appreciated!!!
Thanks, Steve
Most likely you haven't set the right permissions on the phpgedview/index folder.
It needs to have full read/write (777) permissions on that directory, all its sub-directories and contents.
Well, I've set the permissions on the index directory and all content to 777. Also have the owner set as www:www. Also set the ownere of the the PhpGedView directory to www:www.
Deleted the database and started again - went through the configuration to Step 8 again.
To create the database, I simply did "Create Database phpgedview" and did a Grant command to give a all permissions to the database to the user I set up to have access (which is the name I put in the configuration screen for the database).
Feels like I'm missing something simple here.
Any further advice you can provide, please?
Thanks, Steve
One more thing, all of the files in the phpgedview directory have owner set to root:wheel since I imported them when logged in as the root user. Does this matter?
Steve
Can't stop - one more thing… the mySql user I set up doesn't have a password so I left that blank. I did a query on the tables in the phpgedview database, and the tables were created.
Steve
Another strange thing: I can't put in the url …./phpgedview and get the wizard screens to come up again. However, I can do "back" over and over to get it come up again. When I do that I get a message in red on the administrator setup screen that "passwords must be at least 6 characters" and it shows the administrator that I already set up (which has a password of more than 6 characters).
It is possible that my not putting a password on the user in mysql who has access to the DB that it's causing residual errors like this one?
Thanks to anyone who can help me, please.
Steve
> I can't put in the url …./phpgedview
> and get the wizard screens to come up
> again
That is because you only get redirected to the wizard on first install.
> passwords must be at least 6
> characters
This applies to pplication (PGV) user accounts. PGV doesn't have any restrictions on your database connection password. The fact that tables ahve been created suggests this is not an issue.
I know nothing of safari, or what might cause it to display the "cannot open page" error. Have you tried a different browser.
Yes, I've used both Safari and IE. By deleting the database and restarting install, I can restart the wizard. Somewhere it is saving where the installation wizard picks back up when I start the install.php wizard - only way I could force it to start over was to delete and recreate the database.
I noticed that the PHP status (I created a test.php with the line:
<?php phpinfo() ?>
that the mysql socket is set to /var/mysql/mysql.sock, even though I changed the default to /tmp/mysql.sock in the /etc/php.ini file. Not understanding why, I went ahead and copied /tmp/mysql.sock over to /var/mysql/mysql.sock. Thought that might help even though I wasn't getting an error message about the database not being accessed.
Can anyone think of anything else to check? I'm definitely a novice here and am a loss as to what to check next.
Thanks, Steve
the tables were created.
was a row added to the pgv_users table?
Are you sure you've changed the correct php.ini ?
You can see which one is in use using the phpinfo output you've already generated.
Note that you have to stop & start Apache to get the change you've made actually to be noticed.
As you're apparently using a Mac Mini as the server, which route did you use to get Apache, php and MySQL installed? And which versions?
On my iMac (using MacPorts for Apache2, MySQL and php) the htdocs and phpGedView directories and files are generally set to root:admin and 644 / 755 as appropriate for files / directories. I haven't needed to change these. Just the config.php and ./index and ./index/* before running the installation. (I generate thumbnails for images beforehand).
Mark
I changed the php.ini file in the /etc directory (so /etc/php.ini).
I checked the table count and there are no rows in the tables - although the tables were created.
Does it matter what database user id I use? I began to use "root" and get no errors.
I am using a Mac Mini. Apache and PHP were already installed. I downloaded MySQL from www.mysql.com and followed the install instructions there. The most difficult thing was installing PDO/MySQL in PHP - followed instructions I found on the internet and it seemed to work (see the test output below).
Since the tables are created, but a record is not put in each, does that point for a further explanation.
You can see the PHP installation information at my server via this url:
www.schmidtfamilynews.com/phpgedview/test.php
What else might I try?
Thanks for your continuing help here.
Steve
Oops - I checked again and there is one record in the pgv_users table after all. So it seems writing to the database is working.
Does it provide any further help? Still not able to proceed to any of the items on the Step 8 screen of the installation wizard.
Thanks, Steve
Not totally sure but you might need to enable these php extensions too
calendar
gd
mhash
mcrypt
In the MySQL section, my phpinfo says
Client API version mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $
whereas yours has
Client API version 5.0.82
in fact you don't a mysqlnd section either. I'm running php 5.3.1 though and that might be the difference between me and you.
Same API difference for the PDO_mysql section.
You shouldn't need to use the root MySQL user, but if that does work, then it presumably means that there is something awry with the user you were using up til then. Please use some (strong) passwords though!
It'll interesting to see if your phpGedView installation sends email messages when you do get it installed.
(You can't be that much of a novice if you've already recompiled php :-) )
Mark
Also - are you getting any errors in your MySQL log or the Apache error log (assuming your php errors are trapped in Apache's log)
Mark
If you're creating tables and inserting rows, there would seem to be little wrong with your database connection.
The next thing PGV needs to do is write to the index directory, so kiwi_pgv's comments are probably relevant.
Do any files get written/updated here?
In the index subdirectory, the original .htaccess and index.php files are there. In addition it now contains lang_settings.php, lang_settings.php.old, and pgv-201001.log.
Started looking at the process to re-install PHP and looks over my head on first glance, so hoping to avoid.
With this data, where might I look next to find the problem?
Thanks for hanging in there with me and offering your advice!
Steve
Well, these indicate that PGV can write files in this directory.
The file pgv-201001.log may contain useful error messages.
Looks like a lot of successful entries:
added user ….
config.php updated by …
lang_settings.php updated
config.php updated by ….
etc., etc., many lines duplicated due to my many tries to get the Step 8 Items to work.
Back to square one? Am I just not going to get this to work?
By the way, I did have it working successfully with previous version of PVG (pre need for PDO), lost my hard drive, and started over from scratch - started with a fresh install of Leopard. Assume that's a good thing, but at least was successful once before earler version of PVG.
Am I at the end of diagnosis? Any additional leads I can pursue? None of the Step 8 items work - not specific to loading GEDCOMs, trying to do user admin all give the same message like "…. can't open the page "http://mac-min/phpgedview/login.php?url=install.php" type of message. Now I can't even get the wizard back up without deleting the DB and creating it again.
Back to square one. Does the fact that I can't even enter the install wizard again without deleting the DB first point to a new place to investigate?
Thanks again for attempts to help me!
Steve
webserver error logs?
Where do I look for those?
Ok - maybe this helps - I found the error log. Getting this message there:
…. child pid xxxx signal bus error (10)
xxxx varies: 2000, 1320, 2092, etc.
Any clues what this may explain? Are we narrowing in on the problem?
Thanks, Steve
My guess is an issue with your PHP installation.
You said you compiled it yourself. Any reason for doing this, instead of using a precompiled binary package.
Steve
I use Marc' PHP packages at www.entropy.ch
always topnotch.
-Stephen
I did wonder why your phpinfo page had all the "funny stuff" at the top of the output page …
Mark
If you're running the Apache that Apple bundle into OSX 10.6.2, I presume the Apache logs are at
/private/var/log/apache2/
You can either use the Console utility to see them, or Terminal … or BBEdit … or …
Mark