问:
`Apache` `localhost/~username/` not working
So I just recently upgrade to Mac OS X Yosemite and I need to set up my Apache again. I create a folder "Sites" under /user/kevin and change file permission to 777 and uncomment the php5module line in /etc/apache2/httpd.conf just like before.

localhost is working but localhost/~kevin/ gives me an
"The requested URL /~kevin/ was not found on this server."

Here's my httpd.conf file in case anyone needs to look at it. If there's something wrong with it I will be grateful if anyone can post their httpd.conf file so I can recover it and do it again.

```#
# This is the main Apache HTTP server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs/2.4/> for detailed information.
# In particular, see
# <URL:http://httpd.apache.org/docs/2.4/mod/directives.html>
# for a discussion of each configuration directive.
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned.
#
# Configuration and logfile names: If the filenames you specify for many
# of the server's control files begin with "/" (or "drive:/" for Win32), the
# server will use that explicit path.  If the filenames do *not* begin
# with "/", the value of ServerRoot is prepended -- so "logs/access_log"
# with ServerRoot set to "/usr/local/apache2" will be interpreted by the
# server as "/usr/local/apache2/logs/access_log", whereas "/logs/access_log"
# will be interpreted as '/logs/access_log'.

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# Do not add a slash at the end of the directory path.  If you point
# ServerRoot at a non-local disk, be sure to specify a local disk on the
# Mutex directive, if file-based mutexes are used.  If you wish to share the
# same ServerRoot for multiple httpd daemons, you will need to change at
# least PidFile.
#
ServerRoot "/usr"

#
# Mutex: Allows you to set the mutex mechanism and mutex file directory
# for individual mutexes, or change the global defaults
#
# Uncomment and change the directory if mutexes are file-based and the default
# mutex file directory is not on a local disk or is not appropriate for some
# other reason.
#
# Mutex default:/private/var/run

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#
# Change this to Listen on specific IP addresses as shown below to
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 80

#
# Dynamic Shared Object (DSO) Support
#
# To be able to use the functionality of a module which was built as a DSO you
# have to place corresponding `LoadModule' lines at this location so the
# directives contained in it are actually available _before_ they are used.
# Statically compiled modules (those listed by `httpd -l') do not need
# to be loaded here.
#
# Example:
# LoadModule foo_module modules/mod_foo.so
#
LoadModule authn_file_module libexec/apache2/mod_authn_file.so
#LoadModule authn_dbm_module libexec/apache2/mod_authn_dbm.so
#LoadModule authn_anon_module libexec/apache2/mod_authn_anon.so
#LoadModule authn_dbd_module libexec/apache2/mod_authn_dbd.so
#LoadModule authn_socache_module libexec/apache2/mod_authn_socache.so
LoadModule authn_core_module libexec/apache2/mod_authn_core.so
LoadModule authz_host_module libexec/apache2/mod_authz_host.so
LoadModule authz_groupfile_module libexec/apache2/mod_authz_groupfile.so
LoadModule authz_user_module libexec/apache2/mod_authz_user.so
#LoadModule authz_dbm_module libexec/apache2/mod_authz_dbm.so
#LoadModule authz_owner_module libexec/apache2/mod_authz_owner.so
#LoadModule authz_dbd_module libexec/apache2/mod_authz_dbd.so
LoadModule authz_core_module libexec/apache2/mod_authz_core.so
#LoadModule authnz_ldap_module libexec/apache2/mod_authnz_ldap.so
LoadModule access_compat_module libexec/apache2/mod_access_compat.so
LoadModule auth_basic_module libexec/apache2/mod_auth_basic.so
#LoadModule auth_form_module libexec/apache2/mod_auth_form.so
#LoadModule auth_digest_module libexec/apache2/mod_auth_digest.so
#LoadModule allowmethods_module libexec/apache2/mod_allowmethods.so
#LoadModule file_cache_module libexec/apache2/mod_file_cache.so
#LoadModule cache_module libexec/apache2/mod_cache.so
#LoadModule cache_disk_module libexec/apache2/mod_cache_disk.so
#LoadModule cache_socache_module libexec/apache2/mod_cache_socache.so
#LoadModule socache_shmcb_module libexec/apache2/mod_socache_shmcb.so
#LoadModule socache_dbm_module libexec/apache2/mod_socache_dbm.so
#LoadModule socache_memcache_module libexec/apache2/mod_socache_memcache.so
#LoadModule watchdog_module libexec/apache2/mod_watchdog.so
#LoadModule macro_module libexec/apache2/mod_macro.so
#LoadModule dbd_module libexec/apache2/mod_dbd.so
#LoadModule dumpio_module libexec/apache2/mod_dumpio.so
#LoadModule echo_module libexec/apache2/mod_echo.so
#LoadModule buffer_module libexec/apache2/mod_buffer.so
#LoadModule data_module libexec/apache2/mod_data.so
#LoadModule ratelimit_module libexec/apache2/mod_ratelimit.so
LoadModule reqtimeout_module libexec/apache2/mod_reqtimeout.so
#LoadModule ext_filter_module libexec/apache2/mod_ext_filter.so
#LoadModule request_module libexec/apache2/mod_request.so
#LoadModule include_module libexec/apache2/mod_include.so
LoadModule filter_module libexec/apache2/mod_filter.so
#LoadModule reflector_module libexec/apache2/mod_reflector.so
#LoadModule substitute_module libexec/apache2/mod_substitute.so
#LoadModule sed_module libexec/apache2/mod_sed.so
#LoadModule charset_lite_module libexec/apache2/mod_charset_lite.so
#LoadModule deflate_module libexec/apache2/mod_deflate.so
#LoadModule xml2enc_module libexec/apache2/mod_xml2enc.so
#LoadModule proxy_html_module libexec/apache2/mod_proxy_html.so
LoadModule mime_module libexec/apache2/mod_mime.so
#LoadModule ldap_module libexec/apache2/mod_ldap.so
LoadModule log_config_module libexec/apache2/mod_log_config.so
#LoadModule log_debug_module libexec/apache2/mod_log_debug.so
#LoadModule log_forensic_module libexec/apache2/mod_log_forensic.so
#LoadModule logio_module libexec/apache2/mod_logio.so
LoadModule env_module libexec/apache2/mod_env.so
#LoadModule mime_magic_module libexec/apache2/mod_mime_magic.so
#LoadModule expires_module libexec/apache2/mod_expires.so
LoadModule headers_module libexec/apache2/mod_headers.so
#LoadModule usertrack_module libexec/apache2/mod_usertrack.so
#LoadModule unique_id_module libexec/apache2/mod_unique_id.so
LoadModule setenvif_module libexec/apache2/mod_setenvif.so
LoadModule version_module libexec/apache2/mod_version.so
#LoadModule remoteip_module libexec/apache2/mod_remoteip.so
LoadModule proxy_module libexec/apache2/mod_proxy.so
LoadModule proxy_connect_module libexec/apache2/mod_proxy_connect.so
LoadModule proxy_ftp_module libexec/apache2/mod_proxy_ftp.so
LoadModule proxy_http_module libexec/apache2/mod_proxy_http.so
LoadModule proxy_fcgi_module libexec/apache2/mod_proxy_fcgi.so
LoadModule proxy_scgi_module libexec/apache2/mod_proxy_scgi.so
#LoadModule proxy_fdpass_module libexec/apache2/mod_proxy_fdpass.so
LoadModule proxy_wstunnel_module libexec/apache2/mod_proxy_wstunnel.so
LoadModule proxy_ajp_module libexec/apache2/mod_proxy_ajp.so
LoadModule proxy_balancer_module libexec/apache2/mod_proxy_balancer.so
LoadModule proxy_express_module libexec/apache2/mod_proxy_express.so
#LoadModule session_module libexec/apache2/mod_session.so
#LoadModule session_cookie_module libexec/apache2/mod_session_cookie.so
#LoadModule session_dbd_module libexec/apache2/mod_session_dbd.so
LoadModule slotmem_shm_module libexec/apache2/mod_slotmem_shm.so
#LoadModule slotmem_plain_module libexec/apache2/mod_slotmem_plain.so
#LoadModule ssl_module libexec/apache2/mod_ssl.so
#LoadModule dialup_module libexec/apache2/mod_dialup.so
LoadModule lbmethod_byrequests_module libexec/apache2/mod_lbmethod_byrequests.so
LoadModule lbmethod_bytraffic_module libexec/apache2/mod_lbmethod_bytraffic.so
LoadModule lbmethod_bybusyness_module libexec/apache2/mod_lbmethod_bybusyness.so
#LoadModule lbmethod_heartbeat_module libexec/apache2/mod_lbmethod_heartbeat.so
LoadModule unixd_module libexec/apache2/mod_unixd.so
#LoadModule heartbeat_module libexec/apache2/mod_heartbeat.so
#LoadModule heartmonitor_module libexec/apache2/mod_heartmonitor.so
#LoadModule dav_module libexec/apache2/mod_dav.so
LoadModule status_module libexec/apache2/mod_status.so
LoadModule autoindex_module libexec/apache2/mod_autoindex.so
#LoadModule asis_module libexec/apache2/mod_asis.so
#LoadModule info_module libexec/apache2/mod_info.so
#LoadModule cgi_module libexec/apache2/mod_cgi.so
#LoadModule dav_fs_module libexec/apache2/mod_dav_fs.so
#LoadModule dav_lock_module libexec/apache2/mod_dav_lock.so
#LoadModule vhost_alias_module libexec/apache2/mod_vhost_alias.so
LoadModule negotiation_module libexec/apache2/mod_negotiation.so
LoadModule dir_module libexec/apache2/mod_dir.so
#LoadModule imagemap_module libexec/apache2/mod_imagemap.so
#LoadModule actions_module libexec/apache2/mod_actions.so
#LoadModule speling_module libexec/apache2/mod_speling.so
#LoadModule userdir_module libexec/apache2/mod_userdir.so
LoadModule alias_module libexec/apache2/mod_alias.so
#LoadModule rewrite_module libexec/apache2/mod_rewrite.so
LoadModule php5_module libexec/apache2/libphp5.so
#LoadModule hfs_apple_module libexec/apache2/mod_hfs_apple.so

<IfModule unixd_module>
#
# If you wish httpd to run as a different user or group, you must run
# httpd as root initially and it will switch.
#
# User/Group: The name (or #number) of the user/group to run httpd as.
# It is usually good practice to create a dedicated user and group for
# running httpd, as with most system services.
#
User _www
Group _www

</IfModule>

# 'Main' server configuration
#
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition.  These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
#
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.
#

#
# ServerAdmin: Your address, where problems with the server should be
# e-mailed.  This address appears on some server-generated pages, such
# as error documents.  e.g. admin@your-domain.example
#
ServerAdmin you@example.com

#
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
#
#ServerName www.example.com:80

#
# Deny access to the entirety of your server's filesystem. You must
# explicitly permit access to web content directories in other
# <Directory> blocks below.
#
<Directory />
    AllowOverride none
    Require all denied
</Directory>

#
# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.
#

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "/Library/WebServer/Documents"
<Directory "/Library/WebServer/Documents">
    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.4/mod/core.html#options
    # for more information.
    #
    Options FollowSymLinks Multiviews
    MultiviewsMatch Any

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   AllowOverride FileInfo AuthConfig Limit
    #
    AllowOverride None

    #
    # Controls who can get stuff from this server.
    #
    Require all granted
