How To View Who Has Logged In To MySQL

Sep 20, 2007

Am running FreeBSD and MySQL. How do i check the login history for MySQL?

View 2 Replies


ADVERTISEMENT

[cpanel] "create View .." Doesn't Work For Mysql

Jul 11, 2007

why this mysql command doesn't work on phpmyadmin on cpanel server.

Quote:

CREATE VIEW TEST AS SELECT * FROM COURSE

it give this error:

Quote:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW TEST AS SELECT * FROM COURSE' at line 1

View 2 Replies View Related

Did They Logged In

Jul 7, 2007

I just check server logs today and found this:
Seems like someone else logged in to my server via FTP.

Since i only limited my IP to login to server Via FTP, SSH... using APF
But now, beside my IP, there's a few of connections from different IPs.

- Does that mean they logged in?
- What is the localhost login there?

Quote:

--------------------- Connections (secure-log) Begin
------------------------

Connections:
Service ftp [Connection(s) per day]:
My IP---> xx.xx.xxx.75
(CPE001xxxxxx-CM0011axxxxxxxx.cpe.net.cable.rogers.com): 4 Time(s)
125.234.3.44 (125.234.3.44.adsl.viettel.vn): 5 Time(s)
125.234.7.126: 1 Time(s)
125.234.13.160 (125.234.13.160.adsl.viettel.vn): 6 Time(s)
125.235.214.42 (dynamic-adsl-hni.vietel.com.vn): 2 Time(s)
222.252.35.156 (localhost): 7 Time(s)
222.252.91.206 (localhost): 11 Time(s)
222.253.167.25 (localhost): 6 Time(s)
222.254.76.7: 4 Time(s)
222.254.82.115: 8 Time(s)
Total Connections: 54
Service smtp [Connection(s) per day]:
24.110.34.203 (user-0c6s8mb.cable.mindspring.com): 1 Time(s)
65.28.34.116 (CPE-65-28-34-116.kc.res.rr.com): 1 Time(s)
72.184.44.3 (cpe-72-184-44-3.tampabay.res.rr.com): 1 Time(s)
74.67.7.155 (cpe-74-67-7-155.nycap.res.rr.com): 1 Time(s)
77.200.254.128 (128.254.200-77.rev.gaoland.net): 1 Time(s)
85.100.236.104 (dsl.dynamic85100236104.ttnet.net.tr): 1 Time(s)
86.129.186.224
(host86-129-186-224.range86-129.btcentralplus.com): 1 Time(s)
87.69.20.83 (87.69.20.83.cable.012.net.il): 1 Time(s)
132.248.77.252: 1 Time(s)
196.206.107.57 (adsl196-57-107-206-196.adsl196-4.iam.net.ma): 1
Time(s)
201.40.68.18 (201-40-68-18.mganm300.ipd.brasiltelecom.net.br): 1
Time(s)
207.63.250.11 (border.unit5.org): 1 Time(s)
211.208.200.2: 1 Time(s)
216.167.219.22 (216-167-219-22.chaska.net): 1 Time(s)
218.85.56.241
(241.56.85.218.broad.fz.fj.dynamic.163data.com.cn): 8 Time(s)
Total Connections: 22

---------------------- Connections (secure-log) End
-------------------------

View 0 Replies View Related

Root User Not Being Logged

Jun 27, 2007

Our web developer is logging in as root through SSH but log files do not show a record. We are getting the normal email notification but last & last -a does not show that they have logged in. Anyone seen this before?

View 7 Replies View Related

Not Able To Set Crontab To 4755 In SSH Logged In As Root

Mar 20, 2008

For some odd reason, when I run: chmod 4755 /usr/bin/crontab

in ssh, it still does not change it to 4755. It's like I don't have permission to change it, ans I'm logged in as root.

I've read some threads here on the forum and none really come to an issue where when they run that chmod 4755 /usr/bin/crontab it still doesn't chmod it.

So is there a way to check if it is chmodded to 4755 as I use CSF Exploerer to check if it is chmod'd to 4755, and it just stays at 755.

View 6 Replies View Related

Apache :: Redirect To Domain Root When Not Logged In

Sep 12, 2013

I would like to do do following using basic authentication:

1. non authenticated users have access to the index page: [URL] .....
2. there are other pages, e.g: [URL] .... but these would require basic auth
3. if users are not authenticated they would be redirected to [URL] .... otherwise authenticated users would have access to [URL] .... or anything else under that domain

View 1 Replies View Related

Plesk 12.x / Linux :: Admin Account Get Logged Out After A Minute

Feb 26, 2015

I'm running Plesk 12.0.18 Update #36 on CentOS 6.6 and when I log in, after just a minute of inactivity or so I get logged out.

