Powered by Jitbit .Net Forum free trial version. dismiss

recent posts recent posts - RSS

16 days ago
Topic:
MS SQL Server 2017 compatibility

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: MS SQL Server 2017 compatibility
Table creation routines are hardcoded into TekRADIUS Manager. These are added to be used to create tables manually when needed. Please use them to create these tables manually and send me error messages if you get any error while executing them.
16 days ago
Topic:
MS SQL Server 2017 compatibility

caseclosed
caseclosed
Posts: 4
i'm seeing the four sql files already under the tekradius folder for users, groups, accounting, etc - is there another reason why the app wouldn't recognize them in its working directory?
16 days ago
Topic:
Reporting time that the user was connected

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: Reporting time that the user was connected
You welcome. DO not forget to read Readme.rtf in the distribution archive file prior to upgrade.
16 days ago
Topic:
Reporting time that the user was connected

Davilson Negrisoli
Davilson Negrisoli
Posts: 4
OK I will update, I will make some backups here to not lose the information. thanks for your help,
16 days ago
Topic:
Reporting time that the user was connected

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: Reporting time that the user was connected
Please upgrade to the latest version. This is a fixed problem in the latest version.
16 days ago
Topic:
Reporting time that the user was connected

Davilson Negrisoli
Davilson Negrisoli
Posts: 4
5.1.2.0
16 days ago
Topic:
Reporting time that the user was connected

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: Reporting time that the user was connected
Which version of TekRADIUS have you installed?
16 days ago
Topic:
Reporting time that the user was connected

Davilson Negrisoli
Davilson Negrisoli
Posts: 4
hello Yasin,

it seems that when it saves the 'User-Request' value in the database it is giving aglum error, by unmatched data type.

I'm sending the logs for you to see.

thank you
16 days ago
Topic:
MS SQL Server 2017 compatibility

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: MS SQL Server 2017 compatibility
This indicates a problem with the certificate used for signing TRManager.exe. I'll investigate and update you shortly. You can find *.sql files under TekRADIUS application directtory to create Users, Groups and Accounting tables manually.
16 days ago
Topic:
Reporting time that the user was connected

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: Reporting time that the user was connected
Hi,

Can you send TekRADIUS log entries (Accessible through File menu) after setting log level to debug at Settings / Service Parameters for accounting sessions?

Best regards,

Yasin KAPLAN
16 days ago
Topic:
MS SQL Server 2017 compatibility

caseclosed
caseclosed
Posts: 4
zipped the old one, unzipped the new one, execution gives error code of 'A referral was returned from the server."
16 days ago
Topic:
Reporting time that the user was connected

Davilson Negrisoli
Davilson Negrisoli
Posts: 4
Hello, I am a programmer and I use the database to generate reports with the time that the user was connected, The records in the database accounting table are not saved correctly, the StatusType field is only saving the Start value, it does not save the Stop value. Someone has already gone through this to help me, sorry English, I'm from Brazil




18 days ago
Topic:
MS SQL Server 2017 compatibility

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: MS SQL Server 2017 compatibility
Hi,

Please make a backup of C:\Program Files (x86)\TekRADIUS\TRManager.exe and replace TRManager.exe with the one in https://www.kaplansoft.com/tekradius/release/TRManager.zip and try again please.

Best regards,

Yasin KAPLAN
19 days ago
Topic:
MS SQL Server 2017 compatibility

caseclosed
caseclosed
Posts: 4
The picture (attached to the initial post) shows no db called TekRADIUS is listed on the left, just the default 'master'. It is acting like it detects the TekRADIUS db, however, and gives MB sizes for it. The warning says it says it does not detect the 4 listed tables and to click create. it does create different tables on the left, however, under 'master' also shown in the picture.
19 days ago
Topic:
MS SQL Server 2017 compatibility

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: MS SQL Server 2017 compatibility
Hi,

Do you see any error displayed in status bar of TekRADIUS Manager when you click create database or create tables button?

Best regards,

Yasin KAPLAN
19 days ago
Topic:
MS SQL Server 2017 compatibility

caseclosed
caseclosed
Posts: 4
Greetings using the trial I click create database and it does not create a database. it creates fields under ms's master db and not the 4 that are checked. it creates dhcp pool ones. am I wrong using 2017 (with 2018 manager) for this to work?
25 days ago
Topic:
Unable to create TekRADIUS DB and Tables

TRusewk
TRusewk
Posts: 42
Yes, I was trying to use the GUI to create the database and tables, but it was not working. I didn't get any error, but it was not working. I also checked by using the "Test Connection" which was returning connection is successful but database doesn't exist. When I was clicking on "Create Database" button it was showing initialing DB connection in the status bar but nothing was happening.

Now I created the database and tables manually in the C:\TekRADIUSDB folder. So I can't test it now. I also tried to create tables by using the GUI after creating the database in the C:\TekRADIUSDB but I was still not able to create the tables.


Yes, I know that TekRADIUS application runs in x64 mode, what I was saying is that the installer should install it in the "C:\Program Files\TekRADIUS" folder by default to avoid confusion.
25 days ago
Topic:
Unable to create TekRADIUS DB and Tables

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: Unable to create TekRADIUS DB and Tables
You should normally use GUI to create database and tables. What type of error message have you received when you tried to create TekRADIUS database through the GUI? What is the error message when you use folder C:\TekRADIUSDB? TekRADIUS applications run in x64 mode even they are installed to C:\Program Files (x86)\TekRADIUS. You can verify this through Windows Task Manager.
25 days ago
Topic:
Unable to create TekRADIUS DB and Tables

TRusewk
TRusewk
Posts: 42
Hi Yasin,

So I followed your advise and created a folder by the name of C:\TekRADIUSDB and executed the SQL scripts manually to create the tables, as through GUI, I wasn't able to create tables.

This is a standard installation, so the MS SQL Service account should have received enough privileges. Another thing I noticed is the setup file of TekRADIUS installs it by default under the "C:\Program Files (x86)\TekRADIUS" folder. Since TekRADIUS is 64-bit app the installer should install it in the "C:\Program Files\TekRADIUS" instead?
25 days ago
Topic:
Unable to create TekRADIUS DB and Tables

Admin
Admin
Administrator
Posts: 4888
Admin
Admin
Administrator
Posts: 4888
Topic: Unable to create TekRADIUS DB and Tables
Hi,

Please try to create your database in a directory other than C:\Program Files (x86)\TekRADIUS. MS SQL service account, probably, does not have enough privilege to create a file in C:\Program Files (x86)\TekRADIUS folder. You can create a folder like C:\TekRADIUSDB and use it to create your database.

Best regards,

Yasin KAPLAN




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software