Upon first install, on the "connection information," "Database connection and login information" screen, for database login name and password, i input the user name and pass I use to login to my hosting account. It gives me the " Connecting to mysql server: Success! " ok, and then the connection character set option, but when i try to click "Create or test selection of your database," nothing happens. Nothing at all. I can’t go further.
Please help!
Thanks.
Revolution 2.0.2-pl Traditional
Operating system Linux
MySQL version 5.0.91-community
Apache version 2.2.13
PHP version 5.2.11
Some hosts don’t allow you to create a DB in code so MODx fails to create one during Setup. If that’s the case, you’ll have to create the DB yourself in PhpMyAdmin. Be sure to make a note of the database name of the new DB -- it may not be what you entered because some hosts will add a prefix to it.
After you’ve done that, run Setup again and be sure to enter the correct name of the DB.
It’s still not working. I created a database and input the name. Interestingly, both the DB user name and pass, as well as the hosting user name and pass give me the green light: " Connecting to mysql server: Success! " but under neither can I click "Create or test selection of your database." The text comes up as a link, but when I click on it nothing happens.
Did you put "localhost" in the Database Host field -- that’s the normal value.
If so, the only things left that I can think of are: your host uses a different name or port or there’s a mismatch or misconfiguration in the PHP/MySQL setup at the host.
I think character encoding trouble might also be a possibility if your DB is not consistent with respect to charsets.
Permissions are also a recurring problem, but usually MODx will detect that. Make sure your core/config directory is writeable and create an empty, writable core/config/config.inc.php file if there’s not one there already.
Bob,
I uploaded Revolution to a different hosting provider and was surprised to see that, although I had it on the previous server, the config.inc.php file was not there. I created a database, grabbed the aforementioned file off the old server, and voila! Core installation complete.
Additionally, this has allowed me to find out why it wasn’t working on the first server. The second server had me input ’mysql.mydomainname.com’, whereas the second server wanted ’localhost.’
The first server, for user name, wanted ’domain-username_database-username’ and (here’s where it was tripping me up) for database name, wanted ’domain-username_database-title.’
The second server didn’t want the domain-username prefix as part of the whole database username and title. I figured out what the first server wanted by manually setting up a mysql database and looking at what the server called the user name and database name.
So thanks a lot! Oh, and one more question. Should I change the core/cache and core/config folders back to 755?
MODX Staff