</Directory>

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
DirectoryIndex index.html
</IfModule>

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^\.([Hh][Tt]|[Dd][Ss]_[Ss])">
    Require all denied
</FilesMatch>

#
# Apple specific filesystem protection.
#
<Files "rsrc">
    Require all denied
</Files>
<DirectoryMatch ".*\.\.namedfork">
    Require all denied
</DirectoryMatch>

#
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog "/private/var/log/apache2/error_log"

#
# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
#
LogLevel warn

<IfModule log_config_module>
    #
    # The following directives define some format nicknames for use with
    # a CustomLog directive (see below).
    #
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common

    <IfModule logio_module>
      # You need to enable mod_logio.c to use %I and %O
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>

    #
    # The location and format of the access logfile (Common Logfile Format).
    # If you do not define any access logfiles within a <VirtualHost>
    # container, they will be logged here.  Contrariwise, if you *do*
    # define per-<VirtualHost> access logfiles, transactions will be
    # logged therein and *not* in this file.
    #
CustomLog "/private/var/log/apache2/access_log" common

    #
    # If you prefer a logfile with access, agent, and referer information
    # (Combined Logfile Format) you can use the following directive.
    #
    #CustomLog "/private/var/log/apache2/access_log" combined
</IfModule>

<IfModule alias_module>
    #
    # Redirect: Allows you to tell clients about documents that used to
    # exist in your server's namespace, but do not anymore. The client
    # will make a new request for the document at its new location.
    # Example:
    # Redirect permanent /foo http://www.example.com/bar

    #
    # Alias: Maps web paths into filesystem paths and is used to
    # access content that does not live under the DocumentRoot.
    # Example:
    # Alias /webpath /full/filesystem/path
    #
    # If you include a trailing / on /webpath then the server will
    # require it to be present in the URL.  You will also likely
    # need to provide a <Directory> section to allow access to
    # the filesystem path.

    #
    # ScriptAlias: This controls which directories contain server scripts.
    # ScriptAliases are essentially the same as Aliases, except that
    # documents in the target directory are treated as applications and
    # run by the server when requested rather than as documents sent to the
    # client.  The same rules about trailing "/" apply to ScriptAlias
    # directives as to Alias.
    #
    ScriptAliasMatch ^/cgi-bin/((?!(?i:webobjects)).*$) "/Library/WebServer/CGI-Executables/$1"

</IfModule>

<IfModule cgid_module>
    #
    # ScriptSock: On threaded servers, designate the path to the UNIX
    # socket used to communicate with the CGI daemon of mod_cgid.
    #
    #Scriptsock cgisock
</IfModule>

#
# "/Library/WebServer/CGI-Executables" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "/Library/WebServer/CGI-Executables">
    AllowOverride None
    Options None
    Require all granted
</Directory>

<IfModule mime_module>
    #
    # TypesConfig points to the file containing the list of mappings from
    # filename extension to MIME-type.
    #
    TypesConfig /private/etc/apache2/mime.types

    #
    # AddType allows you to add to or override the MIME configuration
    # file specified in TypesConfig for specific file types.
    #
    #AddType application/x-gzip .tgz
    #
    # AddEncoding allows you to have certain browsers uncompress
    # information on the fly. Note: Not all browsers support this.
    #
    #AddEncoding x-compress .Z
    #AddEncoding x-gzip .gz .tgz
    #
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz

    #
    # AddHandler allows you to map certain file extensions to "handlers":
    # actions unrelated to filetype. These can be either built into the server
    # or added with the Action directive (see below)
    #
    # To use CGI scripts outside of ScriptAliased directories:
    # (You will also need to add "ExecCGI" to the "Options" directive.)
    #
    #AddHandler cgi-script .cgi

    # For type maps (negotiated resources):
    #AddHandler type-map var

    #
    # Filters allow you to process content before it is sent to the client.
    #
    # To parse .shtml files for server-side includes (SSI):
    # (You will also need to add "Includes" to the "Options" directive.)
    #
    #AddType text/html .shtml
    #AddOutputFilter INCLUDES .shtml
</IfModule>

#
# The mod_mime_magic module allows the server to use various hints from the
# contents of the file itself to determine its type.  The MIMEMagicFile
# directive tells the module where the hint definitions are located.
#
#MIMEMagicFile /private/etc/apache2/magic

#
# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
#
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/missing_handler.pl"
#ErrorDocument 402 http://www.example.com/subscription_info.html
#

#
# MaxRanges: Maximum number of Ranges in a request before
# returning the entire resource, or one of the special
# values 'default', 'none' or 'unlimited'.
# Default setting is to accept 200 Ranges.
#MaxRanges unlimited

#
# EnableMMAP and EnableSendfile: On systems that support it,
# memory-mapping or the sendfile syscall may be used to deliver
# files.  This usually improves server performance, but must
# be turned off when serving from networked-mounted
# filesystems or if support for these functions is otherwise
# broken on your system.
# Defaults: EnableMMAP On, EnableSendfile Off
#
#EnableMMAP off
#EnableSendfile on

TraceEnable off

# Supplemental configuration
#
# The configuration files in the /private/etc/apache2/extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server, or you may simply copy their contents here and change as
# necessary.

# Server-pool management (MPM specific)
Include /private/etc/apache2/extra/httpd-mpm.conf

# Multi-language error messages
#Include /private/etc/apache2/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
Include /private/etc/apache2/extra/httpd-autoindex.conf

# Language settings
#Include /private/etc/apache2/extra/httpd-languages.conf

# User home directories
#Include /private/etc/apache2/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include /private/etc/apache2/extra/httpd-info.conf

# Virtual hosts
#Include /private/etc/apache2/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include /private/etc/apache2/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include /private/etc/apache2/extra/httpd-dav.conf

# Various default settings
#Include /private/etc/apache2/extra/httpd-default.conf

# Configure mod_proxy_html to understand HTML4/XHTML1
<IfModule proxy_html_module>
Include /private/etc/apache2/extra/proxy-html.conf
</IfModule>

# Secure (SSL/TLS) connections
#Include /private/etc/apache2/extra/httpd-ssl.conf
#
# Note: The following must must be present to support
#       starting without SSL on platforms with no /dev/random equivalent
#       but a statically compiled-in mod_ssl.
#
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

