BOSI2 setup question

deuelz · 01-17-2005, 02:30 PM

Ive reached the point in the installation where you sign as admin with the password of admin. When I do this, i get this message:

Error: No Database Selected trying to read user/pass dbuser = DBUSER

I know I created a DB during the installation so im not real sure on how to continue. If anyone has any ideas, let me know.

Thanks,
Zach

Mr.Opinion · 01-17-2005, 02:31 PM

Are you trying to set this up on a webserver or a personal machine?

deuelz · 01-17-2005, 03:28 PM

A webserver.

DaveHorn · 01-17-2005, 05:13 PM

Sounds like you forgot to modify the constants.inc file.

deuelz · 01-17-2005, 05:53 PM

I checked the constants.inc file and I did modify it, along with the header.inc file. Im going to try and poke around some more too see if I can figure it out. Let me know if you all have any more ideas.
Thanks.

DaveHorn · 01-17-2005, 05:56 PM

It doesn't report the line number or file or anything when you get the error?

deuelz · 01-17-2005, 06:02 PM

No, when i get to the admin page, and put in the password and login as admin I get that error.

I dont know squat about programing, but when i created the data base in step 2 or 3 of the installation process, wouldnt i need to upload that to the server or is it already there. I just looked for it in the file manager and couldnt find it. I checked the installation instructions again, and it doesnt say anything about uploading the data base you create (the one with the tables.sql script). So maybe i messed up there. Could this be the problem?

DaveHorn · 01-17-2005, 06:17 PM

Did you create the database using phpMyAdmin from your browser? Assuming you did then you already created it on the server.

Can you view your database using phpMyAdmin or whatever tool your host supplies?

deuelz · 01-17-2005, 06:23 PM

Yes database was created using phpMyAdmin. The database is there under phpMyAdmin, but i dont know where it is when I went to look for it using the file manager.

DaveHorn · 01-17-2005, 06:44 PM

Its not a single file. Its a collection of files that are all managed through MySQL and assuming you are on a shared host, you likely don't have access to their location. If you can see and access the database through phpMyAdmin then that part is fine.

You double checked and made sure you editing the constants file to include the full info for all 4 following variables?

$DBHOST =
$DBNAME =
$DBUSER =
$DBPASSWORD =

deuelz · 01-17-2005, 06:51 PM

I think thats it. I didnt change the database host. I'll try that and see what happens. Thanks for all the suggestions and info Dave. I really appreciate it.

Zach

DaveHorn · 01-17-2005, 07:10 PM

Just a note, sometimes localhost works, but sometimes you need to be more specific it dependent upon your host. They should have that info in within your Control Panel or whatever tool you host uses to set manage your account. Look around where you set up the database in your control panel if you can figure it out.

deuelz · 01-17-2005, 07:14 PM

Yeah, localhost didnt work, so i will look around and try a few different things. Thanks again for the help.

deuelz · 01-17-2005, 07:52 PM

localhost is the right host, but still cant get it to work. I think im going to go back to the beginning and try it again. Hopefully its something else.

deuelz · 01-18-2005, 01:53 AM

Update, I tweak a few things and now this is the error i get at the admin screen:

Error: No Database Selected trying to read user/pass dbuser = bosi2

Any late nighters out there have any thoughts?

deuelz · 01-18-2005, 05:19 AM

Finally figured it out. I got into the admin page and im off and runnig. Thanks again for those that helped me along the way.

DaveHorn · 01-18-2005, 10:01 AM

What was the problem duelz. It will help the next person who stumbles into the same thing, does a search, think they found it, only to look at the end of the thread with no answers.

Plus I'm curious.

deuelz · 01-18-2005, 02:59 PM

It was simply that I didnt put in the right database name and user name. For some reason, I assumed the didnt use the prefix of your cpanel username. Say I create the db and username bosi and cpanel name is frank. I should have been using frank_bosi as my db and user names. Instead I was just using bosi. So when it went to go look for the database, it couldnt find it. I know, a rookie mistake, but im learning slowly but surely.

01-17-2005, 02:30 PM	#1
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	BOSI2 setup question Ive reached the point in the installation where you sign as admin with the password of admin. When I do this, i get this message: Error: No Database Selected trying to read user/pass dbuser = DBUSER I know I created a DB during the installation so im not real sure on how to continue. If anyone has any ideas, let me know. Thanks, Zach