The period of inactivity is set to 60 minutes, so that shouldn't be the problem.

View 7 Replies View Related

Apache :: Basic Auth User Not Logged In Common Log File

Jul 18, 2013

I use Basic Auth to limit access to a web site. This seems to work ok. I noticed though in the logs that the logged in user is not logged:

80.....188 - - [16/Jul/2013:09:56:29 +0200] "GET ..." 200 1844 "...." " ...

I would expect the second - to be replaced by the logged in user. The doc says, the user is logged if the document is protected. I do protect the whole directory using directory match. Without log in I fail to retrieve the document in question.

View 4 Replies View Related

Plesk 12.x / Linux :: Repeatedly Logged Out While Working On Config Of Primary Website

Feb 19, 2015

On our instance (Plesk 12 / Debian) I am logged out within 1 or 2 minutes quite often while working on config of the primary website (admin access). The session idle time is set to the 30 min default, and the problem isn't to do with changing IP addresses - the multiple sessions visible all have the same IP address.

This happens so constantly it is difficult do any real work. Where is the logic of session creation and termination? What do we need to look at to deal with this problem? We have root access.

View 10 Replies View Related

Can't View Man Pages

May 16, 2009

I can't get any man pages. For some reason when I try to use it, I continue to get this error:

Code:
XXX
XXX WARNING: old character encoding and/or character set
XXX

View 2 Replies View Related

Cant View .asp Files

Oct 30, 2008

im in the midst of doing my school final year project and i done some codings of asp pages but when i tried to upload to a linux server, i can only view the webpage with codes instead of the gui interface....i tried to upload my files to free asp host but same thing i cant view my webpages...

to upload this files online and present it to my teachers for grading...

the files are here [url]I hope i can find a free host dun need domain name with free ftp to upload these files and work properly...

View 14 Replies View Related

Remote View

Apr 3, 2008

how can I view the desktop of my server remotely through ssh.

View 3 Replies View Related

Can't View My Files.

May 21, 2007

Im with easyspace, we ordered an ssl with them a few weeks ago, after a few days they finally installed it for us, then they gave us some ftp details to reupload our site to, we did that but when we try and access our site now it forwards to iomartinternet.com

our website is thescotlandkiltcompany.co.uk

i went and looked at my domain control panel, i see that the nameservers are pointed to ns4.easyspace.com and ns5.easyspace.com

but in the dns control panel the nameservers were ns.iomart.co.uk and ns2.iomart.co.uk

anyone have any ideas whats going on?

