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

[Jesse Vincent]

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

	-j


On 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, <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
> >>
> >
> >
> 

-- 
»|« http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.