[Spce-user] Reset the database

[Sébastien Cramatte]

Ok, I've found the issue ...
Is not sufficient to restore database  ... you must restore all password as
specified  into constants.yml file !

Sipwise Team ... please make us a little perl script to reset DB and
password !

Thank you

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

> 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/20fb55da/attachment-0001.html>