[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / Manual / Troubleshooting.pod

=head1 NAME

DBIx::Class::Manual::Troubleshooting - Got a problem? Shoot it.

=head2  "Can't locate storage blabla"

=head2 Tracing SQL

The C<DBIX_CLASS_STORAGE_DBI_DEBUG> environment variable controls
SQL tracing, so to see what is happening try

  export DBIX_CLASS_STORAGE_DBI_DEBUG=1

Alternatively use the C<storage->debug> class method:-

  $class->storage->debug(1);

To send the output somewhere else set debugfh:-

  $class->storage->debugfh(IO::File->new('/tmp/trace.out', 'w');

Alternatively you can do this with the environment variable too:-

  export DBIX_CLASS_STORAGE_DBI_DEBUG="1=/tmp/trace.out"

=cut
Commit	Line	Data
3b44ccc6	1	=head1 NAME
	2
	3	DBIx::Class::Manual::Troubleshooting - Got a problem? Shoot it.
ee38fa40	4
130c6439	5	=head2 "Can't locate storage blabla"
ee38fa40	6
159a8515	7	=head2 Tracing SQL
	8
	9	The C<DBIX_CLASS_STORAGE_DBI_DEBUG> environment variable controls
	10	SQL tracing, so to see what is happening try
	11
	12	export DBIX_CLASS_STORAGE_DBI_DEBUG=1
	13
	14	Alternatively use the C<storage->debug> class method:-
	15
	16	$class->storage->debug(1);
	17
92b858c9	18	To send the output somewhere else set debugfh:-
	19
	20	$class->storage->debugfh(IO::File->new('/tmp/trace.out', 'w');
	21
	22	Alternatively you can do this with the environment variable too:-
	23
	24	export DBIX_CLASS_STORAGE_DBI_DEBUG="1=/tmp/trace.out"
159a8515	25
ee38fa40	26	=cut
ee38fa40	27