Hello,
My database is currently rendered useless because of this one error. As far as I can tell, no files are corrupted and should be working in theory, but no matter what I do I cannot get in to my DB due to "user not found: SA". The only thing that has changed since I last looked at the core files is the mydb.data file appears to have a default open association with notepad. Does anyone know what to do about this? I have tried to do my due diligence and look online for an answer but nothing has worked or the situations are different. Any help would be appreciated. Currently running HSQLDB with Java 1.8 on a windows 10 machine.
[Solved] User not found "SA"
[Solved] User not found "SA"
Last edited by KLeabu46 on Fri Jun 23, 2017 9:21 pm, edited 1 time in total.
OpenOffice 4.1.0 running HSQLDB in server mode on Windows 10
Re: User not found "SA"
Post the script file and the properties file.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: User not found "SA"
Saw your reply this morning, I attached the files you asked for. Thank you for taking the time to look at these for me!
Script File
Properties file
Please ignore the sloppy layout of the table, I was inexperienced when I made the thing and my boss won't let me make a better one -_-
Script File
Code: Select all
SET DATABASE COLLATION "Latin1_General"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "Customer Database"("ID" INTEGER NOT NULL PRIMARY KEY,"First Name" VARCHAR_IGNORECASE(255),"Last Name" VARCHAR_IGNORECASE(255),"Company" VARCHAR_IGNORECASE(255),"Address" VARCHAR_IGNORECASE(255),"City" VARCHAR_IGNORECASE(255),"State" VARCHAR(2),"Zip" VARCHAR_IGNORECASE(255),"Phone Number" NUMERIC(11),"Cell Phone" NUMERIC(10),"Email" VARCHAR(255),"Tax Exempt" VARCHAR(255),"Date Purchased (OLD)" VARCHAR(5000),"Machine (OLD)" VARCHAR(5000),"Serial (OLD)" VARCHAR(5000),"Machine 1" VARCHAR_IGNORECASE(255),"Serial 1" VARCHAR_IGNORECASE(255),"Date of Purchase 1" VARCHAR(8),"Machine 2" VARCHAR_IGNORECASE(255),"Serial 2" VARCHAR_IGNORECASE(255),"Date of Purchase 2" VARCHAR(8),"Machine 3" VARCHAR_IGNORECASE(255),"Serial 3" VARCHAR_IGNORECASE(255),"Date of Purchase 3" VARCHAR(8),"Software 1" VARCHAR_IGNORECASE(255),"Software Serial 1" VARCHAR_IGNORECASE(255),"Date of Purchase 1.1" VARCHAR(8),"Software 2" VARCHAR_IGNORECASE(255),"Software Serial 2" VARCHAR_IGNORECASE(255),"Date of Purchase 2.1" VARCHAR(8),"Software 3" VARCHAR_IGNORECASE(255),"Software Serial 3" VARCHAR_IGNORECASE(255),"Date of Purchase 3.1" VARCHAR(8),"Machine 4" VARCHAR_IGNORECASE(255),"Serial 4" VARCHAR_IGNORECASE(255),"Date of Purchase 4" VARCHAR(8),"Machine 5" VARCHAR_IGNORECASE(255),"Serial 5" VARCHAR_IGNORECASE(255),"Date of Purchase 5" VARCHAR(8),"Machine 6" VARCHAR_IGNORECASE(255),"Serial 6" VARCHAR_IGNORECASE(255),"Date of Purchase 6" VARCHAR(8),"Notes 1" VARCHAR_IGNORECASE(5000),"Notes 2" VARCHAR_IGNORECASE(5000),"Notes 3" VARCHAR_IGNORECASE(5000),"Notes 4" VARCHAR_IGNORECASE(5000),"Notes 5" VARCHAR_IGNORECASE(5000),"Notes 6" VARCHAR_IGNORECASE(5000),"TAG 1" VARCHAR(7),"Date Recieved 1" VARCHAR(8),"Machine 11" VARCHAR_IGNORECASE(255),"Price 1" VARCHAR(255),"Date Completed 1" VARCHAR(8),"Work Done 1" VARCHAR(5000),"Problem Reported 1" VARCHAR(5000),"Stitch Count 1" VARCHAR(255),"Serial Number 1" VARCHAR_IGNORECASE(255),"TAG 2" VARCHAR(7),"Date Recieved 2" VARCHAR(8),"Machine 21" VARCHAR_IGNORECASE(255),"Price 2" VARCHAR(255),"Date Completed 2" VARCHAR(8),"Work Done 2" VARCHAR(5000),"Problem Reported 2" VARCHAR(5000),"Stitch Count 2" VARCHAR(255),"Serial Number 2" VARCHAR_IGNORECASE(255),"TAG 3" VARCHAR(7),"Date Recieved 3" VARCHAR(8),"Machine 31" VARCHAR_IGNORECASE(255),"Price 3" VARCHAR(255),"Date Completed 3" VARCHAR(8),"Work Done 3" VARCHAR(5000),"Problem Reported 3" VARCHAR(5000),"Stitch Count 3" VARCHAR(255),"Serial Number 3" VARCHAR_IGNORECASE(255),"TAG 4" VARCHAR(7),"Date Recieved 4" VARCHAR(8),"Machine 41" VARCHAR_IGNORECASE(255),"Problem Reported 4" VARCHAR(5000),"Work Done 4" VARCHAR(5000),"Sitch Count 4" VARCHAR(255),"Serial Number 4" VARCHAR_IGNORECASE(255),"Price 4" VARCHAR(255),"Date Completed 4" VARCHAR(8),"Notes 41" VARCHAR(5000),"Notes 11" VARCHAR(5000),"Notes 21" VARCHAR(5000),"Notes 31" VARCHAR(5000))
SET TABLE "Customer Database" INDEX'305944544 0'
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
Code: Select all
#HSQL Database Engine 1.8.0.10
#Sat Jun 17 09:28:27 EDT 2017
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=true
hsqldb.cache_size_scale=8
readonly=false
hsqldb.nio_data_file=false
hsqldb.cache_scale=13
version=1.8.0
hsqldb.default_table_type=cached
hsqldb.cache_file_scale=1
hsqldb.lock_file=true
hsqldb.log_size=10
modified=yes
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0
OpenOffice 4.1.0 running HSQLDB in server mode on Windows 10
Re: User not found "SA"
UPDATE: because reasons I decided to try and host the database from another one of my computers on the network and I am getting two different errors. The first is a socket creation error that I have thrown all of my past experience with at and cant seem to figure out whats wrong (I.e. IPV4 address is correct, jarpaths are correct, 32-bit and 64-bit java installed with the jarpath set to the 32-bit, firewall off, etc.). Funny thing is when I launch the sever it says the socket was successfully created in 15ms. The other I have never seen before being a "connection broken: Java.net.SocketException: Connection reset" error. I can't seem to come up with any posts about this sort of error as well. Hopefully someone with a bit more experience can shed some light on these. Thanks in advance!
OpenOffice 4.1.0 running HSQLDB in server mode on Windows 10
Re: User not found "SA"
From your properties and script files I can create a working database with user "SA" and one empty table "Customer Database". I have no clue about your network problems. I've never seen an error message about some missing user if that user is declared in the script file.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: User not found "SA"
I have fixed the issue, as you suggested earlier, I took a detailed look at the properties and script files and compared them with a clean database file not connected to the server (i.e. the skeleton database before i ripped it apart to make it a split database) and noticed a discrepancy between the script files. I'm not sure how this happened either but I will post the process in case anyone needs this post in the future.
1. I changed by backup database (the one not used as the back-end for the split database) to a .zip file and opened it with 7zip
2. Under the database folder, i opened the.script file with notepad.
3. I compared the .script file here with the .script file being used for my split database. Here's what I found:
.script file from clean copy
.script file from spilt database
4. I copied the data from the clean file to my split database file (after making a backup of course) and boom, worked like a charm
1. I changed by backup database (the one not used as the back-end for the split database) to a .zip file and opened it with 7zip
2. Under the database folder, i opened the.script file with notepad.
3. I compared the .script file here with the .script file being used for my split database. Here's what I found:
.script file from clean copy
Code: Select all
SET DATABASE COLLATION "Latin1_General"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "Customer Database"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"First Name" VARCHAR_IGNORECASE(255),"Last Name" VARCHAR_IGNORECASE(255),"Company" VARCHAR_IGNORECASE(255),"Address" VARCHAR_IGNORECASE(255),"City" VARCHAR_IGNORECASE(255),"State" VARCHAR(2),"Zip" VARCHAR_IGNORECASE(255),"Phone Number" NUMERIC(11),"Cell Phone" NUMERIC(10),"Email" VARCHAR(255),"Tax Exempt" VARCHAR(255),"Date Purchased (OLD)" VARCHAR_IGNORECASE(5000),"Machine (OLD)" VARCHAR_IGNORECASE(5000),"Serial (OLD)" VARCHAR_IGNORECASE(5000),"Machine 1" VARCHAR_IGNORECASE(255),"Serial 1" VARCHAR_IGNORECASE(255),"Date of Purchase 1" VARCHAR(8),"Machine 2" VARCHAR_IGNORECASE(255),"Serial 2" VARCHAR_IGNORECASE(255),"Date of Purchase 2" VARCHAR(8),"Machine 3" VARCHAR_IGNORECASE(255),"Serial 3" VARCHAR_IGNORECASE(255),"Date of Purchase 3" VARCHAR(8),"Software 1" VARCHAR_IGNORECASE(255),"Software Serial 1" VARCHAR_IGNORECASE(255),"Date of Purchase 1.1" VARCHAR(8),"Software 2" VARCHAR_IGNORECASE(255),"Software Serial 2" VARCHAR_IGNORECASE(255),"Date of Purchase 2.1" VARCHAR(8),"Software 3" VARCHAR_IGNORECASE(255),"Software Serial 3" VARCHAR_IGNORECASE(255),"Date of Purchase 3.1" VARCHAR(8),"Machine 4" VARCHAR_IGNORECASE(255),"Serial 4" VARCHAR_IGNORECASE(255),"Date of Purchase 4" VARCHAR(8),"Machine 5" VARCHAR_IGNORECASE(255),"Serial 5" VARCHAR_IGNORECASE(255),"Date of Purchase 5" VARCHAR(8),"Machine 6" VARCHAR_IGNORECASE(255),"Serial 6" VARCHAR_IGNORECASE(255),"Date of Purchase 6" VARCHAR(8),"Notes 1" VARCHAR(5000),"Notes 2" VARCHAR(5000),"Notes 3" VARCHAR(5000),"Notes 4" VARCHAR(5000),"Notes 5" VARCHAR(5000),"Notes 6" VARCHAR(5000),"TAG 1" VARCHAR_IGNORECASE(7),"Date Recieved 1" VARCHAR(8),"Machine 11" VARCHAR_IGNORECASE(255),"Price 1" VARCHAR_IGNORECASE(255),"Date Completed 1" VARCHAR(8),"Work Done 1" VARCHAR_IGNORECASE(5000),"Problem Reported 1" VARCHAR_IGNORECASE(5000),"Stitch Count 1" VARCHAR(255),"Serial Number 1" VARCHAR_IGNORECASE(255),"TAG 2" VARCHAR_IGNORECASE(7),"Date Recieved 2" VARCHAR(8),"Machine 21" VARCHAR_IGNORECASE(255),"Price 2" VARCHAR_IGNORECASE(255),"Date Completed 2" VARCHAR(8),"Work Done 2" VARCHAR_IGNORECASE(5000),"Problem Reported 2" VARCHAR_IGNORECASE(5000),"Stitch Count 2" VARCHAR(255),"Serial Number 2" VARCHAR_IGNORECASE(255),"TAG 3" VARCHAR_IGNORECASE(7),"Date Recieved 3" VARCHAR(8),"Machine 31" VARCHAR_IGNORECASE(255),"Price 3" VARCHAR_IGNORECASE(255),"Date Completed 3" VARCHAR(8),"Work Done 3" VARCHAR_IGNORECASE(5000),"Problem Reported 3" VARCHAR_IGNORECASE(5000),"Stitch Count 3" VARCHAR(255),"Serial Number 3" VARCHAR_IGNORECASE(255),"TAG 4" VARCHAR_IGNORECASE(7),"Date Recieved 4" VARCHAR(8),"Machine 41" VARCHAR_IGNORECASE(255),"Problem Reported 4" VARCHAR_IGNORECASE(5000),"Work Done 4" VARCHAR_IGNORECASE(5000),"Sitch Count 4" VARCHAR(255),"Serial Number 4" VARCHAR_IGNORECASE(255),"Price 4" VARCHAR_IGNORECASE(255),"Date Completed 4" VARCHAR(8),"Notes 41" VARCHAR_IGNORECASE(5000),"Notes 11" VARCHAR_IGNORECASE(5000),"Notes 21" VARCHAR_IGNORECASE(5000),"Notes 31" VARCHAR_IGNORECASE(5000),"TAG 5" VARCHAR_IGNORECASE(7),"Date Recieved 5" VARCHAR(8),"Machine 51" VARCHAR_IGNORECASE(255),"Problem Reported 5" VARCHAR_IGNORECASE(5000),"Work Done 5" VARCHAR_IGNORECASE(5000),"Stitch Count 5" VARCHAR(255),"Serial Number 5" VARCHAR_IGNORECASE(255),"Price 5" VARCHAR_IGNORECASE(50),"Date Completed 5" VARCHAR(8),"Notes 51" VARCHAR_IGNORECASE(5000),"TAG 6" VARCHAR_IGNORECASE(7),"Date Recieved 6" VARCHAR(8),"Machine 61" VARCHAR_IGNORECASE(255),"Problem Reported 6" VARCHAR_IGNORECASE(5000),"Work Done 6" VARCHAR_IGNORECASE(5000),"Stitch Count 6" VARCHAR(255),"Serial Number 6" VARCHAR_IGNORECASE(255),"Price 6" VARCHAR_IGNORECASE(255),"Date Completed 6" VARCHAR(8),"Notes 61" VARCHAR_IGNORECASE(5000),"TAG 7" VARCHAR_IGNORECASE(7),"Date Recieved 7" VARCHAR(8),"Machine 71" VARCHAR_IGNORECASE(255),"Problem Reported 7" VARCHAR_IGNORECASE(5000),"Work Done 7" VARCHAR_IGNORECASE(5000),"Stitch Count 7" VARCHAR(255),"Serial Number 7" VARCHAR_IGNORECASE(255),"Price 7" VARCHAR_IGNORECASE(255),"Date Completed 7" VARCHAR(8),"Notes 71" VARCHAR_IGNORECASE(5000),"TAG 8" VARCHAR_IGNORECASE(7),"Date Recieved 8" VARCHAR(8),"Machine 81" VARCHAR_IGNORECASE(255),"Problem Reported 8" VARCHAR_IGNORECASE(5000),"Work Done 8" VARCHAR_IGNORECASE(5000),"Stitch Count 8" VARCHAR(255),"Serial Number 8" VARCHAR_IGNORECASE(255),"Price 8" VARCHAR_IGNORECASE(255),"Date Completed 8" VARCHAR(8),"Notes 81" VARCHAR_IGNORECASE(5000))
SET TABLE "Customer Database" INDEX'209768136 5578'
ALTER TABLE "Customer Database" ALTER COLUMN "ID" RESTART WITH 5578
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
Code: Select all
SET DATABASE COLLATION "Latin1_General"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "Customer Database"("ID" INTEGER NOT NULL PRIMARY KEY,"First Name" VARCHAR_IGNORECASE(255),"Last Name" VARCHAR_IGNORECASE(255),"Company" VARCHAR_IGNORECASE(255),"Address" VARCHAR_IGNORECASE(255),"City" VARCHAR_IGNORECASE(255),"State" VARCHAR(2),"Zip" VARCHAR_IGNORECASE(255),"Phone Number" NUMERIC(11),"Cell Phone" NUMERIC(10),"Email" VARCHAR(255),"Tax Exempt" VARCHAR(255),"Date Purchased (OLD)" VARCHAR(5000),"Machine (OLD)" VARCHAR(5000),"Serial (OLD)" VARCHAR(5000),"Machine 1" VARCHAR_IGNORECASE(255),"Serial 1" VARCHAR_IGNORECASE(255),"Date of Purchase 1" VARCHAR(8),"Machine 2" VARCHAR_IGNORECASE(255),"Serial 2" VARCHAR_IGNORECASE(255),"Date of Purchase 2" VARCHAR(8),"Machine 3" VARCHAR_IGNORECASE(255),"Serial 3" VARCHAR_IGNORECASE(255),"Date of Purchase 3" VARCHAR(8),"Software 1" VARCHAR_IGNORECASE(255),"Software Serial 1" VARCHAR_IGNORECASE(255),"Date of Purchase 1.1" VARCHAR(8),"Software 2" VARCHAR_IGNORECASE(255),"Software Serial 2" VARCHAR_IGNORECASE(255),"Date of Purchase 2.1" VARCHAR(8),"Software 3" VARCHAR_IGNORECASE(255),"Software Serial 3" VARCHAR_IGNORECASE(255),"Date of Purchase 3.1" VARCHAR(8),"Machine 4" VARCHAR_IGNORECASE(255),"Serial 4" VARCHAR_IGNORECASE(255),"Date of Purchase 4" VARCHAR(8),"Machine 5" VARCHAR_IGNORECASE(255),"Serial 5" VARCHAR_IGNORECASE(255),"Date of Purchase 5" VARCHAR(8),"Machine 6" VARCHAR_IGNORECASE(255),"Serial 6" VARCHAR_IGNORECASE(255),"Date of Purchase 6" VARCHAR(8),"Notes 1" VARCHAR_IGNORECASE(5000),"Notes 2" VARCHAR_IGNORECASE(5000),"Notes 3" VARCHAR_IGNORECASE(5000),"Notes 4" VARCHAR_IGNORECASE(5000),"Notes 5" VARCHAR_IGNORECASE(5000),"Notes 6" VARCHAR_IGNORECASE(5000),"TAG 1" VARCHAR(7),"Date Recieved 1" VARCHAR(8),"Machine 11" VARCHAR_IGNORECASE(255),"Price 1" VARCHAR(255),"Date Completed 1" VARCHAR(8),"Work Done 1" VARCHAR(5000),"Problem Reported 1" VARCHAR(5000),"Stitch Count 1" VARCHAR(255),"Serial Number 1" VARCHAR_IGNORECASE(255),"TAG 2" VARCHAR(7),"Date Recieved 2" VARCHAR(8),"Machine 21" VARCHAR_IGNORECASE(255),"Price 2" VARCHAR(255),"Date Completed 2" VARCHAR(8),"Work Done 2" VARCHAR(5000),"Problem Reported 2" VARCHAR(5000),"Stitch Count 2" VARCHAR(255),"Serial Number 2" VARCHAR_IGNORECASE(255),"TAG 3" VARCHAR(7),"Date Recieved 3" VARCHAR(8),"Machine 31" VARCHAR_IGNORECASE(255),"Price 3" VARCHAR(255),"Date Completed 3" VARCHAR(8),"Work Done 3" VARCHAR(5000),"Problem Reported 3" VARCHAR(5000),"Stitch Count 3" VARCHAR(255),"Serial Number 3" VARCHAR_IGNORECASE(255),"TAG 4" VARCHAR(7),"Date Recieved 4" VARCHAR(8),"Machine 41" VARCHAR_IGNORECASE(255),"Problem Reported 4" VARCHAR(5000),"Work Done 4" VARCHAR(5000),"Sitch Count 4" VARCHAR(255),"Serial Number 4" VARCHAR_IGNORECASE(255),"Price 4" VARCHAR(255),"Date Completed 4" VARCHAR(8),"Notes 41" VARCHAR(5000),"Notes 11" VARCHAR(5000),"Notes 21" VARCHAR(5000),"Notes 31" VARCHAR(5000))
SET TABLE "Customer Database" INDEX'305944544 0'
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
OpenOffice 4.1.0 running HSQLDB in server mode on Windows 10