Login problem

lobertuk · Post by **lobertuk** » Mon Sep 14, 2009 2:55 pm

This concerns PacsOne Basic.

Could not install normal way (setup was not dropping tables into database). After long tweeking the installation, I have decided to create tables using mysql> CREATE TABLE based on data in the file db_schema, which was a success.

Finally, I can get screen http://localhost/pacsone/ = Index of /pacsone. From here, I can go use the following links: 1.http://localhost/pacsone/login.php or 2.http://localhost/pacsone/pacsone.php.
While using second link, I am getting the following adress: http://localhost/pacsone/login.php?mess ... acsone.php.

Both ways bring me to login screen, but no one is working.

Error messages:
1) PacsOne
Sun Sep 13 16:46:23 2009 INFO - Process Intialized
Sun Sep 13 16:46:23 2009 INFO - Server Socket: 244 created successfully
Sun Sep 13 16:46:23 2009 INFO - Socket: 244 bind to Port: 1234
Sun Sep 13 16:46:23 2009 INFO - Worker Thread: 3732 running
Sun Sep 13 16:46:23 2009 INFO - Worker Thread: 5400 running
Sun Sep 13 16:57:59 2009 ERROR - RUNQUERY: SQL Bad Query: Can't connect to MySQL server on 'localhost' (10061)
Sun Sep 13 16:57:59 2009 ERROR - Exeption encountered in Database Job Thread
Sun Sep 13 16:58:05 2009 ERROR - RUNQUERY: SQL Bad Query: Can't connect to MySQL server on 'localhost' (10061)
Sun Sep 13 16:58:05 2009 ERROR - Exeption encountered in Database Job Thread.
2) Apache 2.2
[Mon Sep 14 10:21:29 2009] [error] [client 127.0.0.1] PHP Notice: Undefined variable: HTTP_POST_VARS in C:\\Program Files\\PacsOne\\php\\authenticate.php on line 16, referer: http://localhost/pacsone/login.php?mess ... acsone.php
[Mon Sep 14 10:21:29 2009] [error] [client 127.0.0.1] PHP Notice: Undefined variable: HTTP_POST_VARS in C:\\Program Files\\PacsOne\\php\\authenticate.php on line 17, referer: http://localhost/pacsone/login.php?mess ... acsone.php
[Mon Sep 14 10:21:29 2009] [error] [client 127.0.0.1] PHP Notice: Undefined variable: HTTP_POST_VARS in C:\\Program Files\\PacsOne\\php\\authenticate.php on line 18, referer: http://localhost/pacsone/login.php?mess ... acsone.php
[Mon Sep 14 10:21:31 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.52 for ServerName
[Mon Sep 14 10:21:32 2009] [notice] Apache/2.2.13 (Win32) PHP/5.2.10 configured -- resuming normal operations
[Mon Sep 14 10:21:32 2009] [notice] Server built: Aug 6 2009 15:50:50
[Mon Sep 14 10:21:32 2009] [notice] Parent: Created child process 5728
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.52 for ServerName
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.52 for ServerName
[Mon Sep 14 10:21:33 2009] [notice] Child 5728: Child process is running
[Mon Sep 14 10:21:33 2009] [notice] Child 5728: Acquired the start mutex.
[Mon Sep 14 10:21:33 2009] [notice] Child 5728: Starting 64 worker threads.
[Mon Sep 14 10:21:33 2009] [notice] Child 5728: Starting thread to listen on port 80.
[Mon Sep 14 10:24:39 2009] [error] [client 127.0.0.1] PHP Notice: Undefined variable: HTTP_POST_VARS in C:\\Program Files\\PacsOne\\php\\authenticate.php on line 16, referer: http://localhost/pacsone/login.php?mess ... acsone.php
[Mon Sep 14 10:24:39 2009] [error] [client 127.0.0.1] PHP Notice: Undefined variable: HTTP_POST_VARS in C:\\Program Files\\PacsOne\\php\\authenticate.php on line 17, referer: http://localhost/pacsone/login.php?mess ... acsone.php
[Mon Sep 14 10:24:39 2009] [error] [client 127.0.0.1] PHP Notice: Undefined variable: HTTP_POST_VARS in C:\\Program Files\\PacsOne\\php\\authenticate.php on line 18, referer: http://localhost/pacsone/login.php?mess ... acsone.php
[Mon Sep 14 10:24:40 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.52 for ServerName
[Mon Sep 14 10:24:41 2009] [notice] Apache/2.2.13 (Win32) PHP/5.2.10 configured -- resuming normal operations
[Mon Sep 14 10:24:41 2009] [notice] Server built: Aug 6 2009 15:50:50
[Mon Sep 14 10:24:41 2009] [notice] Parent: Created child process 5920
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.52 for ServerName
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.52 for ServerName
[Mon Sep 14 10:24:41 2009] [notice] Child 5920: Child process is running
[Mon Sep 14 10:24:41 2009] [notice] Child 5920: Acquired the start mutex.
[Mon Sep 14 10:24:41 2009] [notice] Child 5920: Starting 64 worker threads.
[Mon Sep 14 10:24:41 2009] [notice] Child 5920: Starting thread to listen on port 80.

Post by **pacsone** » Mon Sep 14, 2009 3:20 pm

Which version of MySQL did you install on this server? The Basic Edition of PacsOne Server only supports MySQL 3.23.53 or earlier releases, as it's no longer being maintained due to our limited resources.

lobertuk · Post by **lobertuk** » Mon Sep 14, 2009 4:36 pm

MySQL 5.1 (latest).
At the beginning I was getting an error, which I solved as follows:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

Post by **pacsone** » Tue Sep 15, 2009 3:14 am

The Basic Edition of PacsOne Server will not work with MySQL 5.1.x, so you should either install the Premium Edition of PacsOne Server instead, or downgrade MySQL to version 3.23.53 or earlier releases.

lobertuk · Post by **lobertuk** » Wed Sep 16, 2009 6:43 pm

OK.

I have installed the latest PacsOne Premium for evaluation. All postinstall screens are there. But when I try to log in into home.php using root user and password (Welcome to PacsServer), I cannot be connected: "The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings..." After failed log in, the link in address bar would be "http://localhost/pacsone/authenticate.php.

Apache reports the following error: Parent: child process exited with status 3221225477 -- Restarting.

lobertuk · Post by **lobertuk** » Wed Sep 16, 2009 8:00 pm

Just solved the problem. Based on similar case posted on the forum, I have enabled PHP mysqli extension.