This wiki does not contain official documentation and is currently deprecated and read only. Please try reading the documentation on the Liferay Developer Network, the new site dedicated to Liferay documentation. DISCOVER Build your web site, collaborate with your colleagues, manage your content, and more. DEVELOP Build applications that run inside Liferay, extend the features provided out of the box with Liferay's APIs. DISTRIBUTE Let the world know about your app by publishing it in Liferay's marketplace. PARTICIPATE Become a part of Liferay's community, meet other Liferay users, and get involved in the open source project.

Wiki

« 返回到 Portlets

GeoIP UsersMap

详细信息 打印
标签: using liferay google maps geoip usersmap maxmind

Table of Contents [-]

  1. Introduction
    1. Configure

      Introduction #

      Portal users are geographically located by their ip's and displayed with Google Maps API, indicating their cities, countries, flags, etc . The GeoIP UsersMap portlet utilizes Max Mind's GeoIP City Database.

      The GeoIP UsersMap portlet is a independent portlet and dont require any other plugging or portlet to work.

      Configure #

      • 1. Get the GeoIP UsersMap, modify lportal-connection-pool.properties with database credentials and deploy porlet for your Liferay Portal version.
      • 2. Shut down your application server.
      • 3. Download the GeoIP City Database, such as the free GeoLite City Database.
      • 4. Unzip the .dat file to your desired storage path (default: /usr/local/share/GeoIP/), but path can also been configurated in porlet.properties file.
      • 5. Generate a Google Maps API Key
      • 6. Start your application server.
      • 7. Deploy the GeoIP UsersMap portlet.
      • 8. Go to the configuration section inside the own portlet and configure the Google Maps API Key and the desired height.
      • 9. Save changes and reload the page.
      0 附件
      57707 查看
      平均 (2 票)
      满分为 5，平均得分为 5.0。
      评论
      讨论主题回复 作者 日期
      Hey, the portal.properties file contains some... Jakub Liska 2010年10月6日 上午10:26
      The portlets loads, there are no users on the... Jakub Liska 2010年10月6日 下午5:42
      Ouch, sorry, the instructions didn't mention... Jakub Liska 2010年10月6日 下午5:46
      Just to clarify :- ) the first comment, the... Jakub Liska 2010年10月6日 下午6:11
      Hi Jakub, u are right,I forgot to mention that... José Miguel Trinchán 2010年10月9日 上午4:16
      Hi again, I update the project in SourceForge... José Miguel Trinchán 2010年10月9日 上午5:10
      Hi, thank You for this portlet! By the way,... gofri _ 2011年2月4日 上午8:03
      i use a mssql server these are my settings,... steve rieger 2011年5月26日 上午9:00

      Jakub Liska
      Hey, the portal.properties file contains some windows metacharacters....it's encoded into ^M .... it means " include-and-override=portlet-ext.properties^M" so that the file is not included because of it.
      在 10-10-6 上午10:26 发帖。
      Jakub Liska
      The portlets loads, there are no users on the map, and I get this error:

      00:29:47,399 WARN [BasicResourcePool:1224] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@20c1568f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).
      java.sql.SQLException: Connections could not be acquired from the underlying database!
      at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0P­ooledConnectionPool.java:264)
      at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java­:94)
      at com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboPooledDataSource.ja­va:521)
      at com.liferay.geoipusersmap.util.LPortalConnectionPool._getConnection(LPortalConne­ctionPool.java:177)
      at com.liferay.geoipusersmap.util.LPortalConnectionPool.getConnection(LPortalConnec­tionPool.java:64)
      at com.liferay.geoipusersmap.model.GeoIPUsersMapDAO.getUsersData(GeoIPUsersMapDAO.j­ava:74)
      at org.apache.jsp.view_jsp._jspService(view_jsp.java:254)

      Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
      at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.jav­a:972)
      at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool­.java:208)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0P­ooledConnectionPool.java:260)
      在 10-10-6 下午5:42 发帖。
      Jakub Liska
      Ouch, sorry, the instructions didn't mention that one must modify lportal-connection-pool.properties with database credentials.
      在 10-10-6 下午5:46 发帖。
      Jakub Liska
      Just to clarify :- ) the first comment, the property file is not properly encoded for utf-8 linux. The second comment was my fault caused by overlooking the database conf file. And the final comment is, that there is sql select for 'lportal.user_' table ... it should be 'lportal.User_' .... so that there are these errors:

      com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.user_' doesn't exist
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      在 10-10-6 下午6:11 发帖。
      José Miguel Trinchán
      Hi Jakub,

      u are right,I forgot to mention that one must modify lportal-connection-pool.properties with database credentials. I updated the wiki now, thx.

      respect to the user_ table its because my current liferay portal is implemented with PostgreSQL database (instead MySQL) and all tables are in lowercase.

      Before I published the portlet, I change the driver to MySQL in lportal-connection-pool.properties to doit more compatible, but forgot also change the "user_" to "User_" table in the DAO file.

      Thx for your comment.
      在 10-10-9 上午4:16 发帖。
      José Miguel Trinchán
      Hi again,
      I update the project in SourceForge with case sensitive SQL queries, so I hope it works well now in MySQL.
      在 10-10-9 上午5:10 发帖。
      gofri _
      Hi, thank You for this portlet!
      By the way, I've made some changes for my case:
      -I didn't understand the reason to connect to DB. I am using UserLocalServiceUtil.getGroupUsers(groupId) to get all group/community users. This makes configuration simpler (LPortalConnectionPool removed).
      - In view.jsp GeoIPUsersMapDAO.getUsersData(scopeGroupId) parameter is added. This allows to list users only in current scope group (a-la "members list")
      在 11-2-4 上午8:03 发帖以回复 José Miguel Trinchán。
      steve rieger
      i use a mssql server

      these are my settings, yet they dont seem to work

      driver.class=com.jdts.jdbc.Driver
      jdbc.url=jdbc:jtds:sqlserver://192.168.15.2­22/lportal
      user=user
      password=password
      min.pool.size=1
      max.pool.size=5
      acquire.increm­ent=1
      在 11-5-26 上午9:00 发帖以回复 gofri _。