[Spce-user] [EXTERNAL] database error
Pa Ka
pa.ka12 at outlook.com
Thu Jun 13 17:25:04 EDT 2024
Resolved. Certain services like ngcp-tast-agent,.. were inactive. I restarted them. Ooohhh, very long day. I managed to resolve every task I posted in the previous email. It wasn’t easy. Ready for the next task! Ready to see how sipwise works now. !! sorry for bothering everyone !
From: Pa Ka <pa.ka12 at outlook.com>
Sent: Thursday, June 13, 2024 4:00 PM
To: Pa Ka <pa.ka12 at outlook.com>; Dario Busso <dbusso at sipwise.com>
Cc: spce-user at lists.sipwise.com
Subject: RE: [EXTERNAL] [Spce-user] database error
This is also resolved. Drop databases; recreated them.
However, I cannot log into sipwise with administrator password. the error “ Unexpected error 😱: Cannot read properties of undefined (reading 'error') (Thu Jun 13 2024 15:55:06 GMT-0400 (Eastern Daylight Time))” is returned
Below is ngcp-api-admins --op list --login administrator:
From: Pa Ka <pa.ka12 at outlook.com<mailto:pa.ka12 at outlook.com>>
Sent: Thursday, June 13, 2024 12:47 PM
To: pa.ka12 at outlook.com<mailto:pa.ka12 at outlook.com>; Dario Busso <dbusso at sipwise.com<mailto:dbusso at sipwise.com>>
Cc: spce-user at lists.sipwise.com<mailto:spce-user at lists.sipwise.com>
Subject: RE: [EXTERNAL] [Spce-user] database error
Updates.
I managed to re-install the db by using ngcp-update-db-schema. Some DB were missing. I did a DB reset but returns
ERROR 1045 (28000): Access denied for user 'sipwise'@'localhost' (using password: YES)
Any guidance? I think it is related to permission. Not sure how to fix this one.
Thanks
{
"_embedded" : {
"ngcp:admins" : [
{
"_links" : {
"collection" : {
"href" : "/api/admins/"
},
"curies" : {
"href" : http://purl.org/sipwise/ngcp-api/#rel-{rel},
"name" : "ngcp",
"templated" : true
},
"ngcp:admins" : [
{
"href" : "/api/admins/1"
}
],
"ngcp:journal" : [
{
"href" : "/api/admins/1/journal/"
}
],
"ngcp:resellers" : [
{
"href" : "/api/resellers/1"
}
],
"profile" : {
"href" : http://purl.org/sipwise/ngcp-api/
},
"self" : {
"href" : "/api/admins/1"
}
},
"billing_data" : true,
"call_data" : true,
"can_reset_password" : true,
"email" : myemail at email.com<mailto:myemail at email.com>,
"id" : 1,
"is_active" : true,
"is_ccare" : false,
"is_master" : true,
"is_superuser" : true,
"is_system" : true,
"lawful_intercept" : false,
"login" : "administrator",
"read_only" : false,
"reseller_id" : 1,
"role" : "system",
"show_passwords" : true
}
]
},
"_links" : {
"curies" : {
"href" : http://purl.org/sipwise/ngcp-api/#rel-{rel},
"name" : "ngcp",
"templated" : true
},
"ngcp:admins" : [
{
"href" : "/api/admins/1"
}
],
"profile" : {
"href" : http://purl.org/sipwise/ngcp-api/
},
"self" : {
"href" : "/api/admins/?page=1&rows=10&login=administrator"
}
},
"total_count" : 1
}
From: Pa Ka <pa.ka12 at outlook.com<mailto:pa.ka12 at outlook.com>>
Sent: Thursday, June 13, 2024 11:34 AM
To: Dario Busso <dbusso at sipwise.com<mailto:dbusso at sipwise.com>>
Cc: spce-user at lists.sipwise.com<mailto:spce-user at lists.sipwise.com>
Subject: RE: [EXTERNAL] [Spce-user] database error
Thank you for letting me know that external db is not supported for NGCP CE version. Now, I am facing this issue during the installion of ngcp, the database wasn’t created maybe due to mariadb.service down. I fixed this later after the installation.
No db when (mysl>show databases;
Only returns
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys
)
I did ngcp-reset-db , it returns
mysqldump: Got error: 1045: "Access denied for user 'sipwise'@'localhost' (using password: YES)" when trying to connect
ERROR: Error backing up DB 'accounting' to /ngcp-data/backup/db_backup.sql-20240613_172742
Do I need to create ngcp database first? What command should I use?
Thank you !
From: Dario Busso <dbusso at sipwise.com<mailto:dbusso at sipwise.com>>
Sent: Thursday, June 13, 2024 3:17 AM
To: Pa Ka <pa.ka12 at outlook.com<mailto:pa.ka12 at outlook.com>>
Cc: spce-user at lists.sipwise.com<mailto:spce-user at lists.sipwise.com>
Subject: Re: [EXTERNAL] [Spce-user] database error
Deat Pa.
From the Handbook: https://www.sipwise.com/doc/mr12.3.1/spce/ce/mr12.3.1/appendices-main/appendices-main.html#_constants_yml_overview
The usage of external DB is not supported for the NGCP CE version.
KR
Dario
On Thu, Jun 13, 2024 at 8:50 AM Pa Ka <pa.ka12 at outlook.com<mailto:pa.ka12 at outlook.com>> wrote:
Hello team,
Could you please assist me with this ? using mr12.3.1
In constant.yml file I edit the database as follows:
database:
local:
dbhost: IP.address.of.my.db
ngcp-update-db-schema save the db scheme to my db server. But doesn’t create users. I suppose not even all tables are created.
ngcp-reset-db returns [ mysqldump: Got error: 2002: "Can't connect to server on 'localhost' (111)" when trying to connect ] not sure where localhost is coming from. Yet I changed the db host in constant.yml file .
also, mariadb.cnf, my.cnf, grants.yml both from /etc/mysql have been updated. I set mydbip address in those file. But still when I tried to create db to my db server by using ngcp-reset-db it returns localhost access error, above
where can I get this db host, what am I doing wrong? thanks
--
Spce-user mailing list
Spce-user at lists.sipwise.com<mailto:Spce-user at lists.sipwise.com>
http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20240613/17c8c7b5/attachment-0001.htm>
More information about the Spce-user
mailing list