SQL error: role "rosariosis" does not exist

[francoisjacquet]

In the install.sql file, you have commands to set owner.

But in case the rosariosis user does not exist, this generates an error: role "rosariosis" does not exist.

https://github.com/DocStem/ParentAttendance/blob/main/install.sql#L114

These commands are not useful and can be safely removed.

Same applies(but not limited) to:

https://github.com/DocStem/CustomReportCards-master/blob/master/install.sql#L353

https://github.com/DocStem/LunchReport-master/blob/master/install.sql#L111

[DocStem]

All your questions should be answered in the README which includes what Custom Fields to add to the code.

In the ReportCard module if you use that, you would need to modify the code to where the COMMENT Sections are.

Rosariosis user did exist in the past. I have kept my database to that ownership. You have since changed it I believe to rosario or something like that. If you modify the owner or add rosariosis as an owner it will work.

I intend to do something later with it, as I lock it down to PDO so I have kept the ownership in the SQL.

I will contact you on the private email regarding you other email and also provide you feedback on your new version about the issue with USER_TABLE and the JS in the Tiny Formula.

From: François Jacquet @.> Sent: Sunday, September 26, 2021 2:42 PM To: DocStem/ParentAttendance @.> Cc: Subscribed @.***> Subject: [DocStem/ParentAttendance] SQL error: role "rosariosis" does not exist (#2)

In the install.sql file, you have commands to set owner.

But in case the rosariosis user does not exist, this generates an error: role "rosariosis" does not exist.

https://github.com/DocStem/ParentAttendance/blob/main/install.sql#L114

These commands are not useful and can be safely removed.

Same applies(but not limited) to:

https://github.com/DocStem/CustomReportCards-master/blob/master/install.sql#L353

https://github.com/DocStem/LunchReport-master/blob/master/install.sql#L111

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/DocStem/ParentAttendance/issues/2 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AQX6OKHHE4764OJW75ZHEYDUD5SQNANCNFSM5EZB4PJQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . https://github.com/notifications/beacon/AQX6OKEDD57BBGCX3VVLWY3UD5SQNA5CNFSM5EZB4PJ2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4PAMYPWQ.gif

-- CONFIDENTIALITY NOTICE:  This message is being sent by or on behalf of Immaculate Conception Academy.  It is intended exclusively for the individual or entity to which it is addressed.  This communication may contain information that is proprietary, privileged or confidential or otherwise legally protected.  The information herein may also be protected by the Electronic Communications Privacy Act, 18 U.S.C.A. Sections 2510-2521 or Children’s Online Privacy Protection Act (COPPA), 15 U.S.C. §§ 6501–6506.  If you are not the named addressee, you are not authorized to read, print, retain copy or disseminate this message or any part of it.  If you have received this message in error, please notify the sender immediately by e-mail and permanently delete all copies of the message.   INTERNET SECURITY NOTICE:  While all reasonable care has been taken to avoid the transmission of computer viruses, spyware, and other types of malware, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data.  No responsibility is accepted by the sender and the recipient should carry out such virus and other checks as it considers appropriate.

[francoisjacquet]

Rosariosis user did exist in the past. I have kept my database to that ownership. You have since changed it I believe to rosario or something like that.

The user which exists is only the user you create when installing RosarioSIS. You can choose whatever name you like.

Please refer to the INSTALL.md file: https://gitlab.com/francoisjacquet/rosariosis/-/blob/mobile/INSTALL.md#database

postgres=# CREATE USER rosariosis_user WITH PASSWORD 'rosariosis_user_password';

Here as you can see, it is called rosariosis_user, not rosariosis or rosario. And this is just a suggestion, not an obligation.

Anyway, as stated, you can safely remove those SQL commands. Please try without them and let me know.