greenace92

That was it! Thank you for the help as always.

I fixed the redirect to use www, this is part of my apache configuration, I don't know why it is still not working. I did restart/reload the server. <VirtualHost *:80> ServerName www.cunninghamwebdd.com ServerAlias cunninghamwebdd.com http://www.cunninghamwebdd.com DocumentRoot /var/www/html Redirect "/" "https://www.cunninghamwebdd.com/" # CustomLog /directory log file location not enabled # ErrorLog /directory log not enabled </VirtualHost> <VirtualHost *:443> ServerName https://www.cunninghamwebdd.com DocumentRoot /var/www/html # CustomLog # ErrorLog <IfModule mod_ssl.c> SSLEngine on SSLCertificateFile /etc/ssl/certs/cunninghamwebdd_com.crt SSLCertificateKeyFile /etc/ssl/certs/cunninghamwebdd_com.key SSLCACertificateFile /etc/ssl/certs/cunninghamwebdd_com.ca-bundle.crt SSLProtocol All -SSLv2 -SSLv3 +TLSv1 +TLSv1.1 </IfModule> </VirtualHost> <VirtualHost *:443> ServerName https://cunninghamwebdd.com DocumentRoot /var/www/html/ Redirect "/" "https://www.cunninghamwebdd.com/" # CustomLog # ErrorLog <IfModule mod_ssl.c> SSLEngine on SSLCertificateFile /etc/ssl/certs/cunninghamwebdd_com.crt SSLCertificateKeyFile /etc/ssl/certs/cunninghamwebdd_com.key SSLCACertificateFile /etc/ssl/certs/cunninghamwebdd_com.ca-bundle.crt SSLProtocol All -SSLv2 -SSLv3 +TLSv1 +TLSv1.1 </IfModule> </VirtualHost>

Is this a php/apache setting? I'm in the domain without www, but you say the session cookie is created for www. Is that a default thing? I will just use the www one then, it just seems cleaner to not use www.

Wow thanks a lot, I will do that. Let me see if this works, should.

I'm not sure why this is happening, I force an https redirect in apache could that be it? After assigning the $hex var to $_SESSION['user'] and echoing, I see that there is a session, however when redirecting to a new page the session is dropped. I have tested outside of this script/page, and sessions aren't dropped in redirecting, so I must be missing something on this page. I'd appreciate any help. https://www.cunninghamwebdd.com/brian-music/bad-index.html I edited the $user that's missing at the top where I set $user to $_SESSION['user']; This is for if someone's already logged in, they are redirected to the home page or whatever.

No you are right, I don't know if I should really try to be a web developer, I don't think my heart is in it. I'm not sure what I actually want to do aside from trying to make money hoping that will solve my problems. It is nice to have a clue about the internet though and not just take it for what it is.

Yeah so I guess I got it to work, not sure how I fixed it. I'll try to replicate it again on my other computer. It could be due to an interrupted-install dpkg but not sure. I did edit these lines: $cfg['Servers'][$i]['host'] = '127.0.0.1'; bind-address = 127.0.0.1 $cfg['Servers'][$i]['port'] = '3307'; // MySQL port These are my settings: /etc/phpmyadmin/config.inc.php set to $dbserver set to localhost /etc/mysql/my.cnf set to port = 3307 bind-address set to localhost those look like the main changes

I've been trying the solutions on this page, haven't fixed it yet http://stackoverflow.com/questions/3694575/phpmyadmin-is-throwing-a-2002-cannot-log-in-to-the-mysql-server-phpmyadmin

Sorry I just realized that this is phpmyadmin problem, not mysql, I suppose if a mod could move this thread that would be helpful, but when creating the thread and reproducing the steps to get to the problem, I initially thought it was a mysql problem.

