Ok, I have deinstall php4 and installed php4-extensions (using make config)
The setup page is still say that database is not working. I could get to the login page now but when I try to login, I get: DB(mysql): Could not connect to the Database. Phpinfo() shows that mysql is enabled. One thing that looks suspicious is phpinfo shows MYSQL_INCLUDE and MYSQL_LIB show "no value" I can also login to mysql using user jffnms and password jffnms. So, the database has been setup correctly. Thanks in advance. Alhagie Puye - Network Engineer Datawave Group of Companies (604)295-1817 > >-----Original Message----- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of falz > >Sent: January 26, 2006 6:13 AM > >To: jffnms-users@lists.sourceforge.net > >Subject: Re: [jffnms-users] Database not working > > > >FreeBSD's php by default doesn't include session support. Either.. > > > > pkg_add -r php4-session > > > >Or instead install php using > > > > /usr/ports/lang/php4-extensions > > > >and do a "make config" to install php- much easier than > >typing with all of the MAKE lines you did. > > > >--falz > > > >On 1/25/06, Alhagie Puye <[EMAIL PROTECTED]> wrote: > >> Hey all, > >> > >> I just installed jffnms from the port tree that comes with > >FreeBSD 6.0. > >> > >> I have configured php with the following options: > >> > >> CONFIGURE_ARGS= --enable-versioning \ > >> --enable-memory-limit \ > >> --with-layout=GNU \ > >> --with-config-file-scan-dir=${PREFIX}/etc/php \ > >> --disable-cgi \ > >> --enable-safe-mode \ > >> --enable-magic-quotes \ > >> --disable-short-tags \ > >> --with-libxml-dir=/usr/local \ > >> --with-zlib \ > >> --with-mysql \ > >> --enable-bcmath \ > >> --with-bz2 \ > >> --enable-calendar \ > >> --enable-exif \ > >> --with-gd \ > >> --enable-gd-native-ttf \ > >> --enable-sockets \ > >> --with-pcre-regex=yes \ > >> --disable-all > >> > >> When I go to the setup page, it tells me says the database is not > >> working. Mysql modules are loaded properly it says. > >> > >> This is what I get in the httpd-error.log file: > >> > >> [Wed Jan 25 16:23:32 2006] [error] PHP Fatal error: Call > >to undefined > >> function: session_name() in > >/usr/local/share/jffnms/htdocs/auth.php > >> on line 41 [Wed Jan 25 16:24:43 2006] [error] PHP Fatal > >error: Call > >> to undefined > >> function: session_name() in > >/usr/local/share/jffnms/htdocs/auth.php > >> on line 41 > >> > >> Did I miss something during compilation? > >> > >> Here is the output for "php -i" > >> > >> freebsd# /usr/local/bin/php -i | more > >> phpinfo() > >> PHP Version => 4.4.0 > >> > >> System => FreeBSD freebsd.puyenet.com 6.0-STABLE FreeBSD > >6.0-STABLE #0: > >> Wed Jan 11 11:42:50 PST 2006 [EMAIL PROTECTED]:/ > >> usr/obj/usr/src/sys/apuye-01-11-2006 i386 Build Date => > >Jan 25 2006 > >> 16:02:23 Configure Command => './configure' '--enable-versioning' > >> '--enable-memory-limit' '--with-layout=GNU' > >> '--with-config-file-scan-dir=/ > >> usr/local/etc/php' '--disable-cgi' '--enable-safe-mode' > >> '--enable-magic-quotes' '--disable-short-tags' > >> '--with-libxml-dir=/usr/local > >> ' '--with-zlib' '--with-mysql' '--enable-bcmath' '--with-bz2' > >> '--enable-calendar' '--enable-exif' '--with-gd' > >'--enable-gd-native-tt > >> f' '--enable-sockets' '--with-pcre-regex=yes' '--disable-all' > >> '--with-regex=php' '--with-openssl=/usr' > >'--with-openssl-dir=/usr' '-- > >> with-apxs=/usr/local/sbin/apxs' '--disable-ipv6' > >'--prefix=/usr/local' > >> 'i386-portbld-freebsd6.0' > >> Server API => Command Line Interface > >> Virtual Directory Support => disabled > >> Configuration File (php.ini) Path => > >/usr/local/etc/php.ini Scan this > >> dir for additional .ini files => /usr/local/etc/php > >additional .ini > >> files parsed => /usr/local/etc/php/extensions.ini > >> > >> PHP API => 20020918 > >> PHP Extension => 20020429 > >> Zend Extension => 20050606 > >> Debug Build => no > >> Zend Memory Manager => enabled > >> Thread Safety => disabled > >> Registered PHP Streams => php, http, ftp, https, ftps, > >compress.bzip2, > >> compress.zlib > >> > >> > >> This program makes use of the Zend Scripting Language Engine: > >> Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies > >> > >> > >> > >> > >_____________________________________________________________ > >_________ > >> _ > >> > >> > >> Configuration > >> > >> PHP Core > >> > >> Directive => Local Value => Master Value > >> allow_call_time_pass_reference => Off => Off > >allow_url_fopen => On => > >> On always_populate_raw_post_data => Off => Off > >arg_separator.input => > >> & => & arg_separator.output => & => & asp_tags => Off => Off > >> auto_append_file => no value => no value auto_prepend_file > >=> no value > >> => no value browscap => no value => no value default_charset => no > >> value => no value default_mimetype => text/html => text/html > >> define_syslog_variables => Off => Off disable_classes => > >no value => > >> no value disable_functions => no value => no value > >display_errors => > >> Off => Off display_startup_errors => Off => Off doc_root > >=> no value > >> => no value docref_ext => no value => no value docref_root > >=> no value > >> => no value enable_dl => On => On error_append_string => > >no value => > >> no value error_log => no value => no value > >error_prepend_string => no > >> value => no value error_reporting => 2047 => 2047 > >expose_php => On => > >> On extension_dir => /usr/local/lib/php/20020429 => > >> /usr/local/lib/php/20020429 > >> file_uploads => On => On > >> gpc_order => GPC => GPC > >> highlight.bg => #FFFFFF => #FFFFFF > >> highlight.comment => #FF8000 => #FF8000 highlight.default > >=> #0000BB > >> => #0000BB highlight.html => #000000 => #000000 > >highlight.keyword => > >> #007700 => #007700 highlight.string => #DD0000 => #DD0000 > >html_errors > >> => Off => On ignore_repeated_errors => Off => Off > >> ignore_repeated_source => Off => Off ignore_user_abort => > >Off => Off > >> implicit_flush => On => Off include_path => .: => .: > >> log_errors => On => On > >> log_errors_max_len => 1024 => 1024 > >> magic_quotes_gpc => Off => Off > >> magic_quotes_runtime => Off => Off > >> magic_quotes_sybase => Off => Off > >> max_execution_time => 0 => 30 > >> max_input_time => 60 => 60 > >> memory_limit => 8M => 8M > >> open_basedir => no value => no value > >> output_buffering => 0 => 4096 > >> output_handler => no value => no value post_max_size => 8M => 8M > >> precision => 14 => 14 register_argc_argv => On => Off > >register_globals > >> => On => On report_memleaks => On => On safe_mode => Off => Off > >> safe_mode_exec_dir => no value => no value safe_mode_gid > >=> Off => Off > >> safe_mode_include_dir => no value => no value sendmail_from => no > >> value => no value sendmail_path => /usr/sbin/sendmail -t -i => > >> /usr/sbin/sendmail -t -i serialize_precision => 100 => 100 > >> short_open_tag => On => On SMTP => localhost => localhost > >smtp_port => > >> 25 => 25 sql.safe_mode => Off => Off track_errors => Off => Off > >> unserialize_callback_func => no value => no value > >upload_max_filesize > >> => 2M => 2M upload_tmp_dir => no value => no value user_dir => no > >> value => no value variables_order => GPCS => GPCS > >xmlrpc_error_number > >> => 0 => 0 xmlrpc_errors => Off => Off y2k_compliance => On => On > >> > >> bcmath > >> > >> BCMath support => enabled > >> > >> bz2 > >> > >> BZip2 Support => Enabled > >> BZip2 Version => 1.0.3, 15-Feb-2005 > >> > >> calendar > >> > >> Calendar support => enabled > >> > >> exif > >> > >> EXIF Support => enabled > >> EXIF Version => 1.4 $Id: exif.c,v 1.118.2.37 2005/03/22 > >22:07:03 edink > >> Exp $ Supported EXIF Version => 0220 Supported filetypes > >=> JPEG,TIFF > >> > >> gd > >> > >> GD Support => enabled > >> GD Version => bundled (2.0.28 compatible) GIF Read Support > >=> enabled > >> GIF Create Support => enabled PNG Support => enabled WBMP > >Support => > >> enabled XBM Support => enabled > >> > >> mysql > >> > >> MySQL Support => enabled > >> Active Persistent Links => 0 > >> Active Links => 0 > >> Client API version => 3.23.49 > >> MYSQL_MODULE_TYPE => builtin > >> MYSQL_SOCKET => /tmp/mysql.sock > >> MYSQL_INCLUDE => > >> MYSQL_LIBS => > >> > >> Directive => Local Value => Master Value > >mysql.allow_persistent => On > >> => On mysql.connect_timeout => 60 => 60 mysql.default_host > >=> no value > >> => no value mysql.default_password => no value => no value > >> mysql.default_port => no value => no value > >mysql.default_socket => no > >> value => no value mysql.default_user => no value => no value > >> mysql.max_links => Unlimited => Unlimited mysql.max_persistent => > >> Unlimited => Unlimited mysql.trace_mode => Off => Off > >> > >> openssl > >> > >> OpenSSL support => enabled > >> OpenSSL Version => OpenSSL 0.9.7e-p1 25 Oct 2004 > >> > >> pcre > >> > >> PCRE (Perl Compatible Regular Expressions) Support => enabled PCRE > >> Library Version => 5.0 13-Sep-2004 > >> > >> sockets > >> > >> Sockets Support => enabled > >> > >> standard > >> > >> Regex Library => Bundled library enabled Dynamic Library > >Support => > >> enabled Path to sendmail => /usr/sbin/sendmail -t -i > >> > >> Directive => Local Value => Master Value assert.active => 1 => 1 > >> assert.bail => 0 => 0 assert.callback => no value => no value > >> assert.quiet_eval => 0 => 0 assert.warning => 1 => 1 > >> auto_detect_line_endings => 0 => 0 default_socket_timeout > >=> 60 => 60 > >> safe_mode_allowed_env_vars => PHP_ => PHP_ > >> safe_mode_protected_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH > >> url_rewriter.tags => > >> a=href,area=href,frame=src,input=src,form=fakeentry > >> => a=href,area=href,frame=src,input=src,form=fakeentry > >> user_agent => no value => no value > >> > >> zlib > >> > >> ZLib Support => enabled > >> Compiled Version => 1.2.2 > >> Linked Version => 1.2.2 > >> > >> Directive => Local Value => Master Value > >zlib.output_compression => > >> Off => Off zlib.output_compression_level => -1 => -1 > >> zlib.output_handler => no value => no value > >> > >> Additional Modules > >> > >> Module Name > >> > >> Environment > >> > >> Variable => Value > >> SSH_CLIENT => 192.168.42.53 1908 22 > >> USER => apuye > >> MAIL => /var/mail/apuye > >> HOME => /root > >> SSH_TTY => /dev/ttyp0 > >> PAGER => more > >> ENV => /home/apuye/.shrc > >> LOGNAME => apuye > >> BLOCKSIZE => K > >> TERM => vt100 > >> PATH => > >> > >/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr > >/local/bin: > >> /usr/X11R6/bin:/root/bin > >> SSH_AUTH_SOCK => /tmp/ssh-E25ER1qodh/agent.64807 SHELL => /bin/csh > >> SSH_CONNECTION => 192.168.42.53 1908 192.168.42.1 22 > >FTP_PASSIVE_MODE > >> => YES EDITOR => vi HOSTTYPE => FreeBSD VENDOR => intel OSTYPE => > >> FreeBSD MACHTYPE => i386 SHLVL => 1 PWD => > >/usr/local/etc/php GROUP => > >> wheel HOST => freebsd.puyenet.com REMOTEHOST => 192.168.42.53 > >> > >> PHP Variables > >> > >> Variable => Value > >> PHP_SELF => > >> _SERVER["SSH_CLIENT"] => 192.168.42.53 1908 22 _SERVER["USER"] => > >> apuye _SERVER["MAIL"] => /var/mail/apuye _SERVER["HOME"] => /root > >> _SERVER["SSH_TTY"] => /dev/ttyp0 _SERVER["PAGER"] => more > >> _SERVER["ENV"] => /home/apuye/.shrc _SERVER["LOGNAME"] => apuye > >> _SERVER["BLOCKSIZE"] => K _SERVER["TERM"] => vt100 > >_SERVER["PATH"] => > >> > >/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr > >/local/bin: > >> /usr/X11R6/bin:/root/bin > >> _SERVER["SSH_AUTH_SOCK"] => /tmp/ssh-E25ER1qodh/agent.64807 > >> _SERVER["SHELL"] => /bin/csh _SERVER["SSH_CONNECTION"] => > >> 192.168.42.53 1908 192.168.42.1 22 > >_SERVER["FTP_PASSIVE_MODE"] => YES > >> _SERVER["EDITOR"] => vi _SERVER["HOSTTYPE"] => FreeBSD > >> _SERVER["VENDOR"] => intel _SERVER["OSTYPE"] => FreeBSD > >> _SERVER["MACHTYPE"] => i386 _SERVER["SHLVL"] => 1 > >_SERVER["PWD"] => > >> /usr/local/etc/php _SERVER["GROUP"] => wheel _SERVER["HOST"] => > >> freebsd.puyenet.com _SERVER["REMOTEHOST"] => 192.168.42.53 > >> _SERVER["PHP_SELF"] => _SERVER["SCRIPT_NAME"] => > >> _SERVER["SCRIPT_FILENAME"] => _SERVER["PATH_TRANSLATED"] => > >> _SERVER["DOCUMENT_ROOT"] => _SERVER["argv"] => Array ( > >> ) > >> > >> _SERVER["argc"] => 0 > >> > >> PHP License > >> This program is free software; you can redistribute it > >and/or modify > >> it under the terms of the PHP License as published by the > >PHP Group > >> and included in the distribution in the file: LICENSE > >> > >> This program is distributed in the hope that it will be > >useful, but > >> WITHOUT ANY WARRANTY; without even the implied warranty of > >> MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. > >> > >> If you did not receive a copy of the PHP license, or have any > >> questions about PHP licensing, please contact [EMAIL PROTECTED] > >> > >> Alhagie Puye - Network Engineer > >> Datawave Group of Companies > >> (604)295-1817 > >> > >> > >> This message (including any attachments) is confidential, > >may be privileged and is only intended for the person to > >whom it is addressed. If you have received it by mistake > >please notify the sender by return e-mail and delete this > >message from your system. Any unauthorized use or > >dissemination of this message in whole or in part is > >strictly prohibited. E-mail communications are inherently > >vulnerable to interception by unauthorized parties and are > >susceptible to change. We will use alternate communication > >means upon request. > >> > >> > >> ------------------------------------------------------- > >> This SF.net email is sponsored by: Splunk Inc. Do you grep > >through log > >> files for problems? Stop! Download the new AJAX search > >engine that > >> makes searching your log files as easy as surfing the > >web. DOWNLOAD SPLUNK! > >> http://sel.as-us.falkag.net/sel?cmdlnk&kid3432&bid#0486&dat1642 > >> _______________________________________________ > >> jffnms-users mailing list > >> jffnms-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/jffnms-users > >> > > > > > >------------------------------------------------------- > >This SF.net email is sponsored by: Splunk Inc. Do you grep > >through log files for problems? Stop! Download the new > >AJAX search engine that makes searching your log files as > >easy as surfing the web. DOWNLOAD SPLUNK! > >http://sel.as-us.falkag.net/sel?cmd=k&kid3432&bid#0486&dat1642 > >_______________________________________________ > >jffnms-users mailing list > >jffnms-users@lists.sourceforge.net > >https://lists.sourceforge.net/lists/listinfo/jffnms-users > > This message (including any attachments) is confidential, may be privileged and is only intended for the person to whom it is addressed. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. E-mail communications are inherently vulnerable to interception by unauthorized parties and are susceptible to change. We will use alternate communication means upon request. ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users