LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-13-2017, 10:03 PM   #1
TheB2B
Member
 
Registered: Feb 2007
Posts: 75

Rep: Reputation: 16
Loganalyzer setup hang - step 5, blank page


Going through the process of setting up loganalyzer get to step 5 all I get is a blank web page. Using Firefox, tried IE with the same results. From the Apache error.log I get;

PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /usr/share/loganalyzer/install.php:374\nStack trace:\n#0 {main}\n thrown in /usr/share/loganalyzer/install.php on line 374, referer: http://server/loganalyzer/install.php?step=3

Step 4 confirms "the database connection has been successfully verified!" Interesting item about step 4, it to opens blank page but if I force a reload it will open with the step 4 page.

Verified login credentials, logged into mysql from CLI using the same credentials, have tried using root account and got the same error message in the Apache error.log


Line 374 from install.php;
$link_id = mysql_connect( $_SESSION['UserDBServer'], $_SESSION['UserDBUser'], $_SESSION['UserDBPass']);

Is this an issue with the install.php script?

MySQL server & Loganalyzer web host
Ubuntu 16.04
MySQL 5.7.17
LogAnalyzer 4.1.5
From this same server I have phpmyadmin working, no issues,it too access the same DB.

Using a CentOS 7 server as the Rsyslog collector, uses the same credentials to connect to the remote MySQL server without any issues. Installed Loganalyzer on this server, same result as Ubuntu box.
 
Old 02-14-2017, 02:29 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,157
Blog Entries: 1

Rep: Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021
Quote:
PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect()
Looks like a problem with the php7 that's installed by default in ubuntu-16.04, because php7 has removed the support of myslq() functions in favor of mysqli() ones.

Are you sure you're running the latest LogAnalyzer 4.1.5(v4-stable)?
Because according to the release notes it's now using mysqli() instead of mysql(), so you shouldn't see the mysql_connect() error above.
 
Old 02-14-2017, 08:36 AM   #3
TheB2B
Member
 
Registered: Feb 2007
Posts: 75

Original Poster
Rep: Reputation: 16
I created a web page, info.php, with single line of phpinfo(); All I get is a blank white page.

Quote:
Are you sure you're running the latest LogAnalyzer 4.1.5(v4-stable)?
I'm positive I am running version 4.1.5, based on my test above appears to be more than the LogAnalyzer having a problem.

Any thoughts or suggestions on how to proceed?
 
Old 02-14-2017, 11:16 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,157
Blog Entries: 1

Rep: Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021
Quote:
Originally Posted by TheB2B View Post
I created a web page, info.php, with single line of phpinfo(); All I get is a blank white page.

I'm positive I am running version 4.1.5, based on my test above appears to be more than the LogAnalyzer having a problem.

Any thoughts or suggestions on how to proceed?
A blank page means that there is a php error.
Since you said in your OP that phpmyadmin works on that server, I guess that it should be some error you did. Your phpinfo page should look like this:
Code:
<?php
phpinfo();
?>
 
Old 02-14-2017, 07:41 PM   #5
TheB2B
Member
 
Registered: Feb 2007
Posts: 75

Original Poster
Rep: Reputation: 16
Quote:
<?php
phpinfo();
?>
That is what my info.php contains, just has you have shown above.
"I'm cursed I tell yea, cursed"
 
Old 02-15-2017, 12:27 AM   #6
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,157
Blog Entries: 1

Rep: Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021
Quote:
Originally Posted by TheB2B View Post
That is what my info.php contains, just has you have shown above.
"I'm cursed I tell yea, cursed"
In this case check for php errors in apache error.log.
I guess you've already enabled php logging, as you post the loganalyzer error in your OP.
BTW does phpmyadmin still works? How about a more simple page:
Code:
<?php
echo 'Test';
?>
 
Old 02-15-2017, 07:23 AM   #7
TheB2B
Member
 
Registered: Feb 2007
Posts: 75

Original Poster
Rep: Reputation: 16
Ok, I'm visually challenged I guess. Copied then pasted in

<?php
phpinfo();
?>

Works.

Have a new project, as this is a pet project, have a server to setup and that will take up my time for the immediate future. Consider this closed but not solved. Thanks for all your help, really appreciate it.
 
Old 09-08-2022, 07:48 AM   #8
Conan247
LQ Newbie
 
Registered: Sep 2022
Posts: 1

Rep: Reputation: 0
Lightbulb Finally found the solution! Had the same issue.

I know it's 5 years to late, but for me who searched for this error found this forum as the first google entry.

Quick Fix:

sudo apt install php-mysqli
sudo service apache2 restart

damn
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Step By Step Ubuntu 14.10 (Utopic Unicorn) LAMP Server Setup LXer Syndicated Linux News 0 11-20-2014 03:30 AM
postfixadmin blank setup.php page gabsik Linux - Server 6 08-05-2014 03:11 PM
LXer: Step By Step Ubuntu 13.10 (Saucy Salamander) LAMP Server Setup LXer Syndicated Linux News 0 11-12-2013 11:12 AM
LXer: Step By Step Ubuntu 13.04 (Raring Ringtail) LAMP Server Setup LXer Syndicated Linux News 0 09-12-2013 04:34 PM
Step 4: Create partitions page is blank on 9.10 install. Takara Linux - Newbie 9 10-30-2009 08:39 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:23 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration