Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Programming/Scripts

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th May 2010, 19:04
BigThetan BigThetan is offline
Junior Member
 
Join Date: May 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help with phplogcon!!

Hi I am running a Ubuntu rsyslog Server and I am trying to manage my logs thru a web interface. I was following the How To @ http://www.unix-tutorials.com/go.php?id=2758 and When I got to step 5 I tried PHPLOGCON config I get this message after i finish entering the setup info.


Code:
Checking users input... Done!
Creating required tables... 
Database error: Cannot connect to database-server 
mysql error: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 
mysql error number: 2013
Date: 28.05.2010 @ 01:59
Script: /phplogcon/install/perform.php
Referer: http://10.78.46.206/phplogcon/install/install.php
can anyone assist me with this. Mysql is up and listening
Reply With Quote
Sponsored Links
  #2  
Old 31st May 2010, 00:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

What's the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 2nd June 2010, 17:59
BigThetan BigThetan is offline
Junior Member
 
Join Date: May 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for responding. This what I get

Code:
(No info could be read for "-p": geteuid()=1000 but you should be root.)
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 localhost:mysql         *:*                     LISTEN      -               
tcp        0      0 *:www                   *:*                     LISTEN      -               
tcp        0      0 *:ssh                   *:*                     LISTEN      -               
tcp        0      0 localhost:ipp           *:*                     LISTEN      -               
tcp        0      0 *:shell                 *:*                     LISTEN      -               
tcp        0      0 10.78.46.206:shell      10.78.46.138:47788      ESTABLISHED -               
tcp        0      0 10.78.46.206:ssh        10.78.46.138:57231      ESTABLISHED -               
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      -               
tcp6       0      0 localhost:ipp           [::]:*                  LISTEN      -               
tcp6       0      0 [::]:shell              [::]:*                  LISTEN      -
Reply With Quote
  #4  
Old 3rd June 2010, 15:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Can you try to make MySQL listen on all interfaces (not just localhost)?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 3rd June 2010, 17:42
BigThetan BigThetan is offline
Junior Member
 
Join Date: May 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply. I'm a bit of a newb with Linux. how would I go about making it listen on other interfaces?
Reply With Quote
  #6  
Old 4th June 2010, 12:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Take a look at chapter 14 on http://www.howtoforge.com/perfect-se...ispconfig-2-p4
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 7th June 2010, 20:24
BigThetan BigThetan is offline
Junior Member
 
Join Date: May 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi So I got MySql to listen on all interfaces. Thanks for the reference. However I am still not able to get phplogcon to connect to the database i get the following error now:

Code:
.: phpLogCon Installation :.


Checking users input... Done!
Creating required tables... 
Database error: Cannot connect to database-server 
mysql error: Host '10.78.46.206' is not allowed to connect to this MySQL server 
mysql error number: 1130
Date: 07.06.2010 @ 01:38
Script: /phplogcon/install/perform.php
Referer: http://10.78.46.206/phplogcon/install/install.php
that ip address is the address of the server itself. thanks for your help thus far.
Reply With Quote
  #8  
Old 8th June 2010, 16:11
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Please take a look at the mysql.user table. Is there a user with the host 10.78.46.206 or %?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 10th June 2010, 17:29
BigThetan BigThetan is offline
Junior Member
 
Join Date: May 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was doing some research on mysql commands and i did not see the one that would show me how to view that table. Could you point me in the right direction
Reply With Quote
  #10  
Old 11th June 2010, 15:07
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
 
Default

I suggest you install phpMyAdmin to take a look at your tables.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Enhanced Logging With rsyslog On Debian Etch And phpLogcon For Viewing - DSN Problem Kai HOWTO-Related Questions 2 4th December 2007 09:50


All times are GMT +2. The time now is 23:48.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.