| Author |
|
InternetUser
Joined: 02 Feb 2010
Posts: 3
|
 Posted: Tue 02 Feb '10 23:06 Post subject: Issues with XML updating on Apache server |
 |
|
Hi.
This is an issue that we are facing on a Apache RedHat server.
We have created this CMS system to modify the menu items and upload images to a online photo gallery. The CMS has been built using Flex for the front-end and PHP for the uploading and other server functions. There are certain parts of the CMS that do not work on the Apache server, but they work perfectly on a Windows server with PHP support!
The exact same files when uploaded to the Apache server cause certain functions to stop working:
1 - The XML does not get updated when the images are uploaded, however it does successfully upload the image.
2 - The upload function does not work for some MP3 files.
Where could be the cause of such issues? Is it a server problem?
Thanks.
Last edited by InternetUser on Tue 02 Feb '10 23:14; edited 1 time in total |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7407
Location: EU, Germany, Next to Hamburg
|
| Posted: Tue 02 Feb '10 23:13 Post subject: |
|
|
| What is in the error log? Different PHP settings? Did you enable your php error log? What about the permissions (files / folders) from apache and from linux? |
|
| Back to top |
|
InternetUser
Joined: 02 Feb 2010
Posts: 3
|
| Posted: Tue 02 Feb '10 23:19 Post subject: |
|
|
| James Blond wrote: | | What is in the error log? Different PHP settings? Did you enable your php error log? What about the permissions (files / folders) from apache and from linux? |
Thanks for replying.
The error log is not enabled. I will enable this and post its contents.
They did not work with the default settings. So I set the permissions for the SWF and PHP files to:
Owner RWX
Group R-X
Others R-X
However it works on the Windows server with the default settings. |
|
| Back to top |
|
InternetUser
Joined: 02 Feb 2010
Posts: 3
|
| Posted: Tue 02 Feb '10 23:47 Post subject: |
|
|
Here is the error from the error log file:
[Tue Feb 02 14:36:08 2010] [error] [client 000.000.000.000] PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Access denied for user 'xyz'@'localhost' (using password: NO) in /var/www/html/stage/upload.php on line 16
[Tue Feb 02 14:36:08 2010] [error] [client 000.000.000.000] PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /var/www/html/stage/upload.php on line 16
[Tue Feb 02 14:36:53 2010] [error] [client 000.000.000.000] PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Access denied for user 'xyz'@'localhost' (using password: NO) in /var/www/html/stage/upload.php on line 16
[Tue Feb 02 14:36:53 2010] [error] [client 000.000.000.000] PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /var/www/html/stage/upload.php on line 16
The line 16 on 'upload.php' file:
$result = mysql_query($query);
The text in green has been edited. |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7407
Location: EU, Germany, Next to Hamburg
|
| Posted: Wed 03 Feb '10 11:54 Post subject: |
|
|
| So I think you know what you have to do: Fix your mysql user rights that you can connect to the mysql server. |
|
| Back to top |
|