Include /private/etc/apache2/other/*.conf

#
# uncomment out the below to deal with user agents that deliberately
# violate open standards by misusing DNT (DNT *must* be a specific
# end-user choice)
#
#<IfModule setenvif_module>
#BrowserMatch "MSIE 10.0;" bad_DNT
#</IfModule>
#<IfModule headers_module>
#RequestHeader unset DNT env=bad_DNT
#</IfModule>
```

Man this is long....

答:
In Apache 2, you've to enable mod_userdir extension, e.g.

```<code>a2enmod userdir
</code>```

Prefix with sudo if required.

Then reload/restart Apache.

Body:
So I just recently upgrade to Mac OS X Yosemite and I need to set up my Apache again. I create a folder "Sites" under /user/kevin and change file permission to 777 and uncomment the php5module line in /etc/apache2/httpd.conf just like before.

localhost is working but localhost/~kevin/ gives me an
"The requested URL /~kevin/ was not found on this server."

Here's my httpd.conf file in case anyone needs to look at it. If there's something wrong with it I will be grateful if anyone can post their httpd.conf file so I can recover it and do it again.

#
# This is the main Apache HTTP server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs/2.4/> for detailed information.
# In particular, see
# <URL:http://httpd.apache.org/docs/2.4/mod/directives.html>
# for a discussion of each configuration directive.
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned.
#
# Configuration and logfile names: If the filenames you specify for many
# of the server's control files begin with "/" (or "drive:/" for Win32), the
# server will use that explicit path.  If the filenames do *not* begin
# with "/", the value of ServerRoot is prepended -- so "logs/access_log"
# with ServerRoot set to "/usr/local/apache2" will be interpreted by the
# server as "/usr/local/apache2/logs/access_log", whereas "/logs/access_log"
# will be interpreted as '/logs/access_log'.

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# Do not add a slash at the end of the directory path.  If you point
# ServerRoot at a non-local disk, be sure to specify a local disk on the
# Mutex directive, if file-based mutexes are used.  If you wish to share the
# same ServerRoot for multiple httpd daemons, you will need to change at
# least PidFile.
#
ServerRoot "/usr"

#
# Mutex: Allows you to set the mutex mechanism and mutex file directory
# for individual mutexes, or change the global defaults
#
# Uncomment and change the directory if mutexes are file-based and the default
# mutex file directory is not on a local disk or is not appropriate for some
# other reason.
#
# Mutex default:/private/var/run

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#
# Change this to Listen on specific IP addresses as shown below to
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 80

#
# Dynamic Shared Object (DSO) Support
#
# To be able to use the functionality of a module which was built as a DSO you
# have to place corresponding `LoadModule' lines at this location so the
# directives contained in it are actually available _before_ they are used.
# Statically compiled modules (those listed by `httpd -l') do not need
# to be loaded here.
#
# Example:
# LoadModule foo_module modules/mod_foo.so
#
LoadModule authn_file_module libexec/apache2/mod_authn_file.so
#LoadModule authn_dbm_module libexec/apache2/mod_authn_dbm.so
#LoadModule authn_anon_module libexec/apache2/mod_authn_anon.so
#LoadModule authn_dbd_module libexec/apache2/mod_authn_dbd.so
#LoadModule authn_socache_module libexec/apache2/mod_authn_socache.so
LoadModule authn_core_module libexec/apache2/mod_authn_core.so
LoadModule authz_host_module libexec/apache2/mod_authz_host.so
LoadModule authz_groupfile_module libexec/apache2/mod_authz_groupfile.so
LoadModule authz_user_module libexec/apache2/mod_authz_user.so
#LoadModule authz_dbm_module libexec/apache2/mod_authz_dbm.so
#LoadModule authz_owner_module libexec/apache2/mod_authz_owner.so
#LoadModule authz_dbd_module libexec/apache2/mod_authz_dbd.so
LoadModule authz_core_module libexec/apache2/mod_authz_core.so
#LoadModule authnz_ldap_module libexec/apache2/mod_authnz_ldap.so
LoadModule access_compat_module libexec/apache2/mod_access_compat.so
LoadModule auth_basic_module libexec/apache2/mod_auth_basic.so
#LoadModule auth_form_module libexec/apache2/mod_auth_form.so
#LoadModule auth_digest_module libexec/apache2/mod_auth_digest.so
#LoadModule allowmethods_module libexec/apache2/mod_allowmethods.so
#LoadModule file_cache_module libexec/apache2/mod_file_cache.so
#LoadModule cache_module libexec/apache2/mod_cache.so
#LoadModule cache_disk_module libexec/apache2/mod_cache_disk.so
#LoadModule cache_socache_module libexec/apache2/mod_cache_socache.so
#LoadModule socache_shmcb_module libexec/apache2/mod_socache_shmcb.so
#LoadModule socache_dbm_module libexec/apache2/mod_socache_dbm.so
#LoadModule socache_memcache_module libexec/apache2/mod_socache_memcache.so
#LoadModule watchdog_module libexec/apache2/mod_watchdog.so
#LoadModule macro_module libexec/apache2/mod_macro.so
#LoadModule dbd_module libexec/apache2/mod_dbd.so
#LoadModule dumpio_module libexec/apache2/mod_dumpio.so
#LoadModule echo_module libexec/apache2/mod_echo.so
#LoadModule buffer_module libexec/apache2/mod_buffer.so
#LoadModule data_module libexec/apache2/mod_data.so
#LoadModule ratelimit_module libexec/apache2/mod_ratelimit.so
LoadModule reqtimeout_module libexec/apache2/mod_reqtimeout.so
#LoadModule ext_filter_module libexec/apache2/mod_ext_filter.so
#LoadModule request_module libexec/apache2/mod_request.so
#LoadModule include_module libexec/apache2/mod_include.so
LoadModule filter_module libexec/apache2/mod_filter.so
#LoadModule reflector_module libexec/apache2/mod_reflector.so
#LoadModule substitute_module libexec/apache2/mod_substitute.so
#LoadModule sed_module libexec/apache2/mod_sed.so
#LoadModule charset_lite_module libexec/apache2/mod_charset_lite.so
#LoadModule deflate_module libexec/apache2/mod_deflate.so
#LoadModule xml2enc_module libexec/apache2/mod_xml2enc.so
#LoadModule proxy_html_module libexec/apache2/mod_proxy_html.so
LoadModule mime_module libexec/apache2/mod_mime.so
#LoadModule ldap_module libexec/apache2/mod_ldap.so
LoadModule log_config_module libexec/apache2/mod_log_config.so
#LoadModule log_debug_module libexec/apache2/mod_log_debug.so
#LoadModule log_forensic_module libexec/apache2/mod_log_forensic.so
#LoadModule logio_module libexec/apache2/mod_logio.so
LoadModule env_module libexec/apache2/mod_env.so
#LoadModule mime_magic_module libexec/apache2/mod_mime_magic.so
#LoadModule expires_module libexec/apache2/mod_expires.so
LoadModule headers_module libexec/apache2/mod_headers.so
#LoadModule usertrack_module libexec/apache2/mod_usertrack.so
#LoadModule unique_id_module libexec/apache2/mod_unique_id.so
LoadModule setenvif_module libexec/apache2/mod_setenvif.so
LoadModule version_module libexec/apache2/mod_version.so
#LoadModule remoteip_module libexec/apache2/mod_remoteip.so
LoadModule proxy_module libexec/apache2/mod_proxy.so
LoadModule proxy_connect_module libexec/apache2/mod_proxy_connect.so
LoadModule proxy_ftp_module libexec/apache2/mod_proxy_ftp.so
LoadModule proxy_http_module libexec/apache2/mod_proxy_http.so
LoadModule proxy_fcgi_module libexec/apache2/mod_proxy_fcgi.so
LoadModule proxy_scgi_module libexec/apache2/mod_proxy_scgi.so
#LoadModule proxy_fdpass_module libexec/apache2/mod_proxy_fdpass.so
LoadModule proxy_wstunnel_module libexec/apache2/mod_proxy_wstunnel.so
LoadModule proxy_ajp_module libexec/apache2/mod_proxy_ajp.so
LoadModule proxy_balancer_module libexec/apache2/mod_proxy_balancer.so
LoadModule proxy_express_module libexec/apache2/mod_proxy_express.so
#LoadModule session_module libexec/apache2/mod_session.so
#LoadModule session_cookie_module libexec/apache2/mod_session_cookie.so
#LoadModule session_dbd_module libexec/apache2/mod_session_dbd.so
LoadModule slotmem_shm_module libexec/apache2/mod_slotmem_shm.so
#LoadModule slotmem_plain_module libexec/apache2/mod_slotmem_plain.so
#LoadModule ssl_module libexec/apache2/mod_ssl.so
#LoadModule dialup_module libexec/apache2/mod_dialup.so
LoadModule lbmethod_byrequests_module libexec/apache2/mod_lbmethod_byrequests.so
LoadModule lbmethod_bytraffic_module libexec/apache2/mod_lbmethod_bytraffic.so
LoadModule lbmethod_bybusyness_module libexec/apache2/mod_lbmethod_bybusyness.so
#LoadModule lbmethod_heartbeat_module libexec/apache2/mod_lbmethod_heartbeat.so
LoadModule unixd_module libexec/apache2/mod_unixd.so
#LoadModule heartbeat_module libexec/apache2/mod_heartbeat.so
#LoadModule heartmonitor_module libexec/apache2/mod_heartmonitor.so
#LoadModule dav_module libexec/apache2/mod_dav.so
LoadModule status_module libexec/apache2/mod_status.so
LoadModule autoindex_module libexec/apache2/mod_autoindex.so
#LoadModule asis_module libexec/apache2/mod_asis.so
#LoadModule info_module libexec/apache2/mod_info.so
#LoadModule cgi_module libexec/apache2/mod_cgi.so
#LoadModule dav_fs_module libexec/apache2/mod_dav_fs.so
#LoadModule dav_lock_module libexec/apache2/mod_dav_lock.so
#LoadModule vhost_alias_module libexec/apache2/mod_vhost_alias.so
LoadModule negotiation_module libexec/apache2/mod_negotiation.so
LoadModule dir_module libexec/apache2/mod_dir.so
#LoadModule imagemap_module libexec/apache2/mod_imagemap.so
#LoadModule actions_module libexec/apache2/mod_actions.so
#LoadModule speling_module libexec/apache2/mod_speling.so
#LoadModule userdir_module libexec/apache2/mod_userdir.so
LoadModule alias_module libexec/apache2/mod_alias.so
#LoadModule rewrite_module libexec/apache2/mod_rewrite.so
LoadModule php5_module libexec/apache2/libphp5.so
#LoadModule hfs_apple_module libexec/apache2/mod_hfs_apple.so

<IfModule unixd_module>
#
# If you wish httpd to run as a different user or group, you must run
# httpd as root initially and it will switch.
#
# User/Group: The name (or #number) of the user/group to run httpd as.
# It is usually good practice to create a dedicated user and group for
# running httpd, as with most system services.
#
User _www
Group _www

</IfModule>

# 'Main' server configuration
#
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition.  These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
#
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.
#

#
# ServerAdmin: Your address, where problems with the server should be
# e-mailed.  This address appears on some server-generated pages, such
# as error documents.  e.g. admin@your-domain.example
#
ServerAdmin you@example.com

#
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
#
#ServerName www.example.com:80

#
# Deny access to the entirety of your server's filesystem. You must
# explicitly permit access to web content directories in other
# <Directory> blocks below.
#
<Directory />
    AllowOverride none
    Require all denied
</Directory>

#
# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.
#

#
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
DocumentRoot "/Library/WebServer/Documents"
<Directory "/Library/WebServer/Documents">
    #
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
    # The Options directive is both complicated and important.  Please see
    # http://httpd.apache.org/docs/2.4/mod/core.html#options
    # for more information.
    #
    Options FollowSymLinks Multiviews
    MultiviewsMatch Any

    #
    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   AllowOverride FileInfo AuthConfig Limit
    #
    AllowOverride None

    #
    # Controls who can get stuff from this server.
    #
    Require all granted
</Directory>

#
# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
#
<IfModule dir_module>
DirectoryIndex index.html
</IfModule>

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^\.([Hh][Tt]|[Dd][Ss]_[Ss])">
    Require all denied
</FilesMatch>

#
# Apple specific filesystem protection.
#
<Files "rsrc">
    Require all denied
</Files>
<DirectoryMatch ".*\.\.namedfork">
    Require all denied
</DirectoryMatch>

#
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog "/private/var/log/apache2/error_log"

#
# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
#
LogLevel warn

<IfModule log_config_module>
    #
    # The following directives define some format nicknames for use with
    # a CustomLog directive (see below).
    #
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common

    <IfModule logio_module>
      # You need to enable mod_logio.c to use %I and %O
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>

    #
    # The location and format of the access logfile (Common Logfile Format).
    # If you do not define any access logfiles within a <VirtualHost>
    # container, they will be logged here.  Contrariwise, if you *do*
    # define per-<VirtualHost> access logfiles, transactions will be
    # logged therein and *not* in this file.
    #
CustomLog "/private/var/log/apache2/access_log" common

    #
    # If you prefer a logfile with access, agent, and referer information
    # (Combined Logfile Format) you can use the following directive.
    #
    #CustomLog "/private/var/log/apache2/access_log" combined
</IfModule>

<IfModule alias_module>
    #
    # Redirect: Allows you to tell clients about documents that used to
    # exist in your server's namespace, but do not anymore. The client
    # will make a new request for the document at its new location.
    # Example:
    # Redirect permanent /foo http://www.example.com/bar

    #
    # Alias: Maps web paths into filesystem paths and is used to
    # access content that does not live under the DocumentRoot.
    # Example:
    # Alias /webpath /full/filesystem/path
    #
    # If you include a trailing / on /webpath then the server will
    # require it to be present in the URL.  You will also likely
    # need to provide a <Directory> section to allow access to
    # the filesystem path.

    #
    # ScriptAlias: This controls which directories contain server scripts.
    # ScriptAliases are essentially the same as Aliases, except that
    # documents in the target directory are treated as applications and
    # run by the server when requested rather than as documents sent to the
    # client.  The same rules about trailing "/" apply to ScriptAlias
    # directives as to Alias.
    #
    ScriptAliasMatch ^/cgi-bin/((?!(?i:webobjects)).*$) "/Library/WebServer/CGI-Executables/$1"

</IfModule>

<IfModule cgid_module>
    #
    # ScriptSock: On threaded servers, designate the path to the UNIX
    # socket used to communicate with the CGI daemon of mod_cgid.
    #
    #Scriptsock cgisock
</IfModule>

#
# "/Library/WebServer/CGI-Executables" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "/Library/WebServer/CGI-Executables">
    AllowOverride None
    Options None
    Require all granted
</Directory>

<IfModule mime_module>
    #
    # TypesConfig points to the file containing the list of mappings from
    # filename extension to MIME-type.
    #
    TypesConfig /private/etc/apache2/mime.types

    #
    # AddType allows you to add to or override the MIME configuration
    # file specified in TypesConfig for specific file types.
    #
    #AddType application/x-gzip .tgz
    #
    # AddEncoding allows you to have certain browsers uncompress
    # information on the fly. Note: Not all browsers support this.
    #
    #AddEncoding x-compress .Z
    #AddEncoding x-gzip .gz .tgz
    #
    # If the AddEncoding directives above are commented-out, then you
    # probably should define those extensions to indicate media types:
    #
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz

    #
    # AddHandler allows you to map certain file extensions to "handlers":
    # actions unrelated to filetype. These can be either built into the server
    # or added with the Action directive (see below)
    #
    # To use CGI scripts outside of ScriptAliased directories:
    # (You will also need to add "ExecCGI" to the "Options" directive.)
    #
    #AddHandler cgi-script .cgi

    # For type maps (negotiated resources):
    #AddHandler type-map var

    #
    # Filters allow you to process content before it is sent to the client.
    #
    # To parse .shtml files for server-side includes (SSI):
    # (You will also need to add "Includes" to the "Options" directive.)
    #
    #AddType text/html .shtml
    #AddOutputFilter INCLUDES .shtml
</IfModule>

#
# The mod_mime_magic module allows the server to use various hints from the
# contents of the file itself to determine its type.  The MIMEMagicFile
# directive tells the module where the hint definitions are located.
#
#MIMEMagicFile /private/etc/apache2/magic

#
# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
#
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/missing_handler.pl"
#ErrorDocument 402 http://www.example.com/subscription_info.html
#

#
# MaxRanges: Maximum number of Ranges in a request before
# returning the entire resource, or one of the special
# values 'default', 'none' or 'unlimited'.
# Default setting is to accept 200 Ranges.
#MaxRanges unlimited

#
# EnableMMAP and EnableSendfile: On systems that support it,
# memory-mapping or the sendfile syscall may be used to deliver
# files.  This usually improves server performance, but must
# be turned off when serving from networked-mounted
# filesystems or if support for these functions is otherwise
# broken on your system.
# Defaults: EnableMMAP On, EnableSendfile Off
#
#EnableMMAP off
#EnableSendfile on

TraceEnable off

# Supplemental configuration
#
# The configuration files in the /private/etc/apache2/extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server, or you may simply copy their contents here and change as
# necessary.

# Server-pool management (MPM specific)
Include /private/etc/apache2/extra/httpd-mpm.conf

# Multi-language error messages
#Include /private/etc/apache2/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
Include /private/etc/apache2/extra/httpd-autoindex.conf

# Language settings
#Include /private/etc/apache2/extra/httpd-languages.conf

# User home directories
#Include /private/etc/apache2/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include /private/etc/apache2/extra/httpd-info.conf

# Virtual hosts
#Include /private/etc/apache2/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include /private/etc/apache2/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include /private/etc/apache2/extra/httpd-dav.conf

# Various default settings
#Include /private/etc/apache2/extra/httpd-default.conf

# Configure mod_proxy_html to understand HTML4/XHTML1
<IfModule proxy_html_module>
Include /private/etc/apache2/extra/proxy-html.conf
</IfModule>

# Secure (SSL/TLS) connections
#Include /private/etc/apache2/extra/httpd-ssl.conf
#
# Note: The following must must be present to support
#       starting without SSL on platforms with no /dev/random equivalent
#       but a statically compiled-in mod_ssl.
#
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>

Include /private/etc/apache2/other/*.conf

#
# uncomment out the below to deal with user agents that deliberately
# violate open standards by misusing DNT (DNT *must* be a specific
# end-user choice)
#
#<IfModule setenvif_module>
#BrowserMatch "MSIE 10.0;" bad_DNT
#</IfModule>
#<IfModule headers_module>
#RequestHeader unset DNT env=bad_DNT
#</IfModule>

Man this is long....

Body:
In Apache 2, you've to enable mod_userdir extension, e.g.

a2enmod userdir

Prefix with sudo if required.

Then reload/restart Apache.


来源: stackexchange

问:
How to change Java-based configuration in tests for Spring-boot based application?
I’m trying to figure out how to test my code in a proper way and stuck somewhere in the middle.

What I use:

Spring-boot based Java web-application. Java based configuration. Test.

What I want:

I want to manage my testing in a proper way. I have a @RestController annotated class what has two objects what I’d like to change in tests. It’s an entities provider class BooksService and database configuration class DBConfig. I want to change implementations for these classes in my tests in a simple and proper way. I don’t know how to do it correctly.

What kind of help I need:

Working project that implements this approach is most preferable. Don’t spend too many words, the working code is the best way to understand it for me.

If there is no a complete project there, so code snippets with descriptions will be useful too.

Links to some good and simple tutorials about 1) Java based configurations 2) Replacing Java based configuration for tests.

Sorry if my thoughts are little bit messy, I’m pretty new in Java EE development and still didn’t figure out with all basic topics well.

EDIT:

Here is some code

DemoApplication class

```<code>@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}
</code>```

BooksController controller class

```<code>@RestController
public class BooksController {

    @Autowired
    BooksProvider booksProvider;

    @CrossOrigin
    @RequestMapping("/books")
    String allBooks() throws Exception {

        return this.booksProvider.fetchAllBooksAsTring();
    }

}
</code>```

BooksProvider service class

```<code>public class BooksProvider {

    public String fetchAllBooksAsTring() {
        return "[\"Marting Iden\", \"Capital\", \"Strong Wind\"]";
    }
}
</code>```

SimpleConfiguration configuration class

```<code>@Configuration
public class SimpleConfiguration {

    @Bean
    public BooksProvider booksProvider() {
        return new BooksProvider();
    }

}
</code>```

答:
Take a look in the Spring Boot test. There is a very nice tutorial how to test your controllers:

https://spring.io/guides/gs/testing-web/

ContentLicense: CC BY-SA 3.0

Body:
I’m trying to figure out how to test my code in a proper way and stuck somewhere in the middle.

What I use:

Spring-boot based Java web-application. Java based configuration. Test.

What I want:

I want to manage my testing in a proper way. I have a @RestController annotated class what has two objects what I’d like to change in tests. It’s an entities provider class BooksService and database configuration class DBConfig. I want to change implementations for these classes in my tests in a simple and proper way. I don’t know how to do it correctly.

What kind of help I need:

Working project that implements this approach is most preferable. Don’t spend too many words, the working code is the best way to understand it for me.

If there is no a complete project there, so code snippets with descriptions will be useful too.

Links to some good and simple tutorials about 1) Java based configurations 2) Replacing Java based configuration for tests.

Sorry if my thoughts are little bit messy, I’m pretty new in Java EE development and still didn’t figure out with all basic topics well.

EDIT:

Here is some code

DemoApplication class

@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

BooksController controller class

@RestController
public class BooksController {

    @Autowired
    BooksProvider booksProvider;

    @CrossOrigin
    @RequestMapping("/books")
    String allBooks() throws Exception {

        return this.booksProvider.fetchAllBooksAsTring();
    }

}

BooksProvider service class

public class BooksProvider {

    public String fetchAllBooksAsTring() {
        return "[\"Marting Iden\", \"Capital\", \"Strong Wind\"]";
    }
}

SimpleConfiguration configuration class

@Configuration
public class SimpleConfiguration {

    @Bean
    public BooksProvider booksProvider() {
        return new BooksProvider();
    }

}


问:
Mininet Switch Port Mirroring Configuration
I am new in using Mininet and wondering how to configure Switch (preferably in python using native Switch class)in order to duplicate all the traffic on the certain port connected to host with Wireshark launched to be ablee see all the traffic. Any suggestions?

There is my configuration script:

```<code>class MyTopo( Topo ):
"Simple topology example."

def __init__( self ):
    "Create custom topo."

# Initialize topology
Topo.__init__( self )

    # Add hosts and switches
leftHost = self.addHost( 'h1' )
rightHost = self.addHost( 'h2' )
idsHost = self.addHost( 'h3' )
    Switch = self.addSwitch( 's1' )

    # Add links
    self.addLink( leftHost,Switch )
    self.addLink( rightHost, Switch )
    self.addLink( Switch, idsHost )

topos = { 'mytopo': ( lambda: MyTopo() ) }
</code>```

答:
To see the switch's traffic on the host (say h1) having Wireshark. The host needs to get each packet incoming in that switch. You can write a RYU controller for that switch which along with passing the packet to appropriate host (say h2) also passes the packet to h1. You can have a look at https://osrg.github.io/ryu-book/en/html/switching_hub.html
This is switching hub, that is packet incoming to the switch will be forwarded to all interfaces other than the incoming interface. You need to change it such that switch forwards to h1's interface irrespective of intended host.</p>

Body:
I am new in using Mininet and wondering how to configure Switch (preferably in python using native Switch class)in order to duplicate all the traffic on the certain port connected to host with Wireshark launched to be ablee see all the traffic. Any suggestions?

There is my configuration script:

class MyTopo( Topo ):
"Simple topology example."

def __init__( self ):
    "Create custom topo."

# Initialize topology
Topo.__init__( self )

    # Add hosts and switches
leftHost = self.addHost( 'h1' )
rightHost = self.addHost( 'h2' )
idsHost = self.addHost( 'h3' )
    Switch = self.addSwitch( 's1' )

    # Add links
    self.addLink( leftHost,Switch )
    self.addLink( rightHost, Switch )
    self.addLink( Switch, idsHost )

topos = { 'mytopo': ( lambda: MyTopo() ) }


问:
Accessing command line (cmd) from RStudio
In my work under R I need to make the call to another software (ANSYS)
For that I am looking for a command under R which allows access to the command line windows (cmd).
For example under matlab the character (!) Allows to do it
thank you</p>

答:
You can use system, system2, or shell on Windows.

If ANSYS is not in your path then you will have to call it directly:

system("/path/to/ansys140.exe ansys_script.ans")

OwnerDisplayName: Hamid Hamdani


问:
NightwatchJs - Unable to concatenate a referenced element and text
At the moment, I have a lot of duplicate functions, that only differ by an element name they're concatenated to.

Because they're designed in the Page Object Model pattern, they follow this structure:

Declaring elements:

```<code>module.exports = {

    commands: [fixtureCommands],

    elements: {
        navbarPreferences: '#preferences',
    }
};
</code>```

And then consequently, I can reference the element in the test itself (using the @ symbol preceding the element's name:

```<code>this.click('@navbarPreferences')
</code>```

Currently - I have this function that concatenates a variable with text. The text is actually in an element that has been declared below it (as shown above in my example)

```<code>function: function (name) {
var i;

for (i = 0; i < names.length; i++) {
    var elementName = '#preferences-' + strippedName;
    this.click(elementName);
}
    return this.api;
},
</code>```

However, how can I reference an element (like I can in the above example) and concatenate it with another variable.

```<code>var elementName = '@navbarPreferences' + strippedName;
</code>```

The above prints the actual text out, not the element itself.

Many thanks.

答:
you can try adding another declaration structure say "props" with your variable in it. than you can call the variable like this: this.props.your_var
example:

```<code>props: {
   navbarPreferences: '#preferences',
},
elements: {
       someElement: '#some-element'
   },
</code>```

var elementName = this.props.navbarPreferences + strippedName;

Body:
At the moment, I have a lot of duplicate functions, that only differ by an element name they're concatenated to.

Because they're designed in the Page Object Model pattern, they follow this structure:

Declaring elements:

module.exports = {

    commands: [fixtureCommands],

    elements: {
        navbarPreferences: '#preferences',
    }
};

And then consequently, I can reference the element in the test itself (using the @ symbol preceding the element's name:

this.click('@navbarPreferences')

Currently - I have this function that concatenates a variable with text. The text is actually in an element that has been declared below it (as shown above in my example)

function: function (name) {
var i;

for (i = 0; i < names.length; i++) {
    var elementName = '#preferences-' + strippedName;
    this.click(elementName);
}
    return this.api;
},

However, how can I reference an element (like I can in the above example) and concatenate it with another variable.

var elementName = '@navbarPreferences' + strippedName;

The above prints the actual text out, not the element itself.

Many thanks.

Body:
you can try adding another declaration structure say "props" with your variable in it. than you can call the variable like this: this.props.your_var
example:

props: {
   navbarPreferences: '#preferences',
},
elements: {
       someElement: '#some-element'
   },

var elementName = this.props.navbarPreferences + strippedName;


问:
Missing } in XML Expression
I am trying to change our site to load a Header through jquery using the .load() function but to do so I need to set the Title of the page.

From another StackFlow question it was suggested to do something as simple as

```<code>$(document).ready(function() {
    document.title ='Name Changed to Protect the Innocent';
});
</code>```

When i do this I get the firebug error
Missing } in XML Expression for that line in the script

I am sure there is probably an easy solution but it is certainly escaping me.

答:
I found what the problem was.  This script was in the middle of another script block which was causing the error. </p>

<p>Thanks for all the help.  </p>

ContentLicense: CC BY-SA 2.5

Title: Missing } in XML Expression

Body:
I am trying to change our site to load a Header through jquery using the .load() function but to do so I need to set the Title of the page.

From another StackFlow question it was suggested to do something as simple as

$(document).ready(function() {
    document.title ='Name Changed to Protect the Innocent';
});

When i do this I get the firebug error
Missing } in XML Expression for that line in the script

I am sure there is probably an easy solution but it is certainly escaping me.

Body:
I found what the problem was.  This script was in the middle of another script block which was causing the error.

Thanks for all the help.


问:
if not on route('/') go to that route after submitting form, react
Im making a search request to an api in react, it works, I have the searchbar render on all routes so when a user tries to use the searchbar even if he is not in the homepage('/'), it will redirect him to that page and render the results, when I try to use the searchbar in other routes the request gets sent( homepage state changes, which is the route that displays the results) but if i try to do browserHistory('/') i get an error, what is the proper way of doing this

```<code>/*
 * searchBar
 *
 * This is the first thing users see of our App, at the '/' route
 */

