[rt-devel] make initialize-database fails (MySQL server has gone away)

[Sam Johnston]

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, <SCHEMA> line 397.
>>Problem with statement:
>> USE mysql;
>>MySQL server has gone away at //opt/rt3/sbin/initdb line 225, <SCHEMA>
>>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 at lists.fsck.com
>>http://lists.fsck.com/mailman/listinfo/rt-devel
>>
> 
>