Powered by Jitbit .Net Forum free trial version. dismiss

HomeInstallation

Installation Issues

Missing tables in TekRadius database Messages in this topic - RSS

einfur
einfur
Posts: 5


20.08.2020
einfur
einfur
Posts: 5
Due to a requirement for minimum user rights for the application database user I have manually created the tables in the TekRADIUS database using the four provided scrips in the installation folder for "Users", "Accounting", "Groups" and "Sessions".
But the service won't start since it also are expecting to find a table for "Clients". May scripts for creating the "Clients" tables and any other required tables (DHCP....) also be provided ?
0 link
Admin
Admin
Administrator
Posts: 5028


20.08.2020
Admin
Admin
Administrator
Posts: 5028
Client table and DHCP tables are created automatically. DHCP tables are required only if you enable built-in DHCP server. Please use attached SQL statements to create them manually.
edited by Admin on 20.08.2020

Attachments:
DHCP.sql
Clients.sql
0 link
einfur
einfur
Posts: 5


24.08.2020
einfur
einfur
Posts: 5
Admin wrote:
Client table and DHCP tables are created automatically. DHCP tables are required only if you enable built-in DHCP server. Please use attached SQL statements to create them manually.
edited by Admin on 20.08.2020

Thanks. This now works, and the service is up and running.
I see two warnings though this is set correctly in the database:
“Warning, database auto growth option is not set.”
“Warning, database log auto growth option is not set.”
Has this to do with the limited access rights to the database, or should this be of concern?
0 link
Admin
Admin
Administrator
Posts: 5028


24.08.2020
Admin
Admin
Administrator
Posts: 5028
We recommend you to enable database and log auto-growth options in your MS SQL database. You can safely ignore if you sized your database and log file sufficiently. Please also see https://support.microsoft.com/en-ca/help/315512/considerations-for-the-autogrow-and-autoshrink-settings-in-sql-server
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software