import React from 'react';
import Helmet from 'react-helmet';
import { FormattedMessage } from 'react-intl';
import { connect } from 'react-redux';
import { createStructuredSelector } from 'reselect';
import { browserHistory } from 'react-router';

import { makeSelectRepos, makeSelectLoading, makeSelectError } from 'containers/App/selectors';
import H2 from 'components/H2';
import ReposList from 'components/ReposList';
import AtPrefix from './AtPrefix';
import CenteredSection from './CenteredSection';
import Form from './Form';
import Input from './Input';
import Section from './Section';
import messages from './messages';
import { loadRepos } from '../../containers/App/actions';
import { changeUsername } from './actions';
import { makeSelectUsername } from './selectors';

import ActionBar from 'components/MainActionContainer/homepage';

import styled from 'styled-components';

const SearchWrapper = styled.div`
  position: absolute;
  top: 0px;
  right: 0px;
  padding-left: 4%;
  padding-right: 4%;
  padding-top: 30px;
  padding-bottom: 60px;
  height: 200px;
  display: flex;
  @media screen and (max-width: 360px) {
    width: 82%;
    position: absolute;
    top: -21px;
    right: 0px;
    height: 200px;
    padding-left: 4%;
    padding-right: 4%;
    padding-bottom: 60px;
    display: -webkit-box;
    display: -moz-box;
    display: -ms-flexbox;
    display: -webkit-flex;
    display: -webkit-box;
    display: -moz-box;
    display: -ms-flexbox;
    display: -webkit-flex;
    display: flex;
  }
`;

