<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 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 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 align="center" class="gmail_msg"><font face="Verdana, Arial, Helvetica, sans-serif" class="gmail_msg"><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" cellpadding="1" cellspacing="0" border="0" class="gmail_msg">
<tbody class="gmail_msg">
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif" class="gmail_msg"><b class="gmail_msg">error:</b> </font></td>
<td valign="top" align="left" class="gmail_msg"><font size="-2" face="Verdana,
Arial, Helvetica, sans-serif" class="gmail_msg">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 valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif" class="gmail_msg"><b class="gmail_msg">context:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif" class="gmail_msg">
<table cellpadding="0" cellspacing="0" border="0" class="gmail_msg">
<tbody class="gmail_msg">
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">...</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><br class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1270:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg">=cut</font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1271:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><br class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1272:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg">sub HasRight {</font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1273:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg">my $self = shift;</font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1274:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><font color="red" class="gmail_msg">return
$self->PrincipalObj->HasRight(@_);</font></font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1275:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg">}</font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1276:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><br class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1277:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg">=head2 CurrentUserCanSee [FIELD]</font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">1278:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><br class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica,
sans-serif" class="gmail_msg"><b class="gmail_msg">...</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><br class="gmail_msg">
</td>
</tr>
</tbody>
</table>
</font></td>
</tr>
<tr class="gmail_msg">
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif" class="gmail_msg"><b class="gmail_msg">code
stack:</b> </font></td>
<td valign="top" align="left" nowrap class="gmail_msg"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif" class="gmail_msg">/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 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 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 href="http://handler.pl" class="gmail_msg" target="_blank">handler.pl</a> line 153
eval {...} at /usr/local/etc/freeside/<a 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 href="mailto:freeside-users@freeside.biz" class="gmail_msg" target="_blank">freeside-users@freeside.biz</a><br class="gmail_msg">
<a 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>