Error With Database
|
Posted
#36752
(In Topic #8291)
|
|
|---|---|
|
Non-joined user |
ocPortal errorCould not connect to database (Unknown database 'junta')Details here are intended for the website/system-administrator, not for regular website users. If you are a regular website user, please let the website staff deal with this problem. Depending on the error, you may need to edit the base configuration (the info.php file). ocProducts maintains full documentation for all procedures and tools. These may be found on the ocPortal website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you. |
|
|
|
Posted
|
|
Community saint |
you may need to makre sure you are typing in the database name correctly. If you have cpanel it will be like this. username_junta I run Otaku Play Ground and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
|
|
|
|
|
Posted
|
|
ocStaff (admin) |
However, there may be a more basic issue- have you created your database? The installer doesn't create the database, it installs to an existing database that you tell it about. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
|
|
|
|
Posted
|
|
|
Non-joined user |
name: junta (this is the database name I'm assuming) DSN (or "hostname"): junta.db (it says to never use "localhost" Default admin username: newprussia When i enter in the ocportal settings it seems to be accepting the fields i enter for database host, database username, and even database password, but the error seems to be coming from the first field, which is database name. |
|
|
|
|
Posted
|
|
|
ocStaff (admin) |
Anyway, this might be related to this cpanel naming thing Ami said. However, it also could be the server name was given wrong, because if it was connecting to the wrong database server it stands to reason your database wouldn't be on it, thus the error. If you followed their advice though, that shouldn't be the case. If you're still stuck it might be a good idea to ask your webhost if the details you're putting in are correct and give them the error you see. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
|
|
|
|
Posted
|
|
Community saint |
I am attempting a new install of the newest version, and am experiencing the same error message. I just initiated a new vps account and lost the old site. When I checked the info.php file to see if it needed modification I discovered that it is empty. Sorry for asking for help on this again, but it was a year ago when I last encountered this problem…first install. BTW, the prefix and underscore are correct, so is everything else…just checked the MySQL db to be sure. Any help would be greatly appreciated. |
|
|
|
|
Posted
|
|
|
Community saint |
|
|
|
|
|
Posted
|
|
Community saint |
How can I help?
Take my advice. I'm not using it!
View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal |
|
|
|
|
Posted
|
|
|
Community saint |
I have checked the db information closely and it is correct, so the error has to be someplace else. I can't figure out what I am doing wrong. BTW, how is everything going at your site. I dropped by to take a look about a month ago…very impressive!!! 
|
|
|
|
|
Posted
|
|
|
Community saint |
If this helps, my Apache version is 2.2.6, my php is 5.2.4, and the MySQL is 5.0.27. 
Last edit: by psydoc
|
|
|
|
|
Posted
|
|
|
ocStaff (admin) |
The installer will try to connect to the database before it writes out the config file. The config file is intentionally created as blank by an earlier step. So we can be certain this isn't a permission or config file issue. I've traced through the installation code and the error you're seeing (unknown database) is verbatim from mySQL. I'd double check you're trying to connect to the correct mySQL server, and also that the database name given is accurate (no missing prefixes etc). Another more possibility not mentioned in this topic so far is that your server could have a bit of schizophrenia. When you specify 'localhost' to connect to mySQL, the connection is made via the 'socket file'; whilst if you specify the IP address of your own machine, it'll connect via a TCP/IP socket. It is possible your machine could have two mySQL's installed on it, and you might need to give the IP address to get the right one. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
|
|
|
|
Posted
|
|
|
Community saint |
I did think that the config file was intentionally blank, but I wondered if maybe it could be modified to skip this step? That is a good idea…to check if I am trying to connect to the correct database. The prefix is exact and the spelling is also correct; but, as this is a new host, I can't be sure about the existence of more than one…I do know that the config on this server allows for php 4 or 5. Maybe it also allows for local or remote sql. I will open a ticket at the host. When you mention the IP, is that in place of "localhost"? I think I follow, but I have never used the config this host uses. I always kept it simple with my servers. |
|
|
|
|
Posted
|
|
|
Community saint |
I think your problem is best left within Chris' remit, but I shall keep up with the posts. Interested.
Take my advice. I'm not using it!
View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal |
|
|
|
|
Posted
|
|
|
Community saint |
I wish I had the means to contribute to them all, but alas, I don't have that much in the way of discretionary funds.  |
|
|
|
|
Posted
|
|
|
Community saint |
I carry several pairs of gloves and a winter coat to give to people every winter. The small amount of good I can do is always returned many times over in just knowing that I was able to help someone worse off than I. Bless you and yours! Keith Have a good night! |
|
|
|
|
Posted
|
|
|
Community saint |
At the risk of repeating myself, that is an amazingly generous donation, especially for folks you don't know, nor have any connection to. But they're 'needy' folks, and I am sure many blessings will be coming your way on Christmas Day. Be Happy!
Take my advice. I'm not using it!
View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal |
|
|
|
1 guests and 0 members have just viewed this: None
Control functions: