Hi,

I'm really interested in getting OPN installed on my site, but I've been having a nightmare getting it installed with MySql on my hosting site.

First, I created a MySql database.

Seond, I went through step one and two filling out the forms. Step one asks for information about the URL, the physical path, the installation path, etc... Step two asks for information about my MySql configuration, like server name, uid, pw, etc...

Third, when I click the button to move on to the next step, I get a big message stating the following:

The script tried to include the database layer but this didn't work. Check the Physical Path

The just below thist message, there's a message with the following:

mysql - Should work with mySQL Version 3.22 and up

The problem is, It's very difficult to tell if the error is from bad information I provided on step one or step two. Does anyone know of any gotchas installing this?

Thanks,

Kyle

Wie need the informations that you have entered on the first page and the information that OPN will display on the first page.
With this informations we could maybe find the problem with your errormessage.

Below are the fields I provided for the first step:

Database Driver: mySql
URL: http://www.mydomainname.com
Physical Path: /
Install Directory: >
Encryption Type: MD5 >

I tried multiple variations for physical path. I even unzipped all the files in the html directory into the root of my account to try and make it easier. But, no luck.

For the following screen,

Database Server Name : > xx.yy.zz.aa
connection String : > don't know what to put in here.
Database Username: >
Database Password: >
Database Name: >
Database Table Prefix : > opn

Thanks,

Any help you can provide is deeply appreciated.

Quote:
2004-12-09 21:27
kylemanning wrote:
Below are the fields I provided for the first step:

Database Driver: mySql
URL: http://www.mydomainname.com
Physical Path: /

If you call the install.php OPN wil enter herer a path or not? And if yes what path will OPN enter there?
You can also contact me via ICQ, AIM, MSNM, >IM or Jabber if you will not post this data here in the forum.

Quote:
2004-12-09 21:27
kylemanning wrote:

connection String : > don't know what to put in here.

For MySQL nothing. Cause Postgres need the -fh parameter in the connection string we made this field.

Hi,

Yes, the system automatically puts "/" for the path. I have tried other paths, but nothing works. Because I'm using a hosting account... I don't have access to the actual physical path on the machine, like c:.......

So, I have just used the default "/".

However, in my account, if you were to look at the directory structure the way I see it from my file manager.....I have the following directory structure.

/mydomain.com/>

so my files for OPN are at ...

mydomain.com/opn2/html/>

I also copied all the > to my root directory so that they are here....

mydomain.com/>

does his help?

Thanks,

Kyle

You can come to our Chat.
Cause there we can help a bit quicker then here.
It seems that OPN can't detect your path. So some work must be done.

Problem solved in the chat.
It seems that the IIS have some Problems with the detection of the DOCUMENT_ROOT.
We hope that we can solve this problem ASAP.
Meanwhile here is a quick and dirty workaround for IIS user that will install OPN 2.2.2:

Create a little script with the following content:

<?php
echo phpinfo();
?>

Save this script under test.php and put it into the same path where you put OPN.
Then point your browser to this PHP Script and search in the output for DOCUMENT_ROOT.
Copy this value to the clipboard and start the OPN Installer again. Paste the clipboard content into the inputfield for the Physical Path and change the backslashes to slashes ( to /).
The installer should work then.

Hi, well since there's already been a group of people viewing this thread, there must be some interest. So, I'll go ahead and spell out the verdict for you. Hopefully this helps you if you're having similar problems.

In the first form of information, you are prompted to provide a Physical Path to where your install.php resides.

This means that even though you are on a hosting service that would ordinarily hide the fully qualified path from you because you don't ordinarily need to know it, you'll need it in this case.

If you DON'T know your physical path, here's a way to get to it, thanks to the help of hhombergs. ((Thanks for all your help!))

You'll want to create a little script called something like test.php. Inside the script, all you'll need is the following lines:

<?php
echo phpinfo();
?>


Save this script. A good place to put it on your server would be in the same directory as your install.php file since this is the directory whose physical path we are looking for.


Execute the script by loading it into your browser. Many of you who have been working with PHP for some time now are already familiar with what this script is doing. But never the less, execute it and you'll see a wealth of information about your system and php configuration. In this wealth of information will be the diamond we are looking for. There will be an entry call "path translated". The path to the right of this is the physical path to your intall.php script. Now you have this.

If you are running IIS, make sure to do one of two things when typing this directory into your physical path prompt. 1) change the '' single backslash in the directory path to '' double back slashes OR 2) change the '' single backslash to a '/' single forward slash for each. Otherwise PHP will get confused thinking that this is an escape code.

chances are this will take care of your problem if you are experiencing the problems discussed earlier.

Happy OPNing

Woops, the last response was from myself.....but looks like hombergs already provided the response. Well, there you have it twice now.