Joomla Cannot Connect to Mysql - Joomla! Forum - community, help and support


i making local copy of joomla installation on company server.

i have copied files server , did db dump.

i have win xp box running apache 2.2.x, php 5+ , mysql 5.0+.

i have mirrored server as possible in terms of setup , post .htacess , httpd.config vars later if need be.

i copied joomla folder local web root. installed database.

the error getting :

unable connect database:could not connect mysql

i have adjusted configuration.php files fit new database setup etc. no luck!

i have made test.php file connects database same database variables have in configuration.php. test.php connects fine , prints out query results.

code: select all

<?php

$db = mysql_connect("localhost","mcondiff","sunshine") or die ('unable connect database!');
mysql_select_db("newiwebdb");

$query = "select * jos_content limit 0 , 30";
$results = mysql_query($query);
while($row = mysql_fetch_assoc($results)){
   echo '<br>'.$row['title'];
}

?>


version of joomla version 1.5.10.

this part .htaccess

rewritecond %{query_string} mosconfig_[a-za-z_]{1,21}(=|\%3d) [or]
rewritecond %{query_string} base64_encode.*\(.*\) [or]
rewritecond %{query_string} (\<|%3c).*script.*(\>|%3e) [nc,or]
rewritecond %{query_string} globals(=|\[|\%[0-9a-z]{0,2}) [or]
rewritecond %{query_string} _request(=|\[|\%[0-9a-z]{0,2})
rewriterule ^(.*)$ index.php [f,l]

#rewritebase /

########## begin - joomla! core sef section
#
rewritecond %{request_filename} !-f
rewritecond %{request_filename} !-d
rewritecond %{request_uri} !^/index.php
rewritecond %{request_uri} (/|\.php|\.html|\.htm|\.feed|\.pdf|\.raw|/[^.]*)$ [nc]
rewriterule (.*) index.php
rewriterule .* - [e=http_authorization:%{http:authorization},l]


my question here doing wrong. copied joomla instance , made local fine. 1 can't seem talk mysql though test.php can exact same db variables host, db, user, pass etc.

the joomla instance behind ssl on server, i'm not sure how should matter locally. matter?

any insight tremendous. can post other information have in terms of httpd.conf etc.

does server have name? try using instead of "localhost".





Comments

Popular posts from this blog

Hur installera Joomla på One.com - Joomla! Forum - community, help and support

removing index.php from URL address - Joomla! Forum - community, help and support

「イメージマップのアンカー名には、...」のエラーが出ないようにしたい