Hi,

is there any software on linux to save the terminal output to database instantly? I am currently using Putty to read the Serial port data from the PBX but my online issue is I need to save the data to database please..

Thanks,
Jassim

Does it have to be done with a terminal? Is it not possible to have a daemon process that reads from the serial port and writes to a database?

how please?

It could be done many ways. Which language(s) do you know? What sort of database do you want to use?

I am new to linux

I am using MySql and I know .NET and C#.

Assuming the system is Linux, AFAIK we can rule out .NET so that leaves C# unless you want to invest the effort in learning another language. I don't C# but surely it can extract data from a serial port and there must be libraries to write to MySQL.

What you are trying to do does not sound unusual. Might be worth netsearching for a solution before developing your own.

If you do have to develop your own it will be worth netsearching for examples of how a program can daemonise itself, read from the serial port and write to a MySQL database.

as you said, i can do it easily using C# and MySql but the project I have is purely Linux backend...

Isn't C# enough like C++ for you to be able to program it on Linux?

I am not sure about C# on Linux. If it's possible then it won't be a direct solution from Microsoft.. It might be another third party

what about Linux it self? any other solution?!

GNU/Linux has a FOSS c++ compiler, gcc ("GNU/Linux" because Linux is only the kernel; many utilities including gcc are provided by GNU).

Alternatives? C, Ruby, python, perl, bash ... each with their pros and cons for developing in and for the problem/solution domain.

If I understand well, you have a serial connection to your PBX. A PBX is a telephone switch, right? (Public Branch eXchange). And now you are getting data (perhaps calling data, dialled numbers, durations) from that PBX and you have to store that in a database. Right? The next question will be how to represent the data you stored, how to search, produce statistics etc?

I am not sure whether you do this as a pure hobby project (just nice to have), but since PBX-es do not often appear at the home I assume you have been given a professional assigment.

Well, if you are able to fulfill this assigment, I hope you understand you should do some reserch first as to design what your needs are. Rather than wondering what programming language you'd need to pipe your terminal data into MySQL.

If it less severe than this, we would be happy to help you, if you can tell what the requirements are for your program, but more precise than piping it into MySQL.

jlinkels

this is my brother's small office.

There is a PBX (yes phone exchange) and I want to read the data..

I m able to read it with no issue except it's not saving into database so if they server crashed or was restarted then I am losing all the data.

I am currently using Serial PBX logger from Eltima software which is free and does the job. It saves the serial port data into a text file but they only issue here it is on Windows and I am planing to move the environment in my brother's office all to linux backend..

so it's a project for him and it's a study case for me because I am new to linux

Sounds challenging to move your brother's office to a Linux back-end when you are new to Linux

Have fun and tread carefully

Thanks

That has nothing to do with database storage, it is a simple logging utility. See if ttylog is suitable for you. Should be available in the repository of your distro. This is hearsay, I did not apply it myself, just found it in Google.

Minicom and associated logging is more sophisticated, but limited if the PBX does not dump ASCII.

jlinkels