Matthew Snow

Ok, I figured it out. It had to do with my CAS config.php settings. At the bottom is the following piece of code

// Set the session-name to be unique to the current script so that the client script // doesn't share its session with a proxied script. // This is just useful when running the example code, but not normally. session_name( 'session_for:' . preg_replace('/[^a-z0-9-]/i', '_', basename($_SERVER['SCRIPT_NAME'])) );

This effectively is what was causing a session cookie to be generated for each page based off of the page's name. Replacing basename($_SERVER['SCRIPT_NAME']) with 'mySite' has solved the issue.

I've followed Jasig's PHP CAS documentation and have successfully implemented their sample code found here (https://github.com/Jasig/phpCAS/blob/master/docs/examples/example_simple.php). This works well for a single page site, but I'm at a loss for how implement this for multiple pages. For example, how do I check if the user is authenticated on subsequent pages after successfully logging in? I thought I would just need to add this code to each of them but what I've found is that though it doesn't redirect me to our CAS signon page again, it does however generate a new unique session cookie for that subsequent page. Essentially, a unique session cookie is generated for each of the pages on my site. If it then try to log out (phpCAS::logout;) from one of these pages, only that page's unique session cookie is invalidated leaving the others active. Essentially I would need to call logout on every page.

Just as a wrap up if anyone else new to PHP is trying to use a minimalist database with their PHP script, the following code works after enabling the php_sqlite3.dll extension in the php.ini file for Windows users. When run, this code will create a file test.db in the same directory where it is run.

<?php echo "Connecting to database\r\n"; $db = new SQLite3('test.db') or die('Unable to open database.'); echo "Creating table if not exists\r\n"; $result = $db->query("CREATE TABLE IF NOT EXISTS messages ( id INTEGER PRIMARY KEY, title TEXT, message TEXT, datetime TEXT, date TEXT, time TEXT)"); echo "Inserting into table\r\n"; $stmt = $db->prepare("INSERT INTO messages (title, message, datetime, date, time) VALUES (:title, :message, :datetime, :date, :time)"); $stmt->bindValue(':title', 'Greeting'); $stmt->bindValue(':message', 'Hello World'); $stmt->bindValue(':datetime', date('c')); $stmt->bindValue(':date', date('Ymd')); $stmt->bindValue(':time', date('His')); $result = $stmt->execute(); $result = $db->query('SELECT * FROM messages'); while ($row = $result->fetchArray()) { print_r($row); echo "\r\n"; } ?>

Thanks for the advice. From what I'm reading online it seems like that's going to be my bread and butter for PHP development, though for this instance I'll probably go with SQLite.

I see. The reason I'm wanting to do this is I'm dealing with large amounts of data from a web service and so have sacrificed memory for speed and of course I'm running into heap size issues just using arrays. Rather than just increasing PHP's heap size, I thought I'd use the on-demand'ness of a database to dump the data in bulk from the web service so I could query it as needed much faster. I was hoping to go with a "lite as can be" local file system database like HSQLDB which wouldn't require web server or a bunch of libraries to setup. Is there something akin to this in PHP, or should I be approaching the problem in another way?

I am able to do this in Java with HSQLDB's jdbc driver as follows:

java.sql.DriverManager.registerDriver(new org.hsqldb.jdbcDriver()); java.sql.DriverManager.getConnection("jdbc:hsqldb:file:C:\\Test\\db","SA","SA");

This would reference a db.script file located on the file system at C:\Test\ which contained the schema for all the tables being used as well as their data. Is it also possible to reference a HSQLDB script file within the same working directory as your PHP code using oci, odbc, pdo or something else?

Thanks for the reply. Below is my /etc/init.d/tomcat script. This script is invoking CATALINA_HOME/bin/catalina.sh. I did not enable the tomcat user in rc.conf, file does not exist on CentOS 6.5, or at least I can't find it. The chkconfig commands I used were "chkconfig --add /etc/init.d/tomcat" and "chkconfig --level 234 /etc/init.d/tomcat on".

export JAVA_HOME=/usr/java/jdk1.7.0_51 export CATALINA_HOME=/opt/tomcat export PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin DAEMON=$CATALINA_HOME/bin/catalina.sh NAME=tomcat DESC="tomcat6" test -f $DAEMON || exit 0 set -e if [ ! $CATALINA_HOME ] ; then echo "Please define CATALINA_HOME in /etc/profile.d/tomcat.sh" exit 1 fi COMMAND=$1 OPTION=0 if [ $1 = "-f" ] ; then OPTION=$1 COMMAND=$2 fi case $COMMAND in start) echo -n "Starting $DESC: " chown -R tomcat:tomcat $CATALINA_HOME/* $DAEMON start echo "$NAME." ;; stop) echo -n "Stopping $DESC: " if [ $OPTION = "-f" ] ; then $DAEMON stop -force else $DAEMON stop fi echo "$NAME." ;; restart) echo -n "Stopping $DESC: " if [ $OPTION = "-f" ] ; then $DAEMON stop -force else $DAEMON stop fi sleep 1 echo echo -n "Starting $DESC: " $DAEMON start echo "$NAME." ;; *) N=/etc/init.d/$NAME echo "Usage: $N [-f] {start|stop|restart}" >&2 exit 1 ;; esac exit 0

I've setup tomcat on a CentOS 6.5 and chown'ed the directory as tomcat:tomcat (a valid user on the server). I've placed my startup script in /etc/init.d/tomcat (chmod 755) and I've registered it with chkconfig at level 234, though a --list shows level 5 is also on. We've also disabled SELinux, but tomcat still will only come up when the user account root is logged into. The only thing I can think of is that I did all of this as the root user, not as the tomcat user using sudo. Would that be the cause of my problem, or am I missing something else.

I'm running Xampp 1.8.3 for windows (my machine is x64) which comes with PHP 5.5.3 included with cURL enabled by default. I've installed a fresh new copy and am trying to test a connection to mozilla.org over ssl with cURL using a .pem file I extracted from the site's certificate using FireFox 24. But I'm getting the error "unable to get local issuer certificate". Here is my code:

<?php // Set the URL to visit $url = "https://www.mozilla.org/en-US/"; // Set .pem file to use $certFile = dirname(__FILE__) . '\www.mozilla.org.crt'; // In this example we are referring to a page that handles xml $headers = array( "Content-Type: text/xml",); // Initialise Curl $curl = curl_init($url); if ($curl === false) throw new Exception(' cURL init failed'); // Set up to view correct page type curl_setopt($curl, CURLOPT_HTTPHEADER, $headers); // Turn on SSL certificate verfication curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, TRUE); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 2); curl_setopt($curl, CURLOPT_CAINFO, $certFile); // Tell the curl instance to talk to the server using HTTP POST curl_setopt($curl, CURLOPT_POST, 1); // 1 second for a connection timeout with curl curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 5); // Try using this instead of the php set_time_limit function call curl_setopt($curl, CURLOPT_TIMEOUT, 60); // Causes curl to return the result on success which should help us avoid using the writeback option curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); echo "Connecting to " . $url . "<br/>"; echo "Using " . $certFile . "<br/>"; echo "<br/>"; if(curl_exec($curl) == false) echo ("Error: " . curl_errno($curl) . ", " . curl_error($curl) . "<br/>"); else echo "Success!" . "<br/>"; ?>

Here is the contents of the pem file:
-----BEGIN CERTIFICATE----- MIIFfjCCBGagAwIBAgICKTgwDQYJKoZIhvcNAQEFBQAwgYUxCzAJBgNVBAYTAlVT MRUwEwYDVQQKEwxHZW9UcnVzdCBJbmMxMTAvBgNVBAsTKFNlZSB3d3cuZ2VvdHJ1 c3QuY29tL3Jlc291cmNlcy9jcHMgKGMpMDYxLDAqBgNVBAMTI0dlb1RydXN0IEV4 dGVuZGVkIFZhbGlkYXRpb24gU1NMIENBMB4XDTExMTIxNTIwMzU0N1oXDTEzMTIx NjIxMjMwOFowge0xHTAbBgNVBA8TFFByaXZhdGUgT3JnYW5pemF0aW9uMRMwEQYL KwYBBAGCNzwCAQMTAlVTMRswGQYLKwYBBAGCNzwCAQITCkNhbGlmb3JuaWExETAP BgNVBAUTCEMyNTQzNDM2MQswCQYDVQQGEwJVUzETMBEGA1UECBMKQ2FsaWZvcm5p YTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEbMBkGA1UEChMSTW96aWxsYSBGb3Vu ZGF0aW9uMRYwFAYDVQQLEw1JVCBPcGVyYXRpb25zMRgwFgYDVQQDEw93d3cubW96 aWxsYS5vcmcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDeOh6yffa6 EUJiq7B3gmqMopyskeIquGSmuz5lpS3ajoUezV24W/xnKHSgn87C0KBzUSjRY46I x9lHdgfDlptNv1Zt+BoRwVHuZt0IZnGYZeStg05qGY5fsznpDIfyJAWXtOaWmju7 2a1Mpvultu4AkoxD1etPZZgY/FaUSftmpYvpCaHFjL+mLdF88NvUG6OpX4/L/uTv 05OOPcjbLHvL3tw1CerOzqF6BDbB8qOh0DXAN/CF4/OS8LdLWXW2VPDXv+fMq4aw eCV+nDVn6V4sZH5rplztPXMQdZZoxSMESctd1lpFarXpd7uJ8kzrmMz9D3dIzkhL /lA9B6Dng/8BAgMBAAGjggGMMIIBiDAfBgNVHSMEGDAWgBQoxOuP8V95kKMrVcNW Tn1rU3IsGDBuBggrBgEFBQcBAQRiMGAwKgYIKwYBBQUHMAGGHmh0dHA6Ly9FVlNT TC1vY3NwLmdlb3RydXN0LmNvbTAyBggrBgEFBQcwAoYmaHR0cDovL0VWU1NMLWFp YS5nZW90cnVzdC5jb20vZXZjYS5jcnQwDgYDVR0PAQH/BAQDAgWgMB0GA1UdJQQW MBQGCCsGAQUFBwMBBggrBgEFBQcDAjAnBgNVHREEIDAegg93d3cubW96aWxsYS5v cmeCC21vemlsbGEub3JnMEIGA1UdHwQ7MDkwN6A1oDOGMWh0dHA6Ly9FVlNTTC1j cmwuZ2VvdHJ1c3QuY29tL2NybHMvZ3RleHR2YWxjYS5jcmwwDAYDVR0TAQH/BAIw ADBLBgNVHSAERDBCMEAGCSsGAQQB8CIBBjAzMDEGCCsGAQUFBwIBFiVodHRwOi8v d3d3Lmdlb3RydXN0LmNvbS9yZXNvdXJjZXMvY3BzMA0GCSqGSIb3DQEBBQUAA4IB AQDBO3AEZKza01zLPQiq3wzRXClKwW/u6D1Fznv7v7hU97luVcbkY/kNAiMerqPk hTfhtnLYIuu9ZFapv2vVdRuzY/hGc3Rieek7f/T8d0tojfjdGgXwwg9M5qaDe35a 0hbsGR1Z1DdWtuGeKPuP6dzDw2zvfcOEf0l14M/ECS2sRU3MX42Rm6BK4xH1cjac KFz+Ngwe4CivEvU4R0+MjPvmTePTyjazU+rzz5fA1JRQ7CCE00+tAAqAIAzHINlH maKUEkR+OwUDEhKc+cQUq+EBeS3ILlufJWak1HFkxRAJAnw9za1ubG+y9V7MVheL rc60KdNJLKwH5EQ0tZSx71jt -----END CERTIFICATE-----

I've tried Apache's VFS (commons-vfs), but it relies on Jsch as a dependency, and so does not support ECDSA.

I need to connect and upload to a remote sftp server using a ecdsa-sha2-nistp256 key. Unfortunately, it seems Jsch doesn't support ECDSA yet. Are there any other libraries that I could use that support SSH 2? Thanks.

Solved it, putting the @XmlValue element in the parent class has solved this instance as well and any other empty name element occurrences as well. Here is what the two classes look like:

public class Animal { @XmlValue protected String value; }

@XmlRootElement public class Pet extends Animal { @XmlAttribute(name = "type") private String type; //getters & setters for type & value }

Thanks g tsuji, that does work. For anyone wondering, codehaus has a nice maven jaxb plugin for generating code from an xml schema (http://www.altuure.com/2008/01/22/jaxb-quickstart-via-maven2/).

Unfortunately, my Pet bean extends another class and JAXB does not allow the use of @XmlValue on a class that derives another class. I guess I'm just going to have to rethink my code structure on this one.

Thanks for the help, but I've got another. Back to the Pet XML, here's what I got:

<pet type=dog>Fido</pet>

Thank you.