[Solved] User not found "SA"

[KLeabu46]

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.

[Villeroy]

Post the script file and the properties file.

[KLeabu46]

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

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

Properties file

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

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 -_-

[KLeabu46]

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!

[Villeroy]

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.

[KLeabu46]

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

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

.script file from spilt database

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

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