TYPO3 Core

Seems like the database user does not have the right to write to the new database.

PS: Which PHP version do you use?

- Here is the exact string of the Apache config out of phpinfo:
Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.3
- again - the MySQL DB is created, I can see it in phpMyAdmin. Seems to be all tables are there, but they are empty.

Might be the problem is, when I like to work with the installer tool I've to give a user ID and Password from my former typo3 database - which is different to the default one?

My user has full access and admin rights (is admin of localhost).
Just for a try I added an user 'admin' with password 'password' via PhpMyAdmin - no success with install tool again....

This is the last entry in error.log of the apache server:
[Sun Oct 31 01:52:32 2010] [error] [client 127.0.0.1] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\\Dokumente und Einstellungen\\Birgit\\Eigene Dateien\\My Webs\\quickstart\\t3lib\\class.t3lib_db.php on line 1290, referer: http://localhost/quickstart/typo3/install/index.php?TYPO3_INSTALL[type]=database&mode=123&step=4

This ist the function where it has the problem (second line is lin 1290 in php file):
function admin_query($query) {
$res = mysql_query($query, $this->link);
if ($this->debugOutput) {
$this->debug('admin_query', $query);
}
return $res;
}

Sorry, gave a wrong info before (looked for the info at the wrong server)
Apache/2.2.6 (Win32) !
PHP/5.2.4 !

4YI:
Have tried meanwhile the following:
- First setup > Typo3 DB t3_quickstart is created, empty, registered user is the one I gave during setup (not the default one) with full admin rights
Add the default admin/password to the t3_quickstart with full admin rights (same user was already added to phpMyAdmin before)
- Run setup again (ENABLE_INSTALL_TOOL file in typo3conf created) using default admin/password setting and try to use the existing t3_quickstart (step 3), instead of new creation for the introduction package (step 4) download.
Was not successful again.
Seems to be, no userID and no password will be accepted at all by the tool?

Do I understand you correctly that you have set admin/password for the DB connection? I think that is your mistake.

Open the Install Tool (/typo3/install). Do not use the 1-2-3 mode.
Go to the page "Basic Configuration". Down that page there is the section "Check database:", which contains information about your DB Connection.
You should see:
- Connected to SQL database successfully
- Database: xyz is selected as database
Do you see headlines/sections with that text?

If there is an error somewhere, scroll down to "Update localconf.php" and fix the values for the connection, which you find in the first three fields.
I think the default values are something like:
- Username: root
- Password: (empty, nothing here)
- Host: 127.0.0.1

1) This is what I've got directly after unzip:
Check database:
Username, password or host not set
You may need to enter data for these values:
Username:
Host:

Use the form below.

Could not connect to SQL database!
Connecting to SQL database failed with these settings:
Username:
Host:
Make sure you're using the correct set of data.

2) this is what I've got after step 2 right before selecting 'introduction package (recommended): (I opened the install - tool in another window):
Check database:
Connected to SQL database successfully
Username: root
Host: localhost
No database selected
Currently you have no database selected.
Please select one or create a new database.

Write config to localconf.php:
Database not configured yet!
You need to specify database username, password and host as one of the first things.
Next you'll have to select a database to use with TYPO3.

Remark: I had to login at the first step with MY userid (root) and MY password (not empty!). It seems to be, this is used for the db connection correctly (see above), To login at the first step with root and no password was not working. Even not if I updated the localconf.php before...

For some reasons, after case 2) and having the install tool (not the 1-2-3 tool) opened in parallel, I get now the following error at last page:
No database selected.

After this error I was goning back to step 2 in the 1-2-3 tool to select the now existing, empty db t3_quickstart and tried to load introduction package again -> result is http Error 500.....

Having now a refresh at the Basic configuration I find everything is ok:
Check database:
Connected to SQL database successfully
Username: root
Host: localhost
Database
t3_quickstart is selected as database.

But when open http://localhost/quickstart I get again the error message:
No pages are found on the rootlevel!

What's going wrong here?