01-17-2005, 02:31 PM	#2
Mr.Opinion All Star Reserve Join Date: May 2003 Location: SkiFree Lodge Posts: 883	Are you trying to set this up on a webserver or a personal machine? __________________

01-17-2005, 05:13 PM	#4
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Sounds like you forgot to modify the constants.inc file. __________________ Dave HFTC Commish

01-17-2005, 05:56 PM	#6
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	It doesn't report the line number or file or anything when you get the error? __________________ Dave HFTC Commish

01-17-2005, 06:17 PM	#8
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Did you create the database using phpMyAdmin from your browser? Assuming you did then you already created it on the server. Can you view your database using phpMyAdmin or whatever tool your host supplies? __________________ Dave HFTC Commish Last edited by DaveHorn; 01-17-2005 at 06:18 PM.

01-17-2005, 03:28 PM	#3
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	A webserver.

01-17-2005, 05:53 PM	#5
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	I checked the constants.inc file and I did modify it, along with the header.inc file. Im going to try and poke around some more too see if I can figure it out. Let me know if you all have any more ideas. Thanks.

01-17-2005, 06:02 PM	#7
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	No, when i get to the admin page, and put in the password and login as admin I get that error. I dont know squat about programing, but when i created the data base in step 2 or 3 of the installation process, wouldnt i need to upload that to the server or is it already there. I just looked for it in the file manager and couldnt find it. I checked the installation instructions again, and it doesnt say anything about uploading the data base you create (the one with the tables.sql script). So maybe i messed up there. Could this be the problem?

01-17-2005, 06:23 PM	#9
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	Yes database was created using phpMyAdmin. The database is there under phpMyAdmin, but i dont know where it is when I went to look for it using the file manager.

01-17-2005, 06:44 PM	#10
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Its not a single file. Its a collection of files that are all managed through MySQL and assuming you are on a shared host, you likely don't have access to their location. If you can see and access the database through phpMyAdmin then that part is fine. You double checked and made sure you editing the constants file to include the full info for all 4 following variables? $DBHOST = $DBNAME = $DBUSER = $DBPASSWORD = __________________ Dave HFTC Commish

01-17-2005, 06:51 PM	#11
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	I think thats it. I didnt change the database host. I'll try that and see what happens. Thanks for all the suggestions and info Dave. I really appreciate it. Zach

01-17-2005, 07:10 PM	#12
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Just a note, sometimes localhost works, but sometimes you need to be more specific it dependent upon your host. They should have that info in within your Control Panel or whatever tool you host uses to set manage your account. Look around where you set up the database in your control panel if you can figure it out. __________________ Dave HFTC Commish

01-17-2005, 07:14 PM	#13
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	Yeah, localhost didnt work, so i will look around and try a few different things. Thanks again for the help.

01-17-2005, 07:52 PM	#14
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	localhost is the right host, but still cant get it to work. I think im going to go back to the beginning and try it again. Hopefully its something else.

01-18-2005, 01:53 AM	#15
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	Update, I tweak a few things and now this is the error i get at the admin screen: Error: No Database Selected trying to read user/pass dbuser = bosi2 Any late nighters out there have any thoughts?

01-18-2005, 05:19 AM	#16
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	Finally figured it out. I got into the admin page and im off and runnig. Thanks again for those that helped me along the way.

01-18-2005, 10:01 AM	#17
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	What was the problem duelz. It will help the next person who stumbles into the same thing, does a search, think they found it, only to look at the end of the thread with no answers. Plus I'm curious. __________________ Dave HFTC Commish

01-18-2005, 02:59 PM	#18
deuelz Minors (Triple A) Join Date: Nov 2004 Location: Redlands, CA. Posts: 271	It was simply that I didnt put in the right database name and user name. For some reason, I assumed the didnt use the prefix of your cpanel username. Say I create the db and username bosi and cpanel name is frank. I should have been using frank_bosi as my db and user names. Instead I was just using bosi. So when it went to go look for the database, it couldnt find it. I know, a rookie mistake, but im learning slowly but surely.