Install error after Green Bar

[two7design]

I get the green bar but when I click the install button I get a blank screen (other than wordpress sidebar) and this error. My DB name of course has been changed

Cannot open mysql://dbo000000000:Password1@localhost:/tmp/mysql5.sock/db000000000?new_link=true: DB Error: connect failed

[Donald Lobo]

and does the error message have the right string with user name / password etc for your DB.

Does your user name / password / db name have any non-alphanumeric characters in it? If so, might want to try removing them

lobo

[two7design]

Yes, the name, username and password are all correct. As I said before I get the green bars when I click re-check requirements, however when i click the install button it gives me that error.

[two7design]

Can no one answer this?

[Hershel]

The issue is /tmp/mysql5.sock I think. Remove that and if it fails, then set your php.ini to make the default port for mysql /tmp/mysql5.sock and then it should work.

[two7design]

Ok so I have tried everything I can think of. I created an .htacces file and php.ini file and nothing. I called 1and1 and they said there should be a file within the crm that I can adjust the default socket. There is no direct domain because I am on a dedicated server. The crm is obviously seeing the database because it gives me green bars, but when it goes to install something is not connecting properly. I appreciate all the help and hopefully we can fix this. FYI...i also installed on our GoDaddy hosting plan and it worked great. However I would like to get it on the dedicated server because it was just running to slow on GoDaddy

[Hershel]

Your host is wrong. Please see here:

http://php.net/manual/en/mysql.configuration.php

The mysql.default_socket directive has been in PHP since version 4.0, meaning for a few years already. If your host is not able to assist with a basic issue such as this, I would consider finding a more professional host.

[two7design]

Wanted to add a solution to this problem. I replaced the dsn code with this and fixed the problem

$dsn = array(
    'phptype'  => 'pgsql',
    'username' => 'someuser',
    'password' => 'apasswd',
    'hostspec' => 'localhost',
    'database' => 'thedb',
);

$options = array(
    'debug'       => 2,
    'portability' => DB_PORTABILITY_ALL,
);

$db =& DB::connect($dsn, $options);
if (PEAR::isError($db)) {
    die($db->getMessage());
}

[Conte01]

hey,

got the same issue and got no clue how to solve it.

all is green and then the error

any ideas?
thanks

[Hershel]

Can you copy and paste here the text of the error you see?

[Conte01]

here:

Cannot open mysql://dbuXXXXXXXX:XXXXXXXX@localhost/dbXXXXXXXXXXX?new_link=true: DB Error: connect failed

[Hershel]

Did you / can you ask your host for help?

[Conte01]

I dont think they can assist me.

the database works, civi says all green to go and the fail.
is definately a civi thing

had no problems on drupal and will like switch back if this already fails before installation

[Hershel]

I dont think they can assist me.

Well, if you don't ask them, then they for sure won't help you.

I would definitely suggest you ask them because the installer has been successfully used thousands of times so we know it works on a normal server setup. I am uncertain as to the true identity of your host as they are somewhat unlisted, but we anyhow have no data regarding your server and the various settings used so perhaps they have some unusual configuration options set and the installer is not expecting those. The installer can not account for every possible server configuration.

the database works, civi says all green to go and the fail.
is definately a civi thing

Based on what you wrote, the only idea I have is perhaps mysql vs mysqli is the issue.

Did you however, see what Lobo wrote above? Is that applicable?

[Conte01]

hey,

must have overread Lobos suggestion. It was the non-alphanumeric pasword.

still strange