By Jadler2 on

I just removed all my old files from Drupal 5.x off of my 1and1 host's server. Then I placed in the new 6.x install files in order to update. I figured this would remove all my old stuff and start me with a clean slate. However, I can't figure out what is going on with my attempt.

I have a MySQL database version 5.0 set up using phpMyAdmin. This is the standard tool 1and1 gives you to work with.

I placed everything from the tar.gz install of Drupal 6.x into the web host's root folder. (BTW if someone has links to good FTP tutes it would be helpful) 1and1 has a terrible FTP client thing that forces you to select each file by hand. I have FileZilla but I never used it before.

This is the error I get.

Site off-line

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: Access denied for user 'dbo250525413'@'74.208.16.203' (using password: YES).

Help? Tips? Please be simple too, web design is my side gig so terms sometimes get me.

⋅ Categories: Drupal 6.x

Comments

Jadler2’s picture

Jadler2 commented

5) changed line 92 in the file ".../drupal/sites/default/default.settings.php" from $db_url = 'mysql://username:password@localhost/databasename'; to $db_url = 'mysql://dbo********1:*******@db***.perfora.net/db********1'; (inserting the correct information from the database configuration). I saved the files as settings.php and uploaded it to the correct folder on the server.

I did that and now I get this.....

Warning: Table 'db289248591.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('68.74.65.228') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128

Warning: Table 'db289248591.users' doesn't exist query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'd3e1ddc05b6861a8e5ec2d008602df4e' in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /homepages/46/d245590697/htdocs/includes/database.mysql.inc:128) in /homepages/46/d245590697/htdocs/includes/bootstrap.inc on line 1031

Warning: Table 'db289248591.cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128

Warning: Table 'db289248591.variable' doesn't exist query: SELECT * FROM variable in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128

Warning: Table 'db289248591.cache' doesn't exist query: UPDATE cache SET data = '', created = 1245051038, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128

Warning: Table 'db289248591.system' doesn't exist query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /homepages/46/d245590697/htdocs/includes/database.mysql.inc:128) in /homepages/46/d245590697/htdocs/includes/bootstrap.inc on line 630

Warning: Cannot modify header information - headers already sent by (output started at /homepages/46/d245590697/htdocs/includes/database.mysql.inc:128) in /homepages/46/d245590697/htdocs/includes/bootstrap.inc on line 631

Warning: Cannot modify header information - headers already sent by (output started at /homepages/46/d245590697/htdocs/includes/database.mysql.inc:128) in /homepages/46/d245590697/htdocs/includes/bootstrap.inc on line 632

Warning: Cannot modify header information - headers already sent by (output started at /homepages/46/d245590697/htdocs/includes/database.mysql.inc:128) in /homepages/46/d245590697/htdocs/includes/bootstrap.inc on line 633

Warning: Table 'db289248591.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in /homepages/46/d245590697/htdocs/includes/database.mysql.inc on line 128
ashish.cms’s picture

ashish.cms commented

Hi Jadler2

Please upload drupal tables in your database. If you have already installed anywhere or it is new installation of drupal, then please replace from
$db_url = 'mysql://dbo********1:*******@db***.perfora.net/db********1'; to
$db_url = 'mysql://username:password@localhost/databasename';

Also give full permission(777) for "settings.php". After that you can run your site in browser and it'll go to install.php file and give all database information there.

drcheers’s picture

drcheers commented

i have the SAME exact error as him and when I reset everything i get this after entering my mySQL info:

Warning: fopen(./sites/default/default.settings.php) [function.fopen]: failed to open stream: No such file or directory in /homepages/17/d*********/htdocs/includes/install.inc on line 188

Warning: Cannot modify header information - headers already sent by (output started at /homepages/17/d*********/htdocs/includes/install.inc:188) in /homepages/17/d*********/htdocs/includes/install.inc on line 618

Warning: Cannot modify header information - headers already sent by (output started at /homepages/17/d*********/htdocs/includes/install.inc:188) in /homepages/17/d*********/htdocs/includes/install.inc on line 619

