Thread: [Phpwebsite-developers] Moving PHP Website to another machine

Brought to you by: brownbw, jtickle, verdonv

phpwebsite-developers

[Phpwebsite-developers] Moving PHP Website to another machine

From: Ruben F. <rfa...@np...> - 2004-11-19 15:28:42

I have what should be a very simple problem, but I just have not been 
able to figure this out.

I wanted to move a PHP Website site to another machine, and I dumped the 
database, and copied all the files. I placed everything in the same 
directory structure as the original setup.

I have the same logins for MySQL on both boxes, and I created a 2nd 
level domain name to the new box, but every time I try and access the 
2nd box, I get this message.

Unable to load database indicated by configuration file.

The databases have exactly the same name. So, what am I doing wrong in 
trying to move this web site to a new box ? I must be missing something 
simple ? Any suggestions on where to start debugging this. I'm not 
seeing any useful errors in the apache log files. I'm running MySQL 4 on 
both boxes. Old box is Redhat 9 and new box is Fedora C 2

Thanks for your help,
Ruben

Re: [Phpwebsite-developers] Moving PHP Website to another machine

From: Wendall C. <wen...@to...> - 2004-11-19 17:24:53

Ruben,

It would appear something is wrong with your mysql setup. Did you add
permissions to the new database for your user? Try logging into the
database with your user/passwd via the command line and see if you can
get in.

Wendall

On Fri, 2004-11-19 at 10:28 -0500, Ruben Fagundo wrote:
> I have what should be a very simple problem, but I just have not been 
> able to figure this out.
> 
> I wanted to move a PHP Website site to another machine, and I dumped the 
> database, and copied all the files. I placed everything in the same 
> directory structure as the original setup.
> 
> I have the same logins for MySQL on both boxes, and I created a 2nd 
> level domain name to the new box, but every time I try and access the 
> 2nd box, I get this message.
> 
> Unable to load database indicated by configuration file.
> 
> The databases have exactly the same name. So, what am I doing wrong in 
> trying to move this web site to a new box ? I must be missing something 
> simple ? Any suggestions on where to start debugging this. I'm not 
> seeing any useful errors in the apache log files. I'm running MySQL 4 on 
> both boxes. Old box is Redhat 9 and new box is Fedora C 2
> 
> Thanks for your help,
> Ruben
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

Re: [Phpwebsite-developers] Moving PHP Website to another machine

From: Ruben F. <rfa...@np...> - 2004-11-19 19:00:39

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
That's the problem. I can login to the db just fine from the command
line.<br>
<br>
<br>
Wendall Cada wrote:
<blockquote cite="mid...@ww..."
 type="cite">
  <pre wrap="">Ruben,

It would appear something is wrong with your mysql setup. Did you add
permissions to the new database for your user? Try logging into the
database with your user/passwd via the command line and see if you can
get in.

Wendall

On Fri, 2004-11-19 at 10:28 -0500, Ruben Fagundo wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I have what should be a very simple problem, but I just have not been 
able to figure this out.

I wanted to move a PHP Website site to another machine, and I dumped the 
database, and copied all the files. I placed everything in the same 
directory structure as the original setup.

I have the same logins for MySQL on both boxes, and I created a 2nd 
level domain name to the new box, but every time I try and access the 
2nd box, I get this message.

Unable to load database indicated by configuration file.

The databases have exactly the same name. So, what am I doing wrong in 
trying to move this web site to a new box ? I must be missing something 
simple ? Any suggestions on where to start debugging this. I'm not 
seeing any useful errors in the apache log files. I'm running MySQL 4 on 
both boxes. Old box is Redhat 9 and new box is Fedora C 2

Thanks for your help,
Ruben





-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. <a class="moz-txt-link-abbreviated" href="http://www.intersystems.com/match8">www.intersystems.com/match8</a>
_______________________________________________
Phpwebsite-developers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Php...@li...">Php...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers">https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers</a>
    </pre>
  </blockquote>
  <pre wrap=""><!---->


-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. <a class="moz-txt-link-abbreviated" href="http://www.intersystems.com/match8">www.intersystems.com/match8</a>
_______________________________________________
Phpwebsite-developers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Php...@li...">Php...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers">https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers</a>


  </pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Ruben Fagundo
NPV Corporation

Tel: 617-848-0890 x100
Fax: 617-249-1994


</pre>
</body>
</html>

Re: [Phpwebsite-developers] Moving PHP Website to another machine

From: Scott S. <sc...@ha...> - 2004-11-22 18:43:07

>That's the problem. I can login to the db just fine from the command line.

Another thing to check - do you have the php/mysql libraries 
installed on your machine?  Without them, phpWebsite can look correct 
but will not connect to the server.

On Redhat, Fedora or other rpm based linux you need the package php-mysql

rpm -qi php-mysql


will tell you if it's installed.


Had the same problem happen, everything fine on the command line, 
but when I ran phpwebsite just wouldn't connect, and the solution was 
I didn't have the php-mysql libraries installed.


Scott




-- 
--
Scott Sherrill
Technology Coordinator Hancock Public Schools
Hancock, MI
http://www.hancock.k12.mi.us

Re: [Phpwebsite-developers] Moving PHP Website to another machine

From: Shaun M. <sh...@ae...> - 2004-11-22 18:59:46

On 22 Nov 2004, at 18:42, Scott Sherrill wrote:

>> That's the problem. I can login to the db just fine from the command 
>> line.
>
> Another thing to check - do you have the php/mysql libraries installed 
> on your machine?  Without them, phpWebsite can look correct but will 
> not connect to the server.

It's not uncommon that a particular OS distribution or version of PHP 
doesn't have MySQL built in to PHP. Could be that you'll need to 
recompile PHP. IIRC PHP5 may not have MySQL built in.

Ruben, have a look at http://www.yoursite.com/setup/phpinfo.php and 
check that MySQL is there and that you're running the same setup as the 
server that works.

Shaun
aegis design - http://www.aegisdesign.co.uk