OK, so the settings for your database Username, Password and Host are correct.

Now choose a DB. Take an empty one.
Use the options in in "Basic Configuration" --> "Update localconf.php".
You must either enter the name in the field "Create Database?" or you can choose from the drop down list directly above where it says "Database".
After that you should see "Database: xyz is selected as database." in "Basic Configuration" in the section "Check database:".

(I still do not understand where you login at the first step, but it seems as if that login works.)

@ post number 0043410:
Great!

Was that DB completely empty before? I think you now have an empty TYPO3 Installation. If you want the Introduction Package you should delete all the tables with content (not the DB itself).
Then go to the Database Analyser and import introduction.sql (which should now work).

As you can see the db t3_quickstart is already selected (@ post 43410):
Username: root
Host: localhost
Database
t3_quickstart is selected as database.

The login I use is for the mySQL connection (as there are other db's in, which are to be managed, eg. by phpMyAdmin...)

This database is the on, which is created after step 2 of the 1-2-3 tool.
It contains 68 empty tables.
I'll try the option now to remove all tables, but leave the db there.
Give me a second....

Ok, import creates 26 tables (much less then 68!).
I do not receive an error, when open localhost/quickstart.
But .... ;-(( the root is now an empty page!
Luckily no error, but no content as well. The tab of the browser contains the title 'Introduction package: Welcome to Typo3....'.

The table pages got 50 entries, the table tt_content 156 entries.

This is the root-page source code, which is created by Typo3 (see section below). Might be the line
<base href="http://###HOSTNAME_AND_PATH###/&quot; />
causes the empty page. Shouldn't the marker not been replaced?

-------------------------------------------------------------------------------------------
page sorce:

<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml&quot; xml:lang="en" lang="en">
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<base href="http://###HOSTNAME_AND_PATH###/&quot; />
<link rel="shortcut icon" href="http://localhost/quickstart/&quot; />
<link rel="icon" href="http://localhost/quickstart/&quot; />
<title>Introduction Package: Welcome to TYPO3</title>
<meta name="generator" content="TYPO3 4.4 CMS" />
<meta name="description" content="This website is a default website setup for TYPO3. You can use it to demonstrate the basic features of the TYPO3 Content Management System, but you are also welcome to use it as a basis for your own website projects. Please have a look at how it works and how it is structured. In building this package, we have tried to combine a lot of best practices. Feel free to use these structures and use elements of it for your own way of working." />
<meta name="author" content="T3UXW09 / typo3.org" />
<meta name="keywords" content="typo3, introduction package, install, example setup" />
<meta name="revisit" content="7" />
<meta name="copyright" content="typo3.org GPL" />

<link rel="stylesheet" type="text/css" href="typo3temp/stylesheet_d3df03f0b8.css?1288743095" media="all" />

<script src="typo3temp/javascript_26e79dba8d.js?1288743095" type="text/javascript"></script>

<meta name="robots" content="noindex,follow" />
</head>
<body class="hideLeftColumn">

</body>
</html>

OK, I did not develop the Introduction Package, but now we know: It cannot be installed that way. I think you must use the 1-2-3 mode of the Install Tool. Everything else will cause further problems...

So I would again empty the DB, start the Install Tool in 1-2-3 mode and try to complete it. Now you know the data for Database Username, Password, Host and the name of the database. Leave them unchanged (meaning set it to the values you use now). Then set name and password for the admin user, add the tables and choose the colours and ... pray.

If I look at comment 0043328 I'd say: Try increasing your max_execution_time, 30 seconds is a bit too low. I usually have it at 120 - 180 on my development environments.

Hi Chris and Susi, thanks a lot for your effort. Susannes hint was the breaking leverage! I set the max_execution_time to 180 and it works fine.
Anyway, I learned a lot of typo3 configuration, while running through this issues. I'm sure this will help a lot, when I will setup the typo3 at the real server.
Thanks for your patience!
I'm happy and you can close this issue.

I just overread this information between all the other stuff.

However, closed as requested.