ashish.cms’s picture

ashish.cms commented

Please ensure you have followed the Drupal installation instructions properly. To check that, please visit the following link:

http://drupal.org/getting-started/install

vaobeheer’s picture

vaobeheer commented

In my case it had to do something with MySQL... tables crashed. Tried to repair it with;
mysqlcheck -u root -p*** --auto-repair --check --optimize --all-databases --extended

But that didn't help. I had to restore my backup.

56rosa’s picture

56rosa commented

I had the same error as well when I install a multisite configuration, and then I went to add the database name in the settings.php file, where it says sqli something.

And then, it worked OK for me.

satishmunigala’s picture

satishmunigala commented

igot same error how to solve it ,please tell mee

56rosa’s picture

56rosa commented

Hello,

Like I said above, I included the database names in the settings.php file
And then, I had no problem.

emfluence.subrata’s picture

emfluence.subrata commented

I am having the same problem.

1. I installed php on Ubuntu 14.04 using phpbrew and then switched to version 5.3.29. Reference I used http://askubuntu.com/questions/550191/install-php-5-4-on-ubuntu-14-04-lts-without-compiling.

2. When I run my site I am getting

Site off-line: We're offline due to technical difficulties. Check back soon!

3. When I connect mysql from CLI it connects fine (mysql -u root -p) and I I can list databases, use one of them and list tables in it.

4. I checked /var/log/apache2/error.log and /var/www/httpdocs/error.log and both are empty.

5. I created a simple PHP page to check database connectivity:

$servername = "localhost";
$username = "root";
$password = "";

$conn = mysql_connect($servername, $username, $password);

if($conn->connect_error){
	die ("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully";

When I run above page I get

"Fatal error: Call to undefined function mysql_connect() in /var/www/html/dbcon.php on line 6"

6. When I check my /var/log/apache2/error.log after running the above page I can see entries like:

Warning: PHP Startup: Unable to load dynamic library '/home/subrara/.phpbrew/php/php-5.3.29/lib/php/extensions/no-debug-non-zts-20090626/php_mysql.dll' - /home/subrara/.phpbrew/php/php-5.3.29/lib/php/extensions/no-debug-non-zts-20090626/php_mysql.dll: cannot open shared object file: No such file or directory in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library '/home/subrara/.phpbrew/php/php-5.3.29/lib/php/extensions/no-debug-non-zts-20090626/php_mysqli.dll' - /home/subrara/.phpbrew/php/php-5.3.29/lib/php/extensions/no-debug-non-zts-20090626/php_mysqli.dll: cannot open shared object file: No such file or directory in Unknown on line 0
...

[Wed Jun 29 15:18:55.658387 2016] [mpm_prefork:notice] [pid 4560] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.3.29 configured -- resuming normal operations [Wed Jun 29 15:18:55.658454 2016] [core:notice] [pid 4560] AH00094: Command line: '/usr/sbin/apache2' [Wed Jun 29 15:19:01.350978 2016] [:error] [pid 4563] [client ::1:52404] PHP Fatal error: Call to undefined function mysql_connect() in /var/www/html/dbcon.php on line 6

7. I tried to install mysql as an extension to php-5.3.29 using phpbrew ext install mysql but it ended up with a 404 (the download page could not be found). This is the error message I received:

Downloading https://pecl.php.net/rest/r/mysql/stable.txt via curl extension
CurlKit\CurlException: (22) The requested URL returned error: 404 Not Found at [https://pecl.php.net/rest/r/mysql/stable.txt:The requested URL returned error: 404 Not Found]

8. I might have tried to install mysql using sudo apt-get install mysql... but I wasn't sure (a) whether it will work as PHP was installed using phpbrew and (b) whether it will mess up already installed mysql and I have to start over from the scratch!

I am an absolute beginner in Linux and PHP world. Please suggest me a work around at your earliest. I am in real trouble and time is running out! :(

Thank you!