Im summary, i am able to ftp.thescotlandkiltcompany.co.uk (this works)
Im able to upload files
Im able to view www.thescotlandkiltcompany.co.uk/images
but im unable to see my index page or anything else (any files or directories on my root or any other folder

I already created a www folder, public_html folder etc. etc. changed permissions on files and folders, nothing worked, anyone have a clue whats going on?

I did an dnsreport on the site too on dnsstuff.com

View 3 Replies View Related

Can't View My Files.

May 21, 2007

Im with easyspace, we ordered an ssl with them a few weeks ago, after a few days they finally installed it for us, then they gave us some ftp details to reupload our site to, we did that but when we try and access our site now it forwards to iomartinternet[dot]com

our website is thescotlandkiltcompany [dot]co[dot]uk

i went and looked at my domain control panel, i see that the nameservers are pointed to ns4.easyspace.com and ns5.easyspace.com

but in the dns control panel the nameservers were ns.iomart.co.uk and ns2.iomart.co.uk

anyone have any ideas whats going on?

Im summary, i am able to ftp[dot]thescotlandkiltcompany[dot]co[dot]uk (this works)
Im able to upload files
Im able to view www[dot]thescotlandkiltcompany[dot]co[dot]uk/images
but im unable to see my index page or anything else (any files or directories on my root or any other folder

I already created a www folder, public_html folder etc. etc. changed permissions on files and folders, nothing worked, anyone have a clue whats going on?

I did an dnsreport on the site too on dnsstuff[dot]com

View 3 Replies View Related

Softlayer - The European View

Apr 7, 2009

This review is based on my subjective experience with this service provider. Please take into consideration that each customer experience is unique in nature and can be heavily influenced by circumstances and cultural differences. My reviews are more prone to usability aspects rather than mips and milliseconds.

This review has not been financially influenced by the provider in question.

SOFTLAYER from the European perspective

Background:

I work for a value-added reseller hosting company in the Northern Europe and take care of server provisioning, offer request and service definition for our company needs.

We have used this company for the business hosting needs for over a year - we do yearly offer rounds and move our services should the need arise. Currently we are not hosting with Softlayer.

Experience is based on one dedicated server AMD Opteron 1216 with 4GB, 2x500GB RAID1 and Plesk 100 - location Dallas and Washinton DC facility. Reviewed services; control panel, private networking, help desk, sales support

Overview:

Softlayer has been in business for a while. They offer wide range of servers from single processor multicore to quad processor multicore servers. They have 3 different facilities in U.S; Seattle, Dallas and Washington DC. There are no Softlayer facilities available in Europe, but they do offer services to European customers as well. ( which is not the case with all the U.S based providers )
They offer fully automated services, an integrated control panel, developer API and wide range of software solutions for their server range plus number of other services that we have no experience with.

Privacy Policy:

Standard privacy policy with one side note; Softlayer follows the EU privacy protection laws and participates in the EU Safe Harbor program. This is more important for us Europeans; we are obliged to treat customer data in a specific way. (It's a long story, I'm going to spare you from the details)

Contract terms:

Monthly contract with server cancellation, at the latest 3 days prior the monthly anniversary. The cancellation can be done with the customer control panel. No questions asked - you do get a sales rep email and confirmation enquiry surely, for your own protection.

Installation

The server provisioning was really fast - in a few hours we had fully functioning server available with the specs as ordered and tested. This was a great service, we've had experiences with 10 day provisioning times.

Control Panel ( Customer Portal):

Softlayer customer portal is a comprehensive one. You can handle everything related to your server with a click of a button; reboots, OS reloads, reconfigurations, support requests and sales orders. One of the notable features was the ability to test firewall settings with external scanning provided by SL; easily done with a novice understandable report and suggestions.

You can give different access rights, access levels to users and share the control panel with the system administrators and support people. Overall usability of the control panel is good, navigation is simple, the screen is calm and there are no distractive elements. Softlayer has done a rather good job in handling comprehensive set of features in customer control panel.

For a beginner, the control panel can be a bit overwhelming though - it has been designed for the professional administrators with tens/hundreads of servers and whilst supporting this purpose well, a novice user would feel more confident with more narrow set of features. My preference for the novice user would be the server-centric usability focus; choose the server you manage and then the tasks related to that specific server. Help could be more easily available; there is a comprehensive knowledge base, but task oriented help is not necessarily available where the task is at the control panel.

Out of 10 points, Softlayer deservers 8,5 to the customer portal

Private Network

This is one of the brand marks of the Softlayer. They offer an excellent private network with PPTP & SSL access. The bandwidth is unlimited between you and your servers and even between your servers. You can truly shut down the external traffic to your server and still manage it from the background. The access is granted using PPTP (1 user) or SSL browser access with (Java plugin?). I used the PPTP, so the experience with SSL is limited.

This feature is free, which is exceptional. The true value comes when you have several servers with Softlayer and you interchange data between server. For single server owner this is of a less benefit, but surely a secure feature to access your server. The setup for private networking is seamless, easy to understand for a novice and wins my vote hands down

Out of 10 points, Softlayer deserves 9 for their private networking.

Network

Softlayer network is well connected, a connection to Northern Europe is around 80 - 100 ms from the WDC data center, it is barely noticeable for standard web user. During the year with SL, we did not experience any problems with their network connections. Some minor issues with private networking side ( nothing to do with SL )

Out of 10 points, Softlayer deserves 8 for their network connections to Europe

Help desk

Support ticket system; the response times are adequate, but you can sense that there is a night in the U.S and day in Europe. The response time improves at our night time and the tone tends to get more cheerful in the evenings. The responses were always professional though, and we never had a problem that wasn't resolved in a matter of an hour. The hardware was replaced and problems solved efficiently.

Out of 10 points, Softlayer deserves 8 for their helpdesk (If I were in U.S, I might give a 9)

Sales

Like with any service provider contact their sales before ordering; you might get lucky and get unlisted offers and pricing for your server. Softlayer has a good sales staff, but the service level is not consistent . If you are lucky, you might get a sales person not the "I just working here" - type. Their sales people are cheerful, genuine problem solvers and would like to find you the best alternative - the "I just work here" will read their price list and give you exactly what you asked; ie. they might have a great offer on AMD opteron 1216, but you asked for 1212. You'll get what you asked for - not the great offer available. Reason being, "you never asked".

Out of 10 points, I give 8 for the Softlayer sales.

Server pricing

Softlayer is not cheap and not even competitive always. The have a new outlet for bargain servers, but their pricing seems to start with USD119 what ever the case or name of the bargain is. Before signing-up with them, you should always do your own shopping around.

Out of 10 points, I give 7 for the Softlayer pricing

Conclusion

I would suggest Softlayer to any business owner with some experience and with several dedicated servers. For the novice user, with some reservations - maybe a smaller hosting provider would be better to start with. Their technical service is professional, coherent and they certainly know what they are doing.

Softlayer has an impressive service offering, especially with their private networking, but you need to be prepared to pay for it as well.

View 16 Replies View Related

How Can I View The Email Queue?

Jun 29, 2009

How can I view the email que? I have no control panel using CentOS5

View 10 Replies View Related

How To View All Ip Addresses On My Server

Aug 29, 2008

How to view all ip on the server ?

os linux

View 1 Replies View Related

How To View History Log Of Server On WHM

Mar 14, 2007

Is there a way to see what was happening on the server the last 24 hours for example in WHM ? A log or something.. To see if there was any high loads etc..

View 4 Replies View Related

Canīt View Flash On Server

Jul 23, 2007

Here you can see the problem and I am unsure how to fix it.

I am using a phproxy script on this domain

www.youtubetvshow.com

When you browse through this site, and look at youtube.com and try and watch a video, it does not allow you to view the flash.

I know this script works as I was using it on my past server.

My server is running on CentOS, with WHM

Does anyone know how to fix this on my server so people can view flash through my proxy site?

View 2 Replies View Related

View Kernel Logs

Aug 15, 2007

How do I few my server's kernel logs created by klogd?

View 1 Replies View Related

How View Error Log Of Server

Aug 24, 2007

I try view error log of server with this command

/usr/local/cpanel/logs/access_log

/usr/local/cpanel/logs/*

/usr/local/cpanel/logs/access_log

/usr/local/apache/logs/error_log

but it tell me permission denied

so how I view it?

can I view it with WHM or CP?

View 10 Replies View Related

View Error Logs

Feb 4, 2007

I am running Plesk on a VPS and a page on one of my websites won't load no matter what I try, I want to view the error logs but aren't sure how to go about it on this system...

View 4 Replies View Related

How To View Site Without Waiting Propagation

May 15, 2009

I brought a managed vps but I don't know how I can view my site on my vps? without waiting for domain propagation

View 6 Replies View Related

Cannot Edit/view Files In Any Directory

Sep 14, 2008

Command: CWD /public_html

Response: 550 Can't change directory to /public_html: Permission denied
Error: Failed to retrieve directory listing

That's what I see in FTP, but in File Manager in cPanel I don't see any files.

What do I do?

The permissions is set to 750 for /public_html and I cannot change them

View 14 Replies View Related

How To View Domain On Own Local Network

Mar 11, 2008

I am running my own webserver and up untill now checked my sites on a second broadband connection. Due to an accident i can now only afford the one connection.

My question is, how can i view my sites using domain name or static ip (not local)
I am running windows server 2003

I saw a post mentioning host files but did not quite understand if that is what was deeded, I am assuming that i need to loopback somehow.

My router has no loopback

View 6 Replies View Related

Is There A Way To View The Error_log Starting From The Bottom

Aug 3, 2008

Is there a way to view the error_log starting from the bottom? My error_log is HUGE.

View 4 Replies View Related

From A Technical Point Of View: SMF Vs. MyBB

Feb 4, 2007

I know there are many threads covering similar topics but their answers often do not contain technical arguments but rather subjective reasons and I'd like to know whether there are also some technical reasons to favor one of these two forums over the other.

Does one handle a higher load particularly well or does one have the cleaner code or is there any other reason to choose one over the other?

View 14 Replies View Related

Routers Needing Reboots To View Our Sites

May 20, 2008

I have a server with several sites hosted on it. Randomly, a site user will find that they can no longer connect to any of the sites on the server - but they can connect to the rest of the Internet. When this happens, the sites themselves are fine and everyone else can connect without any problems.

The only way the affected user can view sites on the server again is to reboot their router - at which point everything is fine.

why this would happen? I have a CentOS (Red Hat Enterprise) Linux server with DirectAdmin, Apache, PHP/MySQL - the usual. I'm thinking that there must be some kind of network setting which is allowing this to happen, but I can't for the life of me work out what it is.

View 2 Replies View Related

Can't View Emails From My Server In Outlook Or Thunderbird

Mar 5, 2008

I have a virtual dedicated server hosted with "Domains Priced Right" I have several domains hosted on the server with emails for each. I used to be able to view my emails in Outlook however recently I've been getting the error (0x80042108) 'Outlook cannot connect to incoming (POP3) email server'

I've switched to thunderbird and still have the same problem. "Could not connect to the server mail.blahblah.com; the connection was refused."

I have about 10 domains and I can't see the emails for any of them.

I know the emails are there I can see them when I use webmail. I know thunderbird works because it can get email from gmail and my ISP. It just won't connect to the server and download them.

Things worked in the past so I'm perplexed. I'm running Windows Vista and maybe a new update has caused a problem. It may be a firewall issue but I've had a look at that. Also I did do a clean up of some old drivers. I think it might be a dodgey email file.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved