{"id":8,"date":"2009-09-17T16:23:29","date_gmt":"2009-09-17T07:23:29","guid":{"rendered":"http:\/\/www.kaz.bz\/wp\/2009-09-17_254\/"},"modified":"2009-09-17T16:23:29","modified_gmt":"2009-09-17T07:23:29","slug":"vpgsql-c-%e3%81%ae%e3%83%90%e3%82%b0%e3%80%82","status":"publish","type":"post","link":"https:\/\/wp.kaz.bz\/tech\/2009\/09\/17\/8.html","title":{"rendered":"vpgsql.c \u306e\u30d0\u30b0\u3002"},"content":{"rendered":"<p>vpopmail-5.4.28 \u3067\u3001<\/p>\n<p>\u30fbDB\u306bPostgreSQL\u3092\u5229\u7528<br \/>\n\u30fbvalias \u3092DB\u3067\u5229\u7528<\/p>\n<p>\u3059\u308b\u3088\u3046\u306b configure \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3064\u3051\u308b\u3068\u30b3\u30f3\u30d1\u30a4\u30eb\u306b\u5931\u6557\u3059\u308b\u3002<\/p>\n<p>configure \u306e\u4f8b\uff09<br \/>\n.\/configure \\<br \/>\n  --disable-roaming-users \\<br \/>\n  --enable-clear-passwd \\<br \/>\n  --disable-many-domains \\<br \/>\n  --enable-auth-module=pgsql \\<br \/>\n  --enable-auth-logging \\<br \/>\n  --enable-sql-logging \\<br \/>\n  --enable-qmail-ext=y \\<br \/>\n  --enable-valias<\/p>\n<p>vpgsql.c \u306e\u30d0\u30b0\u3002<\/p>\n<p>http:\/\/www.opensubscriber.com\/message\/vchkpw@inter7.com\/8020918.html<\/p>\n<p>\u4e0b\u8a18\u304c\u8a72\u5f53\u3059\u308b\u30d1\u30c3\u30c1\u304b\u3082\u3002<br \/>\nftp:\/\/ftp.ncnu.edu.tw\/FreeBSD\/branches\/-current\/ports\/mail\/vpopmail\/files\/patch-vpgsql.c<\/p>\n<p>\u5225\u4ef6\u3002<br \/>\nvlog \u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u306f\u305a\u3060\u304c\u3001vpgsql.h \u306b\u6307\u5b9a\u3055\u308c\u3066\u3044\u308bCREATE TABLE\u69cb\u6587\u304c\u9593\u9055\u3063\u3066\u3044\u308b\u3002<\/p>\n<p>#ifdef ENABLE_SQL_LOGGING<br \/>\n#define VLOG_TABLE_LAYOUT \"id serial, \\<br \/>\n      userid char(32), passwd CHAR(32), \\<br \/>\n      domain CHAR(96), logon VARCHAR(200), \\<br \/>\n      remoteip char(18), message VARCHAR(255), \\<br \/>\n      timestamp bigint default 0 NOT NULL, error INT, \\<br \/>\n      INDEX user_idx (user), \\<br \/>\n      INDEX domain_idx (domain), INDEX remoteip_idx (remoteip), \\<br \/>\n      INDEX error_idx (error), INDEX message_idx (message)\"<br \/>\n#endif<\/p>\n<p>INDEX \u4ee5\u964d\u306f\u4f7f\u3048\u306a\u3044\u306e\u3067\u4e0b\u8a18\u306b\u5909\u66f4\u3002<\/p>\n<p>#ifdef ENABLE_SQL_LOGGING<br \/>\n#define VLOG_TABLE_LAYOUT \"id serial, \\<br \/>\n      userid char(32), passwd CHAR(32), \\<br \/>\n      domain CHAR(96), logon VARCHAR(200), \\<br \/>\n      remoteip char(18), message VARCHAR(255), \\<br \/>\n      timestamp bigint default 0 NOT NULL, error INT\"<br \/>\n#endif<\/p>\n<p>\u305f\u3060\u3057\u3001\u3053\u308c\u3067\u3082vlog\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u306a\u3044\u3088\u3046\u306a\u306e\u3067\u3001\u7d50\u5c40\u4e0b\u8a18\u306eSQL\u3092\u624b\u52d5\u3067\u5b9f\u884c\u3059\u308b\u306e\u304c\u3044\u3044\u304b\u3082\u3002<\/p>\n<p>create table vlog(<br \/>\nid serial,<br \/>\nuserid char(32), passwd CHAR(32),<br \/>\ndomain CHAR(96), logon VARCHAR(200),<br \/>\nremoteip char(18), message VARCHAR(255),<br \/>\ntimestamp bigint default 0 NOT NULL, error INT<br \/>\n)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>vpopmail-5.4.28 \u3067\u3001 \u30fbDB\u306bPostgreSQL\u3092\u5229\u7528 \u30fbvalias \u3092DB\u3067\u5229\u7528 \u3059\u308b\u3088\u3046\u306b configure \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3064\u3051\u308b\u3068\u30b3\u30f3\u30d1\u30a4\u30eb\u306b\u5931\u6557\u3059\u308b\u3002 configure \u306e\u4f8b\uff09 .\/conf [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-8","post","type-post","status-publish","format-standard","hentry","category-qmail-vpopmail"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":24,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/03\/11\/24.html","url_meta":{"origin":8,"position":0},"title":"ONE\/DEPO\u3092\u5229\u7528\u3059\u308b\u969b\u306b\u4f7f\u3063\u305fPHP\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306econfigure\u30aa\u30d7\u30b7\u30e7\u30f3","author":"kaz. Suenaga","date":"2009\/03\/11","format":false,"excerpt":"\u4f59\u8a08\u306a\u3082\u306e\u3082\u3042\u308b\u306f\u305a\u3067\u3059\u304c\u3001\u3068\u308a\u3042\u3048\u305a\u52d5\u3044\u305fconfigure\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u3059\u3002 \u304a\u305d\u3089\u304fPDO\u7cfb\u306f\u4e0d\u2026","rel":"","context":"ONE\/DEPO","block_context":{"text":"ONE\/DEPO","link":"https:\/\/wp.kaz.bz\/tech\/category\/web\/onedepo"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1179,"url":"https:\/\/wp.kaz.bz\/tech\/2012\/05\/25\/1179.html","url_meta":{"origin":8,"position":1},"title":"1\u3064\u306eIP\u30a2\u30c9\u30ec\u30b9\u3067\u8907\u6570\u306e\u30b3\u30e2\u30f3\u30cd\u30fc\u30e0\u306eSSL\u8a3c\u660e\u66f8\u3092\u5229\u7528\u3059\u308b\uff08\uff1dSNI\uff09\u3002","author":"kaz. Suenaga","date":"2012\/05\/25","format":false,"excerpt":"\u53c2\u7167\uff09 http:\/\/e-garakuta.net\/techinfo\/doku.php\/linux\/\u2026","rel":"","context":"Apache","block_context":{"text":"Apache","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/apache"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":42,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/06\/11\/42.html","url_meta":{"origin":8,"position":2},"title":"PHP5\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306econfigure\u30aa\u30d7\u30b7\u30e7\u30f3\u4f8b\u3002","author":"kaz. Suenaga","date":"2008\/06\/11","format":false,"excerpt":"OpenSSL\u3001MySQL\u3001PostgreSQL\u306a\u3069\u306f\u30bd\u30fc\u30b9\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b\u524d\u63d0\u3067\u3059\u3002 .\/\u2026","rel":"","context":"PHP","block_context":{"text":"PHP","link":"https:\/\/wp.kaz.bz\/tech\/category\/langs\/php"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/11\/11\/4.html","url_meta":{"origin":8,"position":3},"title":"qmail + vpopmail\u74b0\u5883\u3078\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb","author":"kaz. Suenaga","date":"2009\/11\/11","format":false,"excerpt":"qmail + vpopmail \u306e\u74b0\u5883\u306bmailman \u3092\u30bd\u30fc\u30b9\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u969b\u306e\u624b\u9806\u3002 v\u2026","rel":"","context":"mailman","block_context":{"text":"mailman","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/mailman"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/03\/31\/22.html","url_meta":{"origin":8,"position":4},"title":"mod_proxy_balancer \u306b\u3088\u308b\u30ed\u30fc\u30c9\u30d0\u30e9\u30f3\u30b9\u3002\uff3b\u66f8\u304d\u304b\u3051\uff3d","author":"kaz. Suenaga","date":"2009\/03\/31","format":false,"excerpt":"\u53c2\u8003URL\uff09 http:\/\/www.res-system.com\/weblog\/item\/618 [\u2026","rel":"","context":"Apache","block_context":{"text":"Apache","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/apache"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":39,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/06\/18\/39.html","url_meta":{"origin":8,"position":5},"title":"vpopmail\u306e\u5168\u30c9\u30e1\u30a4\u30f3\u30fb\u5168\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3002","author":"kaz. Suenaga","date":"2008\/06\/18","format":false,"excerpt":"vpopmail\u306e\u5168\u30d0\u30fc\u30c1\u30e3\u30eb\u30c9\u30e1\u30a4\u30f3\u30fb\u5168\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u76ee\u7684\u3068\u3057\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u3002 va\u2026","rel":"","context":"qmail \/ vpopmail","block_context":{"text":"qmail \/ vpopmail","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb\/qmail-vpopmail"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/8","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/comments?post=8"}],"version-history":[{"count":0,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/8\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/media?parent=8"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/categories?post=8"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/tags?post=8"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}