Hello all,
I am having some difficulty with my first application that
uses Flex with PHP/MySQL when I try to deploy it on the remote server
that I am using to host my domains. I am taking a class and we
created a Flex application that accesses a database using PHP. This
was done mostly in Flex - other than actually creating the database
and setting up the tables.
I am also looking for information in general about this
process. I use my local system with a WAMP application (Windows,
Apache, MySQL and PHP) for testing. When it works, I want to deploy
it on the remote, production server. I'll use a specific application
but my questions relate to the general process of how this is done.
Ok, after using phpmyadmin to create the database and setup
and populate the tables, I went back to Flex. I selected, Data>
Create Application from Database... Now, during the testing phase, I
set root folder to the folder and subfolder for my webroot plus the
subfolder name. The root URL is localhost/mysubfolder where
subfolder is the folder is under the root folder, that I just
mentioned.
Upon finishing the application I test it using localhost on my
local system and it works fine.
Now, I thought I understood the process and that it would be
trivial to move this to the remote server. I thought the host name
that is used by the database connection would remain localhost even
when I am moving this to http://mydomain.com/mysubdirectory.
There are two applications that exist in this project. My
first step was to create a release build, using File>Export>Release
Build and select all Applications. This works just fine on the local
system.
Are there specific things I need to keep in mind or do when
moving from a local testing server to a remote production server?
What happened for me, was that I got this error: Error #2032: Stream
Error.
Yes, I did create the database on the remote, production
server. I had a php file that defines the host, the database name,
the database username and database password. When I went to change
this for the remote server, from within Flex, I got a warning saying
that this is "derived" data.
Do I need to start again with this step, where I select in
Flex Data>Create Application from Database? Or should I just change
the information in the php connection file to point to the database,
username and password for the remote server? This is where it gave
me that warning in Flex saying that the data is "derived."
When I have installed Joomla, or Wordpress (CMS and Blog),
on the remote, production server, I still use localhost. So, would I
similarly keep that value for the connection host when moving to the
production server or change it to http://mydomain.com or leave off
http://?
Maybe before I compile it again for Exporting a release
build, I should go into Project>Properties and change the root folder
for the unix production folder, and maybe change the root URL as
well, to http://mydomain.com/mysubdirectory
Please help me understand this process in general and in
particular with this particular project that I described.
Thank you,
Bruce