const InputSearch = styled.input`
  width: 90%;
  height: 100%;
  text-align: end;
  color: gray;
  padding-top: 45px;
  font-size: 2.8em;
  outline: 0;
  border-width: 0 0 2px 0;
  border-color: red;
  border-bottom: 2px solid red;
  font-family: district-pro, sans-serif;
  font-style: normal;
  font-weight: 100;
  margin-left: 10%;

  &:hover {
     background-color: #fff;
  }

`;

const InputIcon = styled.div`
  float: right;
  height: 100%;
  margin-left: 5%;
  width: 11%;
  border-bottom: 2px solid red;
  padding-top: 40px;

  @media screen and (max-width: 360px) {
     padding-top: 60px;
  }
`;

const Icon_eyeglass = styled.a`
  font-size: 3.5em;

  @media screen and (max-width: 360px) {
     font-size: 2.2em;
  }
`;

export class SearchBar extends React.PureComponent { // eslint-disable-line react/prefer-stateless-function
  /**
   * when initial state artist is not null, submit the form to load repos
   *
   */
  componentDidMount() {
    if (this.props.username && this.props.username.trim().length > 0) {
      this.props.onSubmitForm();
    }
  }

  render() {
    const { loading, error, repos } = this.props;
    const reposListProps = {
      loading,
      error,
      repos,
    };

    return (
      <div>
        <Helmet
          title="Home Page"
          meta={[
            { name: 'description', content: 'Search upcoming concerts by your favorite Artist' },
          ]}
        />

        <SearchWrapper>
            <form onSubmit={this.props.onSubmitForm} autoComplete="off">
              <label htmlFor="username">
                <InputSearch
                  id="username"
                  type="text"
                  placeholder="Search"
                  value={this.props.username}
                  onChange={this.props.onChangeUsername}
                  autoComplete="off"
                />
              </label>
            </form>
             <InputIcon>
                  <Icon_eyeglass className="material-icons">search</Icon_eyeglass>
             </InputIcon>
        </SearchWrapper>
      </div>
    );
  }
}

SearchBar.propTypes = {
  loading: React.PropTypes.bool,
  error: React.PropTypes.oneOfType([
    React.PropTypes.object,
    React.PropTypes.bool,
  ]),
  repos: React.PropTypes.oneOfType([
    React.PropTypes.array,
    React.PropTypes.bool,
  ]),
  onSubmitForm: React.PropTypes.func,
  username: React.PropTypes.string,
  onChangeUsername: React.PropTypes.func,
};

export function mapDispatchToProps(dispatch) {
  return {
    onChangeUsername: (evt) => dispatch(changeUsername(evt.target.value)),
    onSubmitForm: (evt) => {
      if (evt !== undefined && evt.preventDefault) evt.preventDefault();
      dispatch(loadRepos());
    },
  };
}

const mapStateToProps = createStructuredSelector({
  repos: makeSelectRepos(),
  username: makeSelectUsername(),
  loading: makeSelectLoading(),
  error: makeSelectError(),
});

// Wrap the component to inject dispatch and state into it
export default connect(mapStateToProps, mapDispatchToProps)(SearchBar);
</code>```

I tried this:

```<code>export function mapDispatchToProps(dispatch) {
  return {
    onChangeUsername: (evt) => dispatch(changeUsername(evt.target.value)),
    onSubmitForm: (evt) => {
      if (evt !== undefined && evt.preventDefault) evt.preventDefault();
      dispatch(loadRepos())
      .then(
          () => {
              browserHistory.push('/');
          }
      )}
  };
}
</code>```

but go the error

Uncaught TypeError: Cannot read property 'push' of undefined

答:
If you are using react-router v4, you can correlate your routes with state this way: </p>

```<code><Route path='/*' render={() => (this.state.repos ? ( <Redirect to='/' /> ) : ( <DefaultComponent /> ))} />
</code>```

<p>So, if somebody fetches repos, he will be redirected to the main page, but you have to clear the state before unmounting component to handle next updates of repos. </p>

Body:
Im making a search request to an api in react, it works, I have the searchbar render on all routes so when a user tries to use the searchbar even if he is not in the homepage('/'), it will redirect him to that page and render the results, when I try to use the searchbar in other routes the request gets sent( homepage state changes, which is the route that displays the results) but if i try to do browserHistory('/') i get an error, what is the proper way of doing this

/*
 * searchBar
 *
 * This is the first thing users see of our App, at the '/' route
 */

import React from 'react';
import Helmet from 'react-helmet';
import { FormattedMessage } from 'react-intl';
import { connect } from 'react-redux';
import { createStructuredSelector } from 'reselect';
import { browserHistory } from 'react-router';

import { makeSelectRepos, makeSelectLoading, makeSelectError } from 'containers/App/selectors';
import H2 from 'components/H2';
import ReposList from 'components/ReposList';
import AtPrefix from './AtPrefix';
import CenteredSection from './CenteredSection';
import Form from './Form';
import Input from './Input';
import Section from './Section';
import messages from './messages';
import { loadRepos } from '../../containers/App/actions';
import { changeUsername } from './actions';
import { makeSelectUsername } from './selectors';

import ActionBar from 'components/MainActionContainer/homepage';

import styled from 'styled-components';

const SearchWrapper = styled.div`
  position: absolute;
  top: 0px;
  right: 0px;
  padding-left: 4%;
  padding-right: 4%;
  padding-top: 30px;
  padding-bottom: 60px;
  height: 200px;
  display: flex;
  @media screen and (max-width: 360px) {
    width: 82%;
    position: absolute;
    top: -21px;
    right: 0px;
    height: 200px;
    padding-left: 4%;
    padding-right: 4%;
    padding-bottom: 60px;
    display: -webkit-box;
    display: -moz-box;
    display: -ms-flexbox;
    display: -webkit-flex;
    display: -webkit-box;
    display: -moz-box;
    display: -ms-flexbox;
    display: -webkit-flex;
    display: flex;
  }
`;

const InputSearch = styled.input`
  width: 90%;
  height: 100%;
  text-align: end;
  color: gray;
  padding-top: 45px;
  font-size: 2.8em;
  outline: 0;
  border-width: 0 0 2px 0;
  border-color: red;
  border-bottom: 2px solid red;
  font-family: district-pro, sans-serif;
  font-style: normal;
  font-weight: 100;
  margin-left: 10%;

  &:hover {
     background-color: #fff;
  }

`;

const InputIcon = styled.div`
  float: right;
  height: 100%;
  margin-left: 5%;
  width: 11%;
  border-bottom: 2px solid red;
  padding-top: 40px;

  @media screen and (max-width: 360px) {
     padding-top: 60px;
  }
`;

const Icon_eyeglass = styled.a`
  font-size: 3.5em;

  @media screen and (max-width: 360px) {
     font-size: 2.2em;
  }
`;

export class SearchBar extends React.PureComponent { // eslint-disable-line react/prefer-stateless-function
  /**
   * when initial state artist is not null, submit the form to load repos
   *
   */
  componentDidMount() {
    if (this.props.username && this.props.username.trim().length > 0) {
      this.props.onSubmitForm();
    }
  }

  render() {
    const { loading, error, repos } = this.props;
    const reposListProps = {
      loading,
      error,
      repos,
    };

    return (

        <Helmet
          title="Home Page"
          meta={[
            { name: 'description', content: 'Search upcoming concerts by your favorite Artist' },
          ]}
        />

        <SearchWrapper>
            <form onSubmit={this.props.onSubmitForm} autoComplete="off">

                <InputSearch
                  id="username"
                  type="text"
                  placeholder="Search"
                  value={this.props.username}
                  onChange={this.props.onChangeUsername}
                  autoComplete="off"
                />

            </form>
             <InputIcon>
                  <Icon_eyeglass className="material-icons">search</Icon_eyeglass>
             </InputIcon>
        </SearchWrapper>

    );
  }
}

SearchBar.propTypes = {
  loading: React.PropTypes.bool,
  error: React.PropTypes.oneOfType([
    React.PropTypes.object,
    React.PropTypes.bool,
  ]),
  repos: React.PropTypes.oneOfType([
    React.PropTypes.array,
    React.PropTypes.bool,
  ]),
  onSubmitForm: React.PropTypes.func,
  username: React.PropTypes.string,
  onChangeUsername: React.PropTypes.func,
};

export function mapDispatchToProps(dispatch) {
  return {
    onChangeUsername: (evt) => dispatch(changeUsername(evt.target.value)),
    onSubmitForm: (evt) => {
      if (evt !== undefined && evt.preventDefault) evt.preventDefault();
      dispatch(loadRepos());
    },
  };
}

const mapStateToProps = createStructuredSelector({
  repos: makeSelectRepos(),
  username: makeSelectUsername(),
  loading: makeSelectLoading(),
  error: makeSelectError(),
});

// Wrap the component to inject dispatch and state into it
export default connect(mapStateToProps, mapDispatchToProps)(SearchBar);

I tried this:

export function mapDispatchToProps(dispatch) {
  return {
    onChangeUsername: (evt) => dispatch(changeUsername(evt.target.value)),
    onSubmitForm: (evt) => {
      if (evt !== undefined && evt.preventDefault) evt.preventDefault();
      dispatch(loadRepos())
      .then(
          () => {
              browserHistory.push('/');
          }
      )}
  };
}

but go the error

Uncaught TypeError: Cannot read property 'push' of undefined

Body:
If you are using react-router v4, you can correlate your routes with state this way:

<Route path='/*' render={() => (this.state.repos ? ( <Redirect to='/' /> ) : ( <DefaultComponent /> ))} />

So, if somebody fetches repos, he will be redirected to the main page, but you have to clear the state before unmounting component to handle next updates of repos.

ContentLicense: CC BY-SA 4.0


问:
How to show no result found from a AngularJS search?
I am fetching data from an api and I am using it to search something. When the json returns no result how to show NO RESULT FOUND.

Html code

```<code>        <div class="item item-input-inset">
    <label class="item-input-wrapper">
      <input type="text" placeholder="Search" ng-model="search">
    </label>
    <button class="button button-small" ng-click="load(search)">
      Submit
    </button>
  </div>
  <section class="list">
       <article ng-repeat="object in news">
        <div class="item">

         <div ng-repeat="item in object.news">
        <p class="noWhiteSpace"><b>Available Size</b> - {{item.size}}</p>

         </div>

         </div>
         <div ng-repeat="item in object.news" class="button-bar bar-dark" >
  <a  ng-click = openUrl(item.url); class="button">button</a>

        </div>
      </article>
        </section>
        </ion-content>
      </ion-view>
    </script>
</code>```

This is JS Code where I am fetching data from an api and also searching it.

```<code> $http({

    method: "GET",
    url: https://news.com/json?limit=50"
  })
  .then(function(newsData){
   $scope.news= newsData.data.data.articles;
   $scope.hide();
    console.log(data);

  })

      $scope.load = function(search) {
     $scope.show();
  $http({
    method: "GET",
    url: "https://news.com/json?query_term=" + encodeURIComponent(search)
  })
  .then(function(newsData){
   $scope.newsto= newsData.data.data.article;
   $scope.hide();
    console.log(data);

  });
}

})
</code>```

答:
you can use

```<code><input ng-model='q'/>
</code>```

and in ng-repeat

```<code>   <article ng-repeat="object in news|filter:q as result">
</code>```

and in span

```<code><span ng-if="results.length === 0">
      No results found...
    </span>
</code>```

Body:
I am fetching data from an api and I am using it to search something. When the json returns no result how to show NO RESULT FOUND.

Html code

      <input type="text" placeholder="Search" ng-model="search">

    <button class="button button-small" ng-click="load(search)">
      Submit
    </button>

Available Size - {{item.size}}

  button

        </ion-content>
      </ion-view>
    </script>

This is JS Code where I am fetching data from an api and also searching it.

 $http({

    method: "GET",
    url: https://news.com/json?limit=50"
  })
  .then(function(newsData){
   $scope.news= newsData.data.data.articles;
   $scope.hide();
    console.log(data);

  })

      $scope.load = function(search) {
     $scope.show();
  $http({
    method: "GET",
    url: "https://news.com/json?query_term=" + encodeURIComponent(search)
  })
  .then(function(newsData){
   $scope.newsto= newsData.data.data.article;
   $scope.hide();
    console.log(data);

  });
}

})

Body:
you can use

<input ng-model='q'/>

and in ng-repeat

   <article ng-repeat="object in news|filter:q as result">

and in span

<span ng-if="results.length === 0">
      No results found...
    </span>


问:
How to sum two columns using sub query in a grouped data of joined tables
I've a query :

```<code>SELECT COUNT(*) as Avalied
FROM PY_LeaveTransactionMasterTAB as lm
JOIN PY_LeaveTransactionSubsidaryTAB as ls
ON lm.LV_TransMasterId = ls.LV_TransMasterId
WHERE lm.SystemCode = 'faheem123' AND lm.EmployeeCode = '0014' AND lm.Status ='Approved'
Group by lm.Status
</code>```

The Above query returns:

```<code>Availed
-------
   3
</code>```

and another query :

```<code>SELECT PY_Leave + CY_Leave as Openning
FROM PY_LeaveOpeningTAB
WHERE SystemCode = 'faheem123' and EmployeeCode = '0014'
</code>```

this query returns :

```<code>Openning
--------
   25
   23
   30
</code>```

I want to combine the above two queries to get the below result :

```<code>Openning   Availed
--------   --------
   25         3
   23         0
   30         0
</code>```

How do I achieve the above result? Thanks :)

答:
You could try a using a CTE</p>

```<code> WITH CTE_preselect AS (
 SELECT EmployeeCode,PY_Leave + CY_Leave as Openning
 FROM PY_LeaveOpeningTAB
 WHERE SystemCode = 'faheem123' and EmployeeCode = '0014'
 )

 SELECT Openning,COUNT(*) as Avalied
 FROM PY_LeaveTransactionMasterTAB as lm
 JOIN PY_LeaveTransactionSubsidaryTAB as ls
 ON lm.LV_TransMasterId = ls.LV_TransMasterId
 JOIN CTE_preselect ON lm.EmployeeCode = CTE_preselect.EmployeeCode
 WHERE lm.SystemCode = 'faheem123' AND lm.EmployeeCode = '0014' AND
 lm.Status ='Approved'
 Group by Openning,lm.Status
</code>```

Body:
I've a query :

SELECT COUNT(*) as Avalied
FROM PY_LeaveTransactionMasterTAB as lm
JOIN PY_LeaveTransactionSubsidaryTAB as ls
ON lm.LV_TransMasterId = ls.LV_TransMasterId
WHERE lm.SystemCode = 'faheem123' AND lm.EmployeeCode = '0014' AND lm.Status ='Approved'
Group by lm.Status

The Above query returns:

Availed
-------
   3

and another query :

SELECT PY_Leave + CY_Leave as Openning
FROM PY_LeaveOpeningTAB
WHERE SystemCode = 'faheem123' and EmployeeCode = '0014'

this query returns :

Openning
--------
   25
   23
   30

I want to combine the above two queries to get the below result :

Openning   Availed
--------   --------
   25         3
   23         0
   30         0

How do I achieve the above result? Thanks :)

Body:
You could try a using a CTE

 WITH CTE_preselect AS (
 SELECT EmployeeCode,PY_Leave + CY_Leave as Openning
 FROM PY_LeaveOpeningTAB
 WHERE SystemCode = 'faheem123' and EmployeeCode = '0014'
 )

 SELECT Openning,COUNT(*) as Avalied
 FROM PY_LeaveTransactionMasterTAB as lm
 JOIN PY_LeaveTransactionSubsidaryTAB as ls
 ON lm.LV_TransMasterId = ls.LV_TransMasterId
 JOIN CTE_preselect ON lm.EmployeeCode = CTE_preselect.EmployeeCode
 WHERE lm.SystemCode = 'faheem123' AND lm.EmployeeCode = '0014' AND
 lm.Status ='Approved'
 Group by Openning,lm.Status


问:
Oracle WebCenter Sites Configuration fails
I have the following stack:

RH6/Oracle12c using PLGORCL pluggable database as SID/WebLogic12c/WebCenter Sites 12c

I am following the guide Installing and Configuring Oracle WebCenter Sites.
I have run rcu and config and I have started Node Manager, WebLogic and the WebCenter1 Server.
I am using http://192.168.106.144:7006/sites/sitesconfig to configure the domain.
The configuration fails with the error "Error!There was a problem with the configuration and it could not be completed."
The first error in the stack displayed is:

[2017-03-29T21:44:56.188+00:00] [wcsites_server1] [ERROR] [] [oracle.wcsites.security.context] [tid: 119] [userId: ] [ecid: 374d734d-e63e-4c60-85c1-5e75f64a511e-0000002c,0] [APP: ROOT] [partition-name: DOMAIN] [tenant-name: GLOBAL] Unexpected exception: com.fatwire.security.common.CredentialStoreException: JPS-01033: Cannot set credential. Reason oracle.security.jps.service.policystore.PolicyObjectAlreadyExistsException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OPSS.IDX_JPS_RDN_PDN) violated[[

I have reinstalled the webcenter sites product, including dropping the schema using rcu and uninstalling using ../oui/bin/deinstall.sh
The installation fails again. Anyone knows what I am missing?

答: I have reinstalled the schema with a new prefix, reinstalled the webcenter as well as infrastructure components and installed into a new ORACLE_HOME. The product is now up and running on Linux Centos 6, Oracle 12c pluggable database. This issue is resolved. I think the issue was related to me not removing the ORACLE_HOME contents entirely. Up and running now.</p>


问:
Neo4j - Can't use aggregate functions inside of aggregate functions
everyone! I have a Neo4j database which contains information about visitors who visit a number of checkpoints at specific moments of time. visitors, visits and checkpoints are represented as nodes.

Each visitor is identified by his/her device MAC address, each checkpoint has a unique id.

Each visit node contains an EnterTime property, which is the time (num of millisec since 1970) when the visitor with some specific MAC address is first noticed near the respective checkpoint.

Note: the duration of a visit should be calculated as the difference between EnterTime of the next visit and the EnterTime of this visit.

My goal is to find some statistics about the visits, for example,
1) the average time of a visit by a specific visitor,
2) the average time of a visit to a specific store,
3) the most popular store (i. e. the store with the longest TOTAL time of visits
4) the most popular store (i. e. the store with the longest AVERAGE time of visits) etc.

The database is created with this cypher query:

```<code>//Create visitors:
CREATE (Visitor1: Visitor {MAC:'00:0a:95:9d:68:16'})
CREATE (Visitor2: Visitor {MAC:'00:0a:95:9d:68:17'})
CREATE (Visitor3: Visitor {MAC:'00:0a:95:9d:68:18'})

//Create CheckPoints:
CREATE (CheckPoint1: CheckPoint {CheckPointId: 1})
CREATE (CheckPoint2: CheckPoint {CheckPointId: 2})
CREATE (CheckPoint3: CheckPoint {CheckPointId: 3})
CREATE (CheckPoint4: CheckPoint {CheckPointId: 4})
CREATE (CheckPoint5: CheckPoint {CheckPointId: 5})

//Create visits:
//by visitor 1:
CREATE  (Visitor1)-[:MAKES]->(Visit1: Visit {EnterTime: 1488358800000})-[:TO]->(CheckPoint1)
CREATE  (Visitor1)-[:MAKES]->(Visit2: Visit {EnterTime: 1488359400000})-[:TO]->(CheckPoint2)
CREATE  (Visitor1)-[:MAKES]->(Visit3: Visit {EnterTime: 1488361200000})-[:TO]->(CheckPoint3)
CREATE  (Visitor1)-[:MAKES]->(Visit4: Visit {EnterTime: 1488363600000})-[:TO]->(CheckPoint4)
CREATE  (Visitor1)-[:MAKES]->(Visit5: Visit {EnterTime: 1488364800000})-[:TO]->(CheckPoint5)
CREATE  (Visitor1)-[:MAKES]->(Visit6: Visit {EnterTime: 1488365400000})-[:TO]->(CheckPoint1)

//by visitor 2:
CREATE  (Visitor2)-[:MAKES]->(Visit7: Visit {EnterTime: 1488358800000})-[:TO]->(CheckPoint1)
CREATE  (Visitor2)-[:MAKES]->(Visit8: Visit {EnterTime: 1488360300000})-[:TO]->(CheckPoint4)
CREATE  (Visitor2)-[:MAKES]->(Visit9: Visit {EnterTime: 1488362400000})-[:TO]->(CheckPoint2)
CREATE  (Visitor2)-[:MAKES]->(Visit10: Visit {EnterTime: 1488363000000})-[:TO]->(CheckPoint1)

//by visitor 3:
CREATE  (Visitor3)-[:MAKES]->(Visit11: Visit {EnterTime: 1488353820000})-[:TO]->(CheckPoint1)
CREATE  (Visitor3)-[:MAKES]->(Visit12: Visit {EnterTime: 1488354600000})-[:TO]->(CheckPoint4)
CREATE  (Visitor3)-[:MAKES]->(Visit13: Visit {EnterTime: 1488358200000})-[:TO]->(CheckPoint3)
CREATE  (Visitor3)-[:MAKES]->(Visit14: Visit {EnterTime: 1488359700000})-[:TO]->(CheckPoint1)
</code>```

Please, help me write the queries 1 – 4 correctly.
So far, I have this query, which outputs the visit duration to each checkpoint by a specific visitor (it works correctly):

```<code>match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v1: Visit)-->(cp1: CheckPoint)
optional match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v2: Visit)-->(cp2: CheckPoint)
where v2.EnterTime > v1.EnterTime
return cp1.CheckPointId, v1.EnterTime, min((v2.EnterTime - v1.EnterTime) / 60000) as visit_duration
order by v1.EnterTime;
</code>```

But when I am trying to average the visit duration time:

```<code>match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v1: Visit)-->(cp1: CheckPoint)
optional match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v2: Visit)-->(cp2: CheckPoint)
where v2.EnterTime > v1.EnterTime
return avg(min((v2.EnterTime - v1.EnterTime) / 60000)) as avg_visit_duration;
</code>```

It returns an error message:

```<code>Error occurred: Can't use aggregate functions inside of aggregate functions.
</code>```

Probably, I need to use WITH clause, but so far I have been unable to write a query using WITH clause which gives the correct result (110 minutes).

Any ideas? Your help will be much appreciated! Thanks!

答:
If you need to pass the result of the aggregation function of another aggregation function, do it through the WITH. Something like this:

```<code>match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v1: Visit)-->(cp1: CheckPoint)
optional match (vr)-->(v2: Visit)-->(cp2: CheckPoint)
where v2.EnterTime > v1.EnterTime
with cp1.CheckPointId as CheckPointId,
     v1.EnterTime as EnterTime,
     min((v2.EnterTime - v1.EnterTime) / 60000) as visit_duration
return sum(visit_duration)
</code>```

Body:
everyone! I have a Neo4j database which contains information about visitors who visit a number of checkpoints at specific moments of time. visitors, visits and checkpoints are represented as nodes.

Each visitor is identified by his/her device MAC address, each checkpoint has a unique id.

Each visit node contains an EnterTime property, which is the time (num of millisec since 1970) when the visitor with some specific MAC address is first noticed near the respective checkpoint.

Note: the duration of a visit should be calculated as the difference between EnterTime of the next visit and the EnterTime of this visit.

My goal is to find some statistics about the visits, for example,
1) the average time of a visit by a specific visitor,
2) the average time of a visit to a specific store,
3) the most popular store (i. e. the store with the longest TOTAL time of visits
4) the most popular store (i. e. the store with the longest AVERAGE time of visits) etc.

The database is created with this cypher query:

//Create visitors:
CREATE (Visitor1: Visitor {MAC:'00:0a:95:9d:68:16'})
CREATE (Visitor2: Visitor {MAC:'00:0a:95:9d:68:17'})
CREATE (Visitor3: Visitor {MAC:'00:0a:95:9d:68:18'})

//Create CheckPoints:
CREATE (CheckPoint1: CheckPoint {CheckPointId: 1})
CREATE (CheckPoint2: CheckPoint {CheckPointId: 2})
CREATE (CheckPoint3: CheckPoint {CheckPointId: 3})
CREATE (CheckPoint4: CheckPoint {CheckPointId: 4})
CREATE (CheckPoint5: CheckPoint {CheckPointId: 5})

//Create visits:
//by visitor 1:
CREATE  (Visitor1)-[:MAKES]->(Visit1: Visit {EnterTime: 1488358800000})-[:TO]->(CheckPoint1)
CREATE  (Visitor1)-[:MAKES]->(Visit2: Visit {EnterTime: 1488359400000})-[:TO]->(CheckPoint2)
CREATE  (Visitor1)-[:MAKES]->(Visit3: Visit {EnterTime: 1488361200000})-[:TO]->(CheckPoint3)
CREATE  (Visitor1)-[:MAKES]->(Visit4: Visit {EnterTime: 1488363600000})-[:TO]->(CheckPoint4)
CREATE  (Visitor1)-[:MAKES]->(Visit5: Visit {EnterTime: 1488364800000})-[:TO]->(CheckPoint5)
CREATE  (Visitor1)-[:MAKES]->(Visit6: Visit {EnterTime: 1488365400000})-[:TO]->(CheckPoint1)

//by visitor 2:
CREATE  (Visitor2)-[:MAKES]->(Visit7: Visit {EnterTime: 1488358800000})-[:TO]->(CheckPoint1)
CREATE  (Visitor2)-[:MAKES]->(Visit8: Visit {EnterTime: 1488360300000})-[:TO]->(CheckPoint4)
CREATE  (Visitor2)-[:MAKES]->(Visit9: Visit {EnterTime: 1488362400000})-[:TO]->(CheckPoint2)
CREATE  (Visitor2)-[:MAKES]->(Visit10: Visit {EnterTime: 1488363000000})-[:TO]->(CheckPoint1)

//by visitor 3:
CREATE  (Visitor3)-[:MAKES]->(Visit11: Visit {EnterTime: 1488353820000})-[:TO]->(CheckPoint1)
CREATE  (Visitor3)-[:MAKES]->(Visit12: Visit {EnterTime: 1488354600000})-[:TO]->(CheckPoint4)
CREATE  (Visitor3)-[:MAKES]->(Visit13: Visit {EnterTime: 1488358200000})-[:TO]->(CheckPoint3)
CREATE  (Visitor3)-[:MAKES]->(Visit14: Visit {EnterTime: 1488359700000})-[:TO]->(CheckPoint1)

Please, help me write the queries 1 – 4 correctly.
So far, I have this query, which outputs the visit duration to each checkpoint by a specific visitor (it works correctly):

match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v1: Visit)-->(cp1: CheckPoint)
optional match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v2: Visit)-->(cp2: CheckPoint)
where v2.EnterTime > v1.EnterTime
return cp1.CheckPointId, v1.EnterTime, min((v2.EnterTime - v1.EnterTime) / 60000) as visit_duration
order by v1.EnterTime;

But when I am trying to average the visit duration time:

match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v1: Visit)-->(cp1: CheckPoint)
optional match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v2: Visit)-->(cp2: CheckPoint)
where v2.EnterTime > v1.EnterTime
return avg(min((v2.EnterTime - v1.EnterTime) / 60000)) as avg_visit_duration;

It returns an error message:

Error occurred: Can't use aggregate functions inside of aggregate functions.

Probably, I need to use WITH clause, but so far I have been unable to write a query using WITH clause which gives the correct result (110 minutes).

Any ideas? Your help will be much appreciated! Thanks!

Body:
If you need to pass the result of the aggregation function of another aggregation function, do it through the WITH. Something like this:

match (vr: Visitor {MAC: '00:0a:95:9d:68:16'})-->(v1: Visit)-->(cp1: CheckPoint)
optional match (vr)-->(v2: Visit)-->(cp2: CheckPoint)
where v2.EnterTime > v1.EnterTime
with cp1.CheckPointId as CheckPointId,
     v1.EnterTime as EnterTime,
     min((v2.EnterTime - v1.EnterTime) / 60000) as visit_duration
return sum(visit_duration)


问:
Svg Object moving along a line path and resizing with the window
I created a frame with an svg background (of a fantasy city). When I move over the buildings with the mouse they become red and if I click them I open a bubble with some information.
Now this city need people moving along the street.

Now the problem is that the people are moving along the svg path but if I resize the window the path isn't resizing but stay fixed.

I'm using var SVGPath.getTotalLength(); to get the total length of the path, then inside a jQuery $.each() loop I get the coordinates of the point

```<code>var point = Path.getPointAtLength(v);
  var x = point.x;
  var y = point.y;
</code>```

I don't understand where I'm wrong.

Here the CodePen with the code http://codepen.io/Angussimons/full/oZmNer/

答:
Ok, I found the solution.
I'm posting here if someone else has the same problem.

The original size of the svg was 1920x1080.

So the solution to find the new X and Y adapted to the window size:

```<code>var x = (point.x * w) / 1920;
var y = (point.y * h) / 1080;
</code>```

To get the window size I used jQuery .width() & .height() as follow:

```<code>var w = $(window).width();
var h = $(window).height();
</code>```

Body:
I created a frame with an svg background (of a fantasy city). When I move over the buildings with the mouse they become red and if I click them I open a bubble with some information.
Now this city need people moving along the street.

Now the problem is that the people are moving along the svg path but if I resize the window the path isn't resizing but stay fixed.

I'm using var SVGPath.getTotalLength(); to get the total length of the path, then inside a jQuery $.each() loop I get the coordinates of the point

var point = Path.getPointAtLength(v);
  var x = point.x;
  var y = point.y;

I don't understand where I'm wrong.

Here the CodePen with the code http://codepen.io/Angussimons/full/oZmNer/

Body:
Ok, I found the solution.
I'm posting here if someone else has the same problem.

The original size of the svg was 1920x1080.

So the solution to find the new X and Y adapted to the window size:

var x = (point.x * w) / 1920;
var y = (point.y * h) / 1080;

To get the window size I used jQuery .width() & .height() as follow:

var w = $(window).width();
var h = $(window).height();


问:
Relational Model Objects struggle
I finally want to get into data models. But there is one thing I can't wrap my head around, and I hope this won't sound too stupid:

How or when to set the ID of the object ?
What I mean is, when creating an object, there is no way to know what ID this object is going to have when inserted into the database ( by a mapper class ). So how can I persist relational objects if I dont know the IDs yet ?

I will try to explain this by an example:

```<code>class product {

  private $id; // ??
  private $name;
  private $color;

  function __construct( $name, color $color ){
    $this->name = $name;
    $this->color = $color;
  }

  function getName(){
    return $this->name;
  }

  function getColor(){
    return $this->color;
  }

  function setId(){
    $this->id = $id;
  }

}

class color {

  private $id; // ??
  private $hexCode;

  function __construct( $hexCode ){
    $this->hexCode = $hexCode;
  }

  function getId(){
    return $this->id;
  }

}

class productMapper{

  function persist( product $product ){

    // persist query
    $someQueryBuilder->insert('products')->set('name',$product->getName())->set('refColor',$product->getColor()->getId());

    $product->setId( $someQueryBuilder->getInsertId() );

  }

}

$color = new color('FFCC00');
$product = new product( 'table', $color );

$productMapper = new productMapper();
$productMapper->persist( $product );
</code>```

So my problem here is, I cannot persist my product object, as my color object has no ID yet.
What is the right way to do this ??
Or is my approach here simply wrong ?

Thank you for helping me out or maybe just pointing me in the right direction.

答: Add an auto_increment Primary Key to your products table on the id column.</p>

Title: Relational Model Objects struggle

Body:
I finally want to get into data models. But there is one thing I can't wrap my head around, and I hope this won't sound too stupid:

How or when to set the ID of the object ?
What I mean is, when creating an object, there is no way to know what ID this object is going to have when inserted into the database ( by a mapper class ). So how can I persist relational objects if I dont know the IDs yet ?

I will try to explain this by an example:

class product {

  private $id; // ??
  private $name;
  private $color;

  function __construct( $name, color $color ){
    $this->name = $name;
    $this->color = $color;
  }

  function getName(){
    return $this->name;
  }

  function getColor(){
    return $this->color;
  }

  function setId(){
    $this->id = $id;
  }

}

class color {

  private $id; // ??
  private $hexCode;

  function __construct( $hexCode ){
    $this->hexCode = $hexCode;
  }

  function getId(){
    return $this->id;
  }

}

class productMapper{

  function persist( product $product ){

    // persist query
    $someQueryBuilder->insert('products')->set('name',$product->getName())->set('refColor',$product->getColor()->getId());

    $product->setId( $someQueryBuilder->getInsertId() );

  }

}

$color = new color('FFCC00');
$product = new product( 'table', $color );

$productMapper = new productMapper();
$productMapper->persist( $product );

So my problem here is, I cannot persist my product object, as my color object has no ID yet.
What is the right way to do this ??
Or is my approach here simply wrong ?

Thank you for helping me out or maybe just pointing me in the right direction.


问:
How to use fscanf to reads any character into a string until a tab is reached?
How to use fscanf to reads any character into a string until a tab is reached?

My data file have only 1 row:

```<code>123'\t'(Tab)345'\t'Le Duc Huy'\t'567
</code>```

and i use fscanf like this:

```<code>fscanf(fin,"%d %d %d %[^\t]%s %d",&m,&n,&k,s,&q);
</code>```

it return q with wrong value. Anybody can tell me what made it failed?

答:
Here's the fscanf() version:

```<code>fscanf (stream, "[^\t]", output);
</code>```

Body:
How to use fscanf to reads any character into a string until a tab is reached?

My data file have only 1 row:

123'\t'(Tab)345'\t'Le Duc Huy'\t'567

and i use fscanf like this:

fscanf(fin,"%d %d %d %[^\t]%s %d",&m,&n,&k,s,&q);

it return q with wrong value. Anybody can tell me what made it failed?

Body:
Here's the fscanf() version:

fscanf (stream, "[^\t]", output);


问:
Finding the length of a stringvar
I am trying to make a function that will add text to a text box if the variable behind it is empty. I was attempting to do this using the .len() function, but I get an

```<code>AttributeError: 'StringVar' object has no attribute 'length'.
</code>```

My code is as follows:

```<code>line1var = StringVar()

line1var.set("")

def tobeplaced(value):

    global line1var

    if line1var.length() == 0:

        txtReceipt.insert(END, value)

foo = Button(root, text="foo", command=lambda : tobeplaced("foo")).pack()
</code>```

What do?

答:
A Tkinter StringVar doesn't have a .len or .length method. You can access the associated string with the get method, and get the length of that string with the standard Python built-in len function, eg

```<code>if len(line1var.get()) == 0:
</code>```

but it's cleaner (and more efficient) to do

```<code>if not line1var.get():
</code>```

since an empty string is false-ish.

Here's a small (Python 3) demo:

```<code>import tkinter as tk

root = tk.Tk()

label_text = tk.StringVar()
label = tk.Label(textvariable=label_text)
label.pack()

def update():
    text = label_text.get()
    if not text:
        text = 'base'
    else:
        text += '.'
    label_text.set(text)

b = tk.Button(root, text='update', command=update)
b.pack()

root.mainloop()
</code>```

BTW, you should not do

```<code>foo = Button(root, text="foo", command=lambda : tobeplaced("foo")).pack()
</code>```

The .pack method (and the related .grid and .place methods) returns None, so the above statement assigns None to foo. To assign the widget to foo you need to do the assignment and the packing in separate statements, eg

```<code>foo = Button(root, text="foo", command=lambda : tobeplaced("foo"))
foo.pack()
</code>```

Title: Finding the length of a stringvar

Body:
I am trying to make a function that will add text to a text box if the variable behind it is empty. I was attempting to do this using the .len() function, but I get an

AttributeError: 'StringVar' object has no attribute 'length'.

My code is as follows:

line1var = StringVar()

line1var.set("")

def tobeplaced(value):

    global line1var

    if line1var.length() == 0:

        txtReceipt.insert(END, value)

foo = Button(root, text="foo", command=lambda : tobeplaced("foo")).pack()

What do?

Body:
A Tkinter StringVar doesn't have a .len or .length method. You can access the associated string with the get method, and get the length of that string with the standard Python built-in len function, eg

if len(line1var.get()) == 0:

but it's cleaner (and more efficient) to do

if not line1var.get():

since an empty string is false-ish.

Here's a small (Python 3) demo:

import tkinter as tk

root = tk.Tk()

label_text = tk.StringVar()
label = tk.Label(textvariable=label_text)
label.pack()

def update():
    text = label_text.get()
    if not text:
        text = 'base'
    else:
        text += '.'
    label_text.set(text)

b = tk.Button(root, text='update', command=update)
b.pack()

root.mainloop()

BTW, you should not do

foo = Button(root, text="foo", command=lambda : tobeplaced("foo")).pack()

The .pack method (and the related .grid and .place methods) returns None, so the above statement assigns None to foo. To assign the widget to foo you need to do the assignment and the packing in separate statements, eg

foo = Button(root, text="foo", command=lambda : tobeplaced("foo"))
foo.pack()


答:
As you planned here, you need no Id for the product or color.

However if you insist in having an Id for these classes (for example if you have these objects also in database tables), you must plan some codes in these classes to set the Id for the objects.

```<code>class product {

  private $id;
  private $name;
  private $color;
  private static $last_id;

  function __construct( $name, color $color ){
    $this->last_id++;
    $this->id=$this->last_id;
    $this->name = $name;
    $this->color = $color;
  }

  function getName(){
    return $this->name;
  }

  function getColor(){
    return $this->color;
  }

  function getId(){
    return $this->id;
  }
}

class color {

  private $id;
  private $hexCode;
  private static $last_id;

  function __construct( $hexCode ){
    $this->last_id++;
    $this->id=$this->last_id;
    $this->hexCode = $hexCode;
  }

  function getId(){
    return $this->id;
  }

}

class productMapper{

  function persist( product $product ){

    // persist query
    $someQueryBuilder->insert('products')->set('name',$product->getName())->set('refColor',$product->getColor()->getId());

    $product->setId( $someQueryBuilder->getInsertId() );

  }

}

$color = new color('FFCC00');
$product = new product( 'table', $color );

$productMapper = new productMapper();
$productMapper->persist( $product );
</code>```

Title: Relational Model Objects struggle

Body:
As you planned here, you need no Id for the product or color.

However if you insist in having an Id for these classes (for example if you have these objects also in database tables), you must plan some codes in these classes to set the Id for the objects.

class product {

  private $id;
  private $name;
  private $color;
  private static $last_id;

  function __construct( $name, color $color ){
    $this->last_id++;
    $this->id=$this->last_id;
    $this->name = $name;
    $this->color = $color;
  }

  function getName(){
    return $this->name;
  }

  function getColor(){
    return $this->color;
  }

  function getId(){
    return $this->id;
  }
}

class color {

  private $id;
  private $hexCode;
  private static $last_id;

  function __construct( $hexCode ){
    $this->last_id++;
    $this->id=$this->last_id;
    $this->hexCode = $hexCode;
  }

  function getId(){
    return $this->id;
  }

}

class productMapper{

  function persist( product $product ){

    // persist query
    $someQueryBuilder->insert('products')->set('name',$product->getName())->set('refColor',$product->getColor()->getId());

    $product->setId( $someQueryBuilder->getInsertId() );

  }

}

$color = new color('FFCC00');
$product = new product( 'table', $color );

$productMapper = new productMapper();
$productMapper->persist( $product );


问:
ConcurrentModificationException while iterating through ArrayList
```<code>synchronized(queueClientList){
    Iterator<Client> iterator = queueClientList.iterator();
    while (iterator.hasNext()){
        Client client = new Client();
        client = iterator.next();
        try {
            Thread.sleep(client.serviceTime);
        } catch (InterruptedException e) {
            Thread.currentThread().interrupt();
        }
        System.out.println(client.ID+ " it`s out");
        queueClientList.remove(client);
    }
}
</code>```

This code should iterate through queueClientList and sleep the Thread for client.serviceTime milliseconds. After waking up, it should delete the current client from the queueClientList.

It gives me the ConcurrentModificationException at client = iterator.next() line

The declaration of queueClientList is:

```<code>public List<Client> queueClientList = Collections.synchronizedList(new ArrayList<Client>());
</code>```

Why does it throw that error if this whole method is synchronized?

答:
Problem solved.
The problem was, that I was trying to remove from my list , while iterating thorugh it, which is impossible. </p>

Body:
synchronized(queueClientList){
    Iterator<Client> iterator = queueClientList.iterator();
    while (iterator.hasNext()){
        Client client = new Client();
        client = iterator.next();
        try {
            Thread.sleep(client.serviceTime);
        } catch (InterruptedException e) {
            Thread.currentThread().interrupt();
        }
        System.out.println(client.ID+ " it`s out");
        queueClientList.remove(client);
    }
}

This code should iterate through queueClientList and sleep the Thread for client.serviceTime milliseconds. After waking up, it should delete the current client from the queueClientList.

It gives me the ConcurrentModificationException at client = iterator.next() line

The declaration of queueClientList is:

public List<Client> queueClientList = Collections.synchronizedList(new ArrayList<Client>());

Why does it throw that error if this whole method is synchronized?


问:
mysql command line with MAMP
I realized I couldn't install mysql workbench on my macosx 10.5.8 and I had no other solution but to use mysql command line on the operating system. Here is how I started to use mysql command line on MAMP if anyone found that useful I'm answering my own question to be helpful. </p>

答:
```<code>    cd /Applications/MAMP/Library/bin

then issue

    ./mysql -u root -p

Enter password:

mysql>
</code>```

Title: mysql command line with MAMP