I'm not sure if this is a standard installation message I've seen before regarding the command apt-get install phpmyadmin Message: The phpmyadmin package must have a database installed... If you are an advanced database administrator and know... Otherwise, you should probably choose this option... Configure database for phpmyadmin with dbconfig-common? This is the order of installations that I follow: apt-get update apt-get install libapache2-mod-php5 apt-get install php5 apt-get install mysql-server apt-get install php5-mysql apt-get install phpmyadmin *here at the moment* then edit apache2.conf by adding this line for phpmyadmin: Include /etc/phpmyadmin/apache.conf So I continue the phpmyadmin by choosing yes regarding dbconfig-common: passwords... Ahh here's the error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Then given option to abort, retry, retry (skip questions), ignore All of my other successful installations have been on virtual private servers that I rent. The only thing I could think of is that I don't have a static ip address, using dynamic as provided by ISP, but not sure if that is the problem in question, will do some research.

Hey Jacques1, I was curious if the format you have shown is a standard format eg. used by professional developers? That's not meant to be offensive to you, I don't know what the standard is and would like to engrain it for good formatting habits. I'm going to follow through your examples and see the difference. I have a bad habit of "just get it to work" Haven't done much lately these last couple of weeks been vegging out, being unproductive. I forget how the web is this blank canvas waiting for anyone to create. The joy of seeing your services in use by others. Anyway rambling now. Thanks for your help as always.

I am trying to setup a local LAMP server at the moment so that I can develop without putting stuff online to see it. I had a problem with mysql, regarding the ip-address I think. The problem is that I can't connect and then I can't finish the installation setup and I end up having to abort installation and then purge the files. I'm not sure what to do, I will look around and try again but if someone knows the quick fix I'd appreciate it. I'm not sure if this is a socket problem.

In this particular case, I was trying to check the existence of an account by doing a simple comparison, my query was: $stmt = $link->prepare("SELECT DISTINCT company FROM companies where company=:company"); $stmt->bindParam(':company', $test, PDO::PARAM_STR); $stmt->execute(); $test = $stmt->fetchAll(PDO::FETCH_COLUMN, 0); return $test;

I think I've got it, I'm using FETCH_COLUMN so $result = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);

I am trying to get a bascic website up and running but I'm having a problem with the retrievingt of data. In particular substituting bind_result and pulling single pieces of data. With bind_result, I was able to list out individual columnds and echo them where needed. What is the simple equivalent of: $value = bind_result($value); This link says there is no equivalent http://stackoverflow.com/questions/18706771/what-is-the-equivalent-of-bind-result-on-pdo Where I'm looking for one single result from a query "SELECT DISTINCT" To simply dump an entire collumn I did while ( $row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo htmlspecialchars($row['entry']).'<br>'.'<br>'), ENT_QUOTES, 'UTF-8'); } I need individual rows I know RTFM as people say I'm hoping to get this thing done today but maybe I will have to wait till I thoroughly understand and can substitute the new PDO code.

I guess I don't based on what you have written, I thought I did.

Ahh there it is second sentence: Assuming that Int(4) translates to Int length 4 as seen in phpmyadmin

I usually set an ID to 13, does that mean 9999999999999 ? I say 9 as in 0 to 9, I read the manual saying INT 4 -2147483648 2147483647 I don't see how that relates, or is it like 2^13 when I specify 13?

I don't have an opinion/reason to allow html yet. I really have a lot to read and then while I'm building whatever project I'm working on, I have to keep in mind what purpose the website/application serves. I'm already wondering what comes with Android/RESTful

The 403 forbidden I reliaze comes from not having an index page. Which would then lead to listing out the files in the directory however this is disabled by -Options.

Okay so I guess it could be a domain mapping problem? Now that I have created seperate hosts for the non-www and www versions of the https domain name, it works now for both cases.

I visually checked that the certificate files were different and they are. When I try to open the .crt certificate files, a window appears and each one is different. What part are they the same? There is only one virtual host setup for each domain, I just set the alternative domain as a server alias. When I reverse the names, the non-www works so maybe I will create independent hosts.

I tried it on sslchecker.com and for the second site it says "Hostnames don't match" but the first site says hostnames match... not sure what that means?

I was following through this article here Well I was going to quote that site but it seems to be down? odd... If I search opensource xss filters online, many come up, this was suggested by the article

Okay I don't want to get another warning point so I'll PM you if that is okay.