[Spce-user] Reset the database

[Sébastien Cramatte]

I got this message in  oss.log

Aug 11 11:09:02 sip3 /usr/sbin/apache2: ***Root::auto front page or login
access granted.
Aug 11 11:09:02 sip3 /usr/sbin/apache2: ***login::index called
Aug 11 11:09:02 sip3 /usr/sbin/apache2: ***Provisioning::login called,
authenticating...
Aug 11 11:09:02 sip3 /usr/sbin/apache2: ***Provisioning::_get_admin failed
to get admin 'administrator' from DB: Could not connect to database
'DBI:mysql:database=billing;host=localhost;port=3306'#012.


2011/8/11 Sébastien Cramatte <scramatte at gmail.com>

> After database reset, I'm unable to log into admin panel. Seems that user
> doesn't exists ....
>
>
> 2011/8/10 Jon Bonilla <jbonilla at sipwise.com>
>
>> El Wed, 10 Aug 2011 00:32:40 +0200
>> Daniel Tiefnig <dtiefnig at sipwise.com> escribió:
>>
>> > On 08/09/2011 12:10 PM, Michael Schoepfer wrote:
>> > > Hi,
>> >
>> > Hi,
>> >
>> > > is there a way to reset the database to its original state?
>> >
>> > There are the create scripts in /usr/share/doc/ngcp-ossbss/ which you
>> > could use to recreate the databases. They will drop all existing data.
>> >
>> > br,
>> > daniel
>> >
>>
>> The order to run the scripts is:
>>
>> mysql  < create_bss.mysql
>> mysql  < create_oss.mysql
>> mysql  < create_kamailio_301.mysql
>> mysql  < create_oss_triggers_kamailio.mysql
>> mysql  < create_accounting.mysql
>> mysql  < create_syslog.mysql
>> mysql  < create_no_replicates.mysql
>> mysql  < private_grants_dbs.mysql
>> mysql  < private_grants_proxies_kamailio.mysql
>>
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> http://lists.sipwise.com/listinfo/spce-user
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20110811/44152f7b/attachment-0001.html>