Make initialize-database fails (MySQL server has gone away)

RT Developers
1

Afternoon all,

I am having troubles getting an RT3 database set up on my Debian 3.0 box
running MySQL 3.23.49 and rt-2-1-49, as follows:

make initialize-database
/usr/bin/perl //opt/rt3/sbin/initdb --action init --dba root
–prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password: Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
DBD::mysql::st execute failed: MySQL server has gone away at
//opt/rt3/sbin/initdb line 224, line 397.
Problem with statement:
USE mysql;
MySQL server has gone away at //opt/rt3/sbin/initdb line 225,
line 397.
make: *** [initialize-database] Error 255

It seems the tables are created:

| Tables_in_rt3 |
| ACL |
| Attachments |
| CachedGroupMembers |
| CustomFieldValues |
| CustomFields |
| GroupMembers |
| Groups |
| Links |
| Principals |
| Queues |
| ScripActions |
| ScripConditions |
| Scrips |
| Templates |
| TicketCustomFieldValues |
| Tickets |
| Transactions |
| Users |
| sessions |

And this is the last I see in the mysql.log file:

CREATE TABLE CustomFieldValues (
id INTEGER NOT NULL AUTO_INCREMENT,
CustomField int NOT NULL ,
Name varchar(200) NULL ,
Description varchar(255) NULL ,
SortOrder integer NULL ,

Creator integer NULL ,
Created DATETIME NULL ,
LastUpdatedBy integer NULL ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB

                259 Query

CREATE TABLE sessions (
id char(32) NOT NULL,
a_session LONGTEXT,
PRIMARY KEY (id)
)

                259 Quit

Any assistance/suggestions would be most appreciated.

Sam Johnston
Australian Online Solutions
1300 132 809

2

I found that dbh is closed at the end of insert_schema, and never
reopened before being used again at the start of insert_acl. By
commenting out the $dbh->disconnect at line 140 the script worked as
expected. Hope this helps.

Hrm. I thought that was fixed in 2.1.50. Of course, I seem to have lost
another fix from the same day. I bet there was a botched commit.

-j

»|« Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

2.1.51 should fix this (again :/) and is up now.

-jOn Tue, Nov 26, 2002 at 08:49:47PM +1100, Sam Johnston wrote:

I found that dbh is closed at the end of insert_schema, and never
reopened before being used again at the start of insert_acl. By
commenting out the $dbh->disconnect at line 140 the script worked as
expected. Hope this helps.

In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password: Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
insert_acl
Now inserting RT data
Checking for existing system user…not found. This appears to be a new
installation.
Creating system user…done.
Creating Superuser ACL…Creating groups…3.4.5.6.7.8.9.done.
Creating users…10.12.done.
Creating ACL…2.3.done.
Creating queues…1.done.
Creating ScripActions…1.2.3.4.5.6.7.8.9.10.11.12.13.14.done.
Creating ScripConditions…1.2.3.4.5.6.7.8.9.done.
Creating templates…1.2.3.4.5.6.7.8.done.

–
Sam Johnston
Australian Online Solutions
1300 132 809

Jesse Vincent wrote:

Give 2.1.50 a shot and tell us how it goes.

On Tue, Nov 26, 2002 at 04:00:49PM +1100, Sam Johnston wrote:

Afternoon all,

I am having troubles getting an RT3 database set up on my Debian 3.0 box
running MySQL 3.23.49 and rt-2-1-49, as follows:

make initialize-database
/usr/bin/perl //opt/rt3/sbin/initdb --action init --dba root
–prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password: Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
DBD::mysql::st execute failed: MySQL server has gone away at
//opt/rt3/sbin/initdb line 224, line 397.
Problem with statement:
USE mysql;
MySQL server has gone away at //opt/rt3/sbin/initdb line 225,
line 397.
make: *** [initialize-database] Error 255

It seems the tables are created:

±------------------------+
| Tables_in_rt3 |
±------------------------+
| ACL |
| Attachments |
| CachedGroupMembers |
| CustomFieldValues |
| CustomFields |
| GroupMembers |
| Groups |
| Links |
| Principals |
| Queues |
| ScripActions |
| ScripConditions |
| Scrips |
| Templates |
| TicketCustomFieldValues |
| Tickets |
| Transactions |
| Users |
| sessions |
±------------------------+

And this is the last I see in the mysql.log file:

CREATE TABLE CustomFieldValues (
id INTEGER NOT NULL AUTO_INCREMENT,
CustomField int NOT NULL ,
Name varchar(200) NULL ,
Description varchar(255) NULL ,
SortOrder integer NULL ,

Creator integer NULL ,
Created DATETIME NULL ,
LastUpdatedBy integer NULL ,
LastUpdated DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB

              259 Query

CREATE TABLE sessions (
id char(32) NOT NULL,
a_session LONGTEXT,
PRIMARY KEY (id)
)

              259 Quit

Any assistance/suggestions would be most appreciated.

–
Sam Johnston
Australian Online Solutions
1300 132 809

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

»|« Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

4

I found that dbh is closed at the end of insert_schema, and never
reopened before being used again at the start of insert_acl. By
commenting out the $dbh->disconnect at line 140 the script worked as
expected. Hope this helps.

In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password: Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
schema sucessfully inserted
Now inserting database ACLs
insert_acl
Now inserting RT data
Checking for existing system user…not found. This appears to be a new
installation.
Creating system user…done.
Creating Superuser ACL…Creating groups…3.4.5.6.7.8.9.done.
Creating users…10.12.done.
Creating ACL…2.3.done.
Creating queues…1.done.
Creating ScripActions…1.2.3.4.5.6.7.8.9.10.11.12.13.14.done.
Creating ScripConditions…1.2.3.4.5.6.7.8.9.done.
Creating templates…1.2.3.4.5.6.7.8.done.

Sam Johnston
Australian Online Solutions
1300 132 809

Jesse Vincent wrote: