Doug G

Thanks for the tips, they help on a couple old sites, but some (circa v2.5 or so) don't seem to have the install timestamp in config.php, and also most don't seem to have a site/templates/README file. This isn't a big problem, I am in the process of trying to update some wiki information I keep about site setup and configuration, and discovered I hadn't recorded any information about these older play-around sites from quite a while ago.

Thanks, I'll check for the timestamp in config.php. I'm still wondering what site profile I used to install a couple of these old testing sites though.

I set up some local development processwire sites some time ago, moved on to some other stuff. Now many months later I'm revisiting some of those old sites but I don't remember how I installed them. Does the processwire installer save somewhere the site profile used during installation (and the date, and the pw version)? I looked over the log files from some of those sites and didn't see any such information.

I have a Digital Ocean CentOS cloud server that only exposes the web server and SSH to the outside world, and SSH only with passwordless key-based logins. Linux has a program sshfs (ssh file system) which allows you to mount a remote directory tree via ssh, and then the mounted files act just like they were local files on your workstation, and you can run vscode on your workstation using the sshfs mounted filesystem as the workspace. sshfs has a user/group map file you can use to properly map the user account from your workstation to the user/group account on the server, so files you edit/create end up with the proper file ownership on the server. The hitch in the gitalong is that I've never found a satisfactory sshfs implementation for windows. I've read there is some sshfs extension for vscode but haven't ever tried it. For myself, since I have a full-time linux server here that I use as a file server for my windows machines, I also have samba running on the linux machine to expose directory trees to windows, I can sshfs mount the cloud server files to a mount point on my local linux server, then I can expose the sshfs mount point through a samba share to my windows 10 workstaiton, fire up vscode in windows 10, navigate using windows file explorer to the mount point where the remote cloud server is mounted, and voila! Plus I can open a putty connection to the cloud server and have command-line access to the remote files. Works for me, ymmv.

Kinda OT, but thanks for posting this idea. I had no idea you could click the arrows in windows file explorer and get a dropdown! Learn something new every day.

.local is a special case top level domain. My guess is your change messed up some dns resolution somewhere. And I wouldn't use a tld of .localhost either, since localhost is a widely-used alias for 127.0.0.1 and is usually defined in a computer hosts file and may cause other unexpected confusion. https://en.wikipedia.org/wiki/.local

Good. Microsoft has always been the best for supporting developers. Also good because the founders of github will get a great payday soon ?

Not exactly simple, I use a CentOS server hosting KVM virtual machine running CentOS and ispconfig3. The VM is bridged on to my local LAN. ispconfig allows easy setup of additional websites for experimentation, I currently have over 20 different local domain websites for testing running off one server. Each site allows shell access, so I just use scp/winscp to download/upload files, cli mysql/mysqldump to dump and save databases, and usually just do all my editing in vim from the command line shell access. Occasionally I sshfs mount the "remote" site filesystem and use some gui IDE, usually geany or eclipse. The biggest roadblock is getting an ispconfig3 server installed and running. The ispconfig folks provide a nice tutorial, but it still takes some time and effort to get it set up, but once you do it offers a nice development environment.

So if any documentation project aimed at creating a user/admin/modules/best practices manual(s) was started up, I would be happy to help however I could. I'm more of a back-end server person, not a web designer, and I really don't understand how to effectively use pw yet so maybe I could learn something from writing stuff.

I'd review the changes you made during pw installation. The error message indicates there is no mysql/mairadb username being sent to the database, hence the database login fails. Maybe one of the "changes" you made prevented the database connection information from getting into the pw config file.

W7 and newer have extra protections on certain stuff. Just being an administrator user on your windows is really a "mostly" administrator user, but to edit hosts (and other protected system files) you need to explicitly tick "run as administrator" in the program you're using to access the file. For me, I created a desktop shortcut ot file explorer, in the shortcut properties tick "run as administrator" after navigating to hosts file open it with notepad from within file explorer. FWIW, being linux-oriented and using both windows and linux to edit websites, on w10 I installed xampp, cygwin for ssh server on win, geany (which is available on both win and linux), and git for windows https://git-scm.com/download/win I don't use github though, I use git for my own private git repository I set up running on a Digital Ocean CentOS droplet. I live pretty much in the command line, and this setup allows me to use pretty much the same cli from either windows or linux.

I have a self-hosted (centos7) development server and a test site pw 3.0.61dvl with uikit admin theme and new regular blog profile. PW is installed to a directory, and my only change to .htaccess was to add RewriteBase to /myfolder/. Web server is apache using ispconfig3 and fast-cgi I was getting occasional "too many redirects" errors when testing on my android phone, and finally spent some time today finding how to duplicate the problem. If I log in to the admin (as an added admin user), then immediately log out, then hit the back button in the browser, I get the "too many redirects" error. But if I close the browser or re-type the url to the browser I get back to the login page. I thought it was my android google chrome, but I can duplicate the error using desktop firefox or chrome. I'm not sure this is processwire related, although I haven't encountered this problem elsewhere. Any thoughts welcome.

My guess is your QUESTION column is a text column, if so you need to add apostrophes ( ' ) around $pertanyaan in your sql

szabesz, yep that's what I meant.

You know, I don't use IRC, and I don't particularly like chat channels for technical things. So if y'all move information about processwire to IRC I won't ever see it, which only diminishes processwire's usefulness to me. It's already bad enough having no overall documentation and relying on forums for learning, siphoning off expertise to IRC will only make it harder to learn this system. $0.000000000000000000002

I have a cheap digital ocean droplet with CentOS 7, and on it I installed ispconfig3 http://www.ispconfig.org/ I use it for a development server as well as a private git repository. This probably isn't the way to go if you're not comfortable with linux

Enjoy the Holidays!

Thanks, I can probably try that over the weekend. I already have downloaded the v2 files from github.

It seems to me I just had to set the rewrite_base in the distributed processwire .htaccess

I was getting ready to experiment with the skyscrapers2 demo, but there doesn't seem to be a site profile like with the original skyscrapers. Did I miss finding the profile, or is it just not implemented (yet) for skyscrapers2?

If your php script uses the common mysqldump command, there are a gazillion options that can affect the size of the resulting sql file. For example, you can decide if you want to expand names to include full tablename.columnname or not, Or you can simply backup the database structure without data, you can decide if you want to include CREATE_TABLE in the backup or not, etc. For your reading enjoyment, you can look over the options available from this linux man page: http://linuxcommand.org/man_pages/mysqldump1.html I've never used phpmyadmin to create backups, but I'd imagine there are various options you can include/not include with pma too.

php supports mssql connections, easier from a windows php server than from linux but available for both. You can certainly access mssql databases from php though. Take a look here for starters: http://php.net/manual/en/ref.pdo-dblib.php Be aware there are sql differences between mssql server an mysql server, so you may run across data conversion issues between the two database servers. For example: http://stackoverflow.com/questions/30739204/how-to-convert-mssql-to-mysql-date-in-php

Ownership appears to be user geot and group geot. Apache normally runs under another user account like 'apache' or 'http'. If you change ownership of config.php to the apache user, you won't need to use the insecure settings allowing anyone to modify the file. By the way, using chmod 006 doesn't make a lot of sense, you're saying the owner and group of the file won't have access, only some other user.

Or if you have a local setup like I do on windows w/xampp, you'd navigate to the config file in windows explorer, right-click and choose the security tab to access the permission settings. Windows ntfs doesn't understand chmod and linux permissions. I used to run php on a shared commercial windows-based host and their control panel had a permissions tool, since using ftp clients wouldn't properly change permissions on ntfs.

I've been using autossh on a CentOS 7 server for a year. autossh has been in the repositories for fedora/centos for many years and is definitely not forgotten. Just the other day there were two threads about autossh at the linuxquestions.org forums I'd pick another name to prevent name conflicts.