MySQL Forums
Forum List  »  General

Database Access Error
Posted by: Cyber identity
Date: October 28, 2004 07:34PM

I am the ultra newb, currently ready SQL for dummies, its helping.

I need some definate answers on a few questions i hope someone can help me.

My enviroment is

Windows 2k server, SP4
latest PHP installer
Latest My SQL installer
latest Phpbb package
Personally Hosted

I have tried searching through the phpbb and Mysql forums but have not found this specific error.

The default database to my understanding Mysql creates is called

ibdata1

====

This is the output from the Mysql --console when running for the first time.

====
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
041029 7:57:10 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
041029 7:57:11 InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
041029 7:57:12 InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
041029 7:57:22 InnoDB: Started
C:\mysql\bin\mysqld.exe: ready for connections.
Version: '4.0.21-debug' socket: '' port: 3306 Source distribution

=====

From the above i determined that the database was created, am i wrong?

=====

The install page of Phpbb has no problem with this as far as i can see however when i enter the required data into the fields and click install i am presented with the following error.

An error has occurred during installation
An error occurred trying to update the database
Can't create/write to file '.\ibdata1\phpbb_auth_access.frm' (Errcode: 2)

I have visited the IRC channel for Phpbb and was told that Error 2 is folder/file not found, which leads me to ask the question, is it saying that it cannot access tables in ibdata1, or is a dir ibdata1 that it cannot access.

I have set everything up regarding permissions for folder access.

Thats the problem, as of now I am standing by this post until i get this problem fixed,

Thanks

CyberIDentity

Options: ReplyQuote


Subject
Written By
Posted
Database Access Error
October 28, 2004 07:34PM
October 28, 2004 08:43PM
October 28, 2004 08:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.