redstorm
Posts: 7
|
| Posted: 02/16/2006, 12:05 AM |
|
We have built an application which is working fine on test server. In fact 2 test servers. All OK. We have loaded the application on 2 different live servers for final testing.
We have the DB on one of those 2 live servers. Whether test or live all servers connect to the central live DB and always have. All have no connections issues and update DB etc. MySQL.
The problem is this. Despite running the same server settings and identical files on both live servers, Only one of them actually works. Unfortunately it is the one that we want for a client that does not.
Does anyone have any ideas as to what to do. It is non sensical. We have spent 3 days checking and trying different combinations but no luck. Is there any guides that we could view or any advice that any one could provide to overcome this issue.
Identical files. indentical servers.
All files have been uploaded to the servers through CCS 3.0
Thank you
|
 |
 |
mrachow
Posts: 509
|
| Posted: 02/16/2006, 12:28 AM |
|
What do you mean exactly byQuote :Only one of them actually works ?
The Users/Logins of MySQL are having a property from which servers a login is allowed. Maybe the used database user is allowed to connect from localhost only?
(A speculation only not knowing details, see above.)
_________________
Best regards,
Michael |
|
|
|
David @ Redstorm
|
| Posted: 02/16/2006, 12:50 AM |
|
Thanks Michael.
Let me try and explain
Quote mrachow:
What do you mean exactly by Quote :Only one of them actually works ?
OK Lets call them server 1, 2 and 3 for our purposes.
Server 1 - Client Live Site (DB Stored here)
Server 2 - Test Server (Live Remote Server)
Server 3 - Test Server (Local PC)
OK all servers draw from the central DB at Server 1
DB connects perfectly with Server 2 and 3. Both these servers function correctly. That is all fields are populated and any queries dealt with correctly and post to the relevant CCS (php) file on both server 2 and 3.
As soon as you upload the published files on either server 2 or 3 (and we have tried both) to Server 1 and run Server 1 absolutely no fields or tables are populated.
On the question of login local host does have the necessary permissions.
Thank you for your input! I hope this helps you understand a little better the issues.
|
|
|
|
Walter Kempees
|
| Posted: 02/16/2006, 2:11 AM |
|
David
Open the three Common.php files
look for Host=> "localhost"
Do they all three have this?
If Yes, than that is the problem, because you would need a fully qualified
URL to you MySQL database
if Not, then that part seems ok, and I would seriously have a look at the
connection setting for MySQL
is it allowed to accept requests from all three servers (apparantly 2 are
allowed)
In my case I have one DB on a machine say "dbserver.domain.tld", it can be
set to accept/not accept remote connections.
so my common.php (and Server2 profile->Connection) have dbserver.domain.tld
as Server
just my 2 eurocents
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/16/2006, 5:03 AM |
|
David,
Do you see any errors, or everything works normally except the database is not updated?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
David @ Redstorm
|
| Posted: 02/16/2006, 5:27 AM |
|
Peter ,
Everything works normally except that the DB does not return values.
No error messages at all.
David
|
|
|
|
David @ Redstorm
|
| Posted: 02/16/2006, 5:30 AM |
|
Walter,
2 servers use IP address and (local) client server uses localhost in Common.php
All permissions are set to allow access to both localhost an hte 2 statis IP addresses of the remote servers.
Thanks Walter.
David
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/16/2006, 5:43 AM |
|
David,
By not returning values do you mean that all Grids always show the message "No records found" (which means that DB does not return values)?
Previously you wrote that no fields or tables are populated, which would be rather a different problem, but I cannot imagine how this looks on a grid.
Also, is it possible that you are opening an HTML page instead of PHP? Do you access a URL that specifically contains .php at the end?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
David @ Redstorm
|
| Posted: 02/16/2006, 5:53 AM |
|
Peter,
The Grids always show the message "No records found" However run the same action on either of the remote servers and you get the correct results.
Opening PHP pages.
David
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/16/2006, 6:10 AM |
|
OK. This problem looks strange indeed. I would focus on finding out if the problem is related to:
- the database
- or the way you're connecting to it
- or queries being performed.
You may want to install MySQL Administrator or other MySQL GUI, or PHPMyAdmin on that server, to see if you're able to access the data via localhost.
You may also write (or find on the net) a very basic PHP program that connects to your database and displays 1 record.
Both above tasks should help you eliminate some of the suspected causes of the problem.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Walter Kempees
|
| Posted: 02/16/2006, 6:39 AM |
|
Create a newpage
Generate a simple Grid on a simple table.
Publish that to all three and look for data.
With simple I mean nos session dependancies, no complex where
just a Select * from table
I suspect it to be in a SQL Where using some session var or other
machine/domain specific.
"peterr" <peterr@forum.codecharge> schreef in bericht
news:243f487dca1a70@news.codecharge.com...
> OK. This problem looks strange indeed. I would focus on finding out if
> the
> problem is related to:
> - the database
> - or the way you're connecting to it
> - or queries being performed.
>
> You may want to install MySQL Administrator or other MySQL GUI, or
> PHPMyAdmin
> on that server, to see if you're able to access the data via localhost.
> You may also write (or find on the net) a very basic PHP program that
> connects
> to your database and displays 1 record.
> Both above tasks should help you eliminate some of the suspected causes of
> the
> problem.
> _________________
> Peter R.
> YesSoftware Forums Moderator
> For product support please visit http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Walter Kempees
|
| Posted: 02/16/2006, 6:50 AM |
|
Wait a minute!
Reread your 2nd post.
You are writing something that is terribly wrong and I hope it's in the text
and not in the actual action taken.
Quote :
OK Lets call them server 1, 2 and 3 for our purposes.
Server 1 - Client Live Site (DB Stored here)
Server 2 - Test Server (Live Remote Server)
Server 3 - Test Server (Local PC)
OK all servers draw from the central DB at Server 1
DB connects perfectly with Server 2 and 3. Both these servers function
correctly. That is all fields are populated and any queries dealt with
correctly and post to the relevant CCS (php) file on both server 2 and 3.
As soon as you upload the published files on either server 2 or 3 (and we
have
tried both) to Server 1 and run Server 1 absolutely no fields or tables are
populated.
upload the files published on S2 or S3 to Server 1 THIS IS WRONG
From your project you HAVE to create Server profiles, you can in fact create
as many as you need.
Using the selected Profile you "Publish" to the Server that you want to
publish to.
Do not FTP from Server2 or Server3 the contents to Server1
Assuming that in the project you already have a Server1 profile, which
would be the default profile
and a Server2 profile I would create a Server3 profile (you can rename them
by the way (Develop, Live Test, Client X) )
set all connection parameters right, check all other profile dependant
setting and fire away!
If this is not the solution and you have checked all connections, than my
last advice would be to check all versions used.
MySQL 4 / 5 PhP 4 / 5
I feel your tension!
Walter
|
|
|
|
David @ Redstorm
|
| Posted: 02/17/2006, 3:35 AM |
|
Walter.
We did both forms of upload. One through CCS and the second directly with the same lack of results.
What we have done is re installed PHP on the server creating the issues and all fixed! What ever the issue it was with PHP and is now resolved however very frustrating.
HOWEVER I must say this is one of the most if most responsive forums we have ever posted on.
Despite being a steep learning curve with CCS it is an excellent product and one that obviously has the support of a developing community.
Thank you everyone that has contributed and assisted us in undertstanding the product.
Thank you.
|
|
|
|
Walter Kempees
|
| Posted: 02/17/2006, 4:04 AM |
|
Hurray!
Goo4U.
|
|
|
|
