Powered by Jitbit .Net Forum free trial version. dismiss

recent posts recent posts - RSS

24.08.2020
Topic:
Missing tables in TekRadius database

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: Missing tables in TekRadius database
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
24.08.2020
Topic:
Missing tables in TekRadius database

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?
20.08.2020
Topic:
Missing tables in TekRadius database

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: Missing tables in TekRadius database
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
20.08.2020
Topic:
Missing tables in TekRadius database

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 ?
20.08.2020
Topic:
TekRADIUS and MsSQL2017 domain account (AD)

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: TekRADIUS and MsSQL2017 domain account (AD)
You welcome
20.08.2020
Topic:
TekRADIUS and MsSQL2017 domain account (AD)

einfur
einfur
Posts: 5
Admin wrote:
Here is another update; https://www.kaplansoft.com/tekradius/release/TekRADIUS-Update-A.zip

TekRADIUS Manager connects to MS SQL server using credentials of logged in Windows user account when you set empty username and password for SQL server connection. TekRADIUS service account is installed run under local system account. You can set a Windows/AD account through Windows / Services for TekRADIUS service. This account must have "Act as a part of operating system" privilege.
edited by Admin on 19.08.2020


Thank you again. This part now seems to be working.
19.08.2020
Topic:
TekRADIUS and MsSQL2017 domain account (AD)

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: TekRADIUS and MsSQL2017 domain account (AD)
Here is another update; https://www.kaplansoft.com/tekradius/release/TekRADIUS-Update-A.zip

TekRADIUS Manager connects to MS SQL server using credentials of logged in Windows user account when you set empty username and password for SQL server connection. TekRADIUS service account is installed run under local system account. You can set a Windows/AD account through Windows / Services for TekRADIUS service. This account must have "Act as a part of operating system" privilege.
edited by Admin on 19.08.2020
19.08.2020
Topic:
TekRADIUS and MsSQL2017 domain account (AD)

einfur
einfur
Posts: 5
Admin wrote:
Please replace existing .exe files under TekRADIUS application directory with the ones in https://www.kaplansoft.com/tekradius/release/TekRADIUS-Update.zip Leave SQL server username and password blank. This will force TekRADIUS to use Windows authentication.


Thanks. I have updated with the new files, but I haven't managed to solve the problem. I don't quite understand what you mean by leaving the SQL server username and password blank? TekRADIUS does not allow for these fields to be blank and won't accept saving the configuration. And how will then TekRADIUS know which account to use?
18.08.2020
Topic:
TekRADIUS and MsSQL2017 domain account (AD)

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: TekRADIUS and MsSQL2017 domain account (AD)
Please replace existing .exe files under TekRADIUS application directory with the ones in https://www.kaplansoft.com/tekradius/release/TekRADIUS-Update.zip Leave SQL server username and password blank. This will force TekRADIUS to use Windows authentication.
18.08.2020
Topic:
TekRADIUS and MsSQL2017 domain account (AD)

einfur
einfur
Posts: 5
I am attempting to set up TekRADIUS using with MsSQL2017 running on a separate server with a domain account for MsSQL user.
But from our logs it seem like TekRADIUS is attempting to log on to the database using 'SQL Server Authentication’ instead of ‘Windows Authentication’, which would require a local SQL user account which is not wanted on our systems.
Can TekRADIUS be configured so the database log on can work using a domain account?
27.06.2020
Topic:
Error starting service

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: Error starting service
It is necessary to have Microsoft .NET Framework 4.6.1 installed with the latest updates.
27.06.2020
Topic:
Error starting service

leudys
leudys
Posts: 10
leudys
leudys
Posts: 10
Topic: Error starting service
Admin wrote:
Yes, I have tested. There was not any problem.


do i need any other depenncy rather than .net framework 4.5?
26.06.2020
Topic:
Error starting service

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: Error starting service
Yes, I have tested. There was not any problem.
26.06.2020
Topic:
Error starting service

leudys
leudys
Posts: 10
leudys
leudys
Posts: 10
Topic: Error starting service
Admin wrote:
It looks like a system specific problem.

have you tested with a fresh install in windows 10 v1909?
26.06.2020
Topic:
Error starting service

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: Error starting service
It looks like a system specific problem.
26.06.2020
Topic:
Error starting service

leudys
leudys
Posts: 10
leudys
leudys
Posts: 10
Topic: Error starting service
Admin wrote:
Can you send me the error message? There should be a number with the error message.

leudys wrote:
same error



error reading settings[2], that is the number you ask for?
26.06.2020
Topic:
Error starting service

leudys
leudys
Posts: 10
leudys
leudys
Posts: 10
Topic: Error starting service
Admin wrote:
Can you send me the error message? There should be a number with the error message.

leudys wrote:
same error
26.06.2020
Topic:
Error starting service

leudys
leudys
Posts: 10
leudys
leudys
Posts: 10
Topic: Error starting service
Admin wrote:
Can you send me the error message? There should be a number with the error message.

leudys wrote:
same error



No se puede iniciar el servicio. System.TypeInitializationException: Se produjo una excepción en el inicializador de tipo de '⛘졬ퟫ轄㠗뛜䙎'. ---> System.InvalidOperationException: No se pueden cargar los datos del nombre de contador porque se leyó un índice '' no válido del Registro.
en System.Diagnostics.PerformanceCounterLib.GetStringTable(Boolean isHelp)
en System.Diagnostics.PerformanceCounterLib.get_NameTable()
en System.Diagnostics.PerformanceCounterLib.get_CategoryTable()
en System.Diagnostics.PerformanceCounterLib.CounterExists(String category, String counter, Boolean& categoryExists)
en System.Diagnostics.PerformanceCounterLib.CounterExists(String machine, String category, String counter)
en System.Diagnostics.PerformanceCounter.InitializeImpl()
en System.Diagnostics.PerformanceCounter..ctor(String categoryName, String counterName, String instanceName, Boolean readOnly)
en (String , String , String , Boolean )
en 檸안햪�졶噈ꗼ躶.ఄ考䒤紿䑆ㅹ@뷞(String ⍚䛽䴶嚽᳞ꀽ膪1, String ⍚䛽䴶嚽᳞ꀽ膪1, String ⍚䛽䴶嚽᳞ꀽ膪1, Boolean ⍚䛽䴶嚽᳞ꀽ膪1)...
26.06.2020
Topic:
Error starting service

Admin
Admin
Administrator
Posts: 4997
Admin
Admin
Administrator
Posts: 4997
Topic: Error starting service
Can you send me the error message? There should be a number with the error message.

leudys wrote:
same error
26.06.2020
Topic:
Error starting service

leudys
leudys
Posts: 10
leudys
leudys
Posts: 10
Topic: Error starting service
i install it in another pc and work fine, both runing in windows 10 version 1909




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software