OTRS 6 Install - Database already exists

Moderator: crythias

Post Reply
xavidivekite
OTRS newbie
Posts: 3
Joined: 16 May 2018, 17:15
OTRS Version?: 6 Free

OTRS 6 Install - Database already exists

Post by xavidivekite » 17 May 2018, 16:44

Hi all,

I'm trying to install OTRS 6 Free versión, with the /otrs/installer.pl tool. But I'm getting this recurrent error when trying to create the system database (step 2):

Can't create otrs database. Database already exists.

I've checked that, previous to the database create process, not otrs user nor otrs database exists. This mariadb server is in the same host as otrs.

Any ideas about the error? I've tryed with several database/username names without success.

TIA

fcasal
OTRS wizard
Posts: 135
Joined: 21 Apr 2014, 16:14
OTRS Version?: 6.0.7

Re: OTRS 6 Install - Database already exists

Post by fcasal » 18 May 2018, 07:06

It is possible that chech the database schema and if mysql database exists, it returns as already exists. If you only have this database, I would purge MariaDb and install again.

User avatar
klausneil
OTRS ninja
Posts: 646
Joined: 29 May 2012, 22:47
OTRS Version?: 6.0.6
Real Name: Klaus Salazar
Company: SLP
Location: Perú

Re: OTRS 6 Install - Database already exists

Post by klausneil » 22 May 2018, 04:37

Hi xavidivekite, you can verify entering to mariadb and execute show database; here verify that the database otrs exist, if this is so then delete this database and when you execute installer.php and the otrs will create your own database.

xavidivekite
OTRS newbie
Posts: 3
Joined: 16 May 2018, 17:15
OTRS Version?: 6 Free

Re: OTRS 6 Install - Database already exists

Post by xavidivekite » 22 May 2018, 10:46

Hi all,

I have:

- Checked that database that it's going to be created does not exist. But message that "database already exists" is shown.
- I have purged and reinstalling mariadb, but problem persists.
- I have changed database name, username, but problem still appears.

TIA.

fcasal
OTRS wizard
Posts: 135
Joined: 21 Apr 2014, 16:14
OTRS Version?: 6.0.7

Re: OTRS 6 Install - Database already exists

Post by fcasal » 22 May 2018, 14:26

I think is a problem with the MariaDb, because even with purge, not delete every folder and file, so you could reinstall the o.s. and try again.

xavidivekite
OTRS newbie
Posts: 3
Joined: 16 May 2018, 17:15
OTRS Version?: 6 Free

Re: OTRS 6 Install - Database already exists

Post by xavidivekite » 12 Jun 2018, 13:47

fcasal wrote:
22 May 2018, 14:26
I think is a problem with the MariaDb, because even with purge, not delete every folder and file, so you could reinstall the o.s. and try again.
I think that that's not a valid solution, server has another applications so It's not a solution to reinstall O.S. and try... :shock:

zzz
OTRS wizard
Posts: 189
Joined: 15 Dec 2016, 15:13
OTRS Version?: 3.x - 6.0.x
Real Name: Emin
Company: maxence business consulting GmbH
Contact:

Re: OTRS 6 Install - Database already exists

Post by zzz » 12 Jun 2018, 15:35

Hello,

you could manually create a database and database user and enter the credentials on page two.

Best regards
Emin

Post Reply