Problem creating initial rt3 database in mysql, DBD::mysql::db prepare warning:

Hi all,

I’m currently trying to set up a rt install at a gentoo installation at
my daytime job.

Im following the guide at
http://wiki.bestpractical.com/index.cgi?GentooInstallGuide, and have
recompiled mysql with support for innodb.

When I’m trying to run the rt-setup-database script and I get something
like this.

sbin # ./rt-setup-database --action init --dba root
–prompt-for-dba-password
In order to create or update your RT 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.
Done setting up database schema.
Now inserting database ACLs
DBD::mysql::db prepare warning: at ./rt-setup-database line 347.
Died at ./rt-setup-database line 347.

I wonder what is causing the last error message - any ideas on how to
best debug this?

Regards,
Steffen, Denmark

Thomas Knoezinger wrote:

./rt-setup-database --dba=${RT::DatabaseUser} --action=init --prompt-for-dba-password

replace ${RT::DatabaseUser} with your database user from RT_SiteConfig.pm.

This sould work.

Thanks, it did take me a bit further :slight_smile: Now I get this instead:

Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
Can’t call method “rollback” on an undefined value at
/usr/lib/perl5/vendor_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 713.

Sounds like this may be related to my environment - any hints?

P.S: Please let me know if you installation of rt is eating a lot of memory
even for prompting login page.

Looking forward to return to you on this one :slight_smile:

// Steffen

What is the easiest way to debug this - can I insert a statement that
will check if the database connection is alive before doing the core
objects?

// Steffen

Steffen Poulsen wrote:

Steffen Poulsen wrote:

Thanks, it did take me a bit further :slight_smile: Now I get this instead:

Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
Can’t call method “rollback” on an undefined value at
/usr/lib/perl5/vendor_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 713.

Sounds like this may be related to my environment - any hints?

Seems this had something to do with local environment:

emerge -u dev-perl/dbix-searchbuilder dev-perl/DBIx-DBSchema
dev-perl/DBIx-ContextualFetch dev-perl/DBI

seems to have solved it.

I had to install default password / username while running
rt-setup-database (even though overwritten in …/etc/RT_SiteConfig.pm),
possibly this has to do with Gentoo way of doing things (?).

Looking forward to get on with this :slight_smile:

// Steffen

Thomas Knoezinger wrote:

P.S: Please let me know if you installation of rt is eating a lot of memory
even for prompting login page.

Seems like it’s finally getting to run, after mason was compiled for
modperl support :slight_smile:

But you’re right, it only managed to show the login-page once -
subsequent requests just puts this in apache error log:

Out of memory!
Callback called exit.

Any ideas?

// Steffen, Denmark

Installing an earlier version of DBD-mysql got me past the login screen

  • hope this issue won’t cause any surprises later on! :slight_smile:

emerge -p --oneshot =DBD-mysql-3.0002

// Steffen

Thomas Knoezinger wrote: