Thanks for the detailed answer, Dan. I’ll do that. Alexis
> On Aug 14, 2018, at 12:24 PM, TIMONEY, DAN <[email protected]> wrote: > > Alexis, > > You’ll want to add that to the SDNC database, not CCSDK. That CCSDK database > isn’t really used in the SDNC or APPC container – it’s only there really for > testing of CCSDK in isolation (for example, for CSIT). > > The database is installed in > sdnc/oam/installation/src/main/scripts/installSdncDb.sh. That script > installs sdnc/oam/installation/src/main/resources/sdnctl.dump first, then > loops through sdnc/oam/installation/src/main/resources/*.data.dump and > installs all of those. Those files are all assumed to have been created by > mysqldump, but really at the end of the day those files are just SQL scripts. > So, probably the easiest way to create those 2 new tables would be to add a > new .data.dump file containing either a dump of those new tables (I generally > just add them to a local db in my dev env and do a mysqldump to dump them) or > you could just write a SQL script to add them and call it something that ends > in .data.dump and they’ll get added by the existing installSdncDb.sh script. > > Dan > > -- > Dan Timoney > SDN-CP Development > ONAP Project Technical Lead : CCSDK and SDNC > > Please go to D2 ECOMP Release Planning Wiki > <https://wiki.web.att.com/display/DERP/D2+ECOMP+Release+Planning+Home> for D2 > ECOMP Project In-take, 2016 Release Planning, Change Management, and find key > Release Planning Contact Information. > > > From: Alexis de Talhouët <[email protected]> > Date: Tuesday, August 14, 2018 at 11:21 AM > To: onap-discuss <[email protected]>, "TIMONEY, DAN" > <[email protected]> > Subject: [SDNC][CDS] - Where to create Netbox SQL tables? > > Hello Dan, team, > > For the self serve implementation for vFW use case for Casablanca, we need to > create two tables to store information related to the IPAM (prefixes and > ips). See related information here: > https://wiki.onap.org/pages/viewpage.action?pageId=36966186 > <https://urldefense.proofpoint.com/v2/url?u=https-3A__wiki.onap.org_pages_viewpage.action-3FpageId-3D36966186&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=Ms-DNhR23dO4sQFfYRm4ow&m=3UcTnA13D56pD8Rfx02GrTej30LB-67ETiMkSnxJElk&s=wRF2j48WHLCwvNdkNhkvQvs4iZo-c5XJRe3Nq8JTBxg&e=> > under netbox mS Capability [ccsdk] -> netbox mS Capability [IPAM DB Creation > SDN-C] > > With the aggregation to common controller going on we were wondering whether > we should put this table in CCDSK or SDNC DB; can you advise us? > > Thanks, > Alexis -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#11881): https://lists.onap.org/g/onap-discuss/message/11881 Mute This Topic: https://lists.onap.org/mt/24526012/21656 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
