<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>If the RT database is actually a few tables in the "freeside"
database, then yes, I dropped those tables too. I merely dropped
the entire freeside database, without knowing about any extra RT
add-ons. <br>
<br>
I've already rebuilt the whole server from scratch, but I'll keep
this in mind the next time I need to nuke the database for any
reason, although I doubt I'd be doing that on anything but a dev
server from this point on.<br>
</p>
<br>
<div class="moz-cite-prefix">On 2017-04-05 05:00 PM, John Wilson
wrote:<br>
</div>
<blockquote
cite="mid:CAK2OcwV7UfWsfaVof4qw_GZvOFfU3VM4NUE+1r2t0vcRspt=EQ@mail.gmail.com"
type="cite">
<p dir="ltr">Looks like an issue with rt. Did you drop those
tables? And if so, did you recreate the schema?</p>
<p dir="ltr">$ su freeside <br>
$ /opt/rt3/sbin/rt-setup-database --action schema <br>
$ /opt/rt3/sbin/rt-setup-database --action coredata <br>
$ /opt/rt3/sbin/rt-setup-database --action insert --datafile
/opt/rt3/etc/initialdata </p>
<br>
<div class="gmail_quote">
<div dir="ltr">On Tue, Apr 4, 2017, 2:59 PM Ernie Dunbar <<a
moz-do-not-send="true" href="mailto:maillist@lightspeed.ca">maillist@lightspeed.ca</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF" class="gmail_msg">
<p class="gmail_msg">Hi everyone.</p>
<p class="gmail_msg">We have a Freeside server set up and
working perfectly, using Freeside 4.2.<br
class="gmail_msg">
</p>
<p class="gmail_msg">I'm trying to dump all the test data
we've inserted into Freeside so far, and start fresh. The
normal way a database administrator would do this is to
drop the database and then re-insert the database schema.</p>
<p class="gmail_msg">However, attempting to do it like this:<br
class="gmail_msg">
<br class="gmail_msg">
# /etc/init.d/freeside stop<br class="gmail_msg">
# /etc/init.d/apache stop<br class="gmail_msg">
<br class="gmail_msg">
# su freeside<br class="gmail_msg">
<br class="gmail_msg">
$ createdb -E UTF8 freeside<br class="gmail_msg">
$ freeside-setup -d <a moz-do-not-send="true"
href="http://lightspeed.ca" class="gmail_msg"
target="_blank">lightspeed.ca</a><br class="gmail_msg">
$ freeside-adduser -g 1 fs_queue<br class="gmail_msg">
$ freeside-adduser -g 1 fs_daily<br class="gmail_msg">
$ freeside-adduser -g 1 fs_selfservice<br
class="gmail_msg">
$ freeside-adduser -g 1 fs_api<br class="gmail_msg">
$ freeside-adduser -g 1 myuser mypass<br class="gmail_msg">
$ exit<br class="gmail_msg">
# freeside-queued fs_queue<br class="gmail_msg">
# /etc/init.d/freeside start<br class="gmail_msg">
# /etc/init.d/apache2 start<br class="gmail_msg">
</p>
<p class="gmail_msg">only results in an error like this,
when I try to log in with "myuser" and "mypass", which
definitely, <b class="gmail_msg">definitely</b> got
created properly:<br class="gmail_msg">
<br class="gmail_msg">
</p>
<p class="gmail_msg" align="center"><font class="gmail_msg"
face="Verdana, Arial, Helvetica, sans-serif"><b
class="gmail_msg">System error</b></font></p>
<table style="font-family:"Times New
Roman";letter-spacing:normal;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"
class="gmail_msg" cellpadding="1" cellspacing="0"
border="0">
<tbody class="gmail_msg">
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left"
nowrap="nowrap"><font class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica, sans-serif"><b
class="gmail_msg">error:</b> </font></td>
<td class="gmail_msg" valign="top" align="left"><font
class="gmail_msg" size="-2" face="Verdana, Arial,
Helvetica, sans-serif">Can't call method
"HasRight" on an undefined value at
/opt/rt3/lib/RT/User.pm line 1274.<br
class="gmail_msg">
</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left"
nowrap="nowrap"><font class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica, sans-serif"><b
class="gmail_msg">context:</b> </font></td>
<td class="gmail_msg" valign="top" align="left"
nowrap="nowrap"><font class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica, sans-serif">
<table class="gmail_msg" cellpadding="0"
cellspacing="0" border="0">
<tbody class="gmail_msg">
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">...</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><br
class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1270:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif">=cut</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1271:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><br
class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1272:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif">sub HasRight {</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1273:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif">my $self = shift;</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1274:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><font class="gmail_msg"
color="red">return
$self->PrincipalObj->HasRight(@_);</font></font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1275:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif">}</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1276:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><br
class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1277:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif">=head2 CurrentUserCanSee
[FIELD]</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">1278:</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><br
class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><font
class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">...</b> </font></td>
<td class="gmail_msg" valign="top"
align="left" nowrap="nowrap"><br
class="gmail_msg">
</td>
</tr>
</tbody>
</table>
</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left"
nowrap="nowrap"><font class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica, sans-serif"><b
class="gmail_msg">code stack:</b> </font></td>
<td class="gmail_msg" valign="top" align="left"
nowrap="nowrap"><font class="gmail_msg" size="-2"
face="Verdana, Arial, Helvetica, sans-serif">/opt/rt3/lib/RT/User.pm:1274<br
class="gmail_msg">
/usr/share/perl5/FS/TicketSystem/RT_Internal.pm:47<br
class="gmail_msg">
/usr/share/perl5/FS/TicketSystem.pm:28<br
class="gmail_msg">
/var/www/html/freeside/elements/header-full.html:85<br class="gmail_msg">
/var/www/html/freeside/elements/header.html:5<br
class="gmail_msg">
/var/www/html/freeside/index.html:4<br
class="gmail_msg">
/var/www/html/freeside/autohandler:1<br
class="gmail_msg">
</font></td>
</tr>
</tbody>
</table>
<a moz-do-not-send="true"
href="https://freeside.lightspeed.ca/freeside/index.html#raw"
style="font-family:"Times New
Roman";font-size:medium;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"
class="gmail_msg" target="_blank">raw error</a><br
class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<a moz-do-not-send="true" name="m_3802902595750653017_raw"
class="gmail_msg"></a><span
style="color:rgb(0,0,0);font-family:"Times New
Roman";font-size:medium;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;display:inline!important;float:none"
class="gmail_msg"></span>
<pre style="color:rgb(0,0,0);font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial" class="gmail_msg">Can't call method "HasRight" on an undefined value at /opt/rt3/lib/RT/User.pm line 1274.
Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "HasRight" on an undefined value at /opt/rt3/lib/RT/User.pm line 1274.^J') called at /opt/rt3/lib/RT/User.pm line 1274
RT::User::HasRight('RT::CurrentUser=HASH(0x7ff1a8430a38)', 'Right', 'ModifySelf', 'Object', 'RT::System=HASH(0x7ff1a1abbb48)') called at /usr/share/perl5/FS/TicketSystem/RT_Internal.pm line 47
FS::TicketSystem::RT_Internal::access_right('FS::TicketSystem::RT_Internal', 'HASH(0x7ff19782b170)', 'ModifySelf') called at /usr/share/perl5/FS/TicketSystem.pm line 28
FS::TicketSystem::AUTOLOAD('FS::TicketSystem', 'HASH(0x7ff19782b170)', 'ModifySelf') called at /var/www/html/freeside/elements/header-full.html line 85
HTML::Mason::Commands::__ANON__('Billing Main') called at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7ff1a833aec0)', 'Billing Main') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, 'Billing Main') called at /var/www/html/freeside/elements/header.html line 5
HTML::Mason::Commands::__ANON__('Billing Main') called at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7ff1a82cdb00)', 'Billing Main') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, 'Billing Main') called at /var/www/html/freeside/index.html line 4
HTML::Mason::Commands::__ANON__ at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7ff1a82eecc0)') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/share/perl5/HTML/Mason/Request.pm line 958
HTML::Mason::Request::call_next('FS::Mason::Request=HASH(0x7ff1a17722c8)') called at /var/www/html/freeside/autohandler line 1
HTML::Mason::Commands::__ANON__ at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7ff1a82622e8)') called at /usr/share/perl5/HTML/Mason/Request.pm line 1303
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/share/perl5/HTML/Mason/Request.pm line 484
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 484
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec('FS::Mason::Request=HASH(0x7ff1a17722c8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
HTML::Mason::Request::ApacheHandler::exec('FS::Mason::Request=HASH(0x7ff1a17722c8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7ff1a4c57728)', 'Apache2::RequestRec=SCALAR(0x7ff1a4d0c600)') called at /usr/local/etc/freeside/<a moz-do-not-send="true" href="http://handler.pl" class="gmail_msg" target="_blank">handler.pl</a> line 153
eval {...} at /usr/local/etc/freeside/<a moz-do-not-send="true" href="http://handler.pl" class="gmail_msg" target="_blank">handler.pl</a> line 153
HTML::Mason::handler('Apache2::RequestRec=SCALAR(0x7ff1a4d0c600)') called at -e line 0
eval {...} at -e line 0</pre>
<p class="gmail_msg"><br class="gmail_msg">
</p>
<p class="gmail_msg">I suppose I can blow away the server
and rebuild it again from scratch, but all those perl
dependencies were not easy to build the first time around,
and the ones that needed to be installed through cpan took
a long time. There's got to be a faster way to accomplish
this.<br class="gmail_msg">
</p>
</div>
_______________________________________________<br
class="gmail_msg">
freeside-users mailing list<br class="gmail_msg">
<a moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz" class="gmail_msg"
target="_blank">freeside-users@freeside.biz</a><br
class="gmail_msg">
<a moz-do-not-send="true"
href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users"
rel="noreferrer" class="gmail_msg" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br
class="gmail_msg">
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
freeside-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
</body>
</html>