log server 2

[izlude]

Hi everybody, i try to make an log server under ubuntu 11.10, i have try to install NIS but it's only for linux like not for windows.
Please help

 

[ChrisHirst]

And your question is???????????????????????



Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[izlude]

Sorry, i thought you know the question. So my question is "is it possible ?, and how to built this kind of server ?"
Ps: the client is WinXP and the server is Ubuntu

 

[Noway2]

So my question is "is it possible ?

Yes, it sounds like you want a remote log server.

and how to built this kind of server ?"

See this article for a starting point:

http://www.linuxjournal.com/content/creating-centralized-syslog-server

 

[izlude]

Hi Noway2, thank's for the link but it's very difficult to make an Syslog-ng server, i tried to make one but i don't understand the concept.
Any suggestion?

 

[Noway2]

Not off hand. I've never configured a remote server. You might find some suggestions here:

http://www.linuxquestions.org/questions/search.php?searchid=5430602

There looks to be some "solved" threads on getting a syslog-ng server to work.

 

[izlude]

Me again,
Unfortunatly, they don't know "how to make this kind of server".
Thank's for the link

 

[ChrisHirst]

Unfortunatly, they don't know "how to make this kind of server".

Are you sure??

http://www.linuxquestions.org/questions/linux-general-1/how-to-setup-a-syslog-server-270113/

And 10 seconds plus Google found this

http://news.softpedia.com/news/Setting-Up-a-Central-Syslog-Server-44063.shtml

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[izlude]

They know how to build an SyslogServer but i don't want to make this kind of server.
I'd like to archive open and close session's log in a linux server.
This is what i want to do:
Client-------send log--------------->linux database server



Client:WinXp
log: contain the timeand date the users open/close a session
database: store the sql file, a database over linux server

So i've try to make a script over winXp to send log in a sql file, problem n°1 it works but the script execute only over admin session.
And the problem n°2, i don't know what kind of server i have to use to store the sql file.
the problem n°3, i've try to make a crontab to execute the sql file, it works but it duplicate the same things.

Thank's to Chris and Noway for the links
Someone can help me to resolve the problem 1,2 and 3

 

[IPGuru]

i am not sure I have fully understood your requirements but is you are just wanting to update data in a remote sql database (running on your Linux server) then depending on the database engine in use it should be possible to configure your application on the windows box to access the database directly.

for example there is a MySQL ODB driver for windows that would allow you to execute commands on the remote database without the need to transfer any files or run additional cron tasks

A Maintenance contract is essential, not a Luxury.
Do things on the cheap & it will cost you dear

 

[izlude]

IPGuru,
Are you sure? can you give me a tutorial link.
I'd try to find one but i don't know what to write in google!

 

[IPGuru]

you could try

http://dev.mysql.com/downloads/connector/odbc/

A Maintenance contract is essential, not a Luxury.
Do things on the cheap & it will cost you dear

 

[ChrisHirst]

http://www.heidisql.com/

Does your Win XP machine have a fixed IP, otherwise you may have to allow "Wildcard hosts" which is not a particularly good idea

You could install

http://dev.mysql.com/downloads/connector/odbc/3.51.html/

, you do of course have to write your own commands for whatever it is you need to do on the server, in a client side process/language/application that can use the ODBC connection that you have set up.

By the way: As you can probably now tell, it wasn't necessarily the question that was not understood, it was what the question actually meant.

A "log server" to a Linux server admin means the system (process) logs, and the only connection to a MySql there is the daemon mysqld.




Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[izlude]

Chris and IPGuru,
Sorry if you don't understand my problem (my english is very bad).
So i want to store windows session's log in a database (over linux).

 

[izlude]

I want to do this automatically (it's the reason of the crontab)
Thank's to answer my post

 

[ChrisHirst]

Are you referring to;

"sessions" as in the currently logged in usernames? (As shown from commandline: users <return>)

Or

"sessions" as in the currently active website visitor sessions

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[izlude]

Yes, Session like the current logged in usernames.
this why i use some bat file to save the users name.

I know i'm not very good with linux but i like this OS

 

[IPGuru]

izlude
You English may not be perfect but it is considerably better than my <insert language of your choice here>

A Maintenance contract is essential, not a Luxury.
Do things on the cheap & it will cost you dear

 

[izlude]

IpGuru, thank's i take it like a compliment
So have you any idea to help me to build this...kind of server?