Another PacsOne Login Problem

[davisonp]

Hi,

I have a similar problem to Weijia Su but haven't been able to fix it following that thread. Please bear with me - I'm pretty much a complete novice at this but wanted to set up PacsOne on my PC at home before trying to demo it at work.

OS Windows XP Home
PacsOne server Premium version 1.1.8.0
MySQL version 4.0.21-win
Apache HTTP sever version 2.0.51.0
PHP version 5.0.1.1


There are a few problems!
Following the installation guide and online installation guides I set up MySQL(to default directory), PacsOne, Apache and PHP OK I think - in the winmysqladmin window I can see the pacsone database. I can log on to this via mysql command shell.

I'm not convinced I have set up ImageMagick as a PHP module correctly as although I can see the PHP script at http://localhost/pacsone/hello.php I can't find 'imagick' as a PHP extension.

At the http://localhost/pacsone/pacsone.php login page I also get "Not authorised to access this URL" error. I checked the session save path as

session.save_path = "C:\tmp"

and that C:\tmp exists - also ensured windows type backslash rather than a forward slash. I've also added the various elements to the path environmental variable i.e. for php, mysql and mysql\bin as suggested either in installation or the forum

Finally - if I do try to log on as root at the PacsOne login page I get

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\PacsOne\php\database.php on line 30

I thought I read in the modification history that mysql_connect() should be mysql_real_connect()?

Thanks for any help - bear in mind I'm new at this!

[pacsone]

From your description of the problems, it seems most likely that the MySQL PHP module was not loaded, neither was the ImageMagick PHP module.

Can you post the output from your PHP page:

http://localhost/pacsone/hello.php

here, or send it to:

mailto:pacsone@pacsone.net

and we'll look into it.

[davisonp]

Thanks

I've sent the output to pacsone@pacsone.net as it seemed a bit large to post all of it.

As an aside, I'm currently evaluating a 'mini-PACS' solution for our department from Terarecon called the AquariusNET server. With my new knowledge I've spotted that it uses MySQL and a type of Apache server. Can databases be shared by servers running MySQL and if so do the servers have to be on the same PC or can it be done over a network?

Thanks

[pacsone]

Yes, it's actually quite popular to share MySQL databases across network connections among multiple PCs.

However, there are performance and security considerations you may want to be aware of when you share remote database connections.

[JohnM]

Similar to Weija,

I think I have a similar problem as some other users of PacsOne. But I can not solve it by the method suggest on this forum. I installed

Apache HTTP Server 2.0.52
PHP 5.0.2
MySQL Servers and Clients 4.0.21
PacsOne Server Premium version 1.1.8

Everything went well except when I go to http://localhost/pacsone/pacsone.php
I get
"Not authorized to access this URL: http://localhost/pacsone/pacsone.php"

when I enter the database, username and password and anti-spam code and I get
Not authorized to access this URL: http://localhost/pacsone/login.php,
the fields go blank. It does not allow me to login.
Using the same MySQL database name, username and password, I am able to login in to MySQL from a command shell without any problem:

mysql -u {USERNAME} -p {DBNAME}
I also checked, as suggested by the forum, that
the session save path is set in php.ini file using the following line:

session.save_path = "c:\php\sessiondata"
and it's a valid directory.
I can also go to
http://localhost/pacsone/hello.php
to display all the setup values fine.

I followed the Weija forum closely, but with no success. The MySQL service was originally installed without service line options, just c:\mysql\mysqld MySQL, which starts the debug version as far as I could tell. I tried reconfiguring it to use the mysqld-max-nt version using mysql-administrator 1.0.13, but also without success. I also tried using the suggested my.cnf from Jonathon, but also without success.

Do you have any suggestions?
Thanks.

[pacsone]

You need to verify two things:

1. Make sure your MySQL service is configured with no command line argument, i.e., in the Windows registry:

HKLEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL\

make sure the ImagePath string value contains no argument. It should be something like:

C:\mysql\bin\mysqld

and NOT:

C:\mysql\bin\mysqld MYSQL

2. In the output of the PacsOne test page:

http://localhost/pacsone/hello.php

Make sure you see the mysql and imagick extensions in the current loaded extension list. If not, then your PHP.INI was not configured correctly.

[JohnM]

Hi pacsone,
I altered the registry setting, removing the MySQL arguement.
I also checked that mysql and imagick were loaded PHP extensions.
MySQL quoted the following: Client API version 3.23.57, even though I downloaded the most recent general release. I read in your FAQ about error messages with libmysql.dll, after I had installed the system.

I found three different versions of libmysql.dll, 212, 228 and 240KB in size after installing the versions of programmes listed in my last post. Only the 228KB version in the PHP and Apache/bin directory would work, but I cannot see what version they each represent. Could this be the problem?

Unfortunately, after another reboot, I still cannot log on.

BTW, I am running under Windows 2000, in case it matters.

Thanks for your help.

[pacsone]

The MySQL client API version of 3.23.57 is normal.

The MySQL PHP extension only uses the libMySQL.dll in the Windows %SYSTEM% directory, e.g., C:\Windows\system32\. If you installed the latest MySQL release (4.0.20), the libMySQL.dll should be around 228KBytes and dated 07/13/2004.

Did you try logging in to MySQL using the very same username/password, but from a command shell? e.g.,

C:\>mysql -u $USERNAME -p $DATABASE

If you can login to the MySQL database using the same username/password from a command shell, but not from the web user interface, then something is wrong with your PHP configuration. If that's the case, can you post the HTML output of the test page:

http://localhost/pacsone/hello.php

here or send it to mailto:pacsone@pacsone.net and we'll take a look.

[JohnM]

Hi PacsOne,

I checked that the correct version of libmysql.dll was in the %SYSTEM% directory and I could log into the database from the command prompt.

So I have emailed you a copy of my hello.php response page (a bit big to post).

Thanks