Page 1 of 1
Database host address [solved]
Posted: Wed Dec 20, 2006 4:54 pm
by jabberwocky
Hi,
I am putting CMSMS on a friends server and he has given me an address for the phpmyadmin like;
www.something/phpmyadmin
however, the url I am ftping all the install files and goodies to is
www.totalydifferent.com
so in the phpmyadmin it says the server is 'localhost' which im guessing is the database host address? So im not to sure what to put in the field for step 4 for the Database host address. Does that make any sense? I probably just don't understand what the database host address is. Any help would be appreciated.
Cheers
Re: Database host address
Posted: Wed Dec 20, 2006 6:20 pm
by Dee
Hi,
The database host address is the (network adress) of the database server.
Usually this is the same as the webserver running the site, in that case you can fill in localhost.
Only if the database runs on a different/seperate server (than the webserver) it should be changed to the network address (name or IP address) of the database server.
Regards,
Dee
Re: Database host address
Posted: Thu Dec 21, 2006 12:56 am
by jabberwocky
hmm, well im still not getting any love. i have tried putting in 'localhost' in the field, and have created several users with full access to the database.
so i tried using a simple connection script, using localhost, my login/password, and it keeps saying it could not connect to the mysql.
test script
Code: Select all
<?
// hostname or ip of server
$servername='localhost';
// username and password to log onto db server
$dbusername='test;
$dbpassword='test11';
// name of database
$dbname='mydb_name';
////////////// Do not edit below/////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?>
Re: Database host address
Posted: Thu Dec 21, 2006 1:06 am
by jabberwocky
Ok, my problem was as it turns out my brain.
got through the install but now im faced with blank pages. I can log into the admin however and around the admin sections, just cant view the site itself.
using the latest version of CMSMS 1.0.2
MySQL 4.1.10a
phpMyAdmin 2.6.3-pl1
any suggestions?
Re: Database host address
Posted: Thu Dec 21, 2006 1:12 am
by Dee
Anything in the server (error) logs? What if you turn on debugging in config.php?
First guess is PHP's memory_limit is set to (the default) 8M and PHP runs out of memory.
Re: Database host address
Posted: Thu Dec 21, 2006 1:27 am
by jabberwocky
right, i just found a thread talking about that and turned it on. got the following result;
Code: Select all
Debug: (3.9000000000004E-05) - (668176)
loading smarty
Debug: (0.013731) - (963080)
loading adodb
Debug: (0.017436) - (1033448)
loading page functions
Debug: (0.027007) - (1233448)
loading content functions
Debug: (0.035158) - (1430136)
loading pageinfo functions
Debug: (0.037282) - (1462848)
loading translation functions
Debug: (0.038671) - (1480528)
loading events functions
Debug: (0.043127) - (1586104)
done loading files
Debug: (0.073718) - (2317552)
<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.081254) - (2365808)
<br>
(mysql): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.136355) - (2838424)
<br>
(mysql): SELECT * FROM cms_modules ORDER BY module_name<br>
Error (0): <br>
Debug display of 'End of include':(0.202909) - (4161136)
Debug: (0.203387) - (4116192)
Session found. Moving on...
Debug: (0.203626) - (4116320)
Session found. Moving on...
Debug display of 'Load Content Operations':(0.231413) - (4736240)
Debug display of 'End Load Content Operations':(0.251847) - (5225552)
Debug: (0.252375) - (5228856)
Session found. Moving on...
Debug: (0.254171) - (5230168)
<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
Error (0): <br>
Debug: (0.257087) - (5232624)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.269385) - (5451984)
<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '17'<br>
Error (0): <br>
Debug: (0.270677) - (5456496)
load properties called
Debug: (0.272373) - (5458304)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.274195) - (5518296)
Session found. Moving on...
Debug: (0.275977) - (5518656)
<br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.276901) - (5519368)
Session found. Moving on...
Debug: (0.28107) - (5603480)
Session found. Moving on...
Debug: (0.284287) - (5606104)
<br>
(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '1'<br>
Error (0): <br>
Debug: (0.288428) - (5626976)
Session found. Moving on...
Debug: (0.289774) - (5627992)
Session found. Moving on...
Debug: (0.290907) - (5628488)
Session found. Moving on...
Debug: (0.293465) - (5638688)
Session found. Moving on...
Debug: (0.295685) - (5643112)
Session found. Moving on...
Debug: (0.303491) - (5733256)
<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.305494) - (5733960)
<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = 1<br>
Error (0): <br>
Debug: (0.307716) - (5736024)
<br>
(mysql): SELECT content_id FROM cms_additional_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.34574) - (5845064)
<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
Error (0): <br>
Debug: (0.364444) - (5875152)
Session found. Moving on...
Debug: (0.364879) - (5875056)
get all content...
Debug: (0.36759) - (5874968)
<br>
(mysql): SELECT * FROM cms_content ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.388117) - (5883392)
Session found. Moving on...
Debug: (0.388904) - (5883520)
Session found. Moving on...
Debug: (0.389238) - (5883600)
Session found. Moving on...
Debug: (0.389537) - (5884080)
Session found. Moving on...
Debug: (0.38981) - (5884160)
Session found. Moving on...
Debug: (0.390076) - (5884232)
Session found. Moving on...
Debug: (0.390358) - (5884312)
Session found. Moving on...
Debug: (0.390634) - (5884392)
Session found. Moving on...
Debug: (0.390901) - (5884472)
Session found. Moving on...
Debug: (0.393082) - (5884920)
<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates ORDER BY template_name<br>
Error (0): <br>
Debug: (0.395435) - (5885232)
load properties called
Debug: (0.397146) - (5885120)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.397985) - (5885552)
Session found. Moving on...
Debug: (0.408731) - (5996048)
<br>
(mysql): SELECT user_id, username, password, first_name, last_name, email, active, admin_access FROM cms_users ORDER BY username<br>
Error (0): <br>
Debug: (0.410621) - (5996840)
<br>
(mysql): SELECT user_id, username, password, first_name, last_name, email, active, admin_access FROM cms_users ORDER BY username<br>
Error (0): <br>
Debug: (0.412221) - (5997104)
<br>
(mysql): SELECT user_id FROM cms_additional_users WHERE content_id = '15'<br>
Error (0): <br>
Re: Database host address
Posted: Fri Dec 22, 2006 12:44 am
by jabberwocky
My info is as;
PHP Version 5.0.3,
Apache 2.0,
CMSMS 1.01
I did have the newest version of CMSMS, but since I have had problems, I went back to the version I had working on my server. The problem is, I'm tranferring to another server, from mine, and after a succesful intsall, the site shows up as blank. I can log into the admin sections and view those pages fine. The preview panel also shows nothing.
I have tried an .htacess mem increase to 16meg ( the server is currently defaulted to 8m) and put that in my root folder of the site, but didnt work.
I did double checked permissions for the required files and dirs, but they all are set correctly (to 777).
The tmp cache is cleared.
Here is the debug info
Code: Select all
Debug: (3.9000000000011E-05) - (667952)
loading smarty
Debug: (0.01387) - (962856)
loading adodb
Debug: (0.017635) - (1033144)
loading page functions
Debug: (0.02662) - (1233216)
loading content functions
Debug: (0.034813) - (1429904)
loading pageinfo functions
Debug: (0.036938) - (1462616)
loading translation functions
Debug: (0.038305) - (1480296)
loading events functions
Debug: (0.042787) - (1585872)
done loading files
Debug: (0.073477) - (2315344)
<br>
(mysqli): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.081011) - (2363776)
<br>
(mysqli): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.135577) - (2834960)
<br>
(mysqli): SELECT * FROM cms_modules ORDER BY module_name<br>
Error (0): <br>
Debug display of 'End of include':(0.202172) - (4152496)
Debug: (0.202654) - (4107552)
Session found. Moving on...
Debug: (0.202884) - (4107680)
Session found. Moving on...
Debug display of 'Load Content Operations':(0.230931) - (4727720)
Debug display of 'End Load Content Operations':(0.251391) - (5216952)
Debug: (0.25192) - (5220256)
Session found. Moving on...
Debug: (0.253661) - (5221576)
<br>
(mysqli): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
Error (0): <br>
Debug: (0.256486) - (5224032)
<br>
(mysqli): SELECT * FROM cms_content WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.269033) - (5443392)
<br>
(mysqli): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '17'<br>
Error (0): <br>
Debug: (0.270337) - (5447872)
load properties called
Debug: (0.272006) - (5449712)
<br>
(mysqli): SELECT * FROM cms_content_props WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.273842) - (5509720)
Session found. Moving on...
Debug: (0.27563) - (5510088)
<br>
(mysqli): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.276567) - (5510808)
Session found. Moving on...
Debug: (0.280719) - (5594872)
Session found. Moving on...
Debug: (0.283854) - (5597544)
<br>
(mysqli): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '1'<br>
Error (0): <br>
Debug: (0.288052) - (5618376)
Session found. Moving on...
Debug: (0.28939) - (5619392)
Session found. Moving on...
Debug: (0.290536) - (5619880)
Session found. Moving on...
Debug: (0.292936) - (5628528)
Session found. Moving on...
Debug: (0.295193) - (5633176)
Session found. Moving on...
Debug: (0.30314) - (5723464)
<br>
(mysqli): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.305101) - (5724176)
<br>
(mysqli): SELECT content_id FROM cms_content WHERE owner_id = 1<br>
Error (0): <br>
Debug: (0.30731) - (5726240)
<br>
(mysqli): SELECT content_id FROM cms_additional_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.34577) - (5835336)
<br>
(mysqli): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
Error (0): <br>
Debug: (0.364556) - (5865440)
Session found. Moving on...
Debug: (0.365003) - (5865344)
get all content...
Debug: (0.367672) - (5865248)
<br>
(mysqli): SELECT * FROM cms_content ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.391498) - (5873672)
Session found. Moving on...
Debug: (0.392278) - (5873800)
Session found. Moving on...
Debug: (0.392641) - (5873880)
Session found. Moving on...
Debug: (0.392925) - (5874360)
Session found. Moving on...
Debug: (0.393206) - (5874440)
Session found. Moving on...
Debug: (0.393492) - (5874520)
Session found. Moving on...
Debug: (0.39377) - (5874600)
Session found. Moving on...
Debug: (0.394041) - (5874672)
Session found. Moving on...
Debug: (0.394314) - (5874752)
Session found. Moving on...
Debug: (0.396916) - (5875200)
<br>
(mysqli): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates ORDER BY template_name<br>
Error (0): <br>
Debug: (0.399215) - (5875512)
load properties called
Debug: (0.400901) - (5875400)
<br>
(mysqli): SELECT * FROM cms_content_props WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.401742) - (5875832)
Session found. Moving on...
Debug: (0.412381) - (5986312)
<br>
(mysqli): SELECT user_id, username, password, first_name, last_name, email, active, admin_access FROM cms_users ORDER BY username<br>
Error (0): <br>
Debug: (0.414243) - (5987112)
<br>
(mysqli): SELECT user_id, username, password, first_name, last_name, email, active, admin_access FROM cms_users ORDER BY username<br>
Error (0): <br>
Debug: (0.415834) - (5987368)
<br>
(mysqli): SELECT user_id FROM cms_additional_users WHERE content_id = '15'<br>
Error (0): <br>
I'm not to sure what the Error (0) is but maybe this is showing the problem? Any help would be appreciated please!
Cheers
Re: Database host address
Posted: Fri Dec 22, 2006 1:16 am
by Dee
The Error (0) is good, it means no error.
To raise PHP's memory_limit you can also try
at the start of include.php.
Re: Database host address
Posted: Fri Dec 22, 2006 1:46 am
by jabberwocky
Hello,
I put that into the include.php file at the root of the site, but I'm still getting a blank page. However, now when I go to the admin panel I get this new message;
Debug is on. Redirecting disabled... Please click this link to continue.
http://www.sitename/admin/index.php
I can click on that and log in. the debug shows this now;
Code: Select all
Debug: (3.9000000000011E-05) - (559072)
loading smarty
Debug: (0.013979) - (854064)
loading adodb
Debug: (0.017827) - (924432)
loading page functions
Debug: (0.026988) - (1124432)
loading content functions
Debug: (0.03533) - (1321120)
loading pageinfo functions
Debug: (0.03749) - (1353832)
loading translation functions
Debug: (0.038896) - (1371512)
loading events functions
Debug: (0.043484) - (1477088)
done loading files
Debug: (0.074781) - (2206560)
<br>
(mysqli): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.08244) - (2254992)
<br>
(mysqli): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.137368) - (2726128)
<br>
(mysqli): SELECT * FROM cms_modules ORDER BY module_name<br>
Error (0): <br>
Debug display of 'End of include':(0.205146) - (4043664)
Debug: (0.205619) - (3998496)
Session found. Moving on...
Debug: (0.221502) - (4387488)
Session found. Moving on...
Debug: (0.223415) - (4388904)
<br>
(mysqli): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.224369) - (4390064)
Session found. Moving on...
Debug: (0.228511) - (4474704)
Session found. Moving on...
Debug: (0.231726) - (4477656)
<br>
(mysqli): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '1'<br>
Error (0): <br>
Debug: (0.235868) - (4498488)
Session found. Moving on...
Debug: (0.237189) - (4499504)
Session found. Moving on...
Debug: (0.238342) - (4500000)
Session found. Moving on...
Debug: (0.240776) - (4508648)
Session found. Moving on...
Debug: (0.243041) - (4513296)
Session found. Moving on...
Debug: (0.250908) - (4603760)
<br>
(mysqli): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.252885) - (4604344)
<br>
(mysqli): SELECT content_id FROM cms_content WHERE owner_id = 1<br>
Error (0): <br>
Debug: (0.255179) - (4606408)
<br>
(mysqli): SELECT content_id FROM cms_additional_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.292848) - (4714936)
<br>
(mysqli): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
Error (0): <br>
Debug: (0.295207) - (4700616)
<br>
(mysqli): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title<br>
Error (0): <br>
I have also contacted the Admin to see if he can increase the memory to 16megs or 32megs if possible. Any more suggestions at this point?
Re: Database host address
Posted: Fri Dec 22, 2006 1:55 am
by Dee
Redirection is disabled when you enable debugging, so every time you would normally get redirected you get that screen/link to continue. The debug looks fine as far as I can see.
When you get an all blank page, usually it's caused by PHP encountering a fatal error and PHP's display_errors being set to Off. Then you have to check your webserver logs for the actual cause/PHP fatal error message.
Re: Database host address
Posted: Thu Dec 28, 2006 2:55 pm
by jabberwocky
Thanks for you help Dee
as it turns out, and after a long argument with the server admin as to wether I could have access to view the error logs or not, it was tokenizer that was not installed. once installed everything was good. Thanks again for your help!
Re: Database host address
Posted: Thu Dec 28, 2006 6:17 pm
by Dr.CSS
So this is [solved] ? please amend your first posts subject